At least Version 2.11.0 of ExMeX Framework Core has to be installed.

1. Extract 7z-file to /library/tool in your root directory.

2. A new folder will be added (if it not already exists): LPS Side Injection.

3. Copy or rename LPS Side Injection/LPSSideInjection.orig.sql  to LPS Side Injection/LPSSideInjection.sql  and open script LPS Side Injection/LPSSideInjection.sql in SSMS.

4. Change the following lines (73 and following) to add a LPS Side Injection

You can adapt the script as often as you like, as an LPS side injection only has to take place once. Reinstalling the metadata does not change the injected LPS and its assignment to a batch. Of course, a script can also be created for each LPS side injection.

Specify only the batch to which the LPS Side Injection is to be assigned. Not a related parent, master or child batch.

--#-----------------------------------------------------------------------------
--# Edit Insert below
--# Recommendation: DO NOT INSERT more than 1 (one) row
--#-----------------------------------------------------------------------------

INSERT INTO @LPSSideInjection
    -- Source
    VALUES (
            -- Model, add a fictitious model (ModelCode, ModelName)
            -- Do NOT change the fictitious model!
            'LPSSideInjection','LPS Side Injection'
            -- Add a fictitious Source Entity ('<YourFictitiousSourceEntityCode>','<YourFictitiousSourceEntityName>','<YourFictitiousSourceDatabase>','<YourFictitiousSourceSchema>')
            ,'<YourFictitiousSourceEntityCode>','<YourFictitiousSourceEntityName>','<YourFictitiousSourceDatabase>','<YourFictitiousSourceSchema>'
            -- Add a fictitious Target Entity ('<YourFictitiousTargetEntityCode>','<YourFictitiousTargetEntityName>','<YourFictitiousTargetDatabase>','<YourFictitiousTargetSchema>')
            ,'<YourFictitiousTargetEntityCode>','<YourFictitiousTargetEntityName>','<YourFictitiousTargetDatabase>','<YourFictitiousTargetSchema>'
            -- Batch to which LPS is associated, must exist in table MetadataZone.LoadBatch ('<YourBatchLabel>')
            ,'<YourBatchLabel>'
            )
;

--##############################################################################
--#-----------------------------------------------------------------------------
--# DO NOT EDIT BELOW
--#-----------------------------------------------------------------------------

5. Execute the script.

6. Done. A new LPS is injected and added to a batch.

7. Now the stored procedures uspProcessStepVapourTrail and uspBatchVapourTrail can be used to write to the ExMeX Logging Framework. See also section Framework In Depth -> Stored Procedure.

It is not necessary to install the metadata again. An LPS Side Injection is independent of the ExMeX Framework Core metadata. It is only necessary to use the ExMeX Logging Framework.

At least Version 2.13.0 of ExMeX Framework Core has to be installed.

Please download first the current version of the Batch Setting Tool for the ExMeX Framework Core.

Backup ExMeX Framework Core

Before you update the batch settings in ExMeX Framework Core with the Set Batch Settings tool, you should create a backup of your ExMeX Framework Core database.

If you do not backup, well it’s up to you.

Installation

After downloading the latest version of the Set Batch Setting tool, please follow all the steps below to get the most out of the tool.

The installation of the Set Batch Settings tool has to be done only once!

• Extract 7z-file to ./library/tool in your root directory.
• A new folder will be added (if it not already exists): Set Batch Setting.
• Copy or rename “./library/tool/Set Batch Setting/SetBatchSetting.orig.sql” file to “./library/tool/Set Batch Setting/SetBatchSetting.sql”.
• Copy or rename “./library/tool/Set Batch Setting/Set Batch Setting.orig.xlsx” file to “./library/tool/Set Batch Setting/Set Batch Setting.xlsx”.

Configure batch settings

You can adapt and enhance the script as often as you like, as a Set Batch Setting only has to take place once. Reinstalling the metadata does not change the new configured and set values to a batch.

• Open file “./library/tool/Set Batch Setting/Set Batch Setting.xlsx” to configure the batch settings as needed. Only add batch settings if you want to change anything. If not then skip the following steps.
• Check the currently set values in the Metadata database:

  SELECT BatchLabel
        ,IsActive
        ,ExitOnError
        ,MaxSqlCommandInChunk
  FROM MetadataZoneCore.LoadBatchNowNow
  	

• Add new rows to Excel “./library/tool/Set Batch Setting/Set Batch Setting.xlsx” with the batches where you want to change the installations.
• Then copy the new content from the DML column into the script “./library/tool/Set Batch Setting/SetBatchSetting.sql” starting from line 50.
• Open the “./library/tool/Set Batch Setting/SetBatchSetting.sql” file and run it in an SSMS. To be on the safe side, check the Messages tab for error messages!
• Done. The new settings are applied to the batch(es). Check the new set values in the Metadata database:

  SELECT BatchLabel
        ,IsActive
        ,ExitOnError
        ,MaxSqlCommandInChunk
  FROM MetadataZoneCore.LoadBatchNowNow
  	

It is not necessary to install the metadata again. A Set Batch Setting is independent of the ExMeX Framework Core metadata.

Deployment

In case the settings for the "Set Batch Setting" should be deployed to other environments, such as development, test or production, please refer to the section Framework Core in Depth -> Extensions By User.

At least Version 2.13.0 of ExMeX Framework Core has to be installed.

Please download first the current version of the Metadata Install Tool for the ExMeX Framework Core.

The ExMeX Metadata Install tool is intended to make it easier for data modelers or DevOps to develop and test error-free metadata installation and compilation of LPS.

Backup ExMeX Framework Core

Before you install metadata into the ExMeX Framework Core database with the Metadata Install tool, you should create a backup of your ExMeX Framework Core database.

If you do not backup, well it’s up to you.

Configuration

After downloading the latest version of the ExMeX Metadata Install tool, please follow all the steps below to get the most out of the tool.

• Extract 7z-file to ./library/tool in your root directory.
• A new folder will be added (if it not already exists): Metadata Install.
• Copy and rename ‘./library/tool/Metadata Install/Metadata Install.orig.bat’ file to ‘./Metadata Install.bat’ (to your root directory).
• Open file ‘./Metadata Install.bat’ to configure the default settings as needed:
  
  From

   rem root directory
   set ExMeXRootPath=<YourRootDirectory>\
   rem metadata directory
   set ExMeXMetadataPath=<YourMetadataDirectory>\
   […]
   rem Database config - Database setting, used when param %2 is empty
   set Database=<YourMetadaDatabase>
   rem Database config - Server and Instance settings
   set ServerInstance=<YourServer\YourInstance>
   rem Database config - Server Port setting
   set ServerPort=<YourServerPort>
   rem Credentials only needed, if NO "Windows Authentication" is used
   set DatabaseUser=
   set DatabasePassword=

  To (with NO Default Instance and Port)

   rem root directory
   set ExMeXRootPath=C:\GitRepos\Tutorial ExMeX Framework Core\
   rem metadata directory
   set ExMeXMetadataPath=C:\GitRepos\Tutorial ExMeX Framework Core\var\
   […]
   rem Database config - Database setting, used when param %2 is empty
   set Database=Tutorial-ExMeX-Metadata
   rem Database config - Server, Instance and Port settings
   set ServerInstance=10.8.0.1
   rem Database config - Server Port setting
   set ServerPort=                  
   rem Credentials only needed, if NO "Windows Authentication" is used
   set DatabaseUser=
   set DatabasePassword=

  To (with Default Instance and Port)

   rem root directory
   set ExMeXRootPath=C:\GitRepos\Tutorial ExMeX Framework Core\
   rem metadata directory
   set ExMeXMetadataPath=C:\GitRepos\Tutorial ExMeX Framework Core\var\
   […]
   rem Database config - Database setting, used when param %2 is empty
   set Database=Tutorial-ExMeX-Metadata
   rem Database config - Server, Instance and Port settings
   set ServerInstance=10.8.0.1\TutorialInstance
   rem Database config - Server Port setting
   set ServerPort=1431
   rem Credentials only needed, if NO "Windows Authentication" is used
   set DatabaseUser=
   set DatabasePassword=

• Save and close file.
• Copy and rename ‘./library/tool/Metadata Install/MetadataDataModels.orig.config’ file to ‘./etc/config/MetadataDataModels.config’.
• Open file ‘./etc/config/MetadataDataModels.config’ to configure the sections as needed.
  

  Each section name must be in square bracket, e.g. [All].

  The metadata files (also called data models) must be in the correct order. First must be the metadata file that has no dependencies to other metadata files (e.g. Tutorial-SourceSystem-A). The next file must be the metadata file that has dependencies to the previous file due to Data Object/Item Mappings (Tutorial-DWH-StageLayer has mappings to Tutorial-SourceSystem-A). And so on.

  Any desired number of sections can be created!

  #
  # section, which installs all data models
  # 
  [All]
  Tutorial-SourceSystem-A
  Tutorial-DWH-StageLayer
  Tutorial-DWH-CoreLayer
  
  #
  # Generated with ExMeX Plugin Metadata Export 
  # -> Excel
  #
  [ExMeXPluginExcel]
  TestdataStage
  TestdataCore
  	

• Save and close file.

The configuration of the ExMeX Tool Metadata Install is now complete. In the future, changes only need to be made as required and the previous steps repeated if necessary.

Now the ExMeX Tool Metadata Install can be used as described below:

• Open a Command-line Window (cmd.exe).
• Change to your root directoty ‘./’.
• Execute MetadatInstall.bat with
  
  Syntax
  

  MetadataInstall.bat <section> [<YourMetadataDatabase> [<YourServer\YourInstance> [<YourServerPort>]]]

  Example A (Only with section ‘All’ on default Server and Database)
  

  MetadataInstall.bat All 

  Example B (Section ‘All’ on a different Database, Server\Instance and Port)
  

  MetadataInstall.bat All Tutorial-ExMeX-Metadata 10.8.0.1\MSSQLSERVER 1401

• Done. The metadata is installed in the ExMeX Framework Core database.

ExMeX Tool Metadata Install - Installation of section [All] with some resulting Warnings

For more information you can check the log-file ‘./tmp/output.log’

Deployment

The ExMeX Metadata Install tool is not suitable for automatic deployment.