Double-click the tELTOracleInput component to display its Basic settings view.
Select Repository from the Schema list and click the [...] button preceding Edit schema.
Select your database connection and the desired schema from the
Repository Content dialog
The selected schema name appears in the
Default Table Name field
- In this use case, the database connection is
Talend_Oracle and the schema is
- In this use case, the input schema is stored in the Metadata node of the Repository tree view for easy
retrieval. For further information concerning metadata, see
- You can also select the input component by dropping the
relevant schema from the Metadata area onto the design workspace and double-clicking
the Components dialog box.
Doing so allows you to skip the steps of labeling the input component and
defining its schema manually.
Click the tELTOracleMap component to display its Basic settings view.
Select Repository from the Property Type list, and select the same database connection that you
use for the input components.
Remember: All the database details are automatically
retrieved. Leave the other settings as they are.
Double-click the tELTOracleMap component to launch the ELT Map editor
for setting up the data transformation flow.
Add the input table by clicking the
[+] button on the upper left corner of the ELT Map editor
and selecting the relevant table name in the pop-up dialog box.
In this use case, the only input table is
Select all the columns in the input table and drop
them to the output table.
Click the Generated SQL Select query tab to display the query
statement to be executed.
Click OK to validate the ELT Map settings and close the ELT Map
Double-click the tELTOracleOutput component to display its Basic settings view.
From the Action on
data list, select MERGE.
Click the Sync
columns button to retrieve the schema from the preceding
Select the Use
Merge Update check box to update the data using Oracle's MERGE
In the table that appears, select the check boxes
for the columns you want to update.
In this use case, youupdate all the data
according to the customer ID. Therefore, select all the check boxes except the one
for the ID column.
Warning: The columns defined as the
primary key cannot and must not be made subject to updates.
Select the Use Merge Insert check box to insert new data while
updating the existing data by leveraging the OracleMERGE function.
In the table that appears, select the check boxes for the columns
into which you want to insert new data.
In this use case, insert all the new customer
data. Therefore, select all the check boxes by clicking the Check All check box.
Fill the Default Table Name field with the name of the target
table already existing in your database. In this example, fill in customers_merge.
Leave the other parameters as they are.