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. See “Adding new Sybase IQ destination tables” if you want to write to a new destination table.
Click the Load Stage icon. You can:
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://<name>).
See the “DB Bulk Load Sybase IQ properties list” for specific field requirements.
Click Finish.
For adding DB Bulk Load IQ to your project, make sure:
Sybase IQ must be up and running before you add DB Bulk Load IQ to your project. You can increase performance if you run both ETL Server and the IQ database on the same machine. This is not required.
To connect to the target database on IQ, you need to select a valid host name and interface. See the “DB Bulk Load Sybase IQ properties list” for specific field requirements.
If you want 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”.
If you want 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.
To update the port structure with changes made in the database:
Right-click the DB Bulk Load IQ component.
Select Reconfigure.
The Reconfigure option updates the component configuration when there is a change in the database schema. It closes the current connection, opens a new connection to the database, reads the metadata of the query, and applies the updates to the port structure.
Updating port structure