Generate SQL Server Objects and Actions

Explanation

Select a tabular model from the list and select Deploy to SQL Server DB from the Main Actions list on the Tabular Models page. This opens up an assistant that guides the user to deploy the Data Warehouse objects of the selected IFS Tabular Model. Click Next on the Introduction tab to generate SQL server objects and actions. Fix and validate script errors if any. Here the user can deploy all the scripts or selected scripts. The ability to deploy selected scripts is useful when there is a change in one or a few particular data source(s). Click Next.

Prerequisites

Understanding of the environment setup information.

System Effects

The database objects are deployed.