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 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).
      
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.