tDBConnection
Opens a connection to a database to be reused in the subsequent subJob or
subJobs.
This component works with a variety of databases
depending on your selection.
tDBConnection Standard properties
These properties are used to configure tDBConnection running in
the Standard Job framework.
The Standard
tDBConnection component belongs to the Databases family.
The component in this framework is available in all Talend
products.
Basic settings
This component serves as an entry point for the following
databases. To configure this component, select a type of database from the
Database list and click Apply on its
Basic settings view. For more information about specific
database properties, see the relevant documentation:
-
Access (tAccessConnection)
-
Amazon Aurora (tAmazonAuroraConnection)
-
Amazon Mysql (tAmazonMysqlConnection)
-
Amazon Oracle (tAmazonOracleConnection)
-
Amazon Redshift (tRedshiftConnection)
-
AS400 (tAS400Connection)
-
Exasol (tEXAConnection)
-
FireBird (tFirebirdConnection)
-
Greenplum (tGreenplumConnection)
-
IBM DB2 (tDB2Connection)
-
Informix (tInformixConnection)
-
Ingres (tIngresConnection)
-
Interbase (tInterbaseConnection)
-
JDBC (tJDBCConnection)
-
MemSQL (tMemSQLConnection (deprecated))
-
Microsoft SQL Server (tMSSqlConnection)
-
MySQL (tMysqlConnection)
-
Netezza (tNetezzaConnection)
-
Oracle (tOracleConnection)
-
ParAccel (tParAccelConnection)
-
PostgreSQL (tPostgresqlConnection)
-
PostgresPlus (tPostgresPlusConnection)
-
SAPHana (tSAPHanaConnection)
-
SQLite (tSQLiteConnection)
-
Snowflake (tSnowflakeConnection)
-
Sybase (ASE and IQ) (tSybaseConnection)
-
Teradata (tTeradataConnection)
-
VectorWise (tVectorWiseConnection)
-
Vertica (tVerticaConnection)