Analysis Models - Tabular : Environment Setup¶
This document describes the Environment Setup for the SQL Server Data Warehouse for Analysis Models - Tabular
Environment Setup - Locations¶
The Setup Environment Assistant can be accessed via * Solution Manager > Reporting and Analysis > Analysis Models - Tabular > Setup > Setup Environment Assistant * Setup SQL Server Environment command on the Environment Parameters page.
Note: The Setup SQL Server Environment assistant will have a different UI depending on where the BI infrastructure was setup. It can be either On-Prem or Azure.
Environment Setup Assistant - BI Infrastructure On-Prem¶
Step 1: Environment Parameters¶
In the first step, the current environment parameter settings are displayed.
Make sure to check that the parameters are properly defined.
If needed, the settings can be edited on this page.
Step 2: SQL Database¶
The second step deploys necessary framework objects in the SQL Server or Azure SQL database.
By default, the list is collapsed. Expand the list to see the object deployment details.
Step 3: SQL Database - SSIS¶
The third step deploys necessary framework objects in the SQL Server database related to SSIS.
By default, the list is collapsed. Expand the list to see the object deployment details.
Step 4: SQL Server Agent Jobs¶
Step 4 creates necessary agent jobs in SQL Server.
By default, the list is collapsed. Expand the list to see the object deployment details.
Step 5: SSIS Catalog¶
Step 5 creates a project in the SSIS Catalog in SQL Server.
By default, the list is collapsed. Expand the list to see the object deployment details.
Step 6: SSIS Catalog Configuration¶
Step 6 configures the necessary SSIS catalog parameters.
Step 7: Summary¶
The last step presents a summary of the performed actions.
If all actions were successful, the SQL Server environment is now installed and configured and is ready for use.
If the installation was unsuccessful it will be necessary to investigate reported step errors.
Skipping Installation Steps¶
Even though an initial installation was successful, there might still be issues, e.g. if the installation parameters contain incorrect information that is not detected during the environment setup. Normally it is not necessary to run previously created steps again if those were successful.
Assume that the setup parameter ORA_IFSINFO_PASSWORD has been incorrectly defined.
This will be obvious when trying to load data from IFS Cloud to the SQL Server database.
A correction will be needed in this case. For this you can do the following:
- Use the Environment Parameters page to correct the parameter.
- Start the Setup Environment assistant and check the parameters again in the first step. (The parameter could have been changed in this step as well).
- If everything looks OK, go to step 2 and then use the Skip Step button and make sure to skip until step SSIS Catalog Configuration.
- Since the Oracle user password only affects the data load and the load is performed by SSIS, the Oracle user credentials need to be set appropriately.
- Now use Next to start the configuration of the catalog and when done the summary will be shown.
- Test the data load again to ensure that the supplied Oracle user password is correct.
Environment Setup Assistant - BI Infrastructure in Customer Azure Cloud¶
If the installation mode is Azure then the SQL Server Agent Jobs step is not present since Agent Jobs are not needed.
The steps in Azure mode are according to the above image.
Test Connections Assistant¶
After a successful run of Environment Setup, the Test Connections assistant can be used to test the connections in the SSIS packages. It is important to test and fix issues with all the connections in SSIS packages as SSIS connection failures will raise errors when using Tabular Model related functionalities.
Click on Next to start the connection test process. This will take some time to test the connections and the results will be displayed on the next page.
| Column Name | Description |
|---|---|
| Connection Name | Name of the connection in the SSIS package |
| Description | Details about the connection parameters used |
| Connection Status | Status of the connection test |
| Status Message | The error messages in the case of test failure |
Some troubleshooting information is documented in here.