Imports data from a CSV file into a database table.

The filename should be 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.

Inputs

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.

Artifacts

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

Endpoint Selection

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

Endpoint Execution

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

Special Considerations

The import function uses the FDJDBC_INP_NULL_STRING to identify a String value within the CSV file that represents null. When the CSV file is parsed, this string will be replaced with a null for the database insert.

Replacement Properties

See Appendix.

import (JDBC)