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 […]
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 In this article, we will explore some MongoDB query tricks that can help you retrieve the information you require. Be sure to check out our articles on MongoDB source and MongoDB execute SQL task here. Examples Filtering by Date: First, let’s look at filtering data by date. Ensure that your database has the date column […]
Introduction OpenAI, the creators of ChatGPT, provide both a web interface and an API for seamless integration of their tools into applications. This article provides a comprehensive guide on how to establish a connection with the OpenAI API in SSIS using ZappySys JSON Source, enabling seamless data integration and retrieval. Prerequisites Before we perform steps […]
Introduction In SQL Server Integration Services (SSIS), validating expressions, paths, and URLs is a crucial part of ensuring the integrity and success of your data integration processes. In this article, we’ll explore how the Validator Task can help you achieve this. Before we dive into practical examples, be sure to check our comprehensive Validator Task […]