How to connect an XML Web Service (SOAP) using the ODBC

Introduction

This article provides step-by-step guidance on connecting to Web services using ODBC XML driver.

Prerequisites

Steps

Create an ODBC XML Driver:

  1. Open the ODBC Data Source by typing “ODBC” in the search box and launching it.
    Open ODBC

  2. Create a User Data Source (User DSN) and select the ODBC XML driver.
    Create new System DSN and XML driver option

  3. Now, we will get information on XML web services using the following URL: https://www.w3schools.com/xml/books.xml, and test the connection. After that, you can use the Select Filter option to get the object you want in the preview

  4. Navigate to the Preview tab and preview the data.

Video Tutorial

Conclusion

You are now successfully connected to Web XML Services. For any issues or further assistance, please get in touch with our support team via chat on our website.

References