---
schema_version: "1"
id: 7a528f9837cb192c20ca41e5da21c66dfd996e6816e2c187d18d8ba5b59eb675
title: Set Up a Microsoft SQL Server Analysis Services Connection (Beta)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/microsoftanalysisservices/c360-a-set-up-microsoftanalysisservices-connection.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-set-up-microsoftanalysisservices-connection.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: db84779eed23fe43c7c81ea238ff6c129eb93f383e609cedde792958c44d50f2
products:
  - Data 360 Integration Guide
  - Data 360 Developer Documentation
---
# Set Up a Microsoft SQL Server Analysis Services Connection (Beta)

Set up the Microsoft SQL Server Analysis Services connection to start the flow of data into Data 360.

**note:** This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at [Agreements and Terms.](https://www.salesforce.com/company/legal/agreements/) If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at [datacloud-connectors-beta@salesforce.com.](mailto:datacloud-connectors-beta@salesforce.com)

| User Permissions Needed |                                                             |
| ----------------------- | ----------------------------------------------------------- |
| To create a connection: | System Admin profile or Data Cloud Architect permission set |

Before you begin:

- Enable the Beta connector through the feature manager. See [Enable Data 360 Features](https://help.salesforce.com/s/articleView?id=data.c360_a_feature_manager.htm&type=5).
- Verify your admin has enabled firewalls on the system you want Data 360 to connect to by including these [IP addresses](https://help.salesforce.com/s/articleView?id=data.c360_a_data_cloud_ip_address_allowlist.htm&type=5) to your allowlists.

1.  In Data Cloud, click **Setup**, and select **Data Cloud Setup**.

2.  Under External Integrations, select **Other Connectors**.

3.  Click **New**.

4.  On the Source tab, select **Microsoft SQL Server Analysis Services** and click **Next**.

5.  Enter a connection name, connection API name, and provide the authentication and connection details.

6.  For Authentication Details, enter the username and password to authenticate the user.

    1.  Optionally, for the SSL Server Certificate, enter the certificate string or upload the string as a .pem file.

7.  For Connection Details, enter the connection URL.

    1.  For Connection URL, enter the Fully Qualified Domain Name (FQDN) without the protocol.

    **note:** To learn more about connecting to SQL Server Analysis Services (SSAS), review the [SSAS Documentation](https://developer.salesforce.com/docs/data/data-cloud-int/guide/%3Chttps://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms175609(v=sql.90)?redirectedfrom=MSDN>).

8.  To review your configuration, click **Test Connection**.

9.  Click **Save**.

After the connector details are accepted, the connection is created and listed under Connectors. You can now create data streams.

## Next Step

- [Create a Microsoft SQL Server Analysis Services Data Stream (Beta)](https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-create-microsoftanalysisservices-data-stream.md)