CData Software - Knowledge Base
Recent Articles
-
Connect to MailerLite Data in DBeaver
Use the CData ODBC Driver to connect to MailerLite in DBeaver.
-
Natively Connect to Zendesk Data in PHP
The CData ODBC driver for Zendesk enables you to create PHP applications with connectivity to Zendesk. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Spark 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 Apache Spark SQL for you.
-
How to Access Live ServiceNow Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ServiceNow enables you to integrate ServiceNow into workflows built using Microsoft Power Automate Desktop.
-
Publish Reports with Drift Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Drift.
-
Create MYOB AccountRight-Connected Applications in Appsmith
Connect to MYOB AccountRight Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MYOB AccountRight.
-
Connect to Marketo Data from HeidiSQL
Use CData Connect AI to connect to and query live Marketo from HeidiSQL.
-
Connect to Access Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Access from Appeon PowerBuilder using the CData ADO.NET Provider for Access.
-
Connect to Odoo Data from Crystal Reports
Use CData Connect AI to connect to and report on live Odoo ERP from Crystal Reports.
-
Connect to Planio Data from PowerBuilder via JDBC
This article demonstrates how to access Planio from PowerBuilder using the Planio JDBC Driver.
-
Provide OData Services of Excel Online Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Excel Online by developing a WCF Service Application.
-
Getting Started with the CData ADO.NET Provider for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Snapchat Ads.
-
Publish Reports with EmailOctopus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date EmailOctopus.
-
Connect to Oracle Eloqua Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Eloqua in DBeaver.
-
Getting Started with the CData Python Connector for OnePageCrm
Learn to install and license the CData Python Connector
-
How to import Vercel Data into Apache Solr
Use the CData Software JDBC Driver for Vercel in Data Import Handler and create an automated import of Vercel to Apache Solr Enterprise Search platform.
-
Create a Data Access Object for ChargeOver Data using JDBI
A brief overview of creating a SQL Object API for ChargeOver in JDBI.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SingleStore within intelligent workflows.
-
Configure the CData JDBC Driver for Miro in a Connection Pool in Tomcat
Connect to Miro from a connection pool in Tomcat.
-
Integrate with RabbitMQ Data in JReport Designer
Create charts and reports based on RabbitMQ in JReport Designer.
-
DataBind SAP SuccessFactors LMS Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP SuccessFactors LMS with the DevExpress Windows Forms and Web controls to provide SAP SuccessFactors LMS to a chart.
-
Explore Geographical Relationships in HCL Domino Data with Power Map
Create data visualizations with HCL Domino in Power Map.
-
Connect to Facebook Data in DBeaver
Use the CData ODBC Driver to connect to Facebook in DBeaver.
-
Connect to Billsby Data from PowerBuilder via ADO.NET
This article demonstrates how to access Billsby from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Seamlessly Import Google Campaign Manager 360 Data into IBM SPSS Modeler
Integrate Google Campaign Manager 360 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Antigravity CLI with Apache Impala via CData CLI
Connect Apache Impala to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Google Translate Reporting in OBIEE with the Google Translate JDBC Driver
Deploy the Google Translate JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to Redis Data from IntelliJ
Integrate connectivity to Redis with wizards in IntelliJ.
-
How to Connect the Power BI Service to Retently: Complete Guide
Connect to the CData Software Power BI Connector for Retently from PowerBI.com to provide real-time Retently across the organization.
-
How to Connect the Power BI Service to Jira: Complete Guide
Connect to the CData Software Power BI Connector for Jira from PowerBI.com to provide real-time Atlassian Jira across the organization.
-
DataBind Controls to Bitly Data in Delphi
DataBind to Bitly in Delphi with standard data access components and controls.
-
Prepare, Blend, and Analyze Aweber Data in Alteryx Designer (ODBC)
Build workflows to access live Aweber for self-service data analytics.
-
Integrate Contentful Data in the Pentaho Report Designer
Publish reports based on Contentful in the Pentaho BI tool.
-
Feed Optimizely Data into FineReport
How to set Optimizely as a JDBC data source in FineReport.
-
Connect PabblySubscriptions Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PabblySubscriptions using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build AI/ML Models with Live Shortcut Data using Dataiku
Connect Shortcut Data with Dataiku using the CData API Driver for JDBC.
-
DataBind Controls to Neo4J Data in C++Builder
DataBind to Neo4J in C++Builder with standard components and controls.
-
Import Real-Time ZarMoney Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZarMoney in ColdFusion.
-
Visualize Email Data in Sisense
Create an ElastiCube in Sisense app with access to Email.
-
Connect to Ontraport Data in RapidMiner
Integrate Ontraport with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Real-Time Everhour Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Everhour in Power Apps.
-
Connect to Live Zoom Data in MicroStrategy through CData Connect AI
Create a live connection to Zoom Data in CData Connect AI and connect to your Zoom from MicroStrategy.
-
Bidirectional Access to Strava Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Strava in Filemaker Pro for Mac or Windows.
-
DataBind Controls to Guru Data in Delphi
DataBind to Guru in Delphi with standard data access components and controls.
-
Access Live MarkLogic Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MarkLogic from your Google Sheets.
-
Connect to Wistia Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Wistia.
-
Automated Continuous Campaigner Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Campaigner replication to IBM DB2.
-
Getting Started with the CData JDBC Driver for Snowflake
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Snowflake.
-
How to Create Power BI Visual Reports with Real-Time Notion Data
Use CData Power BI Connectors to visualize Notion in Power BI.
-
Create Dashboards and Visualize Live Gong Data in Geckoboard
Use CData Connect AI to connect to live Gong and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to work with Cassandra Data in Apache Spark using SQL
Access and process Cassandra Data in Apache Spark using the CData Software JDBC Driver.
-
Publish EmailOctopus-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live EmailOctopus.
-
Analyze Egnyte Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Egnyte with the CData JDBC Driver for Egnyte.
-
Getting Started with the CData Power BI Connector for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Eloqua Reporting.
-
Integrate Instagram with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Instagram with External Services.
-
Automated Continuous BambooHR Replication to MongoDB
Use CData Sync for automated, continuous, customizable BambooHR replication to MongoDB.
-
CData SAP Driver Deep Dive: Which Driver Should I Use With SAP S/4HANA and SAP HANA Databases?
A comprehensive guide detailing which CData Driver or Connector you should use to connect to your version of SAP.
-
Query HelloSign Data in ColdFusion
Write standard ColdFusion data access code to connect to HelloSign.
-
Replicate Freshsales Data in Heroku for Use in Salesforce Connect
Replicate Freshsales to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
LINQ to Clockify Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Clockify Data Provider.
-
Visualize Live CSV Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CSV/TSV Files using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to load Redshift data into Elasticsearch via Logstash
Introducing a simple method to load Redshift data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Query Harvest Data in MySQL Workbench
Execute MySQL queries against live Harvest from MySQL Workbench.
-
Automated Continuous Avaza Replication to SingleStore
Use CData Sync for automated, continuous, customizable Avaza replication to SingleStore.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for XML
Provide connectivity to XML Files through an SAP BusinessObjects universe.
-
Build Dashboards with FTP Data in DBxtra
Create dynamic dashboards and perform analytics based on FTP Servers in DBxtra.
-
Integrating Cursor CLI with Webflow 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 CSV Data in PHP
The CData ODBC driver for CSV enables you to create PHP applications with connectivity to CSV/TSV Files. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Zoho Books 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 Zoho Books through natural language.
-
How to Seamlessly Import CockroachDB Data into IBM SPSS Modeler
Integrate CockroachDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Power BI Reports on Real-Time Vercel Data
Use the CData ODBC Driver for Vercel to visualize Vercel in Power BI Desktop.
-
Connect and Query Live HubSpot Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live HubSpot into Databricks
-
Connect to Redis Data in RazorSQL
Connect to Redis from wizards and query Redis from the GUI in the RazorSQL database management tool.
-
Connect to Live Acumatica Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Acumatica in CData Connect AI and connect to your Acumatica ERP from PostgreSQL.
-
Connect Microsoft Planner Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Planner using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Gumloop with Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Dynamics CRM within automated workflows.
-
Visualize Exact Online Data in TIBCO Spotfire through ADO.NET
Integrate Exact Online into dashboards in TIBCO Spotfire.
-
Bidirectional Access to SendInBlue Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SendInBlue in Filemaker Pro for Mac or Windows.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Cassandra actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
LINQ to ZendeskSell Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the ZendeskSell Data Provider.
-
Build Elasticsearch-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Elasticsearch and build web apps with connectivity to live Elasticsearch.
-
Moving Data from Freshdesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Freshdesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Adobe Commerce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Adobe Commerce data access from reports, embedded analytics, and more.
-
Access Live Smartsheet 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 Smartsheet through MCP integration.
-
Visualize Live Box Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Box into custom reports in Power BI.
-
Connect to Sybase Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sybase in FileMaker Pro to connect to Sybase and work with Sybase in your FileMaker applications.
-
Query Live Workday Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Workday directly from the development environment.
-
Build HubSpot-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for HubSpot to explore live HubSpot Data in GitHub Copilot to assist with building HubSpot-powered applications.
-
Build Automated Workflows with Live Sybase Data in Workato
Use CData Connect AI to connect to live Sybase and build automated workflows in Workato.
-
Connect to SAP HANA XS Advanced Data in CloverDX (formerly CloverETL)
Transfer SAP HANA XS Advanced using the visual workflow in the CloverDX data integration tool.
-
Integrate GetResponse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate GetResponse with External Services.
-
Connect to Amazon DynamoDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Amazon DynamoDB Data and connect to Amazon DynamoDB in Akorbi Digital RunMyProcess.
-
Access Reckon Data from MySQL in Amazon QuickSight
Connect to Reckon and build visualizations of Reckon using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData ODBC Driver for Mixpanel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mixpanel.
-
View Reports on Real-Time Telegram Data in Power BI Report Server
Use the CData ODBC Driver for Telegram to visualize Telegram in Power BI Desktop and then publish them to Power BI Report Server.
-
Create YouTube Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connector for YouTube Analytics from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Visualize Outreach.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Outreach.io in Python.
-
Connect to SAP BusinessObjects BI in SpagoBI
Create reports featuring live SAP BusinessObjects BI in SpagoBI Studio. Host SAP BusinessObjects BI reports on SpagoBI Server.
-
Integrating Toggl Data in Talend Cloud Data Management Platform
Connect Toggl Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Operational Reporting on Microsoft Entra ID Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Entra ID.