3Import Marketing Data

About Marketing Integrations

Integrate Oracle Responsys and Oracle Adaptive Intelligent Apps for Customer Experience to get real-time bi-directional data transfer. When you add adaptive intelligent switches to your marketing programs, the switches send and receive decisions. You also activate scheduled data imports from Oracle Responsys. These imports provide an ongoing feed of marketing behavior to train the machine-learning models, giving you continuous improvements to performance.

If you have multiple Oracle Responsys accounts, you can connect all of them to a single Oracle Adaptive Intelligent Apps for CX tenant. You can then send prediction requests and publish programs for all the accounts.

See also: Import Data from Oracle Responsys.

Import Data from Oracle Responsys

You must complete steps both in Oracle Responsys and Oracle Adaptive Intelligent Apps to connect to and import data from Oracle Responsys. Use this flow chart for a summary of steps that you must do in both applications.

Flow chart that provides steps that you must perform in Oracle Responsys and in Oracle Adaptive Intelligence Apps to connect to and import data from Oracle Responsys.

To import data from Oracle Responsys:

  1. Sign in to Oracle Responsys and find the connection information:

    1. Click Account.

    2. On the Account Management page, click Responsys Adaptive Intelligence Connectivity in the Adaptive Intelligence section.

    3. On the Responsys – Adaptive Intelligence Connectivity page, copy values from the following fields in the Responsys Connection Information section:

      • Account Name

      • Service Endpoint URL

      • API Key: If the API key isn’t visible, click Edit, and then click Generate New Key to view the key.

      • Host Name and User Name under Responsys File Area

  2. Sign in to Oracle Adaptive Intelligent Apps for Customer Experience (CX) to paste the information that you copied:

    1. Click Connections and then click Data Sources.

    2. Click Oracle Responsys.

    3. In the Add Responsys Connection dialog box, paste the information you copied from Oracle Responsys.

    4. Enter the Oracle Responsys file area path where you want to export the files for Adaptive Intelligent Apps. For example, /download/aiapps. This action creates a new folder in the specified path when you successfully connect to Oracle Responsys and upload the SSH2 key.

      If you’re importing data from more than one Oracle Responsys account, you can select a different file area path for each of your accounts.

    5. Click Connect.

    The connection is saved. You see the Data Sources page showing the connection information for Oracle Adaptive Intelligence Apps. If you don't see the connection information, click the Manage Connection button for the Oracle Responsys connection to view it.

  3. Copy the following information from the Oracle Adaptive Intelligence connection information:

    • Oracle Adaptive Intelligence API Key

    • Service Endpoint URL

    • Security Endpoint URL

  4. Click Download SSH2 Key to download the public key file to upload it on Oracle Responsys.

    A .pub file containing the key is downloaded.

    Note: If you want to import data from multiple Oracle Responsys accounts, use the same SSH2 key.
  5. On the Oracle Responsys Account Management page, register Oracle Adaptive Intelligent Apps for CX:

    1. Click Responsys – Adaptive Intelligence Connectivity in the Adaptive Intelligence section.

    2. On the Responsys – Adaptive Intelligence Connectivity page, paste values that you copied from the Oracle Adaptive Intelligence Connection Information section.

    3. Click Test Connection and confirm that the connection is successful.

  6. Upload the SSH2 key file to Oracle Responsys:

    1. On the Account Management page, click Manage SSH2 Keys in the Account Customization section.

      If you don’t have the option to manage SSH2 keys, send your downloaded SSH2 key to Oracle Support so that they can upload it.

    2. On the Manage SSH2 Keys page, add the key:

      1. Select the SCP user from the list.

      2. Add a description of the key in the Tag name for key field.

      3. Click Select from the Select Key field and upload the SSH2 key from the download location.

      4. Click Add key.

        The key appears in the list of keys on the page. The status shows processing and changes to completed after an approval process in Oracle Responsys. Oracle Adaptive Intelligent Apps creates the folder based on the Responsys file area path that you entered on the Add Responsys Connection dialog box.

  7. Export contacts list, app channel list, and feed data from Oracle Responsys. For details, see Export Data from Oracle Responsys.

If you want to import data from another Oracle Responsys account, follow the same steps and use the SSH2 key that you already downloaded.

Export Data from Oracle Responsys

After setting up your connection to Oracle Responsys, you must configure regular exports of the contact list, app channel list, and feed data. Adaptive intelligence models make better predictions when they have more data available. Exporting data from Oracle Responsys regularly ensures that the adaptive intelligence models have the latest data.

To prepare the exports:

  1. Create an export job for the contacts list.

  2. Create an export job for the app channel list.

  3. Configure a feed data export.

Create an Export Job for the Contacts and the App Channel Lists

