Table of Contents

Data Pool


A data pool is a collection of tables and views that serves as a data integration point.

It contains all data that developers want to expose from solutions.

It can be implemented through:

  • Compound views
  • Synonyms

dtp


Compound view


Data Stores and Views can join a shared Compound View together with other Stores/Views across different Solutions or Work Process Versions.

To edit Compound View settings, select a Data Store or View and switch to the Data Pool tab.

The name of the Compound View can consist of characters from a-z/A-Z, numbers 0-9, and underscore.


Commands

  • Join: joins the Store or View to the given Compound View.
  • Leave (dropdown under Join): removes the Store or View from named view.
  • Refresh (dropdown under Join): refresh the status shown below the name.
  • View Information (dropdown under Join): brings up a dialog displaying details for the view.
  • Browse Data: brings up a browser to view data in the Compound View.

Note

A Store or View can only be a member in one Compound View.


Synonym

A synonym can be applied to Data Store, Dimensions (linked and local.md), Tables, and View.

Synonyms are using the Microsoft SQL Server synonym functionality with some additions.

To edit Synonyms, select one of the supported content types, and select the Data Pool tab.

The name of the Synonym can consist of characters from a-z/A-Z, numbers 0-9 and underscore.


Commands

  • Take: take the synonym for the given object.
  • Remove (dropdown under Take): removes the object from named view.
  • Refresh (dropdown under Take): refresh the status shown below the name.
  • Synonym Information (dropdown under Take): brings up a dialog displaying details for the synonym.
  • Browse Data: brings up a browser to view data for the synonym.

Data Flow task for taking Synonym ownership

To take Synonyms from a Data Flow, add the Take Synonym Ownership task to a Data Flow Item and add it to a Data Flow.

The argument is an identity to an object in a solution. This can be set to a parent node (folder, package, solution), and then Synonyms will be taken for all descendants.


Edit this page