Introduction Airtable is a cloud-based platform that combines spreadsheet-style usability with relational data capabilities. Many teams use Airtable to manage projects, CRM pipelines, operations, and content workflows. To analyze this data at scale, you can connect Airtable to Power BI and build interactive reports. Using the ZappySys ODBC Driver for REST APIs, you can query […]
Introduction Pipedrive is a CRM platform used by sales teams to manage leads, deals, contacts, activities, and pipelines. Many organisations need this data in Power BI to monitor sales performance, pipeline health, conversion rates, and team productivity. Using ZappySys ODBC Driver for REST APIs, you can connect to Pipedrive APIs, query CRM data with SQL, […]
Introduction Trello is a popular project management platform used by teams worldwide to organize tasks, track progress, and collaborate on projects. Many applications and tools need to integrate with Trello data for reporting, analytics, and business intelligence. Using Zappysys ODBC Driver for Trello, you can easily query card data, lists, and board information from Trello […]
Introduction Claude.IA is a powerful cloud-native intelligence and automation platform that offers REST APIs for accessing AI models, data processing pipelines, and automation workflows. In this guide, we will demonstrate how to connect to Claude using the Zappysys ODBC Driver for REST APIs with API key authentication. Whether you are using Claude for intelligent document processing, […]
Introduction This tutorial walks you through the process of extracting blog posts and comments data from Blogger using the REST API and Zappysys ODBC connectors. In this guide, you will learn how to authenticate with the Blogger REST API, configure a Zappysys ODBC data source, and query extracted data using ODBC. This approach eliminates the […]
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 […]
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 […]
Introduction In this blog post you will learn how to use Infor Compass JDBC driver in ODBC Apps (i.e. non-JAVA apps) such as Power BI, Excel, Informatica and many more listed here using JDBC-ODBC Bridge Driver. In other words, if you like to use Infor Compass data in your App / Programming language and App […]
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 […]
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 […]