Servicenow odbc manager how to#
Servicenow odbc manager install#
Servicenow odbc manager update#
Servicenow odbc manager driver#

To create your own DSN, instead click Add on the User or System tab and then select the CData ODBC Driver for ServiceNow option. Select the DSN and click the Configure button to set connection properties as name-value pairs. To load the query to the worksheet, click the Close and Load button. After opening the iODBC Administrator 64-bit, you will see the CData ServiceNow Source listed under the System tab. You can combine queries from other data sources or refine the data with Power Query formulas. through a standard ODBC Driver interface.

Servicenow odbc manager update#

Access ServiceNow data like you would a database - read, write, and update Schedules, Timelines, Questions, Syslogs, etc. The results of the query are displayed in the Query Editor Preview. The ServiceNow ODBC Driver is a powerful tool that allows you to connect with live ServiceNow data, directly from any applications that support ODBC connectivity. For example:Įnter credentials, if required, and click Connect. Provider=MSDASQL.1 Persist Security Info=False DSN=CData ServiceNow SourceĮnter the SELECT statement to import data with.

Servicenow odbc manager install#

Below is a connection string using the default DSN created when you install the driver: See the 'Getting Started' chapter in the help documentation for a guide on connecting to ServiceNow.įollow the steps below to import ServiceNow data using standard SQL:įrom the ribbon in Excel, click Power Query -> From Other Data Sources -> From ODBC.

In addition to the OAuth values, you will need to specify the Instance, Username, and Password connection properties. To authenticate using OAuth, you will need to register an OAuth app with ServiceNow to obtain the OAuthClientId and OAuthClientSecret connection properties. ServiceNow uses the OAuth 2.0 authentication standard. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name).

Servicenow odbc manager how to#

This article details how to use the ODBC driver to import ServiceNow data into Microsoft Power Query.Ĭonnect to ServiceNow as an ODBC Data Source

Average Age of Last Update of Open Incidents (days)Īll ServiceNow links are attributed to © 2021 ServiceNow, available at CData ODBC Driver for ServiceNow enables you to link to ServiceNow data in Microsoft Power Query, ensuring that you see any updates.

% of Open Incidents Not Updated in Last 5 Days.

% of Open Incidents Not Updated in Last 30 Days.

See the ServiceNow REST API reference to learn about metrics, subscriptions, and more.

Otherwise, the overall status of the API poller displayed in the Orion Web Console will be Down or Unknown because expected metrics are not found.Īssign this template to an external node that points to a ServiceNow instance.Īctivate a ServiceNow Performance Analytics subscription to return statistics.Ĭonfigure OAuth2.0 or Basic Auth credentials.ĭefault thresholds are not set for this template. GUI, Citrix, Win-Install, ODBC, RDBMS, AD, LDAP, FTP, VPN, Checkpoint, etc. Use this SAM API poller template to monitor ServiceNow incident statistics.Īfter creating an API poller based on this template, remove any metrics that don't apply to a specific ServiceNow instance. Servicenow Developer/admin/senior Bto It Asset Manager Consultant Resume.

View All Application Management Products.

View All IT Service Management Products.

Customer Success with the SolarWinds Support Community.

Installing Server & Application Monitor.

How to Install NPM and Other Orion Platform Products.

Upgrading From the Orion Platform 2016.1 to 2019.4.

Upgrading Your Orion Platform Deployment Using Microsoft Azure.

Upgrading Isn't as Daunting as You May Think.

Expand the Console Root tree to: ServiceNow ODBC ManagerManager.

SolarWinds Certified Professional Program In Windows, navigate to Start > Programs > ServiceNow ODBC Management Console.