Keeping data in sync on a day-to-day basis across cloud services (XaaS), and between cloud and on-premise datastores is obviously one of the key benefits of FoxWeave. This is very useful on its own, but for many companies there’s another major headache to be cured before day-to-day synchronization becomes an issue.
Before most companies can start using cloud based services (CRM, ERP etc), they first need to load those services with existing data that’s often stored in on-premise databases e.g. Accounts, Contacts, Opportunities etc. In this blog, we demo how FoxWeave can be used to cure this headache. We show how to load Salesforce.com with Accounts from an on-premise/in-house MySQL database. Of course, the database could be a different type of database (Oracle etc) and the target cloud service could be some other CRM service (OnePage CRM etc), so for that reason we will follow up this blog with other examples of “moving data to the cloud“. As you can imagine, this same basic concept can be extended to moving/migrating your data between cloud services e.g. when switching service provider to get a better deal or service.
(See the On-Premise App Deployment Guide for details of configuring the On-Premise App Deployer)