import (JDBC)
- Copy Page Tree
- Karl Henselin
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 |
| 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 - {ORACLE_HOME}/oracle_common/modules/ oracle.jdbc_11.2.0/ojdbc6.jar). |
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 environment instance scoped |
| Password |
| No | The password for |
| 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.
- style