The Microsoft SQL Server Analysis Services connector is a Palantir-provided driver 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, 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 ↗.
| Capability | Status |
|---|---|
| Exploration | 🟢 Generally available |
| Batch syncs | 🟢 Generally available |
| Incremental | 🟢 Generally available |
The properties below are mandatory or recommended.
| Property | Required? | Description | Default |
|---|---|---|---|
URL ↗ | Mandatory | The URL used to connect to the Microsoft SQL Server Analysis Services. | https://{serverAddress}/olap/msmdpump.dll |
AuthScheme ↗ | Recommended | The scheme used for authentication. Accepted entries are NTLM, Basic, Digest, None, and Negotiate. | Basic |
Password ↗ | Recommended | Specifies the password of the authenticating user account. | — |
User ↗ | Recommended | Specifies the user ID of the authenticating Microsoft SQL Server Analysis Services user account. | — |
The table below lists the domains that the source must be able to access to run.
For each domain, add a corresponding egress policy. If the source is hosted on-premises and not directly reachable from Foundry, use an agent proxy egress policy instead. The agent host itself must also be able to reach the listed domains. See using an agent as a proxy 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 |