Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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.

Environment/Instance Properties

Property Name

Required

Description

FDJDBC_URL

Yes

The JDBC URL of the database.

FDJDBC_USER

No

The username that will be used to connect with.

FDJDBC_PASSWORD

No

The password of the username.

FDJDBC_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

Required

Description

FDJDBC_CATALOG_NAME

No

The table catalog that contains the table to export.

FDJDBC_SCHEMA_NAME

No

The table schema that contains the table to export.

FDJDBC_TABLE_NAME

Yes

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

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

Required

Description

FDJDBC_INP_USER

No

The username that will be used to connect with. This input takes precedence over the environment instance scoped FDJDBC_USER property. This input is required if the FDJDBC_USER property is not specified.

FDJDBC_INP_PASSWORD

No

The password for FDJDBC_INP_USER. This input takes precedence over the environment instance scoped FDJDBC_PASSWORD property. This input is required if the FDJDBC_PASSWORD property is not specified.

FDJDBC_INP_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 produces a CSV file that will be stored in 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.

Replacement Properties

See Appendix.

  • No labels