ServiceNow Schema Tables

ServiceNow stores data in structures which do not follow the rules of data typing and structure that apply to traditional relational tables and columns. Because traditional JDBC toolsets might not support these data structures, the data needs to be mapped to a relational form. To achieve this, the Simba ServiceNow JDBC Connector uses schema tables to map the ServiceNow data to a format that is compatible with JDBC.

The schema tables are listed alphabetically by table name. For each table, the following information is provided:

• The name of the table.
• Whether the table is a virtual table, and if so, the table that it is contained in.
• Whether the table contains any virtual tables, and if so, which ones.
• Any of the columns in the table that are foldable, that is, whether operations on those columns can be delegated to the server instead of the client.

Note:

The Simba ServiceNow JDBC Connector does not currently support query folding.

• A list of all of the columns in the table, with information about the SQL type and whether the column is nullable or updatable.

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.