Integrating ServiceNow with ODBC Driver for Legacy Data Access
"Learn how to integrate ServiceNow with the ODBC Driver for efficient data access in legacy applications. From setting up the ODBC driver to configuring DSN and testing connections, this guide covers all you need to know." (498 characters)
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
NEOSNUG developersCorner Integrating with the ServiceNow ODBC Driver Brett Teacher Software Engineer Lead PNC Bank
NEOSNUG developersCorner I m Down with ODBC Yeah you know Me
NEOSNUG developersCorner Why am I down with ODBC? The ServiceNow ODBC Driver enables legacy applications to pull data from ServiceNow.
NEOSNUG developersCorner Description The ServiceNow ODBC driver is compliant to version 3.52 of the Microsoft ODBC specification and allows any ODBC client to connect to the ServiceNow platform for reporting. The ServiceNow ODBC driver uses the ServiceNow web services support for a query-only interface. The ODBC driver supports only SELECT statements or read- only functions, and does not modify your instance data.
NEOSNUG developersCorner Instance Setup Create a service account in the instance SOAP role to access the web services ITIL role to read all tickets
NEOSNUG developersCorner Download the ODBC Driver 32-bit 64-bit
NEOSNUG developersCorner Create the Data Source Leave at default
NEOSNUG developersCorner The installation creates the following links in the menu: Interactive SQL (ODBC): an interactive SQL command window for directly testing SQL statement. Management Console: a Microsoft MMC snap in for configuring default properties for the ODBC driver. ODBC Administrator: a Microsoft ODBC Administrator program.
NEOSNUG developersCorner Configure the DSN and test the connection using ODBC Administrator
NEOSNUG developersCorner Interactive SQL In Windows, navigate to Start > Programs > ServiceNow ODBC > Interactive SQL (ODBC). CONNECT admin*admin@ServiceNow SELECT number, short_description, category, approval, type, dv_state FROM change_request; IMPORTANT: Add a semicolon to the end of MySQL statements;
NEOSNUG developersCorner Interactive SQL Example:
NEOSNUG developersCorner Display Values When querying a column of type Choice or Reference, an additional column with the prefix dv_ is available that contains the display value.
NEOSNUG developersCorner Examples using the ODBC driver Running Interactive SQL (ODBC) Using the ODBC Driver in Excel 2010 Using the ODBC Driver in Crystal Reports 2008 Using ODBC Driver in SQL Server 2008
