...
- If you have a direct access to an external database, the easiest method is to connect to it through the OFBiz Entity Engine.If
- Use of ETL tool to extract data from the lagacy database and import it using XML-RPC or OFBiz WebServices
- If the data is not in there is an external database but you don't have access to it, then we recommend the use of an ETL tool, Talend is our preferred. After evaluating few ETL tools - Pentaho Kettle, Jitterbit and Talend, we found out that the easiest way to integrate data in Ofbiz is to use Talend.
- If there is not an external database, only flat files, then the best is to use ???
If you don't have access to an external DB
It's easier to use Talend to extract data (you need to know at least the data structure of the DB) and send these data to OFBiz with xml-rpc
- Connect Talend to the external DB
- For each row, prepare the data (doing transformations, joins with other tables, call web services to get ISO codes)
- Call an ofbiz service to create the data in OFBiz DB (like create product)
...
- have data in files that can be loaded
Use the Entity xml data resource
...
By entity XML import reader : on your component indicate to load your files by with ext reader. When you want load your data, run ./ant load-ext from your OFBIz home directory.
For instance in your component/ofbiz-component.xml:Code Block language xml <entity-resource type="data" reader-name="ext" loader="main" location="data/MyImportData.xml"/>
- See How to preparing data for more information.
Directly from webtools in OFBiz, go to
https://localhost:8443/webtools/control/entityImport to load file by file or copy/paste text
https://localhost:8443/webtools/control/EntityImportDir to load a directory content
- Call the OFBiz service importEntityFileDirectory if you have an automation process
Use the OFBiz's Data File Tools to import your cvs file in
...