Deployment and Execution are the most frequently used processes in Jet Data Manager. These processes help in creating various data structures (tables, views, stored procedure, etc…) inside database and populate them with data. This article provides an in-depth analysis of the processes that occur during the deployment and execution.
If we want to create any table inside our database we first create its structure using the deployment procedure. Deploying an object basically means to bring that object into existence.
We will explain using an example the different objects that are created during the deployment process.
Let’s chose the Item table and deploy it.
After selecting Deploy, a pop-up will appear with a Start button to begin deployment and a Review Tasks button to go through all steps before the deployment starts.
The deployment process consists of multiple steps where each one of them represents the creation of a data structure within the database.
Let’s go through the individual steps that occur during the deployment phase.
During this step, data is extracted from the data source and stored inside the _R (RAW) Table.
All the error numbers generated by the application are logged inside the _L (LOG) table. This table will generally be empty.
Error messages are generated and are present inside the _M (MESSAGE) table,. The application generates these messages and are related to the _L table referenced above.
This step creates the _T (TRANSFORMATION) table. This is an intermediate table where the data is altered during the data cleansing process.
After the data cleansing and data quality process, the records are moved into the _V (VALID) table.
A stored procedure is created that will perform the data cleansing.
Execution is the process of populating a data structure (tables, view, cubes, dimensions) with data. A data structure will be empty (contains no data) until it is executed.
We will start by executing the Item table to demonstrate the process.
After selecting Execute, a pop-up will appear with a Start button to begin execution and a Review Tasks button to go through all steps before the execution starts.
The execution phase has two steps.
This step moves (transfers) the data from the source and populates the _R table.
The stored procedure created during the deployment process will be executed in this step. This step performs the cleansing of the data using the _T table and will then transfer the data into the _V table if a physical table is being used for this.