1. Using the SAP ASE (Sybase) Adapter with Oracle Integration 3
  2. Implement Common Patterns Using the SAP ASE (Sybase) Adapter
  3. Import Data Files Using the Bulk Data Import Operation

Import Data Files Using the Bulk Data Import Operation

This use case describes how to import data files from an FTP server into the SAP ASE (Sybase) database. Similarly, you can import data files from an application into the SAP ASE (Sybase) database using the SAP ASE (Sybase) Adapter.

To perform this operation, you create the FTP Adapter and SAP ASE (Sybase) Adapter connections in Oracle Integration. The SAP ASE (Sybase) Adapter first validates an input file header with the target table header (columns), places file data into a mount location (local to the database), and then inserts the mount location data into the target table if the data is in the expected format.
  1. Create a schedule integration.
  2. Drag an FTP Adapter into the integration canvas.
  3. Configure the FTP Adapter as follows.
    1. On the Basic Info page, provide a name.
    2. On the Operations page, select Download File from the Select Operation list.
    3. Select Binary from the Select a Transfer Mode list.
    4. Provide the input directory, file name, and download directory.
    5. On the Summary page, review your selections.
  4. Drag an SAP ASE (Sybase) Adapter into the integration canvas.
  5. Configure the SAP ASE (Sybase) Adapter endpoint:
    1. On the Basic info page, provide an endpoint name, select Perform Bulk Data Import Operation, and click Next.
    2. On the Bulk load from File to table page, enter the mount location, and select the delimiter (for example, comma), schema, table, and table columns.
    3. On the Summary page, review your selections, and click Done.
  6. In the mapper, map the file reference from the FTP response to pass the data to the target table. The FTP response (file reference) provides an input to the SAP ASE (Sybase) database.
  7. Click Validate, and then click Close. The completed integration looks as follows.

    The integrations shows a schedule, mapper, FTP Adapter invoke, mapper, and invoke.

  8. When complete, save and activate the integration. As a result, the SAP ASE (Sybase) Adapter inserts the mount location data into the target table if the data is in the expected format.