Deployment
Overview
The Deployment page is used to define and run a deployment package for the active AnalyticsCreator repository. Use it to name the deployment, choose the output directory, configure deployment options, select generated deployment artifacts, maintain SQLCMD variables, and review deployment progress in the log.
Function
Use this page to maintain the deployment name, output directory, data warehouse deployment settings, SSIS settings, optional output files, tabular OLAP deployment settings, multidimensional OLAP deployment settings, deployment artifacts, and SQLCMD variables.
The Options tab contains the deployment configuration. It controls database deployment, package output, BI output, OLAP deployment scripts, generated package selection, and deployment variables.
Deploy starts the deployment run and writes progress to the log. Interrupt stops an active run. Save stores the deployment definition. Cancel closes the page without continuing the current edit.
Deployment context
A deployment definition controls which AnalyticsCreator artifacts are generated or deployed. The same page is used to create a new deployment definition, edit an existing deployment definition, or run a saved deployment.
Access
Open this page from the Deployments branch in the navigation tree, from the Deployment toolbar, or from the Deployments list.
How to access
Navigation tree
Data warehouse -> Deployments -> Add deployment, List deployments, or [deployment] -> Edit/Run deployment.
Toolbar
Deployment -> Deployment package.
Diagram
Not opened directly from the diagram. Use the Deployments branch or the Deployment toolbar.
Screen overview
The Deployment page is split into three main areas: deployment identity and page actions, deployment options, and deployment run controls. The deployment options area is documented in separate tables because it contains multiple configuration sections.
A. Deployment identity and page actions
Area A contains the deployment name, output directory, and page-level actions.
| ID | Property / Action | Description |
|---|---|---|
| A.1 | Name | Deployment name shown in the Deployments list and navigation tree. |
| A.2 | Directory | Output directory used for generated deployment files. The directory can use the {LOGIN} alias. |
| A.3 | Cancel | Closes the page without continuing the current edit. |
| A.4 | Save | Stores the current deployment definition. |
B. Deployment options
Area B contains the deployment configuration sections, deployment artifact selection, and SQLCMD variables.
B.1 Data warehouse
| ID | Property | Description |
|---|---|---|
| B.1 | Data warehouse | Section used to configure DACPAC generation, target database connection, deployment safety options, and layer-database handling. |
| B.1.1 | Create DACPAC | Generates a DACPAC for the selected repository objects. |
| B.1.2 | Object Group | Limits the deployment to a selected object group or keeps all groups selected. |
| B.1.3 | DACPAC Compatibility | Compatibility level used when generating the DACPAC. |
| B.1.4 | Database to deploy and to use as source in generated files | Target database connection used by the deployment and generated output files. |
| B.1.5 | Manual con. string | Uses a manual connection string instead of the individual connection fields. |
| B.1.6 | Server | Target database server. |
| B.1.7 | DB Name | Target database name. |
| B.1.8 | Authentication options | Selects the database authentication mode: Integrated, Standard, or Azure AD. |
| B.1.9 | Trust server certificate | Allows the connection to trust the server certificate. |
| B.1.10 | Login | Login used when the selected authentication mode requires credentials. |
| B.1.11 | Password | Password used when the selected authentication mode requires credentials. |
| B.1.12 | Deploy DACPAC | Deploys the generated DACPAC to the configured target database. |
| B.1.13 | Allow data loss | Allows deployment changes that may cause data loss. |
| B.1.14 | Drop objects not in source | Drops target objects that are not present in the generated source model. |
| B.1.15 | Backup DB before changes | Creates a database backup before applying deployment changes. |
| B.1.16 | Block when drift detected | Blocks deployment when target drift is detected. |
| B.1.17 | Deploy in single user mode | Runs deployment in single-user mode. |
| B.1.18 | Allow incompatible platform | Allows deployment when the target platform is marked as incompatible. |
| B.1.19 | Deploy test cases | Includes test-case deployment output. |
| B.1.20 | Allow using separate databases to store layers | Enables layer-specific database handling for deployments that store layers in separate databases. |
B.2 SSIS settings
| ID | Property | Description |
|---|---|---|
| B.2 | SSIS settings | Section used to configure generated SSIS package settings. |
| B.2.1 | Connection string to SSIS_Configuration stored as | Defines how the SSIS_Configuration connection string is stored. |
| B.2.2 | Storage mode options | Available storage options include None, Environment variable, Configuration file, Package parameter, and Project parameter. |
| B.2.3 | All connection strings stored as | Defines how all generated package connection strings are stored. |
| B.2.4 | Project reference | Uses project-reference behaviour with the Integration Services catalog. |
| B.2.5 | Package compatibility level | SQL Server package compatibility level used for generated SSIS output. |
| B.2.6 | Environment variable | Environment variable name used when environment-variable storage is selected. |
| B.2.7 | Deploy SSIS_Configurations | Includes SSIS_Configurations deployment output. |
| B.2.8 | Set environment variable | Sets the configured environment variable during deployment generation. |
B.3 Other files
| ID | Property | Description |
|---|---|---|
| B.3 | Other files | Section used to select additional BI and script output files. |
| B.3.1 | Create PowerBI project | Generates Power BI project output. |
| B.3.2 | Create Tableau model | Generates Tableau model output. |
| B.3.3 | Create Qlik script | Generates Qlik script output. |
B.4 Tabular OLAP deployment
| ID | Property | Description |
|---|---|---|
| B.4 | Tabular OLAP deployment | Section used to configure tabular OLAP deployment output. |
| B.4.1 | Create XMLA script | Generates an XMLA script for the tabular OLAP model. |
| B.4.2 | Server | Tabular OLAP server. |
| B.4.3 | DB Name | Tabular OLAP database name. |
| B.4.4 | Login | Login used for the tabular OLAP deployment target when credentials are required. |
| B.4.5 | Password | Password used for the tabular OLAP deployment target when credentials are required. |
| B.4.6 | Use the service account | Uses the service account for the tabular OLAP deployment connection. |
| B.4.7 | Use the credentials of current user | Uses the current user credentials for the tabular OLAP deployment connection. |
| B.4.8 | Process cube in workflow package | Includes cube processing in the workflow package. |
| B.4.9 | Create cube during deployment | Creates the tabular cube during deployment. |
| B.4.10 | Compatibility level | Compatibility level for the tabular OLAP model. |
| B.4.11 | Facts from star | Star context used for fact generation in the tabular model. |
| B.4.12 | Connector name | Connector name used by the tabular model output. |
| B.4.13 | Model name | Model name used for the tabular OLAP output. |
| B.4.14 | Create partitions | Includes tabular partition creation. |
| B.4.15 | Create perspectives | Includes tabular perspective creation. |
B.5 Multidimensional OLAP deployment
| ID | Property | Description |
|---|---|---|
| B.5 | Multidimensional OLAP deployment | Section used to configure multidimensional OLAP deployment output. |
| B.5.1 | Create XMLA script | Generates an XMLA script for the multidimensional OLAP model. |
| B.5.2 | Server | Multidimensional OLAP server. |
| B.5.3 | DB Name | Multidimensional OLAP database name. |
| B.5.4 | Login | Login used for the multidimensional OLAP deployment target when credentials are required. |
| B.5.5 | Password | Password used for the multidimensional OLAP deployment target when credentials are required. |
| B.5.6 | Use the service account | Uses the service account for the multidimensional OLAP deployment connection. |
| B.5.7 | Use the credentials of current user | Uses the current user credentials for the multidimensional OLAP deployment connection. |
| B.5.8 | Process cube in workflow package | Includes cube processing in the workflow package. |
| B.5.9 | Create cube during deployment | Creates the multidimensional cube during deployment. |
| B.5.10 | Compatibility level | Compatibility level for the multidimensional OLAP model. |
| B.5.11 | Create perspectives | Includes multidimensional perspective creation. |
| B.5.12 | Create partitions | Includes multidimensional partition creation. |
B.6 Deployment Packages
| ID | Property | Description |
|---|---|---|
| B.6 | Deployment artifacts | Grid used to select generated packages for deployment output. |
| B.6.1 | SSIS | Includes the package in SSIS output. |
| B.6.2 | ADF2 | Includes the package in Azure Data Factory v2 output. |
| B.6.3 | PackageName | Generated package name. |
| B.6.4 | PackageType | Generated package type. |
| B.6.5 | Description | Description of the generated package. |
B.7 SQLCMD Variables
| ID | Property | Description |
|---|---|---|
| B.7 | SQLCMD Variables | Grid used to maintain deployment variables. |
| B.7.1 | Variable | SQLCMD variable name. |
| B.7.2 | Value | Value assigned to the SQLCMD variable. |
C. Log and run controls
Area C contains the Log tab and deployment run controls.
| ID | Property / Action | Description |
|---|---|---|
| C.1 | Log | Tab used to display deployment progress and run messages after deployment starts. |
| C.2 | Deploy | Starts the deployment run and writes progress to the log. |
| C.3 | Interrupt | Stops an active deployment run. |
