2 Before You Install the Recipe
You must perform the following configuration tasks on your SAP ASE (Sybase) and Oracle Unity instances in order to successfully connect to these external systems using Oracle Integration and import customers and credit card transactions.
Configure SAP ASE (Sybase)
To successfully connect to SAP ASE (Sybase) using Oracle Integration and import customers and credit card transaction data, you must perform certain configurations on SAP ASE (Sybase).
- Ensure that you have write permissions on the database.
- Ensure that you have the required permissions to run stored procedures and packages and SQL statements against the SAP ASE database.
- Know the database hostname or IP address and the port number.
- Know the database name.
- Know the user name and password for connecting to the database.
- Install the connectivity agent. The connectivity agent is required to connect Oracle Integration with an SAP ASE (Sybase) on-premises database. See Configure the Endpoint Access Type.
- Download a Java Database Connectivity (JDBC) .jar file and place it in the third-party lib folder while configuring the connectivity agent. A JDBC driver enables a Java application to interact with a database. See SAP ASE JDBC Driver.
Configure Oracle Unity
To configure Oracle Unity, see Prerequisites for Creating a Connection.
Create custom object for credit card transactions by adding fields such as Card Number, Remarks, Status, Card Type, TRXAMT, TRXDATE, Customer ID and so on. For generic instructions to create custom objects in Oracle Unity, see Creating custom data objects.