Skip to main content
Blog General

How to Integrate Magento with Oracle ERP ?

Iyappan Perumal
August 20, 2014 |

Magento oracle integration is now just a click away for your business. Talk to us.

Enterprise Resource Planning (ERP) systems form the backbone of many of the Omni Channel retailers, offering services in products, inventories, supply chain and resource management. In the current scenario for an Omni Channel retailer, the customer acquisition happens among the multiple channels offered by the retailers. In such situations, it is crucial that there is a seamless data exchange between the store front and the ERP.

Imagine a customer, who places an order through a mobile app and picks up the product in a store. In such cases, the order related data needs to be consistent across channels. To make this happen, a smooth synchronization between the ERP and the Magento store front is essential, so that a product which is available in ERP should reflect in the store and vice versa.

In numerous occasions, retailers face this enormous challenge of integrating the data between an ERP system and the Magento store front.  The main reason behind this hurdle is that each and every retailer follow their own unique business process, which would be customized in their ERP system. Hence, to make a defect free integration, a solid understanding of the ERP architectures and the data sets is necessary.

Let us look one of our customer stories, where we successfully integrated the data from an Oracle ERP with Magento for PDC, a major American Healthcare solutions provider. Here we needed to create a data exchange between Oracle and Magento.

We used the custom API’s in both Oracle ERP and Magento so that all the data sets were synchronized in specific time intervals. This API will be setup as a as routine job which will process the queued data and update the data in Oracle to Magento and vice-versa.

Oracle Magento Integration

The data synchronization can also be triggered based on certain events or on time intervals. This will vary depending on the business requirements of the retailer.

To capture the Data changes in Magento we need to create an event observer. The below sample explains the methodology in creating an event observer, the moment an order is placed.

To create an observer to capture order details, we need to create an order observer


     
        
            
                
                    singleton
                    yourmodule/observer
                    catalog_product_save_after
                
            
         
    

Once the order is captured the required information is sent via CURL function to Oracle ERP or store to enable consistency across channels.

class YourNamespace_YourModule_Model_Observer
{
    public function catalog_product_save_after($observer)
    {
        $product = $observer->getProduct();
        echo "
"; 
        print_r($product->getData());
        echo "

";
exit;
}
}

The only way forward for Omni Channel retailers is to maintain data consistency across warehouses, stock keeping units, physical shops and online stores. To achieve that its crucial to integrate the data between the Magento store front and ERP.

Cloras

is an enterprise ERP integration platform specializing in Magento Oracle Integration. You can reach us at info@dckap.com 

Iyappan Perumal

As the Head of Product for DCKAP Integrator, an ERP Integration Platform for distributors - Iyappan leads the product vision, strategy, and execution for delivering scalable, secure, and user-friendly integration solutions for small to mid-size distributors. With over a decade of experience in building eCommerce stores prior to kick-starting his product journey, he knows the ins & outs of scaling & managing the storefronts. Out of curiosity, he started figuring out solutions to streamline the front-end and back-end operations that help distributors run an effective & profitable distribution business. And ended up launching Cloras (now DCKAP Integrator) in 2017. Today, hundreds of distributors across different verticals use DCKAP Integrator to connect & automate their backend operations. He loves documenting his observations and learnings, while staying up-to-date with the goings on of the industry.

More posts by Iyappan Perumal