JDBC Driver for ServiceNow

Build 22.0.8462

Data Model

You can use the driver to work with all the tables in your account, including custom tables. The table definitions are dynamically retrieved. The driver connects to ServiceNow and gets the list of tables and the metadata for the tables by calling the appropriate Web services. Any changes you make to your ServiceNow account, such as activating a plugin, adding new columns to a table, or changing the data type of a column, will immediately be reflected when you connect.

Tables

The metadata for the tables in ServiceNow are obtained during run time based on a number of predefined schemas from ServiceNow and your unique ServiceNow account information. In Tables you will find a small sample of the tables available in the ServiceNow development environment, which models the core ServiceNow system.

You can use data dictionary tables to obtain details about the tables available in your ServiceNow environment. Data dictionary tables and other system tables are prefixed with "system_".

The following data dictionary tables define the structure of the database tables:

  • system_db_object: This contains information about each table, one row per table.
  • system_dictionary: This defines every table and field in the system.
  • system_documentation: This contains the human-readable labels and language information for every field of every table in the database.

Views

The driver will expose the ServiceNow Database Views as Views only if the IncludeDatabaseViews connection property is set to 'True'.

The metadata for the Views in ServiceNow are obtained during run time based on a number of predefined schemas from ServiceNow and your unique ServiceNow account information. In Views you will find a small sample of the views available in the ServiceNow development environment, which models the core ServiceNow system.

The following data dictionary tables define the structure of the database views:

  • system_db_view: This contains information about each view, one row per view.
  • sys_db_view_table: This defines all source tables that each Database View contains.
  • sys_db_view_table_field: This defines all source table fields exposed for each Database View.
  • system_dictionary: This defines every table field in the system.
  • system_documentation: This contains the human-readable labels and language information for every field of every view in the database.

Stored Procedures

Stored Procedures are function-like interfaces to ServiceNow. They can be used to create materialized views -- tables that contain the results of a query. To use the driver to work with a materialized view, specify the query in the stored procedure call. The resulting schema is then saved in an XML file that can be easily modified without calling the stored procedure again. Schemas are saved in .rsd files in the folder you specify as the Location.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462