One Star

ETL-Process mit/with SQL Script/Template in Talend Open Studio

Hallo zusammen,
ich möchte gerne für meinen ETL-Prozess in Talend Open Studio ein SQL_Script/Template nutzen. Ich habe es schon mit der tSQLTemplate Komponente und der tMap Komoponente probiert aber es hat nicht funktioniert. Auch das SQL in den Expression-Builder der tMap Komponente reinzuschreiben hat mich nicht weitergebracht Smiley Sad Welche Komponenten muss ich in diesem Fall wie nutzen? Daher würde ich mich freuen wenn mir jemand eine Website/Tutorial sagen bzw. nennen könnte auf der man den ETL-Prozess mit SQL-Scripts/Templates nachvollziehen kann. Bin natürlich auch für jede andere Art von Hilfe dankbar
Würde mich freuen wenn mir jemand weiterhelfen könnte

and now in english
i want to use an SQL-Script/Template for my ETL-Process in Talend Open Studio. I have already tried with tSQLTempalte component and the tMap component, but it doesn´t work. The Sql to write/paste into expression builder of the tMap component doesn´t works too. Which component must i used in this case? In this case it will the best if anyone can me say a website or tutorial where is an example with ETL-Process with SQL-Scripts/Templates. I of course, for any other kind of help appreciated
Would be glad if someone could help me
3 REPLIES
One Star

Re: ETL-Process mit/with SQL Script/Template in Talend Open Studio

Hi
Welcome to Talend Community!
You can start with Talend by these tutorials.
There are many kinds of DB components available in TOS.
Which DB do you want to load and transfer?
Regards,
Pedro
One Star

Re: ETL-Process mit/with SQL Script/Template in Talend Open Studio

thx for welcome,
i know your Link, but is not so helpful for this case. I load the data from an excel file and want make a transformartion for this data with sql script/template. At the next Step this transformed file should display to me. For displaying i use the tLogRow component, so this is not the problem. But how i make a transformation with sql script? which component i must use for this?
I look forward to your replies
One Star

Re: ETL-Process mit/with SQL Script/Template in Talend Open Studio

Hi,
What is it you are trying to do in the SQL script that cannot be done in a Talend component? Can you paste the script/template here so we can give you some advice?
Regards,
Arno
BTW: I liked your translation from German to English, was that Google translate? Smiley Happy