Note: You need to export the app channel list only if you have push notifications.
  1. Sign in to Oracle Responsys.

  2. Click Data, and then click Connect.

  3. On the Manage Connect page, click Create Job.

  4. In the Create Job dialog box, select Export Data as the job you want to create.

  5. Enter a name for the export job.

    • For contacts list, enter AI Apps Contacts List Export.

    • For app channel list, enter AI Apps App Channel List Export.

    This screenshot shows an example of exporting the contacts list.

    Export data page in Oracle Responsys
  6. Optionally, provide a description.

  7. Click Create.

    The export job is created.

    You don’t want the export job that you’re creating to expire. Click the edit icon for Expiration and select Never expires in the Edit expiration date dialog box.

    This screenshot shows the Expiration edit icon for contacts list export.

    Select Object step in the Export Data process
  8. In the Select Object section:

    1. Select List if you're exporting contacts list. Select App channel list if you're exporting app channel list.

    2. Select the Only export records inserted or updated since the time of last job run check box.

  9. Click Destination Connectivity.

  10. In the Destination Connectivity section:

    1. Select Responsys File Server from the list.

    2. Change the path to the path that you entered while creating the connection.

  11. Click Destination Specification.

  12. In the Destination Specification section, complete the fields as indicated in this table.

    Field Value
    File to be created (prefix, name of the file, suffix and file extension)
    • No prefix

    • CONTACT_LIST_ or APPCHANNEL_LIST_ (depending on which list you're exporting)

      Don’t enter any other name for the file.

    • YYYYMMDD_HH24MISS

    • .txt
    Character set Unicode (UTF-8)
    Field delimiter Tab

    Tab is the recommended delimiter. You can also select your preferred delimiter.

    Field enclosure
    Insert column header as first line Select
    Encryption/compression Compress to file (zip or gz)

    Compress and encrypt file with PGP/GPG Key is not supported. If you want to encrypt your exports, contact Oracle Support.

    Additional ready file at completion of download Do not create
  13. Click Notification.

  14. Optionally, add a notification to the job so that you know if the job fails.

  15. Click Schedule.

    You can repeat this process for all contact lists and app channel lists that you want to export. Ensure that you set the exports for slightly different times of the day.

    This screenshot shows an example of the schedule for contacts list export.

    The Schedule step of the export data process.
  16. In the Schedule section:

    1. Select Recurring and Daily.

    2. Select a date and time that works for your account activity, and set the recurring frequency to every day with no end date.

    3. Click Activate to save and activate the export job.

Configure a Feed Data Export

Let’s look at two scenarios:

  • Add a file location to any existing export jobs for contact events. If the contact events are partially exported in one job, and partially exported in another, follow the steps described in the section Add a File Location to an Existing Export Job.

  • Set up a new feed export for any contact events that you don't currently export. See the section Set Up a New Export Feed for details. If the contact events are partially exported in one or many jobs, and the rest are not exported at all, see the section Add a File Location to an Existing Export Job. Follow these steps on all existing export jobs.

Add a File Location to an Existing Export Job

  1. Navigate to the Responsys Connect data export tool.

  2. On the Connect page, filter the job type to Export Feed Data and click Submit.

  3. Select your existing export job and ensure that it’s exporting events for Sent, Open, Click, Convert, and Launch State at the minimum.

  4. Navigate to Destination Connectivity.

    Destination Connectivity step of the export feed data process.
  5. Click Add location.

  6. With the new file location highlighted, select Responsys File Server from the list.

  7. Change the path to the path that you entered while creating the connection.

  8. Click the arrow and complete all the steps in the rest of the process.

    Set the Destination Specification section according to the specifications detailed in the section Create an Export Job for the Contacts List. Set the schedule to six times a day. If you’re using different settings for your current export, contact Oracle Support.

  9. Click Save and Close.

Set Up a New Export Feed

  1. Navigate to the Responsys Connect data export tool and select Export Feed Data Job to create an export job.

  2. Select the event files Sent, Open, Click, Convert, and Launch State.

  3. Click Destination Connectivity.

  4. In the Destination Connectivity section, select Responsys File Server from the list.

  5. Change the path to the path that you entered while creating the connection.

  6. Click Destination Specification.

  7. Use this table to complete the Destination Specification section.

    Field Value
    Character set Unicode (UTF-8)
    Field delimiter Tab

    Tab is the recommended delimiter. You can also select your preferred delimiter.

    Field enclosure
    Insert column header as first line Select
    Encryption/compression Compress to file

    Compress and encrypt file with PGP/GPG Key is not supported. If you want to encrypt your exports, contact Oracle Support.

    Additional ready file at completion of download Do not create
  8. Click Notification, and optionally add a notification to the job.

  9. Click Schedule. If your schedule isn’t already set, set it to six times a day.

  10. Click Activate to save and activate the export job.