Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Property Name

Property Code

Required

Description

JDBC Catalog Name

FDJDBC_CATALOG_NAME

No

The table catalog that contains the table to export.

JDBC Schema Name

FDJDBC_SCHEMA_NAME

No

The table schema that contains the table to export.

JDBC Table Name

FDJDBC_TABLE_NAME

Yes

The name of the table that contains the data to export.

JDBC Fields

FDJDBC_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

FDJDBC_INP_USER

No

The username that will be used to connect with. This input takes precedence over the Target scoped FDJDBC_USERproperty. This input is required if the FDJDBC_USERproperty is not specified.

Password

FDJDBC_INP_PASSWORD

No

The password for FDJDBC_INP_USER. This input takes precedence over the Target scoped FDJDBC_PASSWORDproperty. This input is required if the FDJDBC_PASSWORDproperty is not specified.

Null String

FDJDBC_INP_NULL_STRING

No

A string that will be inserted into the CSV file to represent a null value.

Where Clause To Filter Records

FDJDBC_INP_FILTER

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.

...