Introduction Trello is a popular project management platform used by teams worldwide to organize tasks, track progress, and collaborate on projects. Many organizations need to integrate Trello data with SQL Server for reporting, analytics, and business intelligence purposes. Using Zappysys SSIS PowerPack, you can easily extract card data, lists, and board information from Trello using […]
Introduction Tripletex is a cloud-based accounting and enterprise resource planning (ERP) platform used by small and medium-sized businesses in Norway and other Scandinavian countries. It provides financial management, invoicing, project accounting, and inventory features through a REST API. Integrating Tripletex with SQL Server Integration Services (SSIS) lets you synchronize accounting data with databases, reporting systems, […]
Introduction This tutorial walks you through the process of extracting blog posts and comments data from Blogger using the REST API and Zappysys SSIS connectors. In this guide, you will learn how to authenticate with the Blogger REST API, configure a Zappysys REST data source, and load extracted data into SQL Server. This approach eliminates […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Introduction If you need to upload files from SSIS to SharePoint Online, the ZappySys SharePoint Online Connector for SSIS gives you a direct way to configure the connection, authenticate, and send files without building the API calls from scratch. This guide shows how to upload one file or multiple files to SharePoint Online using SSIS, […]