The Runtime is shipped with command line build scripts which allows to generate deliveries from package files.
Those scripts offer the possibility to extract a configuration file from the package to specify all the Metadata parameters which are defined as externalized.
And finally to generate the delivery file, optionally with those customized parameters.
Generalities
A package is an archive containing all the needed files to generate a delivery.
Most of the time, a package is generated by the development team when they have finished working on a Mapping / Process / Project.
The package can then be used to generate the delivery that will be executed by the Runtimes.
Packages can contain one or several processes, each one being able to be transformed into a Delivery.
Prerequisites for multi-process Packages:
Multi-process packages can be generated from Stambia DI Designer S19.0.0 and higher, and the build scripts support them from Stambia DI Runtime S17.6.0 and higher
Build scripts
The Runtime is shipped with command line build scripts allowing to generate a delivery from a package: builddelivery.bat / builddelivery.sh.
Depending on if you are on a Microsoft Windows or Unix OS, the .bat or .sh should be used.
The scripts must be used as follow:
builddelivery.sh mypackage.pck [options]
The following options are available:
| Option | Mandatory for generation mode | Mandatory for substitution mode | Supported from Runtime version | Description |
| -buildmode <mode> | X | X | S17.6.0 and higher |
Specifies how the delivery should be generated. The following modes are supported:
When this parameter is not specified the generation mode is used. See below for further information about each mode. |
| -listprocessenames | X | X | S17.6.0 and higher | list all the processes contained in a package |
| -extract | X | X | all versions | Extract the configuration file of the package containing the externalized Metadata parameters which are used in the processes and which can be customized. |
| -conf <name> | -conffile <file path> | No | Yes | all versions |
When used with the -extract option, specifies a name for the configuration which will be extracted. When used for building a delivery, specifies the previously extracted configuration to use for replacing the externalized Metadata parameters.
|
| -processname <name> | No | No | S17.6.0 and higher |
Indicate which process contained in the package should be built. It is not necessary if you want to build all the processes contained in the package (could be only one process). |
| -deliveryfolder <folder path> | No | No | S17.6.0 and higher | specify the target folder where the deliveries will be generated. |
About build mode
Two build mode are actually available to generate the deliveries, each one having its advantages.
You can find below the differences:
| Build Mode | Supported from Runtime version | Description | Pros and cons |
| generation | all versions |
Mode which has been used by default since the build scripts exist, which launches a generation mechanism to build the delivery. The principal advantage of this mode is that it allows to customize Metadata parameters which were not defined as externalized when generating the package. This offers the possibility to add extra parameters on the extracted configuration file used to build the delivery, to replace parameters which were not anticipated when generating the package. The con is that because of the generation mechanism, it can be time consuming for large processes. Note: Specifying a configuration while building a delivery in this mode is not mandatory. If not specified, the default value with which the package has been generated is used for parameters which has not been valuated. |
Pros
Cons
|
| substitution | S17.6.0 and higher |
Mode which consists of simply replacing the externalized parameters with the values provided inside the extracted configuration file. The builder simply retrieves the pre-built delivery which is inside the package and replace the parameters in. This is also the method that uses Stambia DI Production Analytics for generating deliveries, and this offers better performances as no generation is performed to build the delivery. This also offers the possibility to generate deliveries for all the processes contained in a multi-process package, which is not possible with generation mode. Note: In this mode it is mandatory to build the delivery using a configuration with all the externalized Metadata parameters valuated. |
Pros
|
Which build mode should I use?
For most common usage, the substitution mode can be used as it offers better performances and allows to build all the processes contained in a package.
The generation mode, which is still the default mode for backward compatibility, can be useful when you need to override values for parameters which were not originally externalized when the package was generated.
About configuration files
When using the -extract option, the configuration file of the package is extracted and re-named as specified with the -conf (or -conffile) options.
This file contains all the Metadata parameters which are defined as externalized in the Metadata.
Some are externalized by default, such as the JDBC URL or JDBC User and password, and others can be externalized manually by the user from the Designer in the Metadata.
Those parameters are commented with a default value in the extracted configuration file, for the user to be able to customize them when generating deliveries.
Example of configuration file
#################################################################
### Name: super/Rdbms MetaData/Hypersonic SQL/HSQL - localhost_62210
### Type: com.stambia.rdbms.server
#_-1vK4CVLEeWjxY2_6aCFbA/url=jdbc:hsqldb:hsql://localhost:62210
#_-1vK4CVLEeWjxY2_6aCFbA/user=sa
#################################################################
### Name: super/Rdbms MetaData/Hypersonic SQL/HSQL - localhost_62210/HOTEL_MANAGEMENT
### Type: com.stambia.rdbms.schema
#_aUU9YE26Eeay9ZeykqAlHA/TABLE_SCHEM=HOTEL_MANAGEMENT
#################################################################
To specify a value for a parameter, uncomment the corresponding line (remove the '#' which is at its start) and specify the wanted value.
Example of modified configuration file
#################################################################
### Name: super/Rdbms MetaData/Hypersonic SQL/HSQL - localhost_62210
### Type: com.stambia.rdbms.server
_-1vK4CVLEeWjxY2_6aCFbA/url=jdbc:hsqldb:hsql://productionhost:62210
_-1vK4CVLEeWjxY2_6aCFbA/user=productionuser
#################################################################
### Name: super/Rdbms MetaData/Hypersonic SQL/HSQL - localhost_62210/HOTEL_MANAGEMENT
### Type: com.stambia.rdbms.schema
_aUU9YE26Eeay9ZeykqAlHA/TABLE_SCHEM=HOTEL_PRODUCTION_SCHEMA
#################################################################
When the parameters correspond to the expected values, the delivery can be built using the configuration.
Examples
Below are examples of script usage
Listing the processes contained inside a package
builddelivery.sh mypackage.pck -listprocessnames
Extracting a configuration
builddelivery.sh mypackage.pck -conf myconf -extract
Building a delivery using a previously extracted configuration
builddelivery.sh mypackage.pck -conf myconf
Building a delivery using a configuration, process name, and delivery folder
builddelivery.sh mymultipackage.pck -conf myconf -processname "Load All Datamart" -deliveryfolder D:/deliveries/
Building all the deliveries of a multi-process package inside a specified folder (using substitution mode is mandatory)
builddelivery.sh mymultipackage.pck -conf myconf -deliveryfolder D:/deliveries/ -buildmode substitution