CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Excel Online Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Excel Online replication to AlloyDB.
-
Visualize Landbot Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Landbot data into TIBCO Spotfire.
-
Visualize AgileCRM Data in Tableau
The CData ODBC driver for AgileCRM enables you integrate AgileCRM data into Tableau dashboards.
-
Integrating AlloyDB Data in Talend Cloud Data Management Platform
Connect AlloyDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for AlloyDB.
-
How to connect to Factorial Data in DBVisualizer
Integrate Factorial data with visual data analysis tools and data connection wizards in DBVisualizer
-
Configure the CData JDBC Driver for FormSite in a Connection Pool in Tomcat
Connect to FormSite data from a connection pool in Tomcat.
-
Integrating Antigravity CLI with SAP Concur data via CData CLI
Connect SAP Concur data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Python Connector for Adobe Experience Manager
Learn to install and license the CData Python Connector and configure a connection to live Adobe Experience Manager data.
-
Build Snapchat Ads-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Snapchat Ads data without replication.
-
Replicate Multiple Sage Intacct Accounts via the CData Sync CLI
Replicate multiple Sage Intacct accounts to one or many databases.
-
Use the CData Software ODBC Driver for Klipfolio in MicroStrategy Desktop
Connect to Klipfolio data in MicroStrategy Desktop using the CData Software ODBC Driver for Klipfolio.
-
Visualize ClickTime Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ClickTime data.
-
Connecting Moonlit Workflow with Mode 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 Mode data in real time.
-
Getting Started with the CData ADO.NET Provider for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to create SAP Netweaver Gateway federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Netweaver Gateway data in MySQL .
-
How to Connect DBeaver to Discourse via a JDBC Driver
Manage Discourse data with visual tools in DBeaver like the query browser.
-
Connecting Agentforce with HDFS Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your HDFS data for you.
-
ETL Zendesk in Oracle Data Integrator
This article shows how to transfer Zendesk data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous ConvertKit Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ConvertKit replication to Apache Kafka.
-
Using the CData Software ODBC Driver for Tally in PyCharm
Connect to Tally as an ODBC data source in PyCharm using the CData Software ODBC Driver for Tally.
-
Natively Connect to HelloSign Data in PHP
The CData ODBC driver for HelloSign enables you to create PHP applications with connectivity to HelloSign data. Leverage the native support for ODBC in PHP.
-
Connect to GraphQL Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GraphQL data from Filemaker Pro on Mac.
-
Build Moosend-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Moosend Data and create custom apps in Bubble.
-
Viewing Vercel Data in RAD Studio Data Explorer
How to view Vercel data in RAD Studio Data Explorer using the CData ODBC Driver for Vercel.
-
Visualize Webflow Data in Sisense
Create an ElastiCube in Sisense app with access to Webflow data.
-
Consume Active Directory OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Active Directory feeds that reflect any changes in SAP Lumira.
-
Connect to BigQuery from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from BigQuery data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate SAP Hybris C4C Data in Heroku for Use in Salesforce Connect
Replicate SAP Hybris C4C data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to import Codat Data into Apache Solr
Use the CData Software JDBC Driver for Codat in Data Import Handler and create an automated import of Codat data to Apache Solr Enterprise Search platform.
-
How to connect to Front Data from IntelliJ
Integrate connectivity to Front data with wizards in IntelliJ.
-
View Reports on Real-Time Redshift Data in Power BI Report Server
Use the CData ODBC Driver for Redshift to visualize Redshift data in Power BI Desktop and then publish them to Power BI Report Server.
-
Natively Connect to Xero Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Xero data. Leverage the native support for ODBC in PHP.
-
Connect to Jumpseller Data in DBeaver
Use the CData ODBC Driver to connect to Jumpseller data in DBeaver.
-
Integrating Claude Code with Couchbase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Couchbase data within assisted coding and automated development workflows.
-
Build Microsoft OneDrive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft OneDrive data.
-
How to Visualize Pipeline CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pipeline CRM data in Python.
-
View Reports on Real-Time Apollo Data in Power BI Report Server
Use the CData ODBC Driver for Apollo to visualize Apollo data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to and Visualize Live HelloSign Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HelloSign data.
-
Access WordPress Data from MySQL in Amazon QuickSight
Connect to WordPress and build visualizations of WordPress data using a MySQL Connection in Amazon QuickSight.
-
Access Live Guru Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Guru data from your Google Sheets.
-
Integrate Cline with Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live NetSuite SuiteAnalytics data from within your IDE.
-
Create Exact Online-Connected Applications in Appsmith
Connect to Exact Online Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Exact Online data.
-
Moving Data from Gong to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Gong data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData Tableau Connector for Greenhouse
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Greenhouse.
-
Automated Pinecone Data Replication to Teradata
Use CData Sync to Customize and automate Pinecone data replication to Teradata.
-
Automated Continuous Coinbase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Coinbase replication to Apache Cassandra.
-
Access Live Zoho Books Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Books data into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Books data in the Graph Builder and Query Builder.
-
Connect to and Query Act CRM Data in QlikView over ODBC
Create data visualizations with Act CRM data in QlikView.
-
Query Aweber Data in ColdFusion
Write standard ColdFusion data access code to connect to Aweber data.
-
Use the CData ODBC Driver for Customer.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Customer.io to connect to Customer.io data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Customer.io data in Excel.
-
How to connect and process Google Contacts data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Contacts data.
-
Connect Sage Cloud Accounting to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage Cloud Accounting data using the CData Python MCP Server.
-
Build Data Flows from SQL Server to Pipedrive through SSIS
Easily push SQL Server data to Pipedrive using the CData SSIS Tasks for Pipedrive.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho Projects
Provide connectivity to Zoho Projects data through an SAP BusinessObjects universe.
-
Connect to PayPal Data in DBArtisan
Use wizards in DBArtisan to configure PayPal data as a data source.
-
Automate FreshBooks Data Replication to Couchbase
Use CData Sync to Customize and automate FreshBooks data replication to Couchbase.
-
Integrate Copper with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Copper with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Copper data.
-
Integrate with Cassandra Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Cassandra data in SnapLogic.
-
Automate SAP Concur Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Concur data replication to Azure Data Lake.
-
Getting Started with the CData Power BI Connector for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Dynamics 365 Business Central.
-
Process & Analyze Discourse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Discourse Data.
-
Build Visualizations of GitHub Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of GitHub data in Birst.
-
Stream ShipEngine Data into Apache Kafka Topics
Access and stream ShipEngine data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Freshservice Data in HULFT Integrate
Connect to Freshservice as a JDBC data source in HULFT Integrate
-
Integrate with Azure Analysis Services Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Analysis Services data to a JSON file on disk.
-
Add Blackbaud FE NXT Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Blackbaud FE NXT with the Informatica Enterprise Data Catalog to classify and organize data.
-
Analyze Zuora Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zuora from Power Pivot. You will use the Table Import Wizard to load Zuora data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Coda Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Coda replication to Apache Kafka.
-
Connect Google Search to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Search results using the CData Python MCP Server.
-
Configure the CData JDBC Driver for SAP HANA in a Connection Pool in Tomcat
Connect to SAP HANA data from a connection pool in Tomcat.
-
Natively Connect to Cosmos DB Data in PHP
The CData ODBC driver for Cosmos DB enables you to create PHP applications with connectivity to Cosmos DB data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData SSIS Components for MailChimp
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailChimp.
-
Replicate Qualaroo Data to Multiple Databases
Replicate Qualaroo data to disparate databases with a point-and-click configuration.
-
Integrate LibreChat with Live SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Fieldglass data from within the chat interface.
-
Moving Data from Gorgias to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Gorgias data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use JayDeBeApi to access EnterpriseDB Data in Python
Use standard Python scripting and the development environment of your choice to access live EnterpriseDB data.
-
Automated Continuous MYOB AccountRight Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Amazon S3.
-
DataBind Datadog Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Datadog data to a chart.
-
Automated Continuous Splunk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Splunk replication to Azure SQL Database.
-
Build Missive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Missive data and build web apps with connectivity to live Missive data.
-
Automated Continuous Yelp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Yelp replication to IBM DB2.
-
Query LDAP Objects in DataGrip
Create a Data Source for LDAP in DataGrip and use SQL to query live LDAP objects.
-
Integrating Antigravity CLI with SAP HANA data via CData CLI
Connect SAP HANA data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Oracle Service Cloud Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to SingleStore.
-
Prepare, Blend, and Analyze Freshteam Data in Alteryx Designer (Connect AI)
Build workflows to access live Freshteam data for self-service data analytics.
-
How to Query Live xBase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live xBase data data in natural language using Python.
-
Creating Omnisend-Connected Applications in Unqork
You can use CData Connect AI to feed Omnisend data to Unqork and build custom business apps.
-
Integrating Claude Code CLI with SAP Hybris C4C 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.
-
Connecting Mastra with SurveyMonkey 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 SurveyMonkey data, no replication required.
-
Create Reports from Zoho Creator Data in Looker Studio
Use CData Connect AI to gain access to live Zoho Creator data and create custom reports in Looker Studio.
-
Connect to Toggl Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Toggl data using standard SQL.
-
Integrate OpenCode with Live Jira Assets Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Jira Assets data from within your AI coding agent.
-
Enable the SAP BusinessObjects BI JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP BusinessObjects BI data.
-
Create Reports with Timely Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Timely data.
-
Integrate Live SuiteCRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SuiteCRM data and integrate live SuiteCRM data into apps built in Microsoft Power Apps.
-
Integrating GitHub Copilot with Jodoo 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.
-
Connect to Anaplan from a Connection Pool in WebLogic
Use the CData JDBC Driver for Anaplan to connect to Anaplan data from Web applications running on WebLogic.
-
Build Visualizations of Mode Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mode data in Birst.
-
Automated Continuous Bugsnag Replication to SingleStore
Use CData Sync for automated, continuous, customizable Bugsnag replication to SingleStore.
-
How to Use a Microsoft Access Database to Update HBase Data in Real Time
Update HBase data by creating a linked table in Microsoft Access with the CData HBase ODBC Driver.