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 […]
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 Google Drive into your data workflow, you’re in luck. ZappySys SSIS PowerPack offers a powerful Google Drive Connector that […]
Introduction This release brings tons of new features and bug fixes. We have added new connectors for CosmosDB, Azure DevOps (TFS), ServiceNow, MailChimp, API Drivers and Data Gateway. It includes many enhancements around All Drivers and JSON / XML / CSV Driver. To see full release notes click here New Features/Improvements NEW: API Driver – CosmosDB […]
Introduction This release brings tons of new features and bug fixes. We have added new connectors for Outlook Mail (Office 365), Shopify, Google BigQuery, JDBC Bridge Driver and JSON / CSV / XML Driver. To see full release notes click here New Features/Improvements NEW: API Driver – Outlook Mail (Office 365) – New connector to read […]
Introduction This release brings some of new features and had many bug fixes. To see full release notes click here New Features/Improvements NEW: All Drivers – Add support for Turkey (tr-TR) and Azerbaijani (az-Cyrl) environment NEW: JDBC Bridge Driver – Change Driver name from “Jdbc Bridge” to “JDBC Bridge” Bug fixes FIX: All Drivers – Load […]
Introduction This release brings some of new features and bug fixes. To see full release notes click here New Features/Improvements NEW: API Driver – Allow placeholders in ValueTemplate property for Columns with Dynamic Expand option set to true NEW: API Driver – Use example values from Input Columns to generate CRUD statements if Connector file supports […]
Introduction This release brings tons of new features and bug fixes. We have added a new connector for Youtube, Stripe, Zoom, Amazon Ads, ManageEngine ServiceDesk Plus and for support add HubSpot and SharePoint. To see full release notes click here New Features/Improvements NEW: API Driver – Youtube – New connector to read, search Videos / Playlists […]
Introduction This release brings tons of new features and bug fixes. We have added new connectors for CosmosDB, Azure DevOps (TFS), ServiceNow, MailChimp, HubSpot, JIRA, Zoho and REST API Task. It fixes important issues with connectors for Youtube, SharePoint and XML / CSV Source. To see full release notes click here New Features/Improvements NEW: API Connector […]
Introduction This release brings tons of new features and bug fixes. We have added new connectors for Outlook Mail (Office 365), Shopify, SharePoint and JSON / XML / CSV Generator Transform. It fixes important issues with API Destination, CSV Source, JSON Source and Secure FTP Connection Manager. To see full release notes click here New Features/Improvements […]
Introduction This was a minor update release. It have added a new API Connectors for HubSpot, OneDrive, SharePoint and JSON Source. It fixes important issues with API Connection Manager, API Connector, Export XML Task, JSON Driver, XML Driver and JSON Source. To see full release notes click here New Features/Improvements NEW: General – Add Support for […]
Introduction This was a minor update release. It fixes important issues with All Components and API Connector. To see full release notes click here New Features/Improvements NEW: API Connector – Zendesk – Show all custom fields when you query Tickets (Previous approach was limited to 5 fields only) NEW: API Connector – Zendesk – Update Read […]