Defining Other Options for Ensemble

Lookup Table File Format

There are two XML formats that describe lookup tables: the new format and the legacy format.

The new Lookup Table XML format consists of one or more XML Document elements, for example:

<?xml version="1.0" encoding="UTF-8"?>
<Export generator="Cache" version="25" zv="Cache for Windows (x86-64) 2015.1 (Build 378U)" 
  ts="2014-10-21 11:52:51">
  <Document name="AlertTable.LUT">
  <lookupTable>
      <entry table="AlertTable" key="ABC_HL7FileService">temp_1@company.test<></entry>
      <entry table="AlertTable" key="BadMessageHandler">temp_1@company.test</entry>
      <entry table="AlertTable" key="Extra_Observations">temp_5@company.test</entry>
      <entry table="AlertTable" key="MsgRouter">temp_3@home.test</entry>
      <entry table="AlertTable" key="Priority_FileOperation">temp_5@home.test</entry>
      <entry table="AlertTable" key="Regular_FileOperation">temp_4@company.test</entry>
      <entry table="AlertTable" key="XYZ_HL7FileService">temp_2@company.test</entry>
    </lookupTable>
  </Document>
</Export>

The XML elements have the following syntax:

• Each Document element must has a name attribute that specifies the lookup table name and has a file type .LUT.

• Each Document element contains one lookupTable element.

• Each lookupTable element contains a list of entry elements.

• Each entry element has a table attribute that specifies the same table name as specified in the Document name, specifies a key attribute, and specifies the value of the entry as text.

The legacy format exported by the Ens.Util.LookupTable.%Export() method and the portal in Ensemble 2014.1 and earlier versions does not have the Document element. It consists of just a single lookupTable element and the entry elements that it contains. It can contain entries for multiple lookup tables by specifying different names in the table element.

Importing Flat Files as Data Lookup Tables

You can import a flat file as a data lookup table, if the file is as follows:

• It can include a header row.

• It must include three values, separated by spaces, commas, tabs, or another delimiter.

• From left to right, the three values must correspond to the Value column of a lookup table, the Key value of a lookup table, and the desired name of the lookup table.

To import such a file as a lookup table, use the Data Import Wizard, as described in “Importing Data from a Text File” in Using Caché SQL. For the schema name, use Ens_Util. For the table name, use LookupTable.

Purpose of System Default Settings

The purpose of system default settings is to simplify the process of copying a production definition from one environment to another. In any production, the values of some settings are determined as part of the production design; these settings should usually be the same in all environments. Other settings, however, must be adjusted to the environment; these settings include file paths, port numbers, and so on.

System default settings should specify only the values that are specific to the environment where Ensemble is installed. In contrast, the production definition should specify the values for settings that should be the same in all environments.

To find the value for a setting for a production, business host, or adapter, Ensemble searches the following locations, in order:

1. The production definition. If Ensemble finds a value for a setting here (even if the value is an empty string), it uses that value.

2. The system default settings, which are stored outside the production definition.

   If Ensemble finds a value here (even if the value is an empty string), it uses that value.

3. The value of the setting as specified in the definition of the class on which the production, business host, or adapter is based.

   Ensemble uses this value only if there is no system default for the setting.

   Some settings do not have any default value.

When you configure a production, the labels are color-coded to indicate whether the value was set in the production, the system default settings, or the class definition. See “Understanding the Color Coding for Settings” for more information.

Accessing the System Default Settings

To access the System Default Settings page, select Ensemble, Configure, and System Default Settings. The System Default Settings page displays the settings defined in the namespace:

To create a new system default setting, click New. To edit an existing setting, select the setting and click Edit. To delete a setting, select the setting and click Delete.

The following elements define a system default setting:

• Production Name—Optionally, specifies the production to which this default applies. If set to *, this default applies to all productions in the namespace.

  Note:

  You cannot change the value of this field once you save the default. You must delete the default and create a new one.

• Item Name—Optional, specifies the business host to which this default applies. If set to *, this default applies to all hosts in the production or in all productions.

• Host Class Name—Optional, specifies the class of the business host to which this default applies. If set to *, this default applies to all hosts in the production or in all productions.

• Setting Name—Specifies the name of the property to set. Note that property names do not include spaces. In most cases, the property name is similar to the setting name, with the spaces removed. For example, the setting Log Trace Events is based on a property called LogTraceEvents.

  Tip:

  You can see the property name within the popup window that displays descriptive text for the setting.

• Setting Value—Specifies the value to assign to the property. If this field is blank; it sets the default to an empty string.

• Description—Optional, specifies a description of the default.

• Deployable—If set, the system default setting can be deployed.

Creating or Editing a System Default Setting

If you are creating a new system default setting or editing an existing one, Ensemble displays the following form:

The System Default Setting page allows you to create a new system default setting or edit an existing one. For convenience it displays a tree of productions and other classes. This allows you to find existing settings and drag the names and values to the form. The Expand Tree and Contract Tree buttons and the plus and minus icons allow you to explore the tree to locate the property you are seeking.

When you have completed defining or updating the system default setting, click Save. The Cancel button discards any changes and returns to the list of system default settings without creating or updating a setting. The Restore button returns to fields to their initial values and allows you to edit the values.