Microsoft SQL Server Analysis Services¶
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 ↗.
Configuration¶
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. | — |
Networking¶
The table below lists the domains that the source needs to be able to access in order to successfully 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 |
|---|---|
| \ |
Always. URL connection property |
| \ |
If AuthScheme=Negotiate |
| \ |
If AuthScheme=Negotiate AND Kerberos topology uses multiple realms |
中文翻译¶
Microsoft SQL Server Analysis Services¶
Microsoft SQL Server Analysis Services 连接器是 Palantir 提供的驱动程序(Palantir-provided driver)，用于连接 Microsoft SQL Server Analysis Services。
要创建新的 Microsoft SQL Server Analysis Services 数据源，请遵循 Palantir 提供驱动程序的标准设置流程(standard setup flow)，然后参考以下各节进行 Microsoft SQL Server Analysis Services 的特定配置和网络设置。有关完整的属性参考，请参阅官方 Microsoft SQL Server Analysis Services 驱动程序文档(Official Microsoft SQL Server Analysis Services driver documentation) ↗。
配置(Configuration)¶
以下属性为必填或推荐配置。
| 属性 | 是否必填 | 描述 | 默认值 |
|---|---|---|---|
URL ↗ |
必填 | 用于连接 Microsoft SQL Server Analysis Services 的 URL。 | https://{serverAddress}/olap/msmdpump.dll |
AuthScheme ↗ |
推荐 | 用于身份验证的方案。可接受的值为 NTLM、Basic、Digest、None 和 Negotiate。 | Basic |
Password ↗ |
推荐 | 指定身份验证用户账户的密码。 | — |
User ↗ |
推荐 | 指定进行身份验证的 Microsoft SQL Server Analysis Services 用户账户的用户 ID。 | — |
网络设置(Networking)¶
下表列出了数据源为成功运行而需要能够访问的域名。
对于每个域名，请添加相应的出站策略(egress policy)。如果数据源部署在本地且无法从 Foundry 直接访问，请改用代理出站策略(agent proxy egress policy)；代理主机本身也必须能够访问所列出的域名。详情请参阅使用代理作为代理(using an agent as a proxy)。
| 域名 | 必需条件 |
|---|---|
| \ |
始终需要。URL 连接属性 |
| \ |
如果 AuthScheme=Negotiate |
| \ |
如果 AuthScheme=Negotiate 且 Kerberos 拓扑使用多个领域 |