ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux" <jacques.le.r...@les7arts.com>
Subject Re: What is a ETL tool in OFBiz?
Date Sat, 25 Sep 2010 19:33:53 GMT
Thanks Bilgin,

This will help to feed the FAQ. Notably the example helps much.

Jacques

From: "Bilgin Ibryam" <bibryam@gmail.com>
> 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 <
> jacques.le.roux@les7arts.com> 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" <jacques.le.roux@les7arts.com>
>>
>>  Thanks BJ, Bilgin,
>>>
>>> I will put it in FAQ, except if someone takes the time to dot it...
>>>
>>> Jacques
>>>
>>> From: "Bilgin Ibryam" <bibryam@gmail.com>
>>>
>>>> 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 <bjfree@free-man.net>
>>>> 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<bjfree@free-man.net>
>>>>>>  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
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>
>>
>


Mime
View raw message