---
schema_version: "1"
id: 32bd27304da52c94ae7511c5c0afb1ae7bbd8bd191a65242dedf4a84ec4cb1f4
title: Create a Data Warehouse User Account
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_user_account_create.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_pers_data_warehouse_user_account_create.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 73a21b22bda66efe5385698e3ebd95e79660ee9862c6b854ea5ca10808a78be2
description: Access to the Data Warehouse requires authentication with a Data Warehouse user account. After you create a user account, Marketing Cloud Personalization sends an email with a JDBC and ODBC connection strings, along with other information you need to connect to the Data Warehouse from your BI tool.
products:
  - Marketing
  - Salesforce Personalization
release: "264"
---
# Create a Data Warehouse User Account

Access to the Data Warehouse requires authentication with a Data Warehouse user account. After you create a user account, Marketing Cloud Personalization sends an email with a JDBC and ODBC connection strings, along with other information you need to connect to the Data Warehouse from your BI tool.

### 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="d59270e38">Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d59270e38 ">To create a Data Warehouse user account:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d59270e38 ">Administrator permissions</td>

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

![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.

1. From the main navigation menu, select **Security** | **Manage Data Warehouse**.
2. Click **Create Data Warehouse User**.
3. Enter or select the **Data Warehouse Credentials**:
    
     
    | Field | Description |
    | --- | --- |
    | User Name | Enter the name of the user. User names must be lowercase, start with a letter or underscore character, and contain only alphanumeric values and allowed characters (, +, -, @, or .). |
    | Label | Specify a label for the account. The label is visible only on the **Manage Data Warehouse Users** screen. |
4. Create a password.
5. When prompted, be sure to save the user name and password in a secure location, in accordance with your company’s security policies.
    
    ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_personalization-264-0-0-production-enus/16bf1f60-f44c-4260-a56e-f052cfe515a3/images/icon_important.png)
    
    Important If you lose these credentials, you'll need to create a different Data Warehouse user account to access the Data Warehouse.
6. Click **Close**.

After you create a Data Warehouse user, Marketing Cloud Personalization sends an email with a JDBC string, an ODBC string, and the additional information required to make the connection. You can also see the connection string in the **Connection String** field on the **Manage Data Warehouse Users** screen. The Data Warehouse sets up the scratch schema automatically.

![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 requires SSL for all connections.

#### See Also

- [_Developer Documentation_: Marketing Cloud Personalization Data Analytics](https://developer.salesforce.com/docs/marketing/personalization/guide/data-analytics.html)