import (JDBC)

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

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 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

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 artifact 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 endpoints 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.

The following macros are not currently supported in the footer:
  • style