Sybase IQ

Sybase IQ version

Currently supported versions

Select the version of SAP Sybase IQ that this datastore accesses. Displayed options in the rest of the datastore editor vary depending on the version selected.

Use Data Source (ODBC)

Yes

No

Select to use a DSN to connect to the database.

By default, this option is set to Yes. To use a DSN connection, you must also specify the ODBC data source name.

If you set this option to No, you must also specify the Database server name, Database name, and Port number for a DSN-less connection.

ODBC data source name

Refer to the requirements of your database

Type the data source name defined in the ODBC Administrator for connecting to your database.

This option is required if Use data source (ODBC) is set to Yes.

Database server name

Computer name or IP address

Type the computer name or IP address.

This option is required if Use data source (ODBC) is set to No.

Database name

Refer to the requirements of your database

Type the name of the database defined in SAP Sybase IQ.

This option is required if Use data source (ODBC) is set to No.

Port number

Integer

Type the number of the database port.

This option is required if Use data source (ODBC) is set to No.

Server name

Refer to the requirements of your database

Type the SAP Sybase IQ database server name.

This option is required if Use data source (ODBC) is set to No.

User name

Alphanumeric characters and underscores

Enter the user name of the account through which the software accesses the database.

Password

Alphanumeric characters, underscores, and punctuation

Enter the user's password.

Rows per commit

Positive integer

Default: 1000

Enter the maximum number of rows loaded to a target table before saving the data. This value is the default commit size for target tables in this datastore. You can overwrite this value for individual target tables.

Overflow file directory

Directory path

Enter the location of overflow files written by target tables in this datastore. You can enter a variable for this option.

Language

SAP-supported ISO three-letter language codes or <default>

Select the language from the possible values in the drop-down list. The <default> option sets the language to the system language of the SAP Data Services Agent host system.

Code page

-

Specify the character encoding of character data in the datastore.

Server code page

-

Specify the character encoding of character data in the datastore.

Enable linked remote servers

Yes

No

This option lets you use the INSERT…LOCATION SQL statement for a data flow that uses SAP Sybase IQ as the loader and SAP ASE or SAP Sybase IQ as the reader. The Data Services engine pushes down the SQL statement for the SAP Sybase IQ server location. Type Yes to use remote servers that have already been linked.

To define a remote server, use the CREATE SERVER SQL statement in SAP Sybase IQ. To set up the remote login for users, use the CREATE EXTERNLOGIN SQL statement.

For detailed information about the SQL statements, see the relevant SAP Sybase IQ product documentation.

Additional session parameters

A valid SQL statement or multiple SQL statements delimited by semicolon

Additional session parameters specified as valid SQL statement(s).

Aliases

Enter the alias name and the owner name to which the alias name maps.