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.
Information noteIndustry-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.
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 |