ZappySys Data Gateway Video: The Basics

The video below shows how to load REST API data into SQL Server using ZappySys Data Gateway and T-SQL. Actually, with ZappySys Data Gateway you can also load SOAP API data, XML, CSV files, ODBC sources or other ZappySys ODBC Driver-based sources. At the end of the video, you will see other use cases of when to use ZappySys Data Gateway.

You will learn:

• What ZappySys Data Gateway (ZSDG) is
• How to get REST API data into SQL server straight from SQL Server Management Studio
• How to create a data source in ZSDG to access REST API data using native ZappySys ODBC JSON Driver
• How to add a linked server to ZSDG
• How to override a URL of a data source straight in T-SQL query
• How to use the Query Builder to override a property in a data source
• How to use Code Generator to get a generated ready-to-use T-SQL query
• How to parameterize a query, which gets data from ZSDG, using a stored procedure
• How ZSDG operates and other use cases of it

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/