Common properties for DataStage connectors

Database

The name of the database.

Host

The hostname or IP address of the database.

Password

The password that is associated with the username for accessing the data source.

Username

The username for accessing the data source.

Port

The port of the database.

ssl

The port is configured to accept SSL connections. Default: false.

byte_limit

The maximum number of bytes to return. Use any of following suffixes to change the unit: KB, MB, GB, or TB. A value of 0 returns all data.

ssl_certificate_host

Hostname in the SubjectAlternativeName or Common Name (CN) part of the SSL certificate

ssl_certificate

The SSL certificate of the host to be trusted which is only needed when the host certificate is not signed by a known certificate authority

ssl_certificate_validation

Validate that the SSL certificate that is returned by the host is trusted.

retry_limit

Specify the maximum number of retry connection attempts to be made by the connector with an increasing delay between each retry. Default: 2

read_mode

The method for reading records from the table. Values: [general, select]. Default: general.

query_timeout

Sets the default query timeout in seconds for all statements that are created by a connection. Default: 300.

table_name

The name of the table to read from.

api_key

An application programming interface key that identifies the calling application or user.

decimal_rounding_mode

Different rounding modes for values in columns of decimal and numeric data types. Values: [ceiling, down, floor, halfdown, halfeven, halfup, up]. Default: floor.

call_statement

The SQL statement to execute the stored procedure.

select _statement

The SQL SELECT statement for retrieving data from the table.

schema_name

The name of the schema that contains the table to read from.

sampling_seed

Seed to be used for getting a repeatable sample.

sampling_percentage

Percentage for each row or block to be included in the sample.

sampling_type

Indicates which data sampling type should be used in the select statement. Values: [none, random]. Default: none.