IQ Loader DB via Insert Location component loads data from the source database into the target IQ database using the Insert Location statement.
This is a self contained component that operates as a data source when it reads from a source database and a data sink when it writes to a Sybase IQ database. This component does not have input and output ports. Therefore, there is no need to create one component for performing the read from the source file 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 Sybase Adaptive Server Enterprise, Oracle, IBM DB2, and Microsoft SQL Server. ETL 4.8 supports Sybase ECDA 15.0 with IBM DB2 9.1, Oracle 10g, and Microsoft SQL Server 2005.
See the Sybase Product Manuals Web site for Sybase ECDA documentation.
