Configuration Guide

Back Next

Queries and Packages Overview

MDM Hub

, a query is a request to retrieve data from the

Hub Store

. The request is in the form of an SQL SELECT statement. When you run a query, the

MDM Hub

sends the query SQL statement to the database that contains the

Hub Store

, and the database returns the results of the query. A package is a public view of the results of the query.

Generic Queries: A generic query is a type of query that you define by using a query wizard and building blocks. No SQL knowledge is required. The Queries tool generates an SQL SELECT statement from the selected building blocks. The generated SELECT statement works with all supported databases.
Custom Queries: A custom query is a type of query where you define your own SQL SELECT statement. When you want to use database-specific SQL syntax and grammar, create a custom query.
Query Groups: A query group is a user-defined container for queries. Use query groups to organize your queries so that they are easier to find and run.; If you create query groups before you create queries, you can select a group when you create a query.
Packages: A package is a public view of the results of a query. Data stewards use packages with the Data Manager and Merge Manager tools. You can also use packages with external applications.