I'm looking for help on best methods for syncing bulk data between an ERP system database and Magento. I'm looking for the fast and best approach.
Here is what we have done and tried. We currently have another cloud based application (developed in .Net) where we sync bulk data using a .NET application using Magento SOAP API for authentication and then the .NET app generates data into Jason format for importing using the Magento import process. Although, this works BUT pretty slow. It takes about 30 seconds per record which is extremely slow considering uploading to 20-30k inventory records.
We don't want to use CSV or txt files to import data.
Please help.
