Drag DB Bulk Load Sybase IQ onto the Design window.
Connect the IN-port of DB Bulk Load Sybase IQ to the OUT-port of the component that provides the inbound data.
On the Database Configuration window, add the Sybase IQ connection parameters.
Click the Destination icon and select the table where you want to load the inbound data. To write to a new destination table, see “Adding new Sybase IQ destination tables”.
Click the Load Stage icon. You can either:
Select or enter the file name you want to use as a temporary data file and click Save, or,
Add a pipe name in the Load Stage field (syntax: pipe://).
See “DB Bulk Load Sybase IQ properties list” for specific field requirements.
Click Finish.
To add DB Bulk Load IQ to your project:
Sybase IQ must be up and running before you add the component to your project. You can increase performance if you run both ETL Server and the IQ database on the same machine; however, this is not required.
To connect to the target database on IQ, select a valid host name and interface. See “DB Bulk Load Sybase IQ properties list” for specific field requirements.
To load the data into a new IQ table, you can create a destination table based on DB Bulk Load’s IN-port or the structure of any available port in the project. See “Adding new Sybase IQ destination tables”.
To customize the script, right-click the DB Bulk Load IQ component, and select Generate Load Script. Click the Load Script icon in the Properties window, edit, and save your script.
Updating port structure with database changes