You can use this component to add data into the Sybase IQ table, from files that are located on a different host machine than Sybase IQ. You need not install Sybase ETL and Sybase IQ on the same machine; ETL Server and Sybase IQ can communicate in a networked environment, allowing you to bulk-load from a remote machine in a single step. To support client-side:
Install the Sybase IQ 15 client on the same machine as ETL Server.
Install the Sybase SQL Anywhere 11 ODBC driver on the same machine as ETL Development and ETL Server.
The target IQ database version must be Sybase IQ 15.0.
On each Sybase IQ 15.0 server, enable the allow_read_client_file and allow_write_client_file options. To set these options:
From Sybase Central™, connect to the Sybase IQ 15.0 server.
Right-click the Sybase IQ server database name and select Options.
Select allow_read_client_file and allow_write_client_file options and change their values to On. By default, the value is Off.
Enable the allow_read_client_file server option property using the isql or dbisql utility:
set option allow_read_client_file=on GRANT READCLIENTFILE TO <group | user>
Once you have completed these prerequisites, select Use IQ Client Side Load in the Properties window of the component. Also, select ODBC as the interface, or you may encounter errors loading data from remote host machines. Client-side loading works only with ODBC when the ODBC driver being used is an IQ 15 ODBC driver.
If you select Use IQ Client Side Load to enable bulk
loading of data into the IQ database from files located on client
machines, provide a file path name instead of a pipe name in the
Load Stage property field. Client side loading is not supported using
Load Stage pipe names.
