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 分析スタンダード.
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 |