1. Import Contacts from Oracle ATP to Oracle Responsys
  2. Install and Configure the Recipe

3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

  1. On the Oracle Integration Home page, in the Get started section, click Browse store.
  2. Find the recipe you want to install, then click Get.

    A message confirms that the recipe was successfully installed, and the recipe card shows In use.

  3. Click Configure Configure icon on the recipe to configure its resources.

    The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the AQ Cloud Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Host Not required if you are using Oracle Wallet as the security policy.
    Port Not required if you are using Oracle Wallet as the security policy.
    SID Not required if you are using Oracle Wallet as the security policy.
    Service Name

    Enter the logical representation of a service used for client connections.

    Note:

    The Service Name should be kept low profile and should be same as the tnsnames.ora file in the wallet. To know more, see Service Name Specified on the Connections Page is Too Long.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Oracle Wallet.
    Wallet Select the checkbox and click Upload to upload the wallet file in .zip format. See the Prerequisites to Use the Oracle Wallet Security Policy section in Prerequisites for Creating a Connection.
    Wallet Password Enter the wallet password.
    Database Service Username

    Enter the database username to connect to the Oracle Advanced Queuing (AQ) server account.

    Note:

    The Database Service Username is not the same as the Service Name which you specified in the Properties section above.
    Database Service Password Enter the database password to connect to the Oracle Advanced Queuing (AQ) server account.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the Oracle Responsys Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle Responsys log in URL.

    Note:

    The URL is provided by Oracle Support Services when Web Services is enabled on your account.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Custom Security Policy.
    Username Enter the username provided by Oracle Support Services once Web Service is enabled on your account.
    Password Enter the Password provided by Oracle Support Services once Web Service is enabled on your account.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the Lookup Table

Edit the ORCL-BRT-RESPONSYS_PROPERTIES lookup table to map ATP customer details to Oracle Responsys customer details.

  1. In the Lookups section, click the lookup name.
  2. The ORCL-BRT-RESPONSYS_PROPERTIES lookup table is used to store customer contact details. Edit it as necessary.
    Key Description Example
    HtmlValue Value of incoming preferred email format data. For example, H may represent a preference for HTML formatted email. H
    OptinValue Value of incoming opt-in status data that represents an opt-in status. For example, 1 may represent an opt-in status. 1
    TextValue Value of incoming preferred email format data. For example, T may represent a preference for Text formatted email. T
    InsertOnNoMatch Indicates what should be done for records where a match is not found (true = insert / false = no insert). true
    UpdateOnMatch Controls how the existing record should be updated. REPLACE_ALL
    MatchColumnName1 First match column for determining whether an insert or update should occur. EMAIL_ADDRESS_
    MatchOperator Controls how the boolean expression involving the match columns is constructed to determine a match between the incoming records and existing records. NONE
    DefaultPermissionStatus Controls how the boolean expression involving the match columns is constructed to determine a match between the incoming records and existing records. OPTIN
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.

Update Integration Properties

  1. In the Integrations section, click Actions Actions icon on the integration flow, then select Update property values.
  2. In the Update property values panel, update the integration properties with appropriate values.
    1. EmailTo: This integration property holds the email address to which error notifications are sent.
    2. retryCount: This integration property holds the number of retries when an invoke fails. The default value is 3.
  3. Click Submit.

    A message confirms that the integration properties have been updated successfully.