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 […]
Introduction This tutorial walks you through the process of extracting blog posts and comments data from Blogger using the REST API and Zappysys ODBC connectors. In this guide, you will learn how to authenticate with the Blogger REST API, configure a Zappysys ODBC data source, and query extracted data using ODBC. This approach eliminates the […]
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 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 […]
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 […]