This article describes how to add a Tabular Endpoint to a Deliver instance. On deployment, the model is created on the SSAS Tabular server. To get data in the model, you need to execute the model as well.
In the TimeXtender 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. Fill out the following fields in the form.
- In the Server box, type the name of the Tabular server. The server can be on-premise or in Azure.
- In the Database box, type the name of the database.
- In the Deployment target list, click the version of SSAS you are targeting. Automatic (default) or Analysis Services Universal are the recommended settings.
- In the Compatibility box, click or type the compatibility level you want to use, or leave it blank to use the highest supported by the server.
- Under Server login, the following settings are available:
- 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 (if the SSAS server is on Azure). This can be useful when your SSAS server is on Azure and the user executing the endpoint has two-factor authentication enabled, which will be triggered by an execution. Enter the user name for the user in the Username box and the corresponding password in the Password box. Prefix the username with 'app:' if it is an App Registration application key.
- In the Processing Authentication list, select how the Tabular service will connect to the Prepare instance storage.
- Click Service account to use the SQL Server Analysis Services service account.
- Click Windows user to use another user and then enter the user name for the user in the Username box and the corresponding password in the Password box.
- Select Process model offline to process the model "behind the scenes" and make the deployment seamless for the users. The offline database will have the endpoint's name prefixed with "Offline_".
Note: if the endpoint uses data from a Prepare instance with Snowflake storage follow these additional steps.