Model a Stage OpenQuery Solution

Generalities

The source of a Data Solution can be in another Technology than the target Technology.

For example, you may want to load Oracle data in a Microsoft SQL Server target data Solution.

For this purpose, the Stage OpenQuery Generator is available.

They allow data loading from a different source Technology through a Linked Server into a Stage Layer.

Then, you can use these Stage Model Objects with a Linked project in other Projects.

Available Generators

To use Stage OpenQuery modeling, you can use one of the following Generators:

• Microsoft SQL Server - Stage OpenQuery