Exports data from a database table into a CSV file.

The file will be named FDJDBC_TABLE_NAME.csv. The file will be created in the FD_ARTIFACTS_DIR.

Target Properties

Property Name	Property Code	Required	Description

Property Name	Property Code	Required	Description
JDBC URL	`FDJDBC_URL`	Yes	The JDBC URL of the database.
JDBC User	`FDJDBC_USER`	No	The username that will be used to connect with.
JDBC Password	`FDJDBC_PASSWORD`	No	The password of the username.
JDBC Driver Path	`FDJDBC_DRIVER_PATH`	Yes	Classpath for locating the JDBC Driver (e.g. for Weblogic - `{ORACLE_HOME}/oracle_common/modules/oracle.jdbc_11.2.0/ojdbc6.jar`).

Project Properties

Property Name	Property Code	Required	Description

Property Name	Property Code	Required	Description
JDBC Catalog Name	`FDJDBC_CATALOG_NAME`	No	The table catalog that contains the table to export.
JDBC Schema Name	`FDJDBC_SCHEMA_NAME`	No	The table schema that contains the table to export.
JDBC Table Name	`FDJDBC_TABLE_NAME`	Yes	The name of the table that contains the data to export.
JDBC Fields	`FDJDBC_FIELDS`	No	A comma-separated list of columns to include in the CSV file. If this input is left unspecified all columns will be exported.

Input Name	Input Code	Required	Description

Input Name	Input Code	Required	Description
User	`FDJDBC_INP_USER`	No	The username that will be used to connect with. This input takes precedence over the Target scoped `FDJDBC_USER` property. This input is required if the `FDJDBC_USER` property is not specified.
Password	`FDJDBC_INP_PASSWORD`	No	The password for `FDJDBC_INP_USER`. This input takes precedence over the Target scoped `FDJDBC_PASSWORD` property. This input is required if the `FDJDBC_PASSWORD` property is not specified.
Null String	`FDJDBC_INP_NULL_STRING`	No	A string that will be inserted into the CSV file to represent a null value.

This operation produces a CSV file that will be stored in the artifacts repository.

This operation will select all available endpoints associated to the target.

This operation will randomly execute on one of the endpoint identified during selection.