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 .

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.

Note: For more information about the differences between the values returned by the Actual and Display schemas, see the "Table API FAQs" from the ServiceNow knowledge base (KB number KB0534905): https://hi.service-now.com/kb_view.do?sysparm_article=KB0534905.