How to create database agnostics ETL jobs in Talend

Highlighted
One Star

How to create database agnostics ETL jobs in Talend

In our product we support multiple databases e.g. Oracle, MS SQL server etc. So based on our client’s preference our ETL job should transfer data from Oracle/MSSQL server to Oracle/MS SQL server. Talend provides database specific connectors e.g. tOracleInput, tOracleOutput, tMSSqlInput, tMSSqlOutput, tOracleSqlRow, tMSSqlRow etc. If we use database specific connectors, we have to create multiple jobs for different target database. How to write generic (common) jobs in Talend to build database agnostic ETL process?
Seventeen Stars

Re: How to create database agnostics ETL jobs in Talend

You can use the tJDBC components. In this case I would generally suggest the usage of tJDBCConnection to avoid set the parameters for all database components.
It remains the problem, if the Talend job should create tables, this could cause problems because some SQL datatypes are not in common for all database vendors (like BOOLEAN does not exists in Oracle)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads