1. Import Customers and Credit Card Transactions from SAP ASE (Sybase) to Oracle Unity
  2. About This Recipe

1 About This Recipe

Use this recipe to import customers and credit card transactions from SAP ASE (Sybase) to Oracle Unity.

Note:

This recipe is available as SAP ASE (Sybase) — Oracle Unity | Import Customers and Transactions in Oracle Integration. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe imports customer records and credit card transaction data from SAP ASE (Sybase) to Oracle Unity.

To use the recipe, you must install the recipe project and configure the connections and other resources within it. You can activate and run the integration flows manually or specify execution schedules for them. To fetch customer records from SAP ASE (Sybase) and import them to Oracle Unity, run the Oracle Sybase Unity Customer Synch integration flow. Similarly, to fetch credit card transaction records from SAP ASE (Sybase) and import them to Oracle Unity, run the Oracle Sybase Unity CC Transaction Sync integration flow.

System and Access Requirements

  • Oracle Integration, Version 24.10 or higher

  • SAP ASE (Sybase)

  • An account on SAP ASE Sybase with the Administrator role

  • Oracle Unity

  • An account on Oracle Unity with the Administrator role

Assumption

Ensure that the tables for customer profile data and transaction data are available in SAP ASE (Sybase) database.

Download create_table_query_sybase.sql for the sample table structure of the CustomerProfile table which stores customer profile data and CustTransactions table which stores transactions data.

Note:

More fields can be added, or another table may be used; the SAP ASE (Sybase) endpoint in the recipe may then be modified as necessary.