ServiceNow
You can connect to a ServiceNow database in the Qlik Sense Add data or Data load editor dialogs.
The ServiceNow Connector connects to ServiceNow Workspace clusters and SQL Analytics SQL endpoints to query data in tables.
信息注释Industry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.
信息注释This data source is not available in Qlik Sense Business or Qlik Cloud Analytics Standard.
Supported ServiceNow versions
The followings database versions are supported:
-
ServiceNow Orlando and later
Supported ServiceNow data types
The following ServiceNow data types are supported:
| SourceType (ServiceNow ODBC) | QvxField Type (Qlik Sense) |
|---|---|
| BIGINT | Int64 |
| BIT | Bit |
| CHAR | String |
| DECIMAL | Real |
| DOUBLE | Real |
| FLOAT | Real |
| INTEGER | Int32 |
| LONGVARCHAR | String |
| NUMERIC | Real |
| REAL | Real |
| SMALLINT | Int16 |
| TINYINT | Int16 |
| TYPE_DATE | Date |
| TYPE_TIME | Time |
| TYPE_TIMESTAMP | DateTime |
| UBIGINT | Int64 |
| UINTEGER | Int32 |
| USMALLINT | Int16 |
| UTINYINT | Int16 |
| VARCHAR | String |
| WCHAR | String |
| WLONGVARCHAR | String |
| WVARCHAR | String |