Hi As we currently use SugarCRM (and have custom-developped modules that import data from other sources), we'll need to import clients data if we are to switch to OpenERP for CRM usage, both when we start, and periodically for updating fresh data from our external provider. First of all is it possible to do so without SugarCRM at all after initial import, ie direct import to OpenERP's crm module from our external MySQL source, and how ? Else how can that SugarCRM -> OpenERP import work ? Can the online version support a serious volume of many thousands of clients and prospects ? Best regards.
This king of data migration might be best achieved using Kettle / Pentaho Data Integration. You'll need to learn about ETL, but I assure you it's really worth it.
Additionaly, there is a SugarCRM plugin avalibale that "allows you to access all data available in SugarCRM modules." (Though couldn't find a download link, sorry.)
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 2/12/13, 6:58 AM|
|Seen: 3723 times|
|Last updated: 3/16/15, 8:10 AM|