2 Before You Install the Recipe

You must perform the following configuration tasks on your Oracle SQL Developer instance to successfully connect to Oracle Integration and import customer contact details from Oracle ATP database to Oracle Responsys.

Log in to Oracle SQL Developer instance as an Administrator and perform the following tasks.

1. Create a new connection to Oracle ATP Database using Oracle SQL Developer
   1. Under the Connections pane on the left, click the plus sign + to create a new connection.
   2. In the New/Select Database Connection window, enter the following details:
      1. Enter the Name of the connection.
      2. Enter the Username and Password.
      3. Select Cloud Wallet from the Connection Type drop-down list.
      4. Click Browse next to the Configuration File field and upload the Oracle ATP wallet file. To obtain the wallet file, see Prerequisites for Creating a Connection.
      5. Enter the Service.
      6. Click Test to check if the connection is successful.
      7. Click Save.
   The new connection appears under the Connection pane.
2. Create a new database table.
   1. Under the Connection pane, expand the new connection to load all the objects under it.
   2. Right-click Tables (Filtered) and select New Table from the menu that displays.
   3. In the Create Table window, enter the name of the table in the Name field.
   4. Define the Name and Datatype columns in the table by entering the following information.

      Column Name	Datatype
      CUSTOMERID	VARCHAR2(100 BYTE)
      EMAIL	VARCHAR2(100 BYTE)
      FIRSTNAME	VARCHAR2(100 BYTE)
      LASTNAME	VARCHAR2(100 BYTE)

   5. Commit the changes.
3. Send the data from the newly created database table to a queue table by running the following script: Oracle_SQL_Developer_script.