CData Software - Knowledge Base
Recent Articles
-
How to connect to Grafana Data in DBVisualizer
Integrate Grafana with visual data analysis tools and data connection wizards in DBVisualizer
-
How to work with Active Directory Data in Apache Spark using SQL
Access and process Active Directory Data in Apache Spark using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Dotmailer Data
Use CData Power BI Connectors to visualize Dotmailer in Power BI.
-
Automated Continuous IBM Cloud Object Storage Replication to Amazon S3
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Amazon S3.
-
Integrating Google Analytics Data in Talend Cloud Data Management Platform
Connect Google Analytics Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Analytics.
-
Use the CData Software JDBC Driver for ShipStation in MicroStrategy Web
Connect to ShipStation in MicroStrategy Web using the CData Software JDBC Driver for ShipStation.
-
Access Live SurveyMonkey Data in Excel 365 Online (Excel for the web)
Connect to SurveyMonkey from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Eventbrite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Eventbrite. Leverage the pyodbc module for ODBC in Python.
-
Integrating Cursor CLI with Google Contacts 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.
-
Integrating Boomi Agentstudio with FHIR Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to FHIR, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Shippo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Shippo. Leverage the pyodbc module for ODBC in Python.
-
DataBind Controls to MailerSend Data in Delphi
DataBind to MailerSend in Delphi with standard data access components and controls.
-
Access xBase Data from MySQL in PHP
Connect to xBase through the standard MySQL libraries in PHP.
-
How to connect PolyBase to Email
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Email.
-
Create Data Visualizations in Cognos BI with Wrike Data
Access Wrike as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connecting Mastra with Certinia 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 Certinia, no replication required.
-
Create Informatica Mappings From/To an ODBC Data Source for Suadeo
Create an ODBC connection to Suadeo in Informatica and browse and transfer Suadeo.
-
Use Dash to Build Web Apps on ServiceNow Data via CData Connect AI
Build interactive Dash web apps on live ServiceNow using pandas and the CData Connect AI Python SDK.
-
Integrating Flowlu Data in Talend Cloud Data Management Platform
Connect Flowlu Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Clockify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Clockify from HeidiSQL.
-
View Reports on Real-Time Teradata Data in Power BI Report Server
Use the CData ODBC Driver for Teradata to visualize Teradata in Power BI Desktop and then publish them to Power BI Report Server.
-
Process & Analyze Excel Online Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Excel Online Data.
-
Build Voice Agents in ElevenLabs with access to Live AlloyDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google AlloyDB.
-
Analyze Live Twitter Ads Data in SAS Viya
Use CData Connect AI to connect to Twitter Ads from SAS Viya and deploy self-service analytics using live Twitter Ads.
-
Create ADP-Connected Dashboards in Grafana
Connect to ADP Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ADP.
-
Create a Data Access Object for Airtable Data using JDBI
A brief overview of creating a SQL Object API for Airtable in JDBI.
-
Integrating LangChain with SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SurveyMonkey within automated workflows.
-
Build a Singer.io Tap for Cloudflare With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cloudflare data using
-
Access Live JSON Services in AWS Lambda (with IntelliJ IDEA)
Connect to live JSON in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Data in MicroStrategy Using the CData ODBC Driver for Dynamics CRM
In this article we show the use of CData ODBC Drivers with the MicroStrategy BI platform.
-
Import Shopify Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Shopify. In this article, you will use the OData format to import Shopify into Microsoft Power Query.
-
Automated Continuous Blackbaud FE NXT Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to IBM DB2.
-
Import and Visualize Keap Data in Power View
Create data visualizations based on Keap in Excel.
-
Build Pipelines with Live Dynamics 365 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 from Google Cloud Data Fusion, enabling the integration of live Microsoft Dynamics 365 into the building and management of effective data pipelines.
-
Connect to Raisers Edge NXT 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 Raisers Edge NXT.
-
Automate Mailgun Data Replication to Couchbase
Use CData Sync to Customize and automate Mailgun replication to Couchbase.
-
Access Live MarkLogic Data in AWS Lambda
Connect to live MarkLogic in AWS Lambda using the CData JDBC Driver.
-
Replicate Multiple MarkLogic Accounts via the CData Sync CLI
Replicate multiple MarkLogic accounts to one or many databases.
-
Build Vault CRM-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Vault CRM to explore live Vault CRM Data in Claude Code to assist with building Vault CRM-powered applications.
-
How to Query Live Autopilot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Autopilot data in natural language using Python.
-
Build a Simple VCL Application for Dynamics 365 Data
How to build a simple VCL Application to view Microsoft Dynamics 365 in RAD Studio using the CData ODBC Driver for Dynamics 365.
-
How to Build an ETL App for Harvest Data in Python with CData
Create ETL applications and real-time data pipelines for Harvest in Python with petl.
-
Automated Continuous Certinia Replication to MySQL
Use CData Sync for automated, continuous, customizable Certinia replication to MySQL.
-
Using the CData Software ODBC Driver for QuickBooks in PyCharm
Connect to QuickBooks as an ODBC data source in PyCharm using the CData Software ODBC Driver for QuickBooks.
-
Enable the Spark JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Spark SQL.
-
Edit and Search External FHIR Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of FHIR to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create FHIR Data objects that you can access from apps and the dashboard.
-
How to create Guru federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Guru in MySQL .
-
Integrating GitHub Copilot CLI with iContact 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.
-
Replicate Multiple Zoho Creator Accounts via the CData Sync CLI
Replicate multiple Zoho Creator accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for HelloSign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HelloSign.
-
Use the CData ODBC Driver for Codat from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Codat to connect to Codat from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Codat in Excel.
-
Build Google Directory-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Directory to explore live Google Directory Data in Claude Code to assist with building Google Directory-powered applications.
-
Connect to CapsuleCRM Data in Jaspersoft Studio
Execute SQL to remote CapsuleCRM in Jaspersoft Studio.
-
How to Access Live SAP Ariba Procurement Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Ariba Procurement enables you to integrate SAP Ariba Procurement into workflows built using Microsoft Power Automate Desktop.
-
Build an MVC Application with Connectivity to QuickBooks
CData ADO.NET Providers can be used from many tools and IDEs. In this article we show how to connect to QuickBooks from an MVC project using the CData ADO.NET Provider for QuickBooks. Although this article uses the QuickBooks Data Provider, the same process can be used with any of the CData ADO.NET Providers.
-
Replicate IBM Cloud Object Storage Data in Heroku for Use in Salesforce Connect
Replicate IBM Cloud Object Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating PDFMonkey Data in Talend Cloud Data Management Platform
Connect PDFMonkey Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous MailChimp Replication to SQL Server
Use CData Sync for automated, continuous, customizable MailChimp replication to SQL Server.
-
Visualize Reckon Data in TIBCO Spotfire through ADO.NET
Integrate Reckon into dashboards in TIBCO Spotfire.
-
Creating MariaDB-Connected Applications in Unqork
You can use CData Connect AI to feed MariaDB to Unqork and build custom business apps.
-
Connect to Short.io Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Short.io in the Denodo Virtual DataPort Administrator.
-
Integrate Live Facebook Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Facebook and integrate live Facebook into apps built in Microsoft Power Apps.
-
Create SAP Concur-Connected Applications in Appsmith
Connect to SAP Concur Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Concur.
-
Create ZohoDesk Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoDesk from PowerBI.com to create Power BI Dataflows with real-time data.
-
Bidirectional Access to Rootly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Rootly in Filemaker Pro for Mac or Windows.
-
A PostgreSQL Interface for Lakebase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Lakebase JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with ADP Data in Apache Spark using SQL
Access and process ADP Data in Apache Spark using the CData Software JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Acumatica Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Acumatica ERP for you.
-
Visualize SAP Business Warehouse Data in Tableau
The CData ODBC driver for SAP Business Warehouse enables you integrate SAP Business Warehouse into Tableau dashboards.
-
Connect to Monday.com Data from HeidiSQL
Use CData Connect AI to connect to and query live Monday.com from HeidiSQL.
-
Use the CData Software ODBC Driver for PivotalTracker in MicroStrategy Desktop
Connect to PivotalTracker in MicroStrategy Desktop using the CData Software ODBC Driver for PivotalTracker.
-
Connect to SingleStore Data in DBeaver
Use the CData ODBC Driver to connect to SingleStore in DBeaver.
-
Automated Continuous Access Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Access replication to Apache Cassandra.
-
Access Live Amazon DynamoDB Data in TIBCO Data Virtualization
Use the Amazon DynamoDB Tibco DV Adapter to create a Amazon DynamoDB data source in TIBCO Data Virtualization Studio and gain access to live Amazon DynamoDB from your TDV Server.
-
Integrating LlamaIndex with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Certinia in real time.
-
How to Easily Query Oracle SCM Data in OpenOffice Base
Connect to Oracle SCM data in OpenOffice Base using the CData ODBC Driver for Oracle SCM and generate reports with live data insights.
-
Stream Presto Data into Apache Kafka Topics
Access and stream Presto in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Scrapfly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Scrapfly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Scrapfly.
-
Visualize Live Microsoft Entra ID Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Entra ID into custom reports in Power BI.
-
Create Kintone-Connected Applications in Appsmith
Connect to Kintone Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Kintone.
-
How to connect to Outlook Data with Squirrel SQL client
Connect to Outlook and execute queries in the Squirrel SQL Client.
-
DataBind Charts to Office 365 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Office 365 from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use Microsoft Copilot Studio to talk to your GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your GitHub for you.
-
Integrate Goose with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Asana from within the local AI agent.
-
Automated Continuous Clio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Clio replication to Amazon Redshift.
-
Work with Oracle Sales Data in FoxPro
Load Oracle Sales into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Spotify Data in ColdFusion
Write standard ColdFusion data access code to connect to Spotify.
-
Create a Data Access Object for YouTube Analytics Data using JDBI
A brief overview of creating a SQL Object API for YouTube Analytics in JDBI.
-
Automate Insightly Data Replication to Couchbase
Use CData Sync to Customize and automate Insightly replication to Couchbase.
-
Connect to MailerLite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MailerLite to connect to MailerLite and execute queries in PowerBuilder.
-
Creating CouchDB-Connected Applications in Unqork
You can use CData Connect AI to feed Apache CouchDB to Unqork and build custom business apps.
-
Getting Started with the CData SSIS Components for Float
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Float.
-
Getting Started with the CData Tableau Connector for Drift
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze Oracle Sales Data in Looker
Use CData Connect AI to connect to Oracle Sales Data from Looker and build custom apps using live Oracle Sales.
-
Connect to Pushbullet Data in Aqua Data Studio
Access Pushbullet from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Load Drip Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Drip to a database.
-
Connecting Moonlit Workflow with MongoDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your MongoDB in real time.
-
Query Zoho CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho CRM.
-
Integrating GitHub Copilot CLI with Paymo 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 OneNote Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft OneNote in Airbyte.