• SQL Server – Import REST API / Read JSON / XML File / Call SOAP (Pagination, OAuth, OData)
    Articles,  Blog

    SQL Server – Import REST API / Read JSON / XML File / Call SOAP (Pagination, OAuth, OData)

    Hello and welcome to ZappySys ODBC PowerPack 101. Today you will learn how to load REST API data into SQL Server using ZappySys data gateway and ZappySys ODBC drivers. Before starting the presentation let me briefly tell what ZappySys data gateway is. It’s a tiny SQL Server which gets installed as Windows service as a part of ZappySys ODBC PowerPack. Basically you can view it as a bridge between your client application and a data source you want to access. In our case the client application is a SQL Server and the data source is a REST API service. Actually with ZappySys data gateway you can also load Soap API…

  • Articles

    Getting Started with T-SQL Queries using SQL Server Management Studio

    Hi. I’m Jason Roth. In the previous videos, we installed SQL Server 2008 and began using SQL Server Management Studio. In this video, I’m going to show you how to write basic database queries in SQL Server 2008. I’m also going to provide some tips and tricks along the way. Let’s start by launching SSMS. On the “Start Menu”, expand “Microsoft SQL Server 2008 R2”, and then click “SQL Server Management Studio”. Type the name of your SQL Server instance, and then click Connect. In our first video, “What is a Relational Database?”, we introduced a fictional database that contained experiment data. This database has three tables: Experiements, Runs, and…