Servicenow linked service used connectivity vendor

Amir Bagheripour 0 Reputation points
2024-06-27T10:50:37.5233333+00:00

I am interested in using Servicenow Linked Service to extract data from Servicenow. There are two linked services available; the legacy version and version 2 that uses table API. The documentation mentions a built-in driver for enabling connectivity. Can anyone help me understand how the driver for the legacy linked service connects to my Servicenow account? Is it through rest connector or HTTP?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,614 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,994 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kenneth Phillips 0 Reputation points
    2024-06-27T11:58:09.82+00:00

    Hello,

    Here is some details of how the legacy ServiceNow Linked Service connects to your ServiceNow account.

    Legacy ServiceNow Linked Service

    The legacy version of the ServiceNow Linked Service in Azure Data Factory uses an ODBC (Open Database Connectivity) driver to establish a connection to your ServiceNow instance. This driver is built-in, meaning you don’t need to manually install it.

    Connection Mechanism

    ODBC Driver: The ODBC driver acts as an intermediary between Azure Data Factory and your ServiceNow instance. It translates the queries from Azure Data Factory into a format that ServiceNow can understand and process.

    Connection String: When setting up the linked service, you provide a connection string that includes the necessary details such as the ServiceNow instance URL, username, and password. This string is used by the ODBC driver to authenticate and establish a connection.

    Data Extraction: Once connected, the ODBC driver allows Azure Data Factory to execute SQL-like queries to extract data from ServiceNow tables. This data can then be used for various data integration and transformation tasks within Azure Data Factory.

    Comparison with Version 2

    The newer version of the ServiceNow Linked Service (version 2) uses the Table API for connectivity. This API-based approach leverages RESTful web services to interact with ServiceNow, providing more flexibility and potentially better performance for certain use cases.

    Summary

    Legacy Version: Uses an ODBC driver for connectivity.

    Version 2: Uses the Table API (RESTful web services).
    https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1153115/choiceadvantage
    Best Regard,
    Kenneth Phillips