Microsoft SQL Server - Stage OpenQuery - 1.10

This article will explain the architecture layer of the Microsoft SQL Server - Stage OpenQuery Generator version 1.10.

To better understand what's in a Generator, you can consult Understand the Generator Configuration.

Target Layers

In this configuration, the following Target Layers are available:

• Source
  • Source
• Bronze
  • Stage

More information here: Understand the Layering concept.

Model Object Types

In this configuration, the following Model Object Types can be used:

• Source Layer:
  • Source
• Stage Layer:
  • Stage

Project Properties

In this configuration, the following Properties are available on a Project:

• Push view to repo
• Deployment Options
• Target Object Comment Type
• Hash Algorithm
• Artifact Output Mode
• Configure Load Control
• Deploy Load Control
• Load Control Options

Target environment

For this configuration, we proposed the following possible target environment:

• Microsoft SQL Server - Stage OpenQuery - Target environment