Tabular Endpoint

Note: This article is intended for Azure database administrators. Ensure the following tasks are completed by someone with the appropriate Azure database administration privileges.

This article describes how to add a Tabular Endpoint to a Deliver instance. On deployment, the model is created on the SSAS Tabular server. Data is populated when the model is executed.

The Jet Analytics portal is managed by the insightsoftware Support team. For assistance or additional information, reach out to Product Support.

In the Jet Analytics Portal, navigate to Data Estate > Instances, click Add Instance >Add Deliver instance. Select Tabular Endpoint from the Add endpoints list, then click Add an endpoint. Complete the following fields:

1. In the Server box, enter the name of the Tabular server. The server can be on-premises or in Azure.
2. In the Database box, enter the name of the database.
3. In the Deployment target list, select the version of SSAS you are targeting. Automatic (default) or Analysis Services Universal are the recommended settings.
4. In the Compatibility box, select or enter the compatibility level to use, or leave it blank to use the highest level supported by the server.
5. Under Server login, select one of the following:
   • Use Windows/Microsoft authentication: Uses the credentials of the user executing the endpoint.
   • Use authentication login: Uses the credentials of a specific user or an App Registration (when the SSAS server is on Azure). This is useful when the user executing the endpoint has two-factor authentication enabled, which would otherwise be triggered during execution. Enter the username in the Username box and the corresponding password in the Password box. If using an App Registration, prefix the username with app:.
6. In the Processing Authentication list, select how the Tabular service will connect to the Prepare instance storage:
   • Service account: Uses the SQL Server Analysis Services service account.
   • Windows user: Uses a specific user account. Enter the username in the Username box and the corresponding password in the Password box.
7. Select Process model offline to process the model in the background, making deployment seamless for end users. The offline database will have the endpoint name prefixed with Offline_.

Note: If the endpoint uses data from a Prepare instance with Snowflake storage, follow the additional steps for Snowflake storage.