How to connect MS access with ServiceNow

ODBC PowerPack API Driver
1

Introduction

This article provides a step-by-step guide for connecting MS Access to ServiceNow using the ZappySys ODBC API Driver to facilitate data integration. This solution streamlines the management and analysis of ServiceNow data across different applications.

Prerequisites

Steps

Obtain ServiceNow Credentials

  1. Log in to ServiceNow Developers.
  2. Click on your profile icon and select your instance.
  3. Click “Manage instance password.”
  4. Note the Instance name, Username, and Password.
    ServiceNow Credentials
    ServiceNow Credentials1436×620 79.2 KB

Create a New ODBC Driver

  1. Search for “ODBC” on your system and open the ODBC Data Source application.
    Open ODBC Data Source

  2. Under User DSN or System DSN, click Add to add a new System DSN and select ZappySys API Driver.

  3. Choose ServiceNow as the connector and click Continue.

    Select ServiceNow Connector
    Select ServiceNow Connector625×506 50.3 KB

ServiceNow Connector Configuration

  1. Enter your Instance name, Username, and Password and test the connection.

    ServiceNow Connector Configuration
    ServiceNow Connector Configuration799×704 54.3 KB

  2. In the Preview Tab, select a table, preview the data, and click OK to save.

    Preview Data
    Preview Data799×704 41 KB

Import Data in Microsoft Access

  1. Open MS Access and create a new database.

  2. Go to External Data > New Data Source > Other Sources > ODBC Database.
    MS Access Create Database

  3. Choose Import the source data into a new table.

  4. Under Machine Data Source, select the previously created data source and click OK.
    Select Data Source

  5. Select the tables and views you wish to import, then load the data.
    MS Access Tables

Link Tables for Real-Time Data Access (Optional)

Linked tables allow live access to data, supporting real-time database management and collaboration.

  1. In MS Access, create a new database and follow External Data > New Data Source > ODBC Database > Link to Data Source by creating a linked table.

  2. Select the appropriate Machine Data Source and proceed as before.

  3. Select tables/views to link, and when prompted for a Unique Key column, choose None and click OK.
    Unique Key Selection

  4. Double-click the linked table to view data.

    Linked Table Example
    Linked Table Example768×759 49.1 KB

Considerations

In future sessions, you can save your instance name, username, and password for easy access.

Video Tutorial

Video Tutorial

Conclusion

Using the ZappySys ODBC API Driver, you can seamlessly connect MS Access to ServiceNow, enabling efficient data integration and analysis. Our support team is available on the ZappySys website for further assistance.

References