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