You can load data into the Sybase IQ table, from files that are located on a different host machine than Sybase IQ. You need not install Sybase IQ InfoPrimer Development and Sybase IQ on the same machine; Sybase IQ InfoPrimer 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 load support:
Install the Sybase IQ 15.0 client on the same machine as Sybase IQ InfoPrimer Server.
Install the Sybase SQL Anywhere 11 ODBC driver on the same machine as Sybase IQ InfoPrimer Development and Sybase IQ InfoPrimer Server.
The target IQ database version must be Sybase IQ 15.x.
On each Sybase IQ 15.x 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.x 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.0 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.
You are required to make some additional configurations to enable support for multiplex execution by using multiple writers for loading data to IQ.