CODEWITHSUNDEEP
etltalend
user91599
user91599

Reputation: 17

oracle query talend etl

I am a beginner to use talend etl I would make a request to select a database oracle then make a change _ S and insert it into a mysql table I'm stuck. I have not found how to make select queries with talend not know how I started that can help me please

Upvotes: 0

Views: 2972

Answers (2)

padmith
padmith

Reputation: 12

  1. Create the connection Mysql and Oracle in Metadata Objects (Db Connections).

enter image description here

  1. Create the following objects (tMySqlConnection - TOracleConnection)

enter image description here

  1. Configure the objects with the parameters connections (Property Type: Repository).

enter image description here

  1. Extract data: You can select the table with the object tOracleInput.

enter image description here

  1. Edit schema of the table in the submenu Component

enter image description here

  1. Create object TMAP, (transform the data)

enter image description here

  1. Create object tMysqlOutPut and configure the schema and columns to insert.

enter image description here

enter image description here

  1. Create object tMysqlCommit and close the connection.

enter image description here

  1. Listo! ¡¡Run to job!! :)

Upvotes: 0

Gabriele B
Gabriele B

Reputation: 2685

To make a select on Oracle schema you need a tOracleInput component instance. You need to specify a Oracle connection (either a builtin connection or a repository-registered connection) and the output schema (the columns you need).

Then, click on "Guess query" to build the select SQL code accordingly to your desired output schema. You can then modify the automatically generated SQL code to fit your needs (ie. add WHERE or SORT clauses). Don't forget that output schema and selected columns must be the same (ie if you add a SQL-generated column inside the select clause you must add in your output schema, too). Any valid SELECT syntax can be used here (including subselects, cursors, window over partition and even more weird oracle stuff).

After the input instance, add a tMap where you make all your data manipulations. Finally, close with a tMySqlOutput, specifing connection and output table details. The flow will trivially looks like:

tOracleInput ----> tMap ----> tMySqlOutput

Upvotes: 1

Related Questions