Exports data from a database table into a CSV file.
The file will be named FDJDBC_TABLE_NAME.csv. The file will be created 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 export. |
JDBC Schema Name |
| No | The table schema that contains the table to export. |
JDBC Table Name |
| Yes | The name of the table that contains the data to export. |
JDBC Fields |
| No | A comma-separated list of columns to include in the CSV file. If this input is left unspecified all columns will be exported. |
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. |
Where Clause To Filter Records |
| No | An Input filter which works as a where condition in the SQL Query (e.g. CompanyName='Flexagon'). Note: "where" keyword is not required to be mentioned, just the criteria is required. |
Artifacts
This operation produces a CSV file that will be stored in 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 endpoint identified during selection.