How to authenticate to an API with OAuth 2.0 using SSIS / ODBC
Introduction In the world of REST APIs you have to know how to authenticate, before using any API method. In this article we will cover a topic how to authenticate to an API with OAuth 2.0 technology using SSIS or ODBC Drivers. We are going to use OAuth Connection Manager SSIS component to achieve that, which is a […]
How to add non-admin user access for inked servers
Introduction When you create a linked server, the connection succeeds, but the query fails. By default, non-admin users do not have access to a Linked Server in SQL Server. When such users attempt to query a Linked Server, they may encounter errors similar to the following:
|
1 2 3 4 5 6 |
OLE DB provider "SQLNCLI11" for linked server "ZappySysLink" returned message "Unable to open a logical session". Msg -1, Level 16, State 1, Line 0 SMux Provider: Physical connection is not usable [xFFFFFFFF]. |
This issue occurs because the Linked Server does […]
Stop SQL Server Crashes: Why ZappySys Data Gateway Beats ODBC Linked Servers
Is your SQL Server crashing under heavy data load? If you are using Linked Servers with third-party ODBC drivers via MSDASQL, you are unknowingly putting your entire database environment at risk. The Root Cause: In-Process Driver Risks When you configure a Linked Server using the OLE DB Provider for ODBC (MSDASQL), the third-party driver runs […]
SSIS tutorial: How to load MariaDB data into MongoDB
Introduction In our previous post, we explored how to read and write MongoDB data using the ZappySys MongoDB Source and Destination SSIS connectors. In this article, you will learn how to connect MariaDB to MongoDB using ZappySys SSIS PowerPack and transfer data between both systems. We will demonstrate a practical ETL pattern using ZappySys ODBC/JDBC connectivity to […]
SSIS tutorial: Migrating MariaDB data to PostgreSQL
Introduction In our previous post, we explored how to read and write PostgreSQL data using the ZappySys PostgreSQL Source and Destination connectors for SSIS. In this article, you will learn how to connect MariaDB to PostgreSQL using ZappySys SSIS PowerPack and transfer data between both systems. We will demonstrate a practical ETL pattern using ZappySys […]
SSIS tutorial: How to connect to AliPay
Introduction In this article, you’ll learn how to connect SSIS PowerPack (ZappySys) to AliPay OpenAPI to call REST endpoints from SSIS. We’ll focus on the practical integration pattern AliPay requires: sending requests to the OpenAPI gateway with the correct parameters and a valid RSA2 signature, then parsing JSON responses in SSIS. AliPay OpenAPI basics (what […]
SSIS tutorial: How to connect to Swagger
Introduction In this article, we’ll learn how to integrate a documented API in Swagger with SQL Server Integration Services (SSIS) using ZappySys PowerPack. Swagger enables us to visualize and test REST endpoints, while ZappySys SSIS provides advanced components for consuming APIs and transforming data in ETL processes. Steps Get the Swagger endpoints Before connecting from […]
SSIS: How to download & upload files from Azure Data Lake Storage Gen2 (ADLS v2)
Introduction If you’re using ZappySys SSIS Power Pack to manage files in Azure Data Lake Storage Gen2 (ADLS v2)—including hierarchical folders required by many modern data lake workloads (for example, Parquet-based pipelines)—this guide walks you through the complete setup process step by step. Steps Validating your Azure Storage Account Is Gen2 (ADLS v2) Before connecting from SSIS, confirm […]
How to download Outlook (Office 365) Emails as .EML or .MSG Files
Introduction In this article, you will learn how to download Outlook (Office 365) emails as .EML or .MSG files using ZappySys SSIS PowerPack without writing any code. We’ll leverage the power of Microsoft Graph API, which provides unified access to Microsoft 365 services like Outlook Mail, and integrate it seamlessly using the API Connector for […]
How to upload files on SharePoint Online using SSIS
Introduction In today’s data-driven world, the ability to seamlessly integrate and transfer files between different platforms is crucial for efficient business operations. If you’re a user of SQL Server Integration Services (SSIS) and looking to integrate SharePoint Online into your data workflow, you’re in luck. ZappySys SSIS PowerPack offers a powerful SharePoint Online Connector that […]