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