Read a XML file using ZappySys ODBC XML driver

In this tutorial, we’ll guide you on how to open an XML file using the ZS ODBC Driver. Follow the steps below:

Note: You can find more information about the ZS ODBC XML Driver here.

Prerequisites:

  • Install the ZappySys ODBC PowerPack, which you can download here.

Create an SFTP CSV Driver:

  • Open the ODBC Data Source Administrator.
    odbc-data-source-64-bits

  • Click on System DSN or User DSN tab.

  • Click on Add to create a new data source.
    add driver to user or system DSN

  • Choose the ZS XML Driver and click Continue the connection.
    Select XML driver

  • You can use a REST API to get an XML response. Enter the API details in the respective fields.

  • Alternatively, you can use a local XML file. Select one or more XML files.

  • Go to the preview tab and click on Preview Data to check the result.

Now, you have successfully opened an XML file using the ZS ODBC Driver. If you encounter any issues or need further assistance, you can contact our support team via chat on our website or through email at support@zappysys.com.