Imports data from a CSV file into a database table.

The filename should be the {tablename}.csv, and it the FDJDBC_TABLE_NAME.csv. The file must be in the FD_ARTIFACTS_DIR.

Target Properties

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
JDBC Catalog Name	`FDJDBC_CATALOG_NAME`	No	The table catalog that contains the table to import into.
JDBC Schema Name	`FDJDBC_SCHEMA_NAME`	No	The table schema that contains the table to import into.
JDBC Table Name	`FDJDBC_TABLE_NAME`	Yes	The name of the table that contains the data to import into.

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

environment instance

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

environment instance

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.

Output Name

Required

Description

This operation consumes a CSV file artifacts artifact from the artifacts repository.

...

This operation will select all available endpoints associated to the environment/instancetarget.

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

...