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 |
| Yes | The JDBC URL of the database. |
JDBC User |
| No | The username that will be used to connect with. |
JDBC Password |
| No | The password of the username. |
JDBC Driver Path |
| Yes | Classpath for locating the JDBC Driver (e.g. for Weblogic - |
...
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
JDBC Catalog Name |
| No | The table catalog that contains the table to import into. |
JDBC Schema Name |
| No | The table schema that contains the table to import into. |
JDBC Table Name |
| Yes | The name of the table that contains the data to import into. |
Inputs
Input Name | Input Code | Required | Description |
|---|---|---|---|
User |
| No | The username that will be used to connect with. This input takes precedence over the |
target scoped | |||
Password |
| No | The password for |
target scoped | |||
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 artifact from the artifacts repository.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instancetarget.
Endpoint Execution
This operation will randomly execute on one of the endpoint 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.