How to authenticate to an API with OAuth 2.0 using SSIS / ODBC
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 […]
ODBC PowerPack 1.8.1 released
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: All Amazon, […]
SSIS PowerPack 5.4.0 released
Introduction This release brings tons of new features and bug fixes. We have added new connectors for FastSpring, Power BI, Zoho SalesIQ and new endpoints for Azure DevOps. It fixes important issues with connectors for Shopify, MongoDB Source, REST API Task, JSON, XML, CSV Source, Web API Destination, and API Connector Framework. To see full […]
SSIS PowerPack 5.3.2 released
Introduction This was a minor update release. We have updated connectors and add support for Google Drive. It fixes important issues with connectors for Google Drive and Azure DevOps. To see full release notes click here New Features/Improvements NEW: All Source Components – Throw Validation warning if not attached to avoid issues when it runs from […]
SSIS PowerPack 5.3.1 released
Introduction This release brings tons of new features and bug fixes. We have added support for ElasticSearch, OData connectors. It fixes important issues with connectors for CosmosDB, ElasticSearch, JIRA, and JSON / XML / CSV Generator Transform. To see full release notes click here New Features/Improvements NEW: Advanced File System Task – Do not force wildcard […]
ODBC PowerPack 1.8.3 released
Introduction This release brings tons of new features and bug fixes. We have added new connectors for FastSpring, Power BI, Zoho SalesIQ and new endpoint for Azure DevOps. It fixes important issues with connectors for JDBC Bridge Driver, Shopify, API Connector Framework and Data Gateway. To see full release notes click here New Features/Improvements NEW: API […]
ODBC PowerPack 1.8.2 released
Introduction This was a minor update release. We have added support for JSON / XML/ CSV Driver. It fixes important issues with connectors for JDBC Bridge Driver, API Driver and Data Gateway. To see full release notes click here New Features/Improvements NEW: All Drivers – Remember last query when you Open / Close UI NEW: JDBC […]
ODBC PowerPack 1.8.1 released
Introduction This release brings tons of new features and bug fixes. We have added Spport for Salesforce Driver and All API Drivers. It fixes important issues with connectors for JDBC Bridge Driver, Salesforce Driver and Data Gateway. To see full release notes click here New Features/Improvements NEW: All Amazon, Azure, Secure FTP Drivers- Allow ConvErrorHandlingMode option […]
How to upload files on SharePoint Online using SSIS
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 SharePoint Online into your data workflow, you’re in luck. ZappySys SSIS PowerPack offers a powerful SharePoint Online Connector that […]
How to download files from SharePoint Online using SSIS
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 SharePoint Online into your data workflow, you’re in luck. ZappySys SSIS PowerPack offers a powerful SharePoint Online Connector that […]