ZappySys

04/16/2026

Power BI native ODBC connector does not support DirectQuery. If you connect with the Microsoft ODBC connector, Power BI uses Import mode, which means data is copied into the model and refreshed on a schedule.

If you searched for Power BI ODBC DirectQuery, DirectQuery ODBC connector Power BI, or ZappySys ODBC PowerPack download, this guide gives you the exact workaround and setup steps.

Introduction Power BI native ODBC connectors do not support DirectQuery. This significant platform limitation forces users into Import mode, preventing real-ti

02/03/2026

We’re proud to share that ZappySys has been recognized on the 2025 Capterra Shortlist for Data Integration, based on verified customer reviews.

Thank you to our customers for your trust and feedback.

Learn more:
https://www.capterra.com/integration-software/shortlist/

10/24/2024

This article is Moved to this location

https://zappysys.com/blog/register-google-oauth-application-get-clientid-clientsecret/





Perform following steps to create new google service account

- Login here https://console.developers.google.com/ and create new project under which we will access APIs .

This article is Moved to this location https://zappysys.com/blog/register-google-oauth-application-get-clientid-clientsecret/     Perform

10/17/2024

Full article coming soon.

Meanwhile check following similar articles :
Get data from Zendesk in SSIS using REST API

Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol

FastSpring API Reference:

FastSpring REST API reference link

Full article coming soon. Meanwhile check following similar articles : Get data from Zendesk in SSIS using REST API Read Twitter data in SSIS using REST

10/15/2024

Full article coming soon.

Meanwhile check following similar articles :
Read Zendesk data in SSIS using REST API

Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol

TSheets API Reference:

TSheets REST API reference link

Full article coming soon. Meanwhile check following similar articles : Read Zendesk data in SSIS using REST API Read Twitter data in SSIS using REST API

10/10/2024

Introduction

Zendesk is one the most popular customer service platforms available in the market today. Zendesk offers REST API so you can interact with their cloud based service programmatically (manage or read data). The problem is not every one is programmer and not everyone has time to learn how to write C # or JAVA code to access REST API.

Introduction Zendesk is one the most popular customer service platforms available in the market today. Zendesk offers REST API so you can interact with the

10/03/2024

Introduction
Many times you have requirement to search and replace in files (single or multiple file) content using SSIS. If you are not C # or VB.net programmer then you may find yourself at dead end struggling how to achieve this in SSIS.

Introduction Many times you have requirement to search and replace in files (single or multiple file) content using SSIS. If you are not C # or VB.net programme

10/01/2024

Introduction
Many times during your ETL process you receive files which are in different encoding than you expect. Example all files are in UTF-16 format but your application expect them to be in UTF-8. Or Sometimes files are in ASCII format and you want to convert to UTF-8.

In this post you will see how to use Advanced File System Task to convert multiple files into desired encoding (e.g.

Introduction Many times during your ETL process you receive files which are in different encoding than you expect. Example all files are in UTF-16 format but y

09/26/2024

Introduction
In our previous article we saw how to call REST API or SOAP Web Service in SSIS. In this article we will only focus how to perform HTTP POST in SSIS using RESTful approach.

HTTP Protocol supports many methods also referred as verb (e.g. GET, PUT, POST, HEAD, DELETE). Based on this verb, target server (API server) can perform desired action.

Introduction In our previous article we saw how to call REST API or SOAP Web Service in SSIS. In this article we will only focus how to perform HTTP POST in SS

09/24/2024

Introduction
ZappySys provides high performance drag and drop connectors for MongoDB Integration. In our previous post we discussed how to query/load MongoDB data (Insert, Update, Delete, Upsert). In this post you will see how to query MongoDB by date (or ISODate) using SSIS MongoDB Source. To see full detail about possible query syntax see online help.

Introduction ZappySys provides high performance drag and drop connectors for MongoDB Integration. In our previous post we discussed how to query/load MongoDB

09/19/2024

Introduction
In this article you will learn how to Setup Amazon Redshift Cluster in few clicks. You will also learn how to set Inbound and Outbound Firewall Rules so you can access Redshift Cluster from outside of AWS Network (e.g. from your corporate network or your home). By default Redshift Cluster cannot be access from outside of your AWS Virtual Network (referred

Introduction In this article you will learn how to Setup Amazon Redshift Cluster in few clicks. You will also learn how to set Inbound and Outbound Firewall R