Service now odbc excel3/14/2024 You will also want to decide if you want to use a Secure Store Service to enable single sign-on functionality with the ODBC driver. To do this, you will need to set up the OLE DB provider as a trusted data source. Once the ODBC DSN is configured, you can configure Excel Services to use the DSN to connect. See the "Getting Started" chapter in the help documentation for a guide on connecting to ServiceNow. 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). This article demonstrates how to use the CData ODBC Driver for ServiceNow to connect to ServiceNow data from Excel spreadsheets in on-premises editions of SharePoint.Ĭonnect to ServiceNow as an ODBC Data Source The CData ODBC Driver for ServiceNow can be accessed using the built-in data access tools in Excel.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |