Schema Support

Each ServiceNow database table is exposed through two schemas: Actual and Display. The Actual schema returns the raw data values that are stored in the ServiceNow database. The Display schema returns more human-readable representations of those values, as data of type String. Typically, the values from the Display schema are shown in the ServiceNow user interface.

The Simba ServiceNow ODBC Connector provides access to both schemas. To retrieve data from only one of the schemas, you must either specify the schema name in your query statements, or set the HideSchemas configuration option to exclude the schema that you do not need. For more information, see HideSchemas.

Only the Actual schema supports filters provided by the ServiceNow Server. Using this schema has better performance for these queries, as only delta is fetched.

Related topics

• Features
• HideSchemas