# Microsoft SQL Server Analysis Services

<!-- BEGIN GENERATED:intro -->

The Microsoft SQL Server Analysis Services connector is a [Palantir-provided driver](../../data-integration/foundry-provided-drivers/index.md) for Microsoft SQL Server Analysis Services.

To create a new Microsoft SQL Server Analysis Services source, follow the [standard setup flow for Palantir-provided drivers](../../data-integration/foundry-provided-drivers/index.md#setup), then use the sections below for Microsoft SQL Server Analysis Services-specific configuration and networking. For the complete property reference, see the [official Microsoft SQL Server Analysis Services driver documentation ↗](https://cdn.cdata.com/help/FYK/jdbc/pg_connectionj.htm).

<!-- END GENERATED:intro -->

<!-- BEGIN GENERATED:capabilities -->

## Supported capabilities

| Capability | Status |
|---|---|
| Exploration | 🟢 Generally available |
| Batch syncs | 🟢 Generally available |
| Incremental | 🟢 Generally available |

<!-- END GENERATED:capabilities -->

<!-- BEGIN GENERATED:configuration -->

## Configuration

The properties below are mandatory or recommended.

| Property | Required? | Description | Default |
|---|---|---|---|
| [`URL` ↗](https://cdn.cdata.com/help/FYK/jdbc/RSBAnalysisServices_p_URL.htm) | Mandatory | The URL used to connect to the Microsoft SQL Server Analysis Services. | `https://{serverAddress}/olap/msmdpump.dll` |
| [`AuthScheme` ↗](https://cdn.cdata.com/help/FYK/jdbc/RSBAnalysisServices_p_AuthScheme.htm) | Recommended | The scheme used for authentication. Accepted entries are NTLM, Basic, Digest, None, and Negotiate. | `Basic` |
| [`Password` ↗](https://cdn.cdata.com/help/FYK/jdbc/RSBAnalysisServices_p_Password.htm) | Recommended | Specifies the password of the authenticating user account. | — |
| [`User` ↗](https://cdn.cdata.com/help/FYK/jdbc/RSBAnalysisServices_p_User.htm) | Recommended | Specifies the user ID of the authenticating Microsoft SQL Server Analysis Services user account. | — |

<!-- END GENERATED:configuration -->

<!-- BEGIN GENERATED:networking -->

## Networking

The table below lists the domains that the source must be able to access to run.

For each domain, add a corresponding [egress policy](../../administration/configure-egress/index.md). If the source is hosted on-premises and not directly reachable from Foundry, use an [agent proxy egress policy](../../administration/configure-egress/index.md#agent-proxy-egress-policies) instead. The agent host itself must also be able to reach the listed domains. See [using an agent as a proxy](../../data-connection/agent-proxy/index.md) for details.

| Domain  | Required |
|--- |--- |
| \<URL> | Always. URL connection property |
| \<KerberosKDC>:88 | If `AuthScheme=Negotiate` |
| \<KerberosServiceKDC>:88 | If `AuthScheme=Negotiate` AND Kerberos topology uses multiple realms |

<!-- END GENERATED:networking -->