skip to main content
Catalog tables
 

Try DataDirect Cloud Now

Catalog tables

DataDirect Cloud 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.
DataDirect Cloud provides catalog tables for the following data store types:
*Salesforce.com
*Force.com
*FinancialForce
*Google Analytics
*ServiceMax
*Veeva CRM
*Microsoft Dynamics CRM Online
*SugarCRM
*Oracle Marketing Cloud
*Oracle Service Cloud
*Progress Rollbase
Note: Data stores such as Progress OpenEdge, Oracle, and Microsoft SQL Server do not use the DataDirect Cloud catalog tables.
The following topics describe the catalog tables provided by DataDirect Cloud:
* SYSTEM_SESSIONS catalog table
* SYSTEM_REMOTE_SESSIONS catalog table