CData Software - Knowledge Base
Recent Articles
-
Connect to Elorus Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Elorus as an External Source in Dremio.
-
Integrating Claude Code CLI with Phoenix 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.
-
Import and Visualize Billsby Data in Power View
Create data visualizations based on Billsby in Excel.
-
Connect to Dropbox Data from a Connection Pool in JBoss
Integrate Dropbox into Java servlets: Use the Management Console in JBoss to install the Dropbox JDBC Driver.
-
Connect to Coinbase Data in RazorSQL
Connect to Coinbase from wizards and query Coinbase from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData ADO.NET Provider for Exa
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to ConvertKit Data in Ruby
Connect to ConvertKit in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Amazon S3 Data in DBVisualizer
Integrate Amazon S3 with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Parquet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Parquet replication to Apache Cassandra.
-
Connect to and Visualize Live Google Sheets Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Sheets.
-
Access Odoo Data from MySQL in Amazon QuickSight
Connect to Odoo and build visualizations of Odoo ERP using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Zoom Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoom replication to SingleStore.
-
Automated Continuous Microsoft Exchange Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Amazon S3.
-
Use JayDeBeApi to access AlloyDB Data in Python
Use standard Python scripting and the development environment of your choice to access live Google AlloyDB.
-
Build SAP HANA-Connected Apps in Choreo
Use CData Connect AI to connect to SAP HANA Data from Choreo and build custom apps using live SAP HANA.
-
Getting Started with the CData Tableau Connector for Bugsnag
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build an OLAP Cube in SSAS from Samanage Data
Establish a connection to Samanage data from SQL Server Analysis Services, and use the Samanage Data Provider to build OLAP cubes for use in analytics and reporting.
-
View Reports on Real-Time SharePoint Excel Services Data in Power BI Report Server
Use the CData ODBC Driver for SharePoint Excel Services to visualize SharePoint Excel Services in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Apps with Live CloudConvert Data Using the Low-Code Development Platform of Mendix
Connect CloudConvert with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous QuickBooks Online Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Google BigQuery.
-
DataBind Controls to eBay Data in Delphi
DataBind to eBay in Delphi with standard data access components and controls.
-
Build an OLAP Cube in SSAS from Adobe Analytics Data
Establish a connection to Adobe Analytics data from SQL Server Analysis Services, and use the Adobe Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Build an ETL App for Apollo Data in Python with CData Connect AI
Build ETL pipelines that read and write live Apollo in Python with petl and the CData Connect AI Python SDK.
-
How to import Act CRM Data into Apache Solr
Use the CData Software JDBC Driver for Act CRM in Data Import Handler and create an automated import of Act CRM to Apache Solr Enterprise Search platform.
-
Load Teamgate Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Teamgate to a database.
-
How to connect to Salesforce CRM Analytics Data with Squirrel SQL client
Connect to Salesforce CRM Analytics and execute queries in the Squirrel SQL Client.
-
How to integrate Elorus with Apache Airflow
Access and process Elorus in Apache Airflow using the CData JDBC Driver.
-
Enable the BigQuery JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google BigQuery.
-
Create SSAS Tabular Models from SurveyMonkey Data
How to build a SQL Server Analysis Service Tabular Model from SurveyMonkey using CData drivers.
-
Natively Connect to Apollo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apollo. Leverage the native support for ODBC in PHP.
-
Import and Visualize CouchDB Data in Power View
Create data visualizations based on Apache CouchDB in Excel.
-
Provide OData Services of PDFMonkey Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PDFMonkey by developing a WCF Service Application.
-
Connect to Cvent Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cvent and the SQL Gateway to access Cvent from Google Apps Script.
-
Access SAP SuccessFactors 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 SAP SuccessFactors.
-
Create Reports from IBM Cloud Object Storage Data in Looker Studio
Use CData Connect AI to gain access to live IBM Cloud Object Storage and create custom reports in Looker Studio.
-
Integrate Jira with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jira with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Atlassian Jira.
-
Access Live Oracle Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Database in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Testmonitor
Provide connectivity to Testmonitor through an SAP BusinessObjects universe.
-
How to Connect to Live Snapchat Ads Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Snapchat Ads for you.
-
Automated Continuous AdRoll Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable AdRoll replication to Amazon Redshift.
-
Build Klaviyo-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Klaviyo Data and create custom apps in Bubble.
-
Greenplum Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Greenplum facts in real time.
-
Create Close Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Close data access from reports, embedded analytics, and more.
-
Getting Started with the CData Tableau Connector for FreshBooks
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Apps from Xero Data in Qlik Sense Cloud
Use CData Connect AI to connect to Xero Data and build apps from live Xero Accounting in Qlik Sense Cloud.
-
Use Dash to Build to Web Apps on DB2 Data
Create Python applications that use pandas and Dash to build DB2-connected web apps.
-
Connecting Mastra with Monday.com 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 Monday.com, no replication required.
-
Connect to Dynamics 365 Business Central Data in NetBeans
Connect to Dynamics 365 Business Central in NetBeans with the data source configuration wizard.
-
Seamlessly Bring SAP ByDesign Data into Retool Using CData Connect AI
Integrate SAP ByDesign data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Claude Code with MarkLogic Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MarkLogic within assisted coding and automated development workflows.
-
Enable the ZohoPeople JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoPeople.
-
Integrating Antigravity CLI with Aircall via CData CLI
Connect Aircall to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind Charts to EmailOctopus Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to EmailOctopus 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.
-
Integrating OpenCode Terminal with Greenplum 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.
-
How to Easily Query MailChimp Data in OpenOffice Base
Connect to MailChimp data in OpenOffice Base using the CData ODBC Driver for MailChimp and generate reports with live data insights.
-
Connect to Blackbaud FE NXT Data in HULFT Integrate
Connect to Blackbaud FE NXT as a JDBC data source in HULFT Integrate
-
How to connect to ZarMoney Data with Squirrel SQL client
Connect to ZarMoney and execute queries in the Squirrel SQL Client.
-
Work with PDFMonkey Data in FoxPro
Load PDFMonkey into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous PolarTeamPro Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to AlloyDB.
-
A PostgreSQL Interface for Excel Online Data (MySQL Remoting via JDBC)
Use the Remoting features of the Excel Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Yelp Data in PHP
The CData ODBC driver for Yelp enables you to create PHP applications with connectivity to Yelp. Leverage the native support for ODBC in PHP.
-
Connect to Cvent Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Cvent from Filemaker Pro on Mac.
-
Build Apps with Live OData Services Using the Low-Code Development Platform of Mendix
Connect OData with Mendix to build apps using the CData JDBC Driver for OData.
-
Automated Continuous ServiceNow Replication to MongoDB
Use CData Sync for automated, continuous, customizable ServiceNow replication to MongoDB.
-
Use Dash to Build Web Apps on SAP Hybris C4C Data via CData Connect AI
Build interactive Dash web apps on live SAP Hybris C4C using pandas and the CData Connect AI Python SDK.
-
Build Automated Workflows with Live SAP Netweaver Gateway Data in Workato
Use CData Connect AI to connect to live SAP Netweaver Gateway and build automated workflows in Workato.
-
Using the CData Software ODBC Driver for LDAP in PyCharm
Connect to LDAP as an ODBC data source in PyCharm using the CData Software ODBC Driver for LDAP.
-
Build ShipStation Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ShipStation and build visualizations in Tableau.
-
Access Live Tanda Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Tanda into the statistical analysis tools available in SAS JMP. This article shows how to use Tanda in the Graph Builder and Query Builder.
-
Integrate SAP Ariba Procurement with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Ariba Procurement with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Ariba Procurement.
-
Extend Google Sheets with FTP Data
Make calls to FTP from Google Apps Script via the API Server.
-
Access Authorize.Net Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Authorize.Net from your Oracle system.
-
Access Zoho Books Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Books from HeidiSQL.
-
How to connect to Copper Data from Spring Boot
Connect to Copper in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Netweaver Gateway within intelligent workflows.
-
Manage Office 365 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Office 365.
-
Access Jodoo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Jodoo from your Oracle system.
-
Access Live ConstantContact Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ConstantContact into the statistical analysis tools available in SAS JMP. This article shows how to use ConstantContact in the Graph Builder and Query Builder.
-
Connect Contentful to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Contentful using the CData Python MCP Server.
-
Access Live HBase Data in TIBCO Data Virtualization
Use the HBase Tibco DV Adapter to create a Apache HBase data source in TIBCO Data Virtualization Studio and gain access to live Apache HBase from your TDV Server.
-
How to Seamlessly Import OneNote Data into IBM SPSS Modeler
Integrate OneNote data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect PolyBase to Outlook
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Outlook.
-
Rapidly Develop MySQL-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by MySQL.
-
Use the CData Software ODBC Driver for Freshdesk in MicroStrategy Web
Connect to Freshdesk in MicroStrategy Web using the CData Software ODBC Driver for Freshdesk.
-
Back Up Anaplan to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Anaplan. In this article, we will employ an SSIS workflow to populate a database with Anaplan data.
-
Build Dashboards with SAP ByDesign Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Business ByDesign in DBxtra.
-
How to Query Live ShipStation Data in Perplexity MacOS Desktop
Connect to and query live ShipStation Data in Perplexity Desktop using CData MCP Server.
-
Access Live HCL Domino Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live HCL Domino through MCP integration.
-
Visualize Autopilot Data in Sisense
Create an ElastiCube in Sisense app with access to Autopilot.
-
Easily Integrate Procore Data in Lazarus Pascal IDE
Learn how to easily integrate live Procore in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Egnyte Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Egnyte replication to delimited files (CSV/TSV).
-
Publish Instantly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Instantly.
-
Create Data Visualizations in Cognos BI with Grafana Data
Access Grafana as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Stream Amplitude Data into Apache Kafka Topics
Access and stream Amplitude in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Klaviyo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Klaviyo facts in real time.
-
Build Tavily-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Tavily.
-
Visualize PDFMonkey Data in Tableau
The CData ODBC driver for PDFMonkey enables you integrate PDFMonkey into Tableau dashboards.
-
Access GitLab 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 GitLab.
-
Load Reckon Accounts Hosted Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Reckon Accounts Hosted to a database.
-
Design BIRT Reports on Delighted Data
Provide current Delighted to your embedded analytics.