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 do not require to 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 Adaptive Server Anywhere (ASA) 11 ODBC driver on the same machine as ETL Development and ETL Server.
The target IQ database version must be Sybase IQ 15.
Enable the allow_read_client_file and allow_write_client_file options of the Sybase IQ 15.0 server. Set these options once on every IQ server. To set these options:
Go to Sybase Central and connect to the Sybase IQ 15.0 server.
Right-click the Sybase IQ server database name and select Options. A list of all the database options is displayed.
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 the Use IQ Client Side Load option 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 only works with ODBC, when the ODBC
driver being used is an IQ 15 ODBC driver.
