---
schema_version: "1"
id: 32b31ee9d9fbac06925708ef99a464c99ecd4c1844dd651060b4392e93cd25db
title: Connect to the Data Warehouse
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_pers_data_warehouse_connect.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_pers_data_warehouse_connect.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e3473b1789f3f0c6b57f86bf07a6cd27bac25b19eb05eed4f95a8a5d2af73f24
description: Connect to your Marketing Cloud Personalization Data Warehouse from your BI tool using the user account credentials, the JDBC or ODBC connection string, and other connection settings. For example, you can explore personal data in the Personalization Data Warehouse using Tableau, Marketing Cloud Intelligence, or CRM Analytics.
products:
  - Marketing
  - Salesforce Personalization
release: "264"
---
# Connect to the Data Warehouse

Connect to your Marketing Cloud Personalization Data Warehouse from your BI tool using the user account credentials, the JDBC or ODBC connection string, and other connection settings. For example, you can explore personal data in the Personalization Data Warehouse using Tableau, Marketing Cloud Intelligence, or CRM Analytics.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_personalization-264-0-0-production-enus/16bf1f60-f44c-4260-a56e-f052cfe515a3/images/icon_note.png)

Note The Data Warehouse is available only for customers who have already purchased the Marketing Cloud Personalization - Data Warehouse add-on product.

## Use Your BI Tool to Connect

Use your favorite business intelligence (BI) tool to connect by JDBC or ODBC to the Data Warehouse and explore its contents. After you’ve connected, navigate the preformatted schema and explore the data. For information about what’s available and how it’s structured, see the developer documentation in [Data Analytics](https://developer.salesforce.com/docs/marketing/personalization/guide/data-analytics.html).

## Encrypted Connections Only

The Data Warehouse requires SSL for all connections.

## Required Connection Information

Connect to the Data Warehouse using the information sent by email when the user account was created. Most BI tools use either a JDBC or an ODBC connection and require the following information:

- Database name
- Username
- Password
- Host
- Port
- Schemas

## Test the Connection

To verify the behavior you expect before proceeding to analyze the data, be sure to test the connection. The Data Warehouse sets up scratch schema automatically.

## Use a JDBC Connection

If you use the Data Warehouse with a BI tool that supports a JDBC connection, use the sample JDBC Connection String.

Example: `jdbc:redshift://client-xxx.examplecluster.abc123xyz789.region-xyz.amazonaws.com:5439/xxx`.

Replace the xxx placeholders with your own information. To test the connection, use the string provided by email with your JDBC-connected BI tool.

## Use an ODBC Connection

If you use the Data Warehouse with a BI tool that supports an ODBC connection, use the sample ODBC Connection String.

Example:

`Driver={Amazon Redshift (x64)}; Server=xxx.examplecluster.abc123xyz789.region-xyz.amazonaws.com; Database=xxx; UID=xxx; PWD=insert_your_master_user_password_here; Port=5439`

Replace the xxx placeholders with your own information. For `Database=xxx`, replace xxx with the value of the tenant name. To test the connection, use the string provided by email with your ODBC-connected BI tool.

#### See Also

- [Integrate Marketing Cloud Personalization with Tableau](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_salesforce_tableau.htm&release=264.0.0&type=5 "In Tableau, connect to Marketing Cloud Personalization’s Data Warehouse and explore personalization data.")
- [Integrate Marketing Cloud Personalization with CRM Analytics](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_salesforce_crma.htm&release=264.0.0&type=5 "In Salesforce CRM Analytics, connect to Marketing Cloud Personalization’s Data Warehouse and explore personalization data. Import prediction scores from CRM Analytics into Personalization using ETL data feeds.")
- [Integrate Marketing Cloud Personalization with Intelligence](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_salesforce_marketing_cloud_intelligence.htm&release=264.0.0&type=5 "In Marketing Cloud Intelligence, explore personalization data in Marketing Cloud Personalization’s Data Warehouse. Marketing Cloud Intelligence supports advanced roll-up analysis and deeper media spend analytics.")