From Batch to Real-Time: How Data Teams Are Replacing SQL Server ETL Debt
Explore real-time pipelines for reliable data delivery. Overcome legacy tooling challenges with innovative solutions.
API
Resources for building APIs to interact with applications and databases.
A history of accessing REST APIs and web pages from SQL Server
Learn about various ways to access REST APIs from SQL Server and a new easier approach that was introduced in SQL Server 2025.
Optimize SQL Server Integration: Automated Data Movement
Join us to see how CData Sync modernizes SQL Server data pipelines, reduces maintenance, and unlocks new possibilities for analytics, AI, and business insights.
API Strategy – Important for Digital Success
An API strategy puts architecture and creation at the heart of every piece of software work for productivity, collaboration, and agility.
Getting Started with Kiota for Building API Clients
Learn how to build an API using Microsoft Kiota and how popular programming languages like Python can be used to write the API.
Advanced Features of DAB (Data API Builder) to Build a REST API
Get guidance on the advanced features of DAB (Data API Builder) and how to set up a production-ready environment.
Build REST API with Azure Data API Builder (DAB)
This tip will guide you through creating your first REST API using Azure SQL database and the Microsoft Data API Builder (DAB).
OpenAI API – Setup Development Environment, Create Account and API Key
In this article, we start diving into the OpenAI API and how to set up a development environment, create an OpenAI account, and generate an API key.
Binance API and Python with SQL Server for Data Analysis and Reporting
Learn how to use the Binance API and Python to load cryptocurrency data into a SQL Server database for data analysis and reporting.
Create a Simple REST API with SQL Server Python, Flask and HTML
Learn how to create a simple API to write to a SQL Server database using Python, Flask, and some HTML code.
Flight Plan API with Python and SQL Server
In this article, we look at an API that allows us to retrieve flight information which we will use to load into a SQL Server table using Python code.
Skype API and Python to Load Meeting Data into SQL Server Database
Skype has an API to access its data and in this article we look at how to use this API with Python and how to load the data to a SQL Server database.
Twitter API to Load Data to a SQL Server Database using Python Code
Learn how to load Twitter data to a SQL Server database using Python code and the Twitter API to execute queries and analysis in SQL Server.
Request and Process Data from a Restful API using Python and JSON
This tip presents several examples for requesting and processing data from a Restful API using Python and JSON files.
Consume Multiple APIs to Load Data Asynchronously to SQL Server
Learn how to consume multiple API calls to load data to a SQL Server database using Python.
Load SQL Server Data using Python and an API with Power BI Reporting
Learn to load data to SQL Server database using an API with Python and build a simple Power BI report using this imported data.
Graph Analytics Using Apache Spark GraphFrame API
Learn how to install the Apache Spark GraphFrame API and see a practical example using the GraphFrame API.
Read API Data with Power BI using Power Query
In this tip we will walk through how to load API data into Power BI using Power Query.
Azure Vision Service and Face API Example with Python
This article provides a real-world example of analyzing images with Microsoft Azure Face and Vision API by writing python scripts in Jupyter notebook.
SSRS Rest API
In this tip we look at how to use the new REST API for accessing certain meta data details concerning SQL Server Reporting Services (SSRS).
Best Practices For Building Alerts for Using APIs with SQL Server
Read this tip to learn some ideas about how to handle and alert on irregular data coming from APIs when loading your database.
Extracting API Data Using PowerShell and Loading into SQL Server
We'd like to minimize using third party tools to extract data from APIs to load into SQL Server and wanted to know if we could implement solutions with PowerShell without too much overhead.