Virtual Data Warehouse v.1.6.10

New features

• A significant number of load patterns / templates has been added to the collection of available templates
• Better resizing of the template collection grid

Breaking changes

The term 'Load Pattern' has been replaced with 'Template' everywhere. This is not noticeable in most cases except for some labels, except for the following two scenarios:

• In the VDW_Configuration.txt file (Core directory), the entry 'LoadPatternPath' has been replaced with 'TemplatePath'. You can update this manually or re-set the path in the application, in which case this entry will be added.
• The JSON file that contains the list of load patterns/templates has been renamed from loadPatternCollection.json to templateCollection.json. In addition, the segments have been renamed, for example:

  {
    "templateName": "Data Vault Hub 001 View Template",
    "templateType": "CoreBusinessConcept",
    "templateConnectionKey": "PsaConnectionInternalId",
    "TemplateOutputFileConvention": "{targetDataObject.name}.sql",
    "templateFilePath": "templateHubView.handlebars",
    "templateNotes": "Standard Hub template - display the distinct list of Business Keys for a Core Business Concept."
  }

The reasoning behind this is to standardise the naming to how they are used in the various related initiatives. The term 'pattern' is reserved for more conceptual explanation of certain concepts and approaches. The term 'template' is used to identify a technology-specific code (generation) version of this.

Bug fixes

• More detail on SQL error messages, in case there is an issue generating SQL directly against the database