tDBOutputBulk
Writes a file with columns based on the defined delimiter and the standards of
the selected database type.
This component works with a variety of databases
depending on your selection.
The tDBOutputBulk and tDBBulkExec components are
used together in a two step process. In the first step, an output file is generated. In
the second step, this file is used in the INSERT statement used to feed a database the
selected database type. These two steps are fused together in the
tDBOutputBulkExec component, detailed in a separate section. The
advantage of using two separate steps is that the data can be transformed before it is
loaded in the database.
tDBOutputBulk Standard properties
These properties are used to configure tDBOutputBulk running in
the Standard Job framework.
The Standard
tDBOutputBulk 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 (tAccessOutputBulk)
-
Amazon Redshift (tRedshiftOutputBulk)
-
Greenplum (tGreenplumOutputBulk)
-
Informix (tInformixOutputBulk)
-
Ingres (tIngresOutputBulk)
-
Microsoft SQL Server (tMSSqlOutputBulk)
-
MySQL (tMysqlOutputBulk)
-
Oracle (tOracleOutputBulk)
-
ParAccel (tParAccelOutputBulk)
-
PostgreSQL (tPostgresqlOutputBulk)
-
PostgresPlus (tPostgresPlusOutputBulk)
-
Snowflake (tSnowflakeOutputBulk)
-
Sybase (ASE and IQ) (tSybaseOutputBulk)
-
Vertica (tVerticaOutputBulk)