Category Archives: ODBC PowerPack

How to add non-admin user access for inked servers

Posted on by ZappySys Team

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:

This issue occurs because the Linked Server does […]

Call ChatGPT REST API in SSIS

Updated on by ZappySys Team

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 […]

Using Custom API Connector File - New ODBC DSN - ZappySys API Driver

How to create custom ODBC Driver for API without coding

Updated on by ZappySys

Introduction Imagine this situation, you or users of your product wants to consume some REST API in ETL / BI / Programming Tools using ODBC / JDBC Driver interface but there are no ODBC / JDBC Driver available for that API and you dont even know coding? If you are in a situation No Problem […]

How to call NetSuite RESTlet API in SSIS / ODBC

Updated on by ZappySys

Introduction In our previous post we saw how to read API data in SSIS. This post we will cover how to call NetSuite RESTlet to read / write data in SSIS or ODBC Apps. For demo purpose we will use SSIS PowerPack REST API Task but concepts and many UI elements remain same for ODBC […]

Open ZappySys Data Gateway

How to Secure ZappySys Data Gateway (Network Settings)

Updated on by Sudhir Dandale

Introduction In our previous article we explored several powerful features of the ZappySys Data Gateway. This follow‑up post focuses on keeping the gateway secure. You’ll learn about the new options available in the Network Settings tab, how to restrict access by IP address, and how to grant dataset‑level permissions to non‑admin users. Network Settings Overview […]

How to register Salesforce App and obtain Client ID / Secret (for API Call / OAuth)

Updated on by ZappySys

Introduction Using Salesforce Connection with OAuth App in SSIS / ODBC Once you have Client ID / Secret, you can use it in the Salesforce Connection in SSIS Connector / ODBC Driver for Salesforce like below (Only the new version will have OAuth option) Troubleshooting Known Issues Let’s look at some common issues with Salesforce […]

Create a new connection

Download Gmail Attachment in SSIS

Updated on by ZappySys Team

Introduction Downloading Gmail Attachments in SSIS is always a little more difficult than working with simple text or numeric columns. If you are not an SSIS expert, doing it for the first time may be challenging. That is why we created this article for you. This is a common request we receive, so we are […]

Importing Virtual Tables in MS Access (JSON REST API Example)

Using Custom Objects in ZappySys Drivers (Proc / View)

Updated on by ZappySys

Introduction ODBC PowerPack v1.2 release brought an interesting feature for all API drivers. New version gives you an ability to create Custom Objects. You can create parameterized Stored Procedure and Virtual Tables on the same Data Source (ODBC DSN or Data Gateway Data Source). For more information you see here Custom Objects There are mainly […]

Download AdWords report using Google Ads API, ODBC, and XML Driver

Updated on by ZappySys

Introduction In the previous article, we learned how to get data from AdWords in SSIS and basically control your AdWords account programmatically, outside the dashboard. In this one, we will continue on how to download AdWords report by using Google Ads API, ODBC, and ZappySys XML Driver. Let’s not waste our time and cut to […]