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 Firebase is a popular cloud platform that provides real-time databases, cloud storage, and various backend services. Many organizations use Firebase to store application data and need to integrate it with their SQL Server databases for reporting, analytics, and business intelligence. Using Zappysys SSIS PowerPack, you can easily insert or extract data from Firebase Realtime […]
Introduction Tripletex is a cloud-based accounting and enterprise resource planning (ERP) platform designed for small to medium-sized businesses in Norway and other Scandinavian countries. It provides comprehensive financial management, invoicing, project accounting, and inventory management capabilities through a robust REST API. Integrating Tripletex with ODBC enables seamless data access between your accounting system and any […]
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 Claude.IA is a powerful cloud-native intelligence and automation platform that offers REST APIs for accessing AI models, data processing pipelines, and automation workflows. In this guide, we will demonstrate how to connect to Claude using the Zappysys ODBC Driver for REST APIs with API key authentication. Whether you are using Claude for intelligent document processing, […]
Introduction Claude is a powerful cloud-native intelligence and automation platform that offers REST APIs for accessing AI models, data processing pipelines, and automation workflows. In this guide, we will demonstrate how to connect Zappysys SSIS connectors to the Claude using API key authentication. Whether you are using Claude for intelligent document processing, data enrichment, or […]
Introduction Jamf Pro is a comprehensive Apple device management platform that provides REST APIs for managing Macs, iPads, and iPhones across your organization. This guide demonstrates how to connect Zappysys ODBC drivers to Jamf Pro using OAuth 2.0 API authentication. Whether you are using Jamf Cloud or an on-premises Jamf Pro server, you will learn […]
Introduction Jamf Pro is a comprehensive Apple device management platform that provides REST APIs for managing Macs, iPads, and iPhones across your organization. This guide demonstrates how to connect Zappysys SSIS connectors to Jamf Pro using OAuth 2.0 API authentication. Whether you are using Jamf Cloud or an on-premises Jamf Pro server, you will learn […]
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 […]
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 […]