Loading
Salesforce now sends email only from verified domains. Read More
Integrate and Analyze Marketing Data with Marketing Cloud Intelligence
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Interaction Studio API Connector

            You are here:

            1. Salesforce Help
            2. Docs
            3. Marketing Cloud Intelligence

            Interaction Studio API Connector

            Use the Interaction Studio API connector to explore and pull personalization data from your Marketing Cloud Personalization (formerly Interaction Studio) Data Warehouse.

            Required Editions

            User Permissions Needed
            To create an API connector: Admin
            Note
            Note The Personalization Data Warehouse is available only for customers who have already purchased the Marketing Cloud Personalization - Data Warehouse add-on product.
            1. Get your Marketing Cloud Personalization credentials for Marketing Cloud Intelligence.
              1. Log into Personalization.
              2. On the left, click Security and then select Manage Data Warehouse.
              3. Copy the connectionString from the top of the screen.
              4. Create a user for Marketing Cloud Intelligence. You need the User name and Password to set up the connector in Intelligence.
              5. In the Data Warehouse IP allow-list, add these IP addresses:
              PLATFORM.DATORAMA.COM (AWS US) PLATFORM-US2.DATORAMA.COM (AZURE US) PLATFORM-EU.DATORAMA.COM (AWS EU) PLATFORM-EU2.DATORAMA.COM (AZURE EU)
              54.163.226.11 20.41.43.59 35.157.8.65 40.67.249.123
              54.83.10.143 20.44.73.165 54.93.174.35 52.155.226.154
              54.227.219.146 40.65.212.209   52.155.230.152
            2. In Marketing Cloud Intelligence, on the Connect & Mix tab, expand Data Streams.
            3. Click Add New and select the Interaction Studio connector.
            4. Enter this information:
              1. Host: client-TestClientName.abn45544mmvmvmg.eu-central-1.redshift.amazonaws.com
              2. Port: 5439
              3. Database: TestDatabaseName
            5. Click the edit button and paste the connection string from Personalization.
            6. In the User and Password fields, add the details for the user you created in Personalization.
            7. Find your datasets in Personalization.
              1. Click the database icon near your profile name (1).
              2. Click Manage Datasets (2).
                showing interaction studio database icon
            8. Create the query for the datasets you found in step 7 using this pattern: select * from dataSetName. For example, select * from dataSetName.users.
            9. Click Evaluate to test the query, and then click Next.
             
            Loading
            Salesforce Help | Article