• Documentation
    • Search documentation
    karat

    +

    K

    API Reference ↗
    Data connectivity & integrationAvailable connectorsMicrosoft SQL Server Analysis Services

    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 ↗.

    Supported capabilities

    CapabilityStatus
    Exploration🟢 Generally available
    Batch syncs🟢 Generally available
    Incremental🟢 Generally available

    Configuration

    The properties below are mandatory or recommended.

    PropertyRequired?DescriptionDefault
    URL ↗MandatoryThe URL used to connect to the Microsoft SQL Server Analysis Services.https://{serverAddress}/olap/msmdpump.dll
    AuthScheme ↗RecommendedThe scheme used for authentication. Accepted entries are NTLM, Basic, Digest, None, and Negotiate.Basic
    Password ↗RecommendedSpecifies the password of the authenticating user account.—
    User ↗RecommendedSpecifies the user ID of the authenticating Microsoft SQL Server Analysis Services user account.—

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

    DomainRequired
    <URL>Always. URL connection property
    <KerberosKDC>:88If AuthScheme=Negotiate
    <KerberosServiceKDC>:88If AuthScheme=Negotiate AND Kerberos topology uses multiple realms