Previous Next  

  Overview: Deploy & Execute

Deploy & Execute Basics

In TX DWA, before a project is deployed and executed, it is simply a meta data model. Deployment and execution generates and runs the code for extracting, transferring and loading your data.

Deploy: Overview

Deployment consists of generating the necessary SQL and SSIS scripts for execution, creating the tables, fields, and views and saving the project.

What else should you know about Deploys?

  • First, a deploy creates the backend physical structures represented by objects in TX DWA - such as tables, views, scripts, stored procedures, etc.
  • Second, red indicates that the object has been modified since the last deployment.
  • Third, the Differential Deployment option checks if the structure has been changed and skips unnecessary deployment.
  • Forth, the Managed Deployment option uses an algorithm to detect object dependencies and deploys your objects in the correct order.

Deploys and Version Control?

  • TX DWA automatically saves during each deployment, which creates a new version. During development, it is good practice to deploy, execute, and validate your data often to ensure everything works as expected.

  • You can preview old versions, as well as roll back to them.

Execution: Overview

Execution runs the scripts generated during deployment in order to transfer the data from the source, and process it through any established transformation and data cleansing rules - the execution procedure.

What else you should know about Executions?

  • First, the Managed Execution option uses an algorithm to detect object dependencies and loads data in the correct order.
  • Second, the Execution Window uses a horizontal bar chart or Gantt chart to show the duration of the data transferred and data cleansing procedures run for each table. Hovering over each bar in the Gantt Chart shows the description, start, and stop time for each object.
  • Third, are Execution Error Information which you can receive if there are any errors during deployment or execution. A Error Window will be displayed if any errors occur.
  • Forth, is the Log which you can click Yes to view. In the log, the object on which the deployment or execution failed, will have an Error Information node. Double-click on this node to view the error description.

What does the Execution Procedure look like?

Difference between Deploy and Execute?

A Deploy creates the tables, views, and scripts. This essentially creates the "box" to hold the data.

An Execute runs the load scripts, which then fills the "box" with data.