IQ Loader DB via Insert Location

The IQ Loader DB via Insert Location component loads data from the source database into the target IQ database using the Insert Location statement.

This self-contained component operates as a datasource when it reads from a source database and a data sink when it writes to a Sybase IQ database. It does not have input ports and output ports, therefore, you do not have to create one component for performing the read from the source database and another component for invoking Insert Location in Sybase IQ. Sybase IQ InfoPrimer automatically generates Insert Location statements to transfer data from the source database to Sybase IQ. Insert Location:

Allows you to move columns from Sybase IQ versions earlier than 12.0 to version 12.0 and later.
Provides optimized load to Sybase IQ from Adaptive Server Enterprise or Sybase IQ.
Also works with Sybase Enterprise Connect™ Data Access (ECDA) to load Sybase IQ from Oracle, IBM DB2, and Microsoft SQL Server. Sybase IQ InfoPrimer supports Sybase ECDA 15.0 with IBM DB2 9.1, Oracle 10g, and Microsoft SQL Server 2005.

For Sybase ECDA documentation, see the Sybase Product Documentation Web site at http://www.sybase.com/support/manuals.

Note:

Sybase is the only interface supported by the IQ Loader DB via Insert Location component.

Configuring the IQ Loader DB via Insert Location Component
Add and configure a IQ Loader DB via Insert Location component to your project.
Setting Locales for Insert Location Statements
When you execute Insert Location statements, Sybase IQ loads the localization information needed to determine language, collation sequence, character set, and date/time format. If your database uses a non-default locale for your platform, you must set an environment variable on your local client to ensure that Sybase IQ loads the correct information.
IQ Loader DB via Insert Location Properties List
IQ Loader DB via Insert Location properties list identifies the connection parameters and other items you must define on the IQ Loader DB via Insert Location component window.

Parent topic: Loader Components