I have a data ware house running in PostgreSQL server ,i'm loading data using PYTHON to the DWH from Magento, I want to consolidate all the mailing process from my DWH , for which i have devised a mailing mechanism using python.
Now my issue is how to get the order confirmation details from Magento to my DWH as I need to send an order confirmation email to users as soon as they places an order(Time period is not an issue).
So i need to understand how the mail sending mechanism in Magento is working in case of Order confirmation? Is there a trigger for that or an event? Does anyone have the SQL code for checking this?
Any ideas/suggestions will be heartily welcomed.
Using Version Magento 1.9
Thanks in advance