Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →
Connect to ServiceNow from Asprova with CData ODBC Driver for ServiceNow
This article shows how to connect faster to ServiceNow data from Asprova.
The CData ODBC driver for ServiceNow enables you to access ServiceNow data from Asprova. In this article, you will import ServiceNow data into item data in Asprova as an example.
About ServiceNow Data Integration
CData simplifies access and integration of live ServiceNow data. Our customers leverage CData connectivity to:
- Get optimized performance since CData uses the REST API for data and the SOAP API for schema.
- Read, write, update, and delete ServiceNow objects like Schedules, Timelines, Questions, Syslogs and more.
- Use SQL stored procedures for actions like adding items to a cart, submitting orders, and downloading attachments.
- Securely authenticate with ServiceNow, including basic (username and password), OKTA, ADFS, OneLogin, and PingFederate authentication schemes.
Many users access live ServiceNow data from preferred analytics tools like Tableau, Power BI, and Excel, and use CData solutions to integrate ServiceNow data with their database or data warehouse.
Getting Started
Asprova setting
-
Click File -> Data I/O Settings.
![]( "DataIO")
-
Double click the header of Item and open the Edit I/O dialog.
![]( "DataIO")
-
Select "No" from the RDB transaction combo box and close the dialog.
![]( "DataIO")
Data driver setting
-
Select "OLE DB" from combo box in "Data source" column.
![]( "DataIO")
-
Click button in Folder/database column and open the Data Link Property dialog. Select "Microsoft OLE DB Provider for ODBC Drivers" from the list of data provider.
-
Select the Connection tab. Check "Use data source name" and select "CData ServiceNow Source" from DSN combo box.
-
Click the Test Connection button and make sure you see the message "Connection successful".
Schema setting
-
Click the button in "External table name" column and open the Table List dialog. Make sure tables in ServiceNow are listed in the dialog.
![]( "DataIO")
-
Click the button in "Field mapping" column and open the Item-Field Mapping dialog.
![]( "DataIO")
-
Open the context menu in the space between tables and click Delete All. Link corresponding fields by dragging mouse.
![]( "DataIO")
-
Click File > Import and data will be imported into Asprova.
Check data
Click Table View > Item. Be sure you can see the item data stored in ServiceNow.
Ready to get started?
Download a free trial of the ServiceNow ODBC Driver to get started:
Download NowLearn more:
ServiceNow ODBC Driver
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.
Access ServiceNow data like you would a database - read, write, and update Schedules, Timelines, Questions, Syslogs, etc. through a standard ODBC Driver interface.
