CData Software - Knowledge Base
Recent Articles
-
Extend Google Sheets with FHIR Data
Make calls to FHIR from Google Apps Script via the API Server.
-
Visualize Live Airtable Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Airtable into custom reports in Power BI.
-
DataBind Controls to Optimizely Data in C++Builder
DataBind to Optimizely in C++Builder with standard components and controls.
-
A PostgreSQL Interface for Greenplum Data using the CData ODBC Driver
Use the SQL Gateway and Greenplum ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Neo4J Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Neo4J through natural language.
-
Connect to JSON Services in ACL Analytics
Connect to JSON via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to JSON.
-
Build GitLab-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for GitLab Data and create custom apps in Mendix.
-
Create Data Visualizations Based On Asana Data in Mode
Use CData Connect AI to connect to Asana Data from Mode and build visualizations using live
-
Connect to Live Google Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to Google Analytics Data in CData Connect AI and connect to your Google Analytics from MicroStrategy.
-
Integrate Clockify Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Clockify from Informatica Cloud.
-
Choosing the Best Method to Connect FreshBooks to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FreshBooks from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to & Open Discord Data in Microsoft Excel
This article uses the CData ODBC driver for Discord to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software JDBC Driver for Dynamics CRM in MicroStrategy Web
Connect to Microsoft Dynamics CRM in MicroStrategy Web using the CData Software JDBC Driver for Dynamics CRM.
-
Connect to and Visualize Live Printify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Printify.
-
Import and Visualize ZohoExpense Data in Power View
Create data visualizations based on ZohoExpense in Excel.
-
Integrating GitHub Copilot CLI with Odoo ERP via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to MailChimp in SpagoBI
Create reports featuring live MailChimp in SpagoBI Studio. Host MailChimp reports on SpagoBI Server.
-
How to connect to Anaplan Data in DBVisualizer
Integrate Anaplan with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Authorize.Net Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Authorize.Net with the CData JDBC Driver for Authorize.Net.
-
How to create FreshBooks federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for FreshBooks in MySQL .
-
Use ChatGPT to Talk to Your Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Twitter Ads for you.
-
How to Connect Phoenix Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Phoenix data in real time using natural language.
-
Integrate Azure Synapse Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Synapse and integrate live Azure Synapse into your Power Automate tasks.
-
Integrating Coinbase Data in Talend Cloud Data Management Platform
Connect Coinbase Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query, Visualize, and Share live Hive Data in Redash
Use CData Connect AI to connect to live Apache Hive in Redash for querying, visualizing, and sharing.
-
Integrate with MarkLogic Data in JReport Designer
Create charts and reports based on MarkLogic in JReport Designer.
-
Use Agno to Talk to Your Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Workday for you.
-
Create Dynamic SuiteCRM Grids Using the Infragistics XamDataGrid
Learn how you can connect SuiteCRM to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Oracle Eloqua Reporting Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Apache Kafka.
-
How to Query HubDB Data in MySQL Workbench
Execute MySQL queries against live HubDB from MySQL Workbench.
-
Integrating Asana Data in Talend Cloud Data Management Platform
Connect Asana Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Asana.
-
Model, Search, and Visualize Live Azure Analysis Services Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Analysis Services for modeling, searching, and visualizing.
-
Connect to Live Azure Synapse Data in MicroStrategy through CData Connect AI
Create a live connection to Azure Synapse Data in CData Connect AI and connect to your Azure Synapse from MicroStrategy.
-
Access ServiceNow Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ServiceNow from HeidiSQL.
-
How to Create Power BI Visual Reports with Real-Time Bannerbear Data
Use CData Power BI Connectors to visualize Bannerbear in Power BI.
-
Connect to Facebook Data in NetBeans
Connect to Facebook in NetBeans with the data source configuration wizard.
-
How to Connect to Live Azure Data Lake Storage Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Azure Data Lake Storage for you.
-
Build Charts with Basecamp Data in Clear Analytics
Create dynamic charts and perform analytics based on Basecamp in Clear Analytics.
-
Migrating data from SAP HANA XS Advanced to Databricks using CData SSIS Components.
Easily push SAP HANA XS Advanced to Databricks using the CData SSIS Tasks for SAP HANA XS Advanced and Databricks.
-
Choosing the Best Method to Connect Procore to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Procore from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Trigger Workday IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Workday with standard wizards in Logic Apps.
-
Connect and Visualize Live Zoho CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoho CRM into the Databricks platform and create visualization dashboards with real-time Zoho CRM.
-
Integrate Theia IDE with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Analyze Neo4J Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Neo4J with the CData JDBC Driver for Neo4J.
-
Build Dashboards with MongoDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on MongoDB in Dundas BI.
-
Connect to SAP Ariba Procurement from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Ariba Procurement, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software ODBC Driver for Azure Table in MicroStrategy Desktop
Connect to Azure Table Storage in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Table.
-
Prepare, Blend, and Analyze Yelp Data in Alteryx Designer (ODBC)
Build workflows to access live Yelp for self-service data analytics.
-
Use ChatGPT to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Salesforce Marketing Cloud for you.
-
Publish Reports with ZohoPeople Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoPeople.
-
Connect to IBM Informix in SpagoBI
Create reports featuring live IBM Informix in SpagoBI Studio. Host IBM Informix reports on SpagoBI Server.
-
Explore Geographical Relationships in BigCommerce Data with Power Map
Create data visualizations with BigCommerce in Power Map.
-
Connect to Teradata Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Teradata and the Script function in FileMaker Pro to connect to Teradata and work with Teradata in your FileMaker application.
-
How to Query Live Act CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Act CRM data in natural language using Python.
-
Use the CData Software JDBC Driver for CampaignMonitor in MicroStrategy
Connect to CampaignMonitor in MicroStrategy Developer using the CData Software JDBC Driver for CampaignMonitor.
-
Automated Continuous MessageBird Replication to MySQL
Use CData Sync for automated, continuous, customizable MessageBird replication to MySQL.
-
Build Automated Workflows with Live Databricks Data in Workato
Use CData Connect AI to connect to live Databricks and build automated workflows in Workato.
-
How to Connect to Live Dynamics CRM Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft Dynamics CRM through natural language.
-
Connecting Mastra with Pipedrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Pipedrive, no replication required.
-
Automated Continuous Salesforce Pardot Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Oracle.
-
Feed Elasticsearch Data into FineReport
How to set Elasticsearch as a JDBC data source in FineReport.
-
How to Connect the Power BI Service to Google Contacts: Complete Guide
Connect to the CData Software Power BI Connector for Google Contacts from PowerBI.com to provide real-time Google Contacts across the organization.
-
Access Cloudant Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access IBM Cloudant from your Oracle system.
-
DataBind Controls to Mode Data in C++Builder
DataBind to Mode in C++Builder with standard components and controls.
-
Integrate Live FTP Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to FTP from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live FTP Servers.
-
Extract, Transform, and Load Exa Data in Informatica PowerCenter
Create a simple Workflow for Exa in Informatica PowerCenter.
-
Automate Avalara AvaTax Data Replication to Azure Synapse
Use CData Sync to customize and automate Avalara AvaTax replication to Azure Synapse.
-
Connect to Google Contacts Data in RazorSQL
Connect to Google Contacts from wizards and query Google Contacts from the GUI in the RazorSQL database management tool.
-
Import and Visualize ADP Data in Power View
Create data visualizations based on ADP in Excel.
-
Access Live Nethunt Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Nethunt in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Claude Code with Oracle Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Database within assisted coding and automated development workflows.
-
Connect to Okta Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Okta.
-
Connect to Real-Time Stripe Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Stripe and Dataflow to import and use Stripe in Power Apps.
-
Create Datasets from Azure DevOps in Domo Workbench and Build Visualizations of Azure DevOps Data in Domo
Use the CData Software ODBC Driver for Azure DevOps to create datasets from Azure DevOps in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData ADO.NET Provider for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zoho Creator.
-
Use the CData Software ODBC Driver for MySQL in MicroStrategy Web
Connect to MySQL in MicroStrategy Web using the CData Software ODBC Driver for MySQL.
-
Connect to Wistia Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Wistia in the Denodo Virtual DataPort Administrator.
-
Write a Simple Go Application to work with DocuSign Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to DocuSign.
-
ETL Printful in Oracle Data Integrator
This article shows how to transfer Printful into a data warehouse using Oracle Data Integrator.
-
Replicate Presto Data to Multiple Databases
Replicate Presto to disparate databases with a point-and-click configuration.
-
Create Reports with Clari Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clari.
-
Provide OData Services of TaxJar Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for TaxJar by developing a WCF Service Application.
-
How to load CockroachDB data into Elasticsearch via Logstash
Introducing a simple method to load CockroachDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build SparkPost-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SparkPost.
-
Design BIRT Reports on SAP Business One Data
Provide current SAP Business One to your embedded analytics.
-
Integrating OpenCode Terminal with PDFMonkey Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Analyze ActiveCampaign Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of ActiveCampaign and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Sugar CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sugar CRM.
-
How to Build an ETL App for Azure DevOps Data in Python with CData Connect AI
Build ETL pipelines that read and write live Azure DevOps in Python with petl and the CData Connect AI Python SDK.
-
Build MailChimp-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for MailChimp to explore live MailChimp Data in GitHub Copilot to assist with building MailChimp-powered applications.
-
Create a Data Access Object for Sendwithus Data using JDBI
A brief overview of creating a SQL Object API for Sendwithus in JDBI.
-
Import SAS xpt Data Using Azure Data Factory
Use CData Connect AI to connect to SAS xpt Data from Azure Data Factory and import live SAS XPORT.
-
Build Elasticsearch-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Elasticsearch.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live FreshBooks using the Model Context Protocol.
-
Trigger FTP IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for FTP with standard wizards in Logic Apps.
-
Natively Connect to Float Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Float. Leverage the native support for ODBC in PHP.
-
Create Dynamic PDFMonkey Grids Using the Infragistics XamDataGrid
Learn how you can connect PDFMonkey to Infragistics XamDataGrid to build dynamic grids.
-
Connect to NASA Data in RapidMiner
Integrate NASA with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Authorize.Net Replication to SQLite
Use CData Sync for automated, continuous, customizable Authorize.Net replication to SQLite.
-
Connect to Apollo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital