Data model package

This topic describes the Data model package section, how to create and run a Data model (Transporter) package, and its other features.

 

The Data model package page allows you to create and manage Data model (Transporter) packages, which contain the Data model structure (i.e. metadata) resulting from comparing two Data model snapshots. You can execute Data model packages to transport and apply the structure of the Data model contained in the package to the desired Data model of a Platform. This feature is commonly used to transport the structure of a Data model from a "Development" environment to a "Production" environment.

In this case, usually the same Data model exists in both environments, and after making new changes to the Data model in the "Development" environment, that very Data model is transported to the "Production" environment following the process below:

  1. Create a Data model snapshot in the "Production" environment and give it a name, for example, "PRODUCTION-SNAPSHOT"
  2. Download "PRODUCTION-SNAPSHOT" to your local machine
  3. Upload "PRODUCTION-SNAPSHOT" to the "Development" environment
  4. Create a Data model snapshot of the Data model in the "Development" environment and give it a name, for example, "DEVELOPMENT-SNAPSHOT"
  5. Create a Transporter package by using both the snapshots "PRODUCTION-SNAPSHOT" and "DEVELOPMENT-SNAPSHOT" located in the "Development" environment
  6. Download the Transporter package to your local machine
  7. Upload the Transporter package in the "Production" environment and execute it

 

To access the Transporter package section, access the System Administration area of the desired Platform and click on the Transporter packages tile. You will be taken to the Transporter package page.

In the Data model package page you can see all existing Data model packages and their main information: the table is sortable and searchable using the interactive header fields. You can also show or hide columns to your liking by clicking the Column chooser button in the upper right corner of the table.

The table contains the following information:

  • Name. This column displays the name of each Transporter package
  • Target db. This column displays the name of the target Data model which each Transporter package will update (if executed)
  • Comments. This column displays additional comments about each Transporter package. You can click on the desired column cell to edit a comment
  • Run. This column displays a button that you can click to execute the corresponding Transporter package
  • Last run. This column displays the date and time of the last run of each Transporter package, in the following format: DD/MM/YYYY, HH:SS
  • Result. This column displays the result of the last run of each Transporter package

 

 

Creating a Data model package

To create a Data model package, proceed as follows:

  1. From the Data model package section of the desired Platform, click on “+TRANSPORTER PACKAGE” in the upper left corner to bring up the "New transporter package" configuration panel. You can also do this by selecting at least one desired Data model snapshot and then clicking on the same button in the Data model snapshot page
  2. Snapshots. Here you must choose the source Data model snapshot on the left drop-down list and then choose the target Data model snapshot on the right drop-down list. You can click on the arrow in the middle to switch their position
  3. Compare. This page displays changes to elements between the source and target Data model snapshots. On the left is a list of the types of Data model elements that have been modified. You can click on an item of the list to filter the table on the right, which displays the modified elements along with the following information:
    • Object Type. This column displays the icon related to the type of element
    • Object source name. This column displays the name of each element in the source Data model snapshot
    • Object target name. This column displays the name of each element in the target Data model snapshot
    • Action. This column displays the type of action that will be performed on each element when the Transporter package is executed. The actions that can be shown here are: "Create", "Update", or "Delete". In the case of an "Update" action, a "Log" icon is displayed: click it to open a pop-up window where you can check the specific change to that element

    You can click on one or more elements in the table on the right to include or exclude the action the Transporter package would execute on those elements (if executed).

    All Data model elements that can be transported are the following:

    The comparison between elements is done by using internal identifiers (i.e. "idx" value for Cubes) for each type of element and not the display name. This is because the display name of elements can change during development and, therefore, cannot be used as an identifier for the comparison.

  4. CHECK. Here you can see the summary of all the actions that you have included in the Transporter package in the previous step. You can click on the "CHECK CONSISTENCY" button to check for any inconsistencies between the source and target Data model snapshots as well as the actions that you have included and excluded (i.e. deleting an Entity that is part of the Structure of a Cube that will be updated. In this case, a warning message will appear). In the case of warning or error messages caused by the inclusion or exclusion of some actions, you can go back to the previous step and include or exclude them to solve such inconsistencies.
    If you cannot solve the inconsistencies in this way, then you may have to manually align the source Data model with the target Data model from the Data model area and recreate the corresponding snapshots

    You cannot create a Transporter package if the consistency check is not successful.

  5. SAVE. Here you must enter the name of the package in the "Name" field and add any additional comments in the "Comment" field. You can also enable the "Backup" option, which automatically creates a backup of the target Data model when you execute the Transporter package.
    In addition, you can enable the "Maintenance mode" option, which automatically puts the target Data model in maintenance mode before running the Transporter package
  6. Click on "SAVE CHANGES" to save the Transporter package.

 

Managing a Transporter package

The Transporter packages page allows you to perform the following management tasks on existing packages:

  • Edit a Transporter package
  • Delete a Transporter package
  • Download a Transporter package to your local machine
  • Upload a Transporter package to the Platform you are logged into

To edit a Transporter package, select it to bring up the package configuration panel and modify the desired available options.

The package configuration panel displays additional information under the following menus:

  • AUTOMATION COMMANDS. This menu contains the commands that you can use to run the package via the CLI Automation feature
  • LOGS. This menu contains a log that provides information about the execution of the package.

 

To delete Transporter packages, select the desired ones and then click the "DELETE" button.

 

To download Transporter packages, select the desired ones and then click the "DOWNLOAD" button. A .trsp file containing the selected packages will download to your local machine.

 

To upload Transporter packages, click on the "UPLOAD" button and choose the .trsp file containing the desired packages.

 

Running a Transporter package

To run a Transporter package, proceed as follows:

  1. From the Transporter package page, click on the button under the "Run" column of the desired Transporter package to run it.
  2. Board will automatically choose the target Data model that has been configured in the Transporter package and perform a pre-execution check where it will list any possible warning or error messages caused by inconsistencies found between the source and target Data models.
    You can manually change the target from the "Target DB" drop-down list.
  3. Click on "GO" to run the package

    You cannot run a Transporter package if errors are detected during the pre-execution check.

The Transporter package only transports the structure (i.e. metadata) of a Data model and not the data contained inside.

When you execute a package, the changes are applied as if they were manually made by a user. This means that existing data in the target Data model may be lost in various cases, such as modifying the Structure of Cubes, adjusting the Time range, or changing the Max Item Number of an Entity etc.