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.

  

Environment/Instance 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 environment instance 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 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.

 

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.