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 data source when it reads from a source database and a data sink when it writes to a Sybase IQ database. It does not have IN-ports and OUT-ports, therefore, there is no need to create one component for performing the read from the source database and another component for invoking Insert Location in Sybase IQ. ETL 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. ETL 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 Manuals Web site.
Sybase is the only interface supported by the IQ Loader
DB via Insert Location component.
