skip to main content
Querying data stores with SQL : Catalog tables

Try Now

Catalog tables

Hybrid Data Pipeline provides a standard set of catalog tables that maintain the information returned by various catalog functions such as SQLTables, SQLColumns, SQLDescribeParam, and SQLDescribeCol. If possible, use the catalog functions to obtain this information instead of querying the catalog tables directly. The INFORMATION_SCHEMA contains additional catalog tables that maintain metadata.
Hybrid Data Pipeline provides catalog tables for the following data store types.
*Google Analytics
*Veeva CRM
*Microsoft Dynamics CRM Online
*Oracle Marketing Cloud
*Oracle Sales Cloud
*Oracle Service Cloud
*Progress Rollbase
Note: Data stores such as Progress OpenEdge, Oracle, and Microsoft SQL Server do not use Hybrid Data Pipeline catalog tables.
* SYSTEM_SESSIONS catalog table