topic about elt component question in Talend Studio

about elt component question

Anonymous — Sat, 16 Nov 2024 12:41:20 GMT

i want to use elt component accomlish of differ source database that accomlish main link, but i do not known how to accomlish differ database sources than now i only accomplish the same database that use elt main....

Re: about elt component question

Anonymous — Tue, 13 Sep 2011 14:33:35 GMT

Hi Sunner,
For the use of ELT components, you can only use tables from the same database and/or schema. The ELT components basically generate a SQL Query, I don't know how you could execute a SQL Query that takes tables from different servers... You will need to use the ETL components to do so.

Re: about elt component question

Anonymous — Tue, 13 Sep 2011 15:02:22 GMT

Hi Sunner888,
As the previous reply mentioned if you want to use the ELT components you are limited to working with the same database. That said, if you go to the Databases
tab on the palette list (and the database you are working with has a folder there), you should be able to work with tables from different databases.
I have a process that reads tables from two different MySQL databases using the tMysqlInput component for each table being read. The server connection information
gets entered at the component level so this gives you the means to pull the tables from the servers you want to access.
I hope this helps and please let me know if you need clarification on the above.
Regards,
Tom

Re: about elt component question

Anonymous — Wed, 14 Sep 2011 03:10:17 GMT

Hi tgrady,
thanks for your help.
yours means is the elt component can not use different database source ,for example (mysql,oracle,db2 etc).
but,the oracle odi can accomplish the different database sources, if so ,the elt component is useless?

Re: about elt component question

Anonymous — Wed, 14 Sep 2011 03:15:17 GMT

Hi vgalopin,
thanks for your help.
my elt can not use sql statement that define the schema..
but why the talend design the elt ,like oracle odi can use different database.
i am a bird. so about it i can not known very deep,can you gei me some example?

Re: about elt component question

Anonymous — Wed, 14 Sep 2011 09:32:20 GMT

Hi vgalopin,
thanks for your help.
my elt can not use sql statement that define the schema..
but why the talend design the elt ,like oracle odi can use different database.
i am a bird. so about it i can not known very deep,can you gei me some example?

Hi
The ELT component is used to generate the SQL query and the query will be executed on the DB server, it will be more faster for a large of data. The source table and target table should in the same database.
Best regards
Shong

Re: about elt component question

janhess — Wed, 14 Sep 2011 14:19:32 GMT

sunner888 you misunderstand what tgragdy was saying. You use a different database component for each type of database you want to get data from, then merge it together in tMap etc, then output it to your target database.

Re: about elt component question

Anonymous — Thu, 15 Sep 2011 02:54:23 GMT

Hi vgalopin,
thanks for your help.
my elt can not use sql statement that define the schema..
but why the talend design the elt ,like oracle odi can use different database.
i am a bird. so about it i can not known very deep,can you gei me some example?

Re: about elt component question

Anonymous — Thu, 15 Sep 2011 02:56:27 GMT

sunner888 you misunderstand what tgragdy was saying. You use a different database component for each type of database you want to get data from, then merge it together in tMap etc, then output it to your target database.

\
hi ,
now,shong said,i understand. tgragdy`s means is use etl components that i known.
thank you.