Sure. The main advance of using Talend was that it is able to extract data from many datasources and then invoke ofbiz service thru xml-rpc (or soap).
Importing with OFBiz datafiles (or with xml files) requires handling of all the low-level tasks (primary keys, relatations, types, timestamps) to be done manually. Consider that you want to import the postal address for a person. You have to create 5-6 entities and manage the relations, types correctly... On the other hand, with Talend (or similar tool) you have to extract the needed data from legacy data source and call createPartyPostalAddress service. No need to worry if you missed to populate some of the entities. Bilgin On Sat, Sep 25, 2010 at 1:14 PM, Jacques Le Roux < [email protected]> wrote: > Hi Bilgin, > > Before putting this into the FAQ, I was wondering why you choose to use > Talend over OOTB OFBiz datafiles? > I guess there are advantages, could you please name some? > > Thanks > > Jacques > > From: "Jacques Le Roux" <[email protected]> > > Thanks BJ, Bilgin, >> >> I will put it in FAQ, except if someone takes the time to dot it... >> >> Jacques >> >> From: "Bilgin Ibryam" <[email protected]> >> >>> For reference: >>> >>> After evaluating few ETL tools - Pentaho Kettle, Jitterbit, Talend, we >>> found >>> out that the most easier way to integrate data in Ofbiz is using Talend. >>> >>> The process: >>> >>> - 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) >>> >>> Ofbiz services can be called as web service (real pain with the way >>> parameters are encoded in maps) or through XML-RPC >>> >>> The process is really easy, since Talend can connect to many data >>> sources, >>> and importing the data using Ofbiz services ensure that the data is >>> properly >>> created. >>> >>> Bilgin >>> >>> On Mon, Jul 12, 2010 at 10:07 PM, BJ Freeman <[email protected]> >>> wrote: >>> >>> your welcome >>>> in addition if you got the DB route you can write scripts to map ofbiz >>>> to >>>> the other db and use SECAS. >>>> so if say a createcustomers service is run you can have your SECA call >>>> your >>>> script and load the other DB. >>>> from you legacy db you can have scheduled services that pull from it to >>>> ofbiz. >>>> >>>> Chatree Srichart sent the following on 7/12/2010 1:05 PM: >>>> >>>> Hi, BJ Freeman >>>> >>>>> Thanks for your quick answer. >>>>> >>>>> Regards, >>>>> Chatree Srichart >>>>> >>>>> On Tue, Jul 13, 2010 at 2:53 AM, BJ Freeman<[email protected]> >>>>> wrote: >>>>> >>>>> it depends on the data form you using. >>>>> >>>>>> for files >>>>>> >>>>>> >>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data >>>>>> >>>>>> if you have a db you can connect to ofbiz then you can >>>>>> create the entities and write minilang scripts to pull from the old >>>>>> one, >>>>>> map then store in ofbiz. >>>>>> >>>>>> >>>>>> https://demo-trunk.ofbiz.apache.org/webtools/control/view/ModelInduceFromDb >>>>>> your need to define a datasource in the entityengine.xml for your db, >>>>>> to >>>>>> use this tool. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Chatree Srichart sent the following on 7/12/2010 12:19 PM: >>>>>> >>>>>> Hi community, >>>>>> >>>>>> >>>>>>> Now I'm working on OFBiz and need to integrate it to several systems. >>>>>>> I >>>>>>> have >>>>>>> to get data from several sources to store in OFBiz data model. >>>>>>> I need to use ETL tool for help this process but I don't know what is >>>>>>> a >>>>>>> ETL >>>>>>> tool that OFBiz use. >>>>>>> >>>>>>> Can anyone tell me what is a ETL tool in OFBiz? >>>>>>> >>>>>>> Regards, >>>>>>> Chatree Srichart >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>> >>> >> >
