ODBC PowerPack

Tips and Tricks

• How to Copy Gateway / ODBC settings to another server or new data source
• How to export REST API call to raw JSON / XML using ODBC Driver
• Convert file format / Export REST API to CSV, JSON, XML, Excel - Command Line / ODBC Driver

General

• Why ZappySys supports only OPENQUERY syntax not 4Parts Linked Server Query Syntax
• When to use ZappySys SSIS PowerPack and when to use ODBC PowerPack
• How to upgrade ZappySys ODBC PowerPack
• Where can I configure the TLS with ZappySys ODBC PowerPack
• How to connect to Jira using C#
• Does the Log4j affects Zappysys SSIS PowerPack or ZappySys ODBC or ZappySys ZappyShell

See all 16 articles

Data Gateway

• Error: The data is invalid - Communication link failure (OPENQUERY with SQL Server Linked Server)
• How to use ODBC PowerPack for apps on Linux (i.e. Informatica) to read from REST / JSON / XML
• How to read REST API Data in Talend
• ZappySys Data Gateway Video: The Basics

XML / SOAP API Driver

• How to read / parse nested XML in CData Section / Base64 / encoded text using XML ODBC Driver

JSON / REST API Driver

• How to read GA4 Data API using ODBC JSON Driver
• How to authenticate / call REST API using Dynamic Token in your App using ODBC Driver
• ODBC PowerPack Video: The Basics