CData Software - Knowledge Base
Recent Articles
-
Connect to DocuSign Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for DocuSign data in Airbyte.
-
Import and Visualize BambooHR Data in Power View
Create data visualizations based on BambooHR data in Excel.
-
Create Dashboards and Visualize Live Paymo Data in Geckoboard
Use CData Connect AI to connect to live Paymo data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Kiro with Aircall 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.
-
Natively Connect to JotForm Data in PHP
The CData ODBC driver for JotForm enables you to create PHP applications with connectivity to JotForm data. Leverage the native support for ODBC in PHP.
-
Automated Continuous MailChimp Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MailChimp replication to Azure SQL Database.
-
Build Zuora-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zuora Data and create custom apps in Mendix.
-
Create Datasets from Workable in Domo Workbench and Build Visualizations of Workable Data in Domo
Use the CData Software ODBC Driver for Workable to create datasets from Workable data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous NetSuite Replication to Vertica
Use CData Sync for automated, continuous, customizable NetSuite replication to Vertica.
-
Integrating eBay Data in Talend Cloud Data Management Platform
Connect eBay Data with Talend Cloud Data Management Platform using the CData JDBC Driver for eBay.
-
Connect Samanage Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Samanage data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Twitter Ads Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Twitter Ads data.
-
Connect to Facebook Data in RapidMiner
Integrate Facebook data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for Avalara AvaTax in MicroStrategy
Connect to Avalara AvaTax data in MicroStrategy Developer using the CData Software ODBC Driver for Avalara AvaTax.
-
Create Power BI Reports on Real-Time Instagram Data
Use the CData ODBC Driver for Instagram to visualize Instagram data in Power BI Desktop.
-
Build MVC Applications with Connectivity to Act CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Act CRM from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for Mouseflow in MicroStrategy Desktop
Connect to Mouseflow data in MicroStrategy Desktop using the CData Software ODBC Driver for Mouseflow.
-
Automate LeadDesk Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LeadDesk data from PowerShell? This article demonstrates how to utilize the LeadDesk Cmdlets for tasks like connecting to LeadDesk data, automating operations, downloading data, and more.
-
How to Replicate Data Between MySQL and SQL Server with CData
In this entry you will find how to replicate MySQL data into SQL Server (and vice versa) using CData.
-
Access Accelo Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Accelo data.
-
How to create Mouseflow federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mouseflow data in MySQL .
-
Connect to Real-Time ZohoDesk Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoDesk data in Power Apps.
-
Connect to Hugging Face Data in NetBeans
Connect to Hugging Face data in NetBeans with the data source configuration wizard.
-
Integrating Antigravity CLI with JSON services via CData CLI
Connect JSON services to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Semantic Layer Views for Twilio Data in APOS Live Data Gateway
Use the CData Connector for Twilio in APOS Live Data Gateway to build Semantic Layer Views for Twilio data.
-
How to integrate Nuclia with Apache Airflow
Access and process Nuclia data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Samanage Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Samanage data for you.
-
Connect to Tally in SpagoBI
Create reports featuring live Tally data in SpagoBI Studio. Host Tally reports on SpagoBI Server.
-
Connect to Workable Data from PowerBuilder via JDBC
This article demonstrates how to access Workable data from PowerBuilder using the Workable JDBC Driver.
-
Access Live xBase Data in Coginiti Pro
Connect to and query live xBase data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Cosmos DB Data from MySQL in Amazon QuickSight
Connect to Cosmos DB and build visualizations of Cosmos DB data using a MySQL Connection in Amazon QuickSight.
-
Import Real-Time Mixpanel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mixpanel data in ColdFusion.
-
Integrate Live LeadDesk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LeadDesk data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use Dash to Build to Web Apps on Hubstaff Data
Create Python applications that use pandas and Dash to build Hubstaff-connected web apps.
-
Publish Airtable-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Airtable data.
-
Access Greenplum Data from MySQL in Amazon QuickSight
Connect to Greenplum and build visualizations of Greenplum data using a MySQL Connection in Amazon QuickSight.
-
Replicate Postmark Data to Multiple Databases via the CData Sync CLI
Replicate Postmark data to disparate databases with a single configuration.
-
Automated Continuous Sage Intacct Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sage Intacct replication to AlloyDB.
-
Import Real-Time Placid Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Placid data in ColdFusion.
-
Integrate Cursor with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle SCM data from within the editor.
-
Access HDFS Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for HDFS data.
-
How to Connect to PostgreSQL Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PostgreSQL data. Leverage the pyodbc module for ODBC in Python.
-
Automate iContact Data Replication to SAP HANA
Use CData Sync to customize and automate iContact data replication to SAP HANA.
-
Publish CloudConvert-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CloudConvert data.
-
How to Access Live OneNote Data in Power Automate Desktop via ODBC
The CData ODBC Driver for OneNote enables you to integrate OneNote data into workflows built using Microsoft Power Automate Desktop.
-
Connect Accelo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Accelo data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Twilio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Twilio with External Services.
-
Build a Singer.io Tap for GraphQL With the CData Python Connector
Learn how to easily build a Singer.io Tap for live GraphQL data using the CData Python Connector.
-
Integrate Theia IDE with Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live ShipStation data from within the development environment.
-
Create a Data Access Object for JSON Services using JDBI
A brief overview of creating a SQL Object API for JSON services in JDBI.
-
Connect to Vault CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Vault CRM data.
-
Connect to RabbitMQ Data in Ruby
Connect to RabbitMQ data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating OpenCode with FreeAgent 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.
-
Create Data Visualizations Based On DB2 Data in Mode
Use CData Connect AI to connect to DB2 Data from Mode and build visualizations using live DB2 data.
-
Integrating LlamaIndex with SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SendGrid data in real time.
-
Use Manus AI to Talk to Your Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Airtable data.
-
Connect and Query Live eBay Analytics Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live eBay Analytics data into Databricks and enable direct, live querying and analysis without replication.
-
Seamlessly Bring SQL Server Data into Retool Using CData Connect AI
Integrate SQL Server data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Getting Started with the CData Python Connector for Elasticsearch
Learn to install and license the CData Python Connector and configure a connection to live Elasticsearch data.
-
Visualize Live Zoom Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoom data into custom reports in Power BI.
-
Integrate Live ShipEngine Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ShipEngine data and integrate live ShipEngine data into apps built in Microsoft Power Apps.
-
Create Informatica Mappings From/To a JDBC Data Source for Square
Create Square data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect and Query Live FTP Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live FTP data into Databricks and enable direct, live querying and analysis without replication.
-
Create Informatica Mappings From/To an ODBC Data Source for CapsuleCRM
Create an ODBC connection to CapsuleCRM in Informatica and browse and transfer CapsuleCRM data.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Inventory Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Inventory data to SQL Server.
-
Getting Started with the CData JDBC Driver for Wrike
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Wrike.
-
Connect to Discord Data in Jaspersoft Studio
Execute SQL to remote Discord data in Jaspersoft Studio.
-
Use the CData ODBC Driver for Rebilly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Rebilly to connect to Rebilly data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Rebilly data in Excel.
-
Use Grok to Talk to Your Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Analytics data for you.
-
Integrate Gong Data in the Pentaho Report Designer
Publish reports based on Gong data in the Pentaho BI tool.
-
Access Live Testmonitor Data in Coginiti Pro
Connect to and query live Testmonitor data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Antigravity CLI with Oracle HCM Cloud data via CData CLI
Connect Oracle HCM Cloud data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate PostgreSQL Data into Power Automate Desktop using CData Connect
CData Connect for PostgreSQL Data enables you to integrate PostgreSQL data into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Kintone to Snowflake using CData SSIS Components.
Easily push Kintone data to Snowflake using the CData SSIS Tasks for Kintone and Snowflake.
-
Access Live Oracle SCM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle SCM data from your Excel spreadsheets.
-
Configure the CData JDBC Driver for Customer.io in a Connection Pool in Tomcat
Connect to Customer.io data from a connection pool in Tomcat.
-
Import Real-Time Salesloft Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesloft data in ColdFusion.
-
Connect Azure DevOps Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure DevOps data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Deploy the ADO.NET Provider for Cloudflare on an SSRS Report Server
Connect to Cloudflare data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Excel Spreadsheet Automation on Vault CRM Data with the QUERY Formula
Pull data from Vault CRM, automate spreadsheets, and more with the QUERY formula.
-
How to create an RPA flow for Google Calendar Data in UiPath Studio
Use the Google Calendar ODBC Driver to create workflows that access real-time Google Calendar data without any coding.
-
Integrate with SAP Business Warehouse Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Business Warehouse data in SnapLogic.
-
Connect to SAP ByDesign Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP ByDesign data in Airbyte.
-
Establish a Live Connection with Outreach.io Data using Tableau Bridge
The CData ODBC Driver for Outreach.io enables you to integrate live Outreach.io data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live SAP Concur Data in AWS Lambda
Connect to live SAP Concur data in AWS Lambda using the CData JDBC Driver.
-
Build SQL Server-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SQL Server data and build web apps with connectivity to live SQL Server data.
-
Design BIRT Reports on JobNimbus Data
Provide current JobNimbus data to your embedded analytics.
-
Create Informatica Mappings From/To an ODBC Data Source for ActiveCampaign
Create an ODBC connection to ActiveCampaign in Informatica and browse and transfer ActiveCampaign data.
-
Migrating data from Mailgun to Snowflake using CData SSIS Components.
Easily push Mailgun data to Snowflake using the CData SSIS Tasks for Mailgun and Snowflake.
-
Visualize Live Guru Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Guru data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with SAP Netweaver Gateway Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Netweaver Gateway data in SnapLogic.
-
Migrating data from Workable to Google BigQuery using CData SSIS Components.
Easily push Workable data to Google BigQuery using the CData SSIS Tasks for Workable and Google BigQuery.
-
Access Live BigQuery Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live BigQuery data through MCP integration.
-
Excel Spreadsheet Automation on Office 365 Data with the QUERY Formula
Pull data from Office 365, automate spreadsheets, and more with the QUERY formula.
-
Link OpenWeatherMap with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate OpenWeatherMap data in Filemaker Pro for Mac or Windows.
-
Use Dash to Build Web Apps on SAP HANA XS Advanced Data via CData Connect AI
Build interactive Dash web apps on live SAP HANA XS Advanced data using pandas and the CData Connect AI Python SDK.
-
Integrate Open WebUI with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Drive data from within the chat interface.
-
Integrate Real-Time Access to Tally in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Tally data in real time.
-
Deploy the ADO.NET Provider for Datadog on an SSRS Report Server
Connect to Datadog data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Apps with Live Oracle Data Using the Low-Code Development Platform of Mendix
Connect Oracle data with Mendix to build apps using the CData JDBC Driver for Oracle.