Solutions
...
Litmus Companion Solutions for...
Litmus Production Record Data ...

Installation Guide Litmus Production Record Data Model Configurator

4min

How to deploy Litmus Production Record Data Model Configurator

This section will provide instructions on how to deploy Litmus Production Record Data Model Configurator.

Requirements

  • Litmus Production Record Database is installed
  • A SQL Authentication User and password is available
  • The SQL Server is reachable via its IP / the IP for the SQL Server is known
  • Microsoft Excel capable of executing macros

Step by Step guide to setup the Litmus Production Record Data Model Configurator

This guide will provide instructions on how to setup Litmus Production Record Data Model Configurator.

This guide will not provide instructions on how to create a data model.

Step 1: Download the excel file in "xlsm" format.

Step 2: Open the "xlsm" file with Microsoft Excel

Step 3: Enable Macros.

Document image


Step 4: Open the sheet "CONFIGURATION".

Document image


Step 5: Provide the IP Address of the SQL Server on which Litmus Production Record Database is installed.

Document image


Step 6: The solution will verify that Litmus Production Record Database can be reached. Provide therefore the SQL Authentication user and password.

Document image


In Case of Security Alert



Some organizations do by default not trust any custom code for MS Excel. So the sheet might display

Document image


In this case, go to the file and open its properties. And check the Unblock checkbox and apply.

Document image