Imports data from a CSV file into a database table.

Environment/Instance Properties

Property Name	Required	Description
`FDJDBC_URL`	Yes	The JDBC URL of the database.
`FDJDBC_USER`	No	The username that will be used to connect.
`FDJDBC_PASSWORD`	No	The password for `FDJDBC_USER`.
`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	Required	Description
`FDJDBC_CATALOG_NAME`	No	The table catalog that contains the table to import into.
`FDJDBC_SCHEMA_NAME`	No	The table schema that contains the table to import into.
`FDJDBC_TABLE_NAME`	Yes	The name of the table that contains the data to import into.

Inputs

Input Name	Required	Description
`FDJDBC_INP_USER`	No	The username that will be used to connect with. This input takes precedence over the environment instance scoped `FDJDBC_USER` property. This input is required if the `FDJDBC_USER` property is not specified.
`FDJDBC_INP_PASSWORD`	No	The password for `FDJDBC_INP_USER`. This input takes precedence over the environment instance scoped `FDJDBC_PASSWORD` property. This input is required if the `FDJDBC_PASSWORD` property is not specified.
`FDJDBC_INP_NULL_STRING`	No	A string within the CSV that represents a null value.

Outputs

Output Name	Required	Description

Artifacts

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

Endpoint Selection

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

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.

FlexDeploy 3.7

import (JDBC)