---
schema_version: "1"
id: ebacb7507bfe012f58b4af46bca3a259a38a3ac1ddc9602102209598a44eb6ac
title: Interaction Studio API Connector
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_streams_api_interaction_studio.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_streams_api_interaction_studio.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3384792ec9c9b6fb13bba01dc60937695aaa84f17dbb529fcc77f1a4613c210a
description: Use the Interaction Studio API connector to explore and pull personalization data from your Marketing Cloud Personalization (formerly Interaction Studio) Data Warehouse.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d86646e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d86646e38 ">To create an API connector:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d86646e38 ">Admin</td>

          </tr>
        </tbody>
      </table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/images/icon_note.png)

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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/interactionstudio.png)
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**.