The video below shows how to use ZappySys ODBC drivers to load JSON data into an Excel sheet. The concepts can be applied for loading JSON/XML or REST/SOAP API data into any other ODBC compliant app (e.g. Power BI, Informatica, SQL Server, Crystal Reports / Business Objects, SSRS, SSIS).
You will learn:
- What ODBC PowerPack is
- What the difference between User DSN and System DSN is
- How to create a User DSN based on ZappySys JSON Driver
- How to load JSON from a URL into an Excel sheet
- How to load JSON from a file into an Excel sheet
- How to preview data using a table (and automatically generate a SQL query)
- How to use a Filter option
- How to use a SQL query in Excel to select data from ODBC data source (and thus, the JSON)
Contact Us
If you have more question(s) feel free to contact us via Live chat or email to support@zappysys.com
Comments
0 comments
Please sign in to leave a comment.