Drag IQ Loader DB via Insert Location component into the Design window.
Enter IQ database connection properties for the destination database.
Host – Select the IQ host.
User – Enter an authorized database user name.
Password – Enter the password for the database user.
Database – Select the database you want to use as the destination database.
Schema – Select schema/owner to restrict the objects displayed and create new tables in that schema.
Click Processing to specify Pre-Processing SQL and Post-Processing SQL on the IQ destination database.
Click Logon to view the list of available tables.
Click Next.
Enter connection information for the source database and select the tables to transfer.
Select the Use remote server definition for accessing source database option to get data and metadata from the source. Select this option only if you have defined the source server as a remote server on the destination IQ database using the Create Server command. If you do not select this option, you are directly connected to the source data using the configuration information provided in the .INI or interfaces file.
Host – Select the data source.
Database – Select the database you want to use.
Schema – Select schema/owner to restrict the objects displayed and create new tables in that schema.
Click Processing to specify Pre-Processing SQL and Post-Processing SQL on the source database.
Select the Create Target Tables option to create the destination tables if they do not exist.
Select the Continue on Error option if you want the processing to continue, even if an error occurs when loading data into a database.
Select the Encrypted Password option to transmit the password in encrypted format.
When used as a remote server, Sybase IQ does not support password
encryption.
Select the Use IQ Multiplex option to support multiplex execution by using multiple writers for loading data to IQ. Select this option if more than one table is being migrated to the IQ database.
Select the Lock Table option to lock the target table in Exclusive mode and prevent it from being updated by concurrent transactions. If selected, no other transaction can execute queries or perform any updates against the locked table. The Lock Table option also queues multiple projects that load the same table in Sybase IQ.
If you select this option, you must also specify the maximum blocking time that the project should wait, before acquiring the lock.
Enter a network packet size in the Packet Size field.
Enter a value for Limit Rows.
Specify the number of rows to skip at the beginning of the input table(s) for a load in the Skip Rows field.
Click Logon to view the list of available tables for the specified database. By default, each table is selected for transfer. Unselect the Transfer option for tables you do not want to transfer. You can also choose one or multiple table rows, right-click and select Exclude. To include a table for transfer, right-click and select Transfer.
Alternatively:
Click the Exclude all objects from transfer icon to exclude all tables.
Click the Include all objects in transfer icon to include all tables.
Click Next.
Verify the source tables. They should be in the following format:
source_schema.source_table
Select the destination table(s) from the drop-down menu. There should be a one on one mapping (one source for each destination) between sources and destinations.
Click the Truncate Destination option to delete all existing data rows from the destination table.
Click Next.
Review the load configuration summary. Click Finish.
