X hits on this document

387 views

0 shares

1 downloads

0 comments

123 / 131

Enables simple Changed Data Capture on Sybase Adaptive Server Enterprise.

Load

LKM SQL to Sybase ASE (BCP)

Loads data from any SQL compliant database to a Sybase Adaptive Server Enterprise staging area database using the BCP (Bulk Copy Program) utility.

This LKM unloads the source data in a temporary file and calls the Sybase BCP utility to populate the staging table. Because this method uses the native BCP utility, it is often more efficient than the “LKM SQL to SQL” method when dealing with large volumes of data.

Consider using this LKM if your source data located on a generic database is large, and when your staging area is a Sybase Adaptive Server Enterprise database.

Load

LKM Sybase ASE to Sybase ASE (BCP)

Loads data from a Sybase Adaptive Server Enterprise source database to a Sybase Adaptive Server Enterprise staging area database using the native BCP out/BCP in commands.

This module uses the native BCP (Bulk Copy Program) command to extract data in a temporary file. Data is then loaded in the target staging Sybase Adaptive Server Enterprise table using the native BCP command again. This method if often more efficient than the standard “LKM SQL to SQL” when dealing with large volumes of data.

Consider using this LKM if your source tables are located on a Sybase Adaptive Server Enterprise instance and your staging area is on a different Sybase Adaptive Server Enterprise instance.

Specific Requirements

Some of the Knowledge Modules for Sybase Adaptive Server Enterprise use the BCP specific loading utility. The following restrictions apply when using such Knowledge Modules. Refer to the Sybase Adaptive Server Enterprise documentation for additional information on these topics.

  • 1.

    The BCP utility as well as the Sybase Adaptive Server Enterprise Client must be installed on the machine running the Oracle Data Integrator Agent.

  • 2.

    The server names defined in the Topology must match the Sybase Adaptive Server Enterprise Client connect strings used for these servers.

  • 3.

    White spaces in server names defined on the Client are not supported.

  • 4.

    The target staging area database must have option "select into/bulk copy"

  • 5.

    Execution can remain pending if the file generated by the BCP program is empty.

  • 6.

    For performance reasons, it is often recommended to install Oracle Data Integrator Agent on the target server machine.

Knowledge Modules Reference Guide

123/131

Document info
Document views387
Page views390
Page last viewedWed Dec 07 20:16:20 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments