Help >
Getting Started - Using ODBC PowerPack
PreviousNext

After you install ZappySys ODBC Drivers you can use Driver functionality few ways (see below).

  1. Using ODBC DSN (User level DSN or System level DSN)
  2. Using Direct ODBC Connection String
  3. Connect client app/server from Windows, Linux, Mac OS to ZappySys Data Gateway using Microsoft SQL Server Driver (i.e. JDBC, ODBC, OLEDB ...)
Regardless which method you choose from your App below steps will help you to configure your connectivity in correct way.
If you choose to connect using direct ConnectionString then also try below Steps to create correct ConnectionString which you can copy from DSN Config Tool and paste inside your App / Programming Language Code.

Using ODBC DSN (User level DSN or System level DSN)

Configure DSN

In this section you will learn how to Configure ODBC DSN. Later on this DSN can be used to use ZappySys Driver. ODBC DSN can be stored at Machine Level (for all users) or Current User Level.
  1. Type odbcad32.exe in your search box and launch the DSN Config utility.
  2. If you want access for yourself then stay of User DSN Tab. If you want grant access other users then go to System DSN tab. For SQL Server Integration go to System Tab and add new System DSN rather than User DSN
  3. Click New button
  4. From the Driver list Select ZappySys ODBC Driver. For this example select [ZappySys JSON Driver]
  5. When you see DSN Config Editor with zappysys logo first thing you need to do is change default DSN Name at the top. For this example call it [ZS-ODATA-Customers]
  6. Enter following URL in the Data Source
    https://services.odata.org/V3/Northwind/Northwind.svc/Customers?$format=json
  7. Click on Preview Tab
  8. Select Table from Tables Dropdown and select [value] and click Preview
  9. If you are using Direct ConnectionString method in other tool/code then just Click [Copy ConnectionString] button and hit cancel so we don't create DSN.
  10. If you are using DSN method then Click OK to save our DSN Configuration.

Video Tutorial

Consume Data inside your App / Programming Language

Now you can click on below link to learn steps to consume data inside your App / Programming Language.

ODBC inside ETL / Reporting / BI Tools

ODBC inside Programming Languages


Copyrights reserved. ZappySys LLC.