Imports data from a CSV file into a database table.
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.
...