CData Software - Knowledge Base
Recent Articles
-
Build Charts with ConstantContact Data in Clear Analytics
Create dynamic charts and perform analytics based on ConstantContact data in Clear Analytics.
-
Getting Started with the CData JDBC Driver for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics CRM.
-
Integrate with Elasticsearch Data in JReport Designer
Create charts and reports based on Elasticsearch data in JReport Designer.
-
Use the CData ODBC Driver for Google Directory from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Directory to connect to Google Directory data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Directory data in Excel.
-
Build a Simple VCL Application for Salesforce Data
How to build a simple VCL Application to view Salesforce data in RAD Studio using the CData ODBC Driver for Salesforce.
-
Start with CData Sync Part 1: Licensing, Creating Connections, and Creating a Replication Job
Use CData Sync to create a replication job.
-
How to Visualize SAP SuccessFactors Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP SuccessFactors data in Python.
-
Publish Reckon-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Reckon data.
-
Automated Continuous Zoho Recruit Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to Azure SQL Database.
-
Integrate Google's Antigravity Agent with Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAS Data Sets data using the Model Context Protocol.
-
Connect to MarkLogic Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MarkLogic data.
-
Natively Connect to Webex Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Webex data. Leverage the native support for ODBC in PHP.
-
Connect to Dynamics NAV Data in ACL Analytics
Connect to Dynamics NAV data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Dynamics NAV data.
-
How to Create Power BI Visual Reports with Real-Time Pipeliner CRM Data
Use CData Power BI Connectors to visualize Pipeliner CRM data in Power BI.
-
Connect to Neo4J Data in Ruby
Connect to Neo4J data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Demio Data in Tableau
The CData ODBC driver for Demio enables you integrate Demio data into Tableau dashboards.
-
Easily Integrate Google Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Analytics data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Live MariaDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live MariaDB data from within the IDE.
-
Access Live Sage Cloud Accounting Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage Cloud Accounting data into the statistical analysis tools available in SAS JMP. This article shows how to use Sage Cloud Accounting data in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for PDFMonkey
Create PDFMonkey data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Rapidly Develop Shortcut-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 Shortcut.
-
Create Power BI Reports on Real-Time Stripe Data
Use the CData ODBC Driver for Stripe to visualize Stripe data in Power BI Desktop.
-
Connect to Instantly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Instantly data.
-
Connect to Everhour Data in NetBeans
Connect to Everhour data in NetBeans with the data source configuration wizard.
-
View Reports on Real-Time SAS xpt Data in Power BI Report Server
Use the CData ODBC Driver for SAS xpt to visualize SAS xpt data in Power BI Desktop and then publish them to Power BI Report Server.
-
Stream eBay Analytics Data into Apache Kafka Topics
Access and stream eBay Analytics data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connecting Pipedream with Google Calendar Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Calendar data in real time.
-
Connect to Stripe Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Stripe Data and connect to Stripe data in Akorbi Digital RunMyProcess.
-
Build a Singer.io Tap for QuickBooks Time With the CData Python Connector
Learn how to easily build a Singer.io Tap for live QuickBooks Time data using the CData Python Connector.
-
Publish ClickTime-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ClickTime data.
-
Connecting GenSpark with Spark Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Spark data without any replication or custom integration required.
-
Link Nuclia with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Nuclia data in Filemaker Pro for Mac or Windows.
-
Build Paymo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Paymo Data and create custom apps in Mendix.
-
Use the CData Software ODBC Driver for LightSpeedRetail in MicroStrategy
Connect to LightSpeedRetail data in MicroStrategy Developer using the CData Software ODBC Driver for LightSpeedRetail.
-
Provide OData Services of CloudConvert Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CloudConvert data by developing a WCF Service Application.
-
Visualize Live Amplitude Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amplitude data.
-
Build Dashboards with Strava Data in DBxtra
Create dynamic dashboards and perform analytics based on Strava data in DBxtra.
-
Analyze Outreach.io Data in Looker
Use CData Connect AI to connect to Outreach.io Data from Looker and build custom apps using live Outreach.io data.
-
Access Live SAS Data Sets Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS Data Sets data from your Google Sheets.
-
Connect to Greenplum Data in JRuby
Create a simple JRuby app with access to live Greenplum data.
-
Use the CData Software JDBC Driver for Hubstaff in MicroStrategy Desktop
Connect to Hubstaff data in MicroStrategy Desktop using the CData Software JDBC Driver for Hubstaff.
-
Build AI Agents with SAP ByDesign Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP ByDesign data through CData Connect AI.
-
Integrate eBay Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live eBay Analytics data from Informatica Cloud.
-
Connect to Shortcut Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Shortcut data.
-
Import Real-Time Campaigner Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Campaigner data in ColdFusion.
-
Getting Started with the CData Python Connector for Printful
Learn to install and license the CData Python Connector and configure a connection to live Printful data.
-
Visualize Live Perigon Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Perigon data.
-
How to Connect to & Open Oracle Sales Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Sales to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to AfterShip Data in NetBeans
Connect to AfterShip data in NetBeans with the data source configuration wizard.
-
Connect to Zendesk Data in HULFT Integrate
Connect to Zendesk as a JDBC data source in HULFT Integrate
-
Connect to SurveyMonkey Data in Google Apps Script via Connect AI
Use CData Connect AI to access SurveyMonkey data in Google Apps Script.
-
How to import Samanage Data into Apache Solr
Use the CData Software JDBC Driver for Samanage in Data Import Handler and create an automated import of Samanage data to Apache Solr Enterprise Search platform.
-
Create Data Visualizations Based On Zoho Inventory Data in Mode
Use CData Connect AI to connect to Zoho Inventory Data from Mode and build visualizations using live Zoho Inventory data.
-
Model, Search, and Visualize Live Guru Data in ThoughtSpot
Use CData Connect AI to connect to live Guru data for modeling, searching, and visualizing.
-
Connect to Oracle Sales from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle Sales to connect to Oracle Sales data from Web applications running on WebLogic.
-
Automated Continuous Bugsnag Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Bugsnag replication to Apache Kafka.
-
How to connect PolyBase to Beeminder
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Beeminder data.
-
Build a Simple VCL Application for EmailOctopus Data
How to build a simple VCL Application to view EmailOctopus data in RAD Studio using the CData ODBC Driver for EmailOctopus.
-
Replicate Lakebase Data in Heroku for Use in Salesforce Connect
Replicate Lakebase data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Optimizely-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Optimizely Data from Zoho Analytics and import live Optimizely data.
-
Automated Continuous Freshsales Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshsales replication to SQLite.
-
Automated Continuous QuickBooks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks replication to Amazon Redshift.
-
Integrate Aweber Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Aweber data from Informatica Cloud.
-
Integrating Claude Code with Dynamics 365 Business Central Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Dynamics 365 Business Central data within assisted coding and automated development workflows.
-
Integrate ZarMoney Data in the Pentaho Report Designer
Publish reports based on ZarMoney data in the Pentaho BI tool.
-
Automated Continuous Bullhorn CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to delimited files (CSV/TSV).
-
Create Klaviyo-Connected Business Apps in AppSheet
Connect to Klaviyo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Klaviyo data.
-
Build AI/ML Models with Live GitHub Data using Dataiku
Connect GitHub Data with Dataiku using the CData JDBC Driver for GitHub.
-
Integrate iContact Data into Power Automate Desktop using CData Connect
CData Connect for iContact Data enables you to integrate iContact data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Ontraport Data in DBArtisan
Use wizards in DBArtisan to configure Ontraport data as a data source.
-
Integrate OpenCode with Live Timely Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Timely data from within your AI coding agent.
-
Integrate with Jira Assets Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Jira Assets data to a JSON file on disk.
-
Building Dynamic Web Pages with SAP HANA XS Advanced Data Using AngularJS
Create single-page applications with live connectivity to SAP HANA XS Advanced using the CData API Server.
-
How to Connect to Live Zendesk Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zendesk data without replication.
-
Using the CData Software ODBC Driver for Oracle Financials Cloud in PyCharm
Connect to Oracle Financials Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Financials Cloud.
-
Automated Continuous Jumpseller Replication to Vertica
Use CData Sync for automated, continuous, customizable Jumpseller replication to Vertica.
-
CircleCI Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CircleCI facts in real time.
-
LINQ to GitHub 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 GitHub Data Provider.
-
Connect to Parallel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Parallel data using standard SQL.
-
Work with Browserless Data in FoxPro
Load Browserless data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Cursor with VWO 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 Stripe from a Connection Pool in WebLogic
Use the CData JDBC Driver for Stripe to connect to Stripe data from Web applications running on WebLogic.
-
Use the CData SSIS Components to Insert New or Update Existing Outreach.io Records from SQL Server
Easily push SQL Server data to Outreach.io using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Outreach.io or update existing records with data from a SQL Server database.
-
Connect to FreeAgent Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to FreeAgent and work with FreeAgent data in your FileMaker applications.
-
Integrating LangGraph with Google Calendar Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Calendar data within automated workflows.
-
Connect to Moosend Data from a Connection Pool in JBoss
Integrate Moosend data into Java servlets: Use the Management Console in JBoss to install the Moosend JDBC Driver.
-
Connect ZohoInvoice to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoInvoice data using the CData Python MCP Server.
-
Create Data Visualizations in Cognos BI with EnterpriseDB Data
Access EnterpriseDB data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live MarkLogic Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MarkLogic data from your Excel spreadsheets.
-
Build Bannerbear-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Bannerbear Data from Zoho Analytics and import live Bannerbear data.
-
Integrating OpenCode with Reckon 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.
-
Automate Google Forms Data Replication to Couchbase
Use CData Sync to Customize and automate Google Forms data replication to Couchbase.
-
Build Microsoft Exchange-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Exchange Data and create custom apps in Mendix.
-
A PostgreSQL Interface for SQL Analysis Services Data using the CData ODBC Driver
Use the SQL Gateway and SQL Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP Ariba Procurement from Asprova with CData Software ODBC Driver for SAP Ariba Procurement
This article shows how to connect faster to SAP Ariba Procurement data from Asprova.
-
Use Azure AI Foundry to Talk to Your Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Shortcut data for you.
-
Create Data Visualizations in Cognos BI with Twilio Data
Access Twilio data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Theia IDE with Live BambooHR 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 BambooHR data from within the development environment.
-
Integrate Real-Time Access to Spark in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Spark data in real time.
-
Automated Continuous Sage Cloud Accounting Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to PostgreSQL.