CData Software - Knowledge Base
Recent Articles
-
Integrate with Odoo Data in JReport Designer
Create charts and reports based on Odoo ERP in JReport Designer.
-
Access Marketo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Marketo from your Oracle system.
-
DataBind Excel Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Excel with the DevExpress Windows Forms and Web controls to provide Microsoft Excel to a chart.
-
How to work with Snowflake Data in Apache Spark using SQL
Access and process Snowflake Data in Apache Spark using the CData Software JDBC Driver.
-
Create Epicor Kinetic-Connected Applications in Appsmith
Connect to Epicor Kinetic Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Epicor Kinetic.
-
Automated Continuous Amplitude Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amplitude replication to Azure SQL Database.
-
Create Data Visualizations Based On QuickBooks Online Data in Mode
Use CData Connect AI to connect to QuickBooks Online Data from Mode and build visualizations using live
-
Create Reply.io Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Reply.io data access from reports, embedded analytics, and more.
-
Import and Visualize Raisers Edge NXT Data in Power View
Create data visualizations based on Raisers Edge NXT in Excel.
-
Connect SAP Ariba Procurement to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Ariba Procurement using the CData Python MCP Server.
-
Rapidly Develop Perplexity-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 Perplexity.
-
Choosing the Best Method to Connect EmailOctopus to SQL Server: 5 Options Explained
Discover multiple ways to connect and use EmailOctopus from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate with Microsoft OneDrive Data in JReport Designer
Create charts and reports based on Microsoft OneDrive in JReport Designer.
-
Build Semantic Layer Views for DB2 Data in APOS Live Data Gateway
Use the CData Connector for DB2 in APOS Live Data Gateway to build Semantic Layer Views for IBM DB2.
-
Bidirectional Access to Odoo Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Odoo ERP in Filemaker Pro for Mac or Windows.
-
Access QuickBooks from RazorSQL
Connect to QuickBooks company file data through the RazorSQL database query tool.
-
DataBind Basecamp Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Basecamp with the DevExpress Windows Forms and Web controls to provide Basecamp to a chart.
-
Query SuiteCRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SuiteCRM entities in PHP by modeling them as objects.
-
How to create an RPA flow for Clio Data in UiPath Studio
Use the Clio ODBC Driver to create workflows that access real-time Clio without any coding.
-
Integrate Productboard with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Productboard with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Productboard.
-
Getting Started with the CData ODBC Driver for Access
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Access.
-
Use ChatGPT to Talk to Your Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Apache Avro for you.
-
Connect and Visualize Live Dynamics CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Dynamics CRM into the Databricks platform and create visualization dashboards with real-time Microsoft Dynamics CRM.
-
Automate Unbounce Data Replication to Azure Data Lake
Use CData Sync to customize and automate Unbounce replication to Azure Data Lake.
-
Integrating Kiro CLI with Microsoft Entra ID 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 Paylocity Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Paylocity using standard SQL.
-
Integrating Antigravity CLI with Autopilot via CData CLI
Connect Autopilot to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build MVC Applications with Connectivity to Strava Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Strava from an ASP.NET MVC application.
-
Working with xBase Data in LINQPad
Execute LINQ queries to xBase in LINQPad.
-
How to work with MailChimp Data in Apache Spark using SQL
Access and process MailChimp Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Elorus Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Elorus in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Replicate Mouseflow Data in Heroku for Use in Salesforce Connect
Replicate Mouseflow to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Data Flows from PabblySubscriptions to SQL Server using SSIS
Easily back up PabblySubscriptions to SQL Server using the SSIS components for PabblySubscriptions.
-
Access Avro Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Avro from your Oracle system.
-
Visualize Oracle Sales Data in TIBCO Spotfire through ADO.NET
Integrate Oracle Sales into dashboards in TIBCO Spotfire.
-
Automated Continuous Oracle Financials Cloud Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Apache Kafka.
-
Access Elasticsearch Data from MySQL in Amazon QuickSight
Connect to Elasticsearch and build visualizations of Elasticsearch using a MySQL Connection in Amazon QuickSight.
-
Access Workable 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 Workable.
-
Integrating OpenCode Terminal with Browserless 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.
-
Migrating data from Webflow to Databricks using CData SSIS Components.
Easily push Webflow to Databricks using the CData SSIS Tasks for Webflow and Databricks.
-
Integrate Theia IDE with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to connect and process ScrapingBee from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ScrapingBee.
-
Oracle Eloqua Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle Eloqua facts in real time.
-
How to connect PolyBase to Contentful
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Contentful.
-
Visualize Live MailChimp Data in the Power BI Service
Use CData Connect AI to connect to live MailChimp and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Stack Exchange Data from a Connection Pool in Jetty
The Stack Exchange JDBC Driver supports connection pooling: This article shows how to connect faster to Stack Exchange from Web apps in Jetty.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Close
Provide connectivity to Close through an SAP BusinessObjects universe.
-
Natively Connect to ClickTime Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ClickTime. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Azure Data Lake Storage Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Azure Data Lake Storage without replication.
-
Build Dashboards with Mailjet Data in DBxtra
Create dynamic dashboards and perform analytics based on Mailjet in DBxtra.
-
Connect to CampaignMonitor Data in HULFT Integrate
Connect to CampaignMonitor as a JDBC data source in HULFT Integrate
-
Getting Started with the CData JDBC Driver for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Facebook Ads.
-
Connect to MarkLogic Data in DBArtisan
Use wizards in DBArtisan to configure MarkLogic as a data source.
-
Use JayDeBeApi to access FreeAgent Data in Python
Use standard Python scripting and the development environment of your choice to access live FreeAgent.
-
Query HubDB Data in DataGrip
Create a Data Source for HubDB in DataGrip and use SQL to query live HubDB.
-
How to Access Google Cloud Storage Data Using Entity Framework
This article shows how to access Google Cloud Storage using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access ZendeskSell Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZendeskSell from your Oracle system.
-
How to work with SuiteCRM Data in Apache Spark using SQL
Access and process SuiteCRM Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Amazon S3 Data from AWS Glue
Use CData Connect AI to gain access to live Amazon S3 from your AWS Glue jobs.
-
How to Connect to Live Google Analytics Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Analytics without replication.
-
Integrating Cursor CLI with Coinbase 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.
-
Create Dynamic Azure Data Catalog Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Data Catalog to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Clio Replication to MongoDB
Use CData Sync for automated, continuous, customizable Clio replication to MongoDB.
-
Connect to Instagram Data from AWS Glue
Use CData Connect AI to gain access to live Instagram from your AWS Glue jobs.
-
Access Live SAP ByDesign Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP ByDesign data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
DataBind Charts to Power BI XMLA Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Power BI XMLA 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.
-
Bridge CouchDB Connectivity with Apache NiFi
Access and process Apache CouchDB in Apache NiFi using the CData JDBC Driver.
-
Use Azure AI Foundry to Talk to Your Workday 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 Workday for you.
-
Connect to Facebook Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Codex CLI with Sage Business Cloud Accounting 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 SAS xpt Data Replication to Couchbase
Use CData Sync to Customize and automate SAS XPORT replication to Couchbase.
-
Getting Started with the CData Connect AI Python SDK for ActiveCampaign
Install the CData Connect AI Python SDK to read and write live ActiveCampaign with standard DB-API 2.0 Python code.
-
Use Dash to Build to Web Apps on Autopilot Data
Create Python applications that use pandas and Dash to build Autopilot-connected web apps.
-
How to Connect DBeaver to Greenhouse via a JDBC Driver
Manage Greenhouse with visual tools in DBeaver like the query browser.
-
Query Instantly Data in ColdFusion
Write standard ColdFusion data access code to connect to Instantly.
-
Access JotForm Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live JotForm from HeidiSQL.
-
Automate SAP Data Replication to Couchbase
Use CData Sync to Customize and automate SAP ERP/NetWeaver replication to Couchbase.
-
Getting Started with the CData JDBC Driver for Omnisend
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Omnisend.
-
Connect to Zoho Creator Data in Ruby
Connect to Zoho Creator in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Deploy the ADO.NET Provider for AgileCRM on an SSRS Report Server
Connect to AgileCRM from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to create Zoom federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoom in MySQL .
-
Integrating Claude Code CLI with Oracle Service Cloud 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.
-
Use Databricks Agent Bricks to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your MYOB AccountRight for you.
-
Visualize Reckon Accounts Hosted Data in Tableau
The CData ODBC driver for Reckon Accounts Hosted enables you integrate Reckon Accounts Hosted into Tableau dashboards.
-
Excel Spreadsheet Automation on Chargebee Data with the QUERY Formula
Pull data from Chargebee, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Python Connector for Intercom
Learn to install and license the CData Python Connector
-
Connect to Microsoft OneDrive Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft OneDrive to connect to Microsoft OneDrive and execute queries in PowerBuilder.
-
Analyze Cloudant Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of IBM Cloudant and visualize live IBM Cloudant in Infragistics Reveal.
-
How to create SFTP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SFTP in MySQL .
-
Connect to CircleCI Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CircleCI and the SQL Gateway to access CircleCI from Google Apps Script.
-
Integrate GraphQL with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate GraphQL with External Services.
-
DataBind Charts to PivotalTracker Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PivotalTracker 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.
-
Enable the Figshare JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Figshare.
-
Model, Search, and Visualize Live PayPal Data in ThoughtSpot
Use CData Connect AI to connect to live PayPal for modeling, searching, and visualizing.
-
Connect to EnterpriseDB Data in NetBeans
Connect to EnterpriseDB in NetBeans with the data source configuration wizard.
-
Connect to Confluence Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Atlassian Confluence from Filemaker Pro on Mac.
-
Integrating Boomi Agentstudio with Xero Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Xero Accounting, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Sage Intacct-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage Intacct.
-
How to work with QuickBooks Data in Apache Spark using SQL
Access and process QuickBooks Data in Apache Spark using the CData Software JDBC Driver.
-
Object-Relational Mapping (ORM) with Retently Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Retently into a Java-based ORM framework, Hibernate.