CData Software - Knowledge Base
Recent Articles
-
Connect to and Visualize Live Shortcut Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Shortcut.
-
Connect to Splunk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Splunk from Appeon PowerBuilder using the CData ADO.NET Provider for Splunk.
-
Use the CData ODBC Driver for Acumatica in Microsoft Power Query
You can use the CData Acumatica ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Acumatica ERP into Microsoft Power Query.
-
Create Power BI Reports on Real-Time FHIR Data
Use the CData ODBC Driver for FHIR to visualize FHIR in Power BI Desktop.
-
Access Zoho Books Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Books from your Oracle system.
-
Use the CData Software JDBC Driver for Acumatica in MicroStrategy Web
Connect to Acumatica ERP in MicroStrategy Web using the CData Software JDBC Driver for Acumatica.
-
How to integrate ElevenLabs with Apache Airflow
Access and process ElevenLabs in Apache Airflow using the CData JDBC Driver.
-
Moving Data from Act CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Act CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Apps with Live Factorial Data Using the Low-Code Development Platform of Mendix
Connect Factorial with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Demio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Demio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Demio.
-
Automated Continuous Supabase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Supabase replication to PostgreSQL.
-
Getting Started with the CData Tableau Connector for Retently
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create a Data Access Object for Apify Data using JDBI
A brief overview of creating a SQL Object API for Apify in JDBI.
-
Connect to Reply.io Data in DBeaver
Use the CData ODBC Driver to connect to Reply.io in DBeaver.
-
Rapidly Develop SendPulse-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 SendPulse.
-
Access Live GitHub Data in Excel 365 Online (Excel for the web)
Connect to GitHub from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Live Zoho CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho CRM.
-
Design BIRT Reports on Access Data
Provide current Microsoft Access to your embedded analytics.
-
Connect Azure Synapse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Synapse with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Controls to Testmonitor Data in Delphi
DataBind to Testmonitor in Delphi with standard data access components and controls.
-
Elasticsearch Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Elasticsearch through CData Connect AI using different applications and tools.
-
How to connect SharePoint with Reckon Data through external lists
Provide Reckon to SharePoint users as an external list.
-
Use JayDeBeApi to access SuiteCRM Data in Python
Use standard Python scripting and the development environment of your choice to access live SuiteCRM.
-
Enable the Marketo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Marketo.
-
Use ChatGPT to Talk to Your Zuora 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 Zuora for you.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Analytics within intelligent workflows.
-
Write a Simple Go Application to work with Float Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Float.
-
Natively Connect to Dynamics 365 Business Central Data in PHP
The CData ODBC driver for Dynamics 365 Business Central enables you to create PHP applications with connectivity to Dynamics 365 Business Central. Leverage the native support for ODBC in PHP.
-
Integrate Theia IDE with Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use Agno to Talk to Your Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Atlassian Confluence for you.
-
Integrate Real-Time Access to Adobe Target in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Adobe Target in real time.
-
Access Live Sage Intacct Data in AWS Lambda
Connect to live Sage Intacct in AWS Lambda using the CData JDBC Driver.
-
Build Semantic Layer Views for ClickUp Data in APOS Live Data Gateway
Use the CData Connector for ClickUp in APOS Live Data Gateway to build Semantic Layer Views for ClickUp.
-
Connect to Guru Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Guru and work with Guru in your FileMaker applications.
-
Use Biml to Build SSIS Tasks to Replicate SAP SuccessFactors LMS Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP SuccessFactors LMS to SQL Server.
-
Build Oracle SCM-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle SCM Data from Choreo and build custom apps using live Oracle SCM.
-
How to Visualize Asana Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Asana in Python.
-
Use the CData Software ODBC Driver for LaunchDarkly in MicroStrategy Desktop
Connect to LaunchDarkly in MicroStrategy Desktop using the CData Software ODBC Driver for LaunchDarkly.
-
Access Live Azure Table 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 Azure Table Storage through MCP integration.
-
Build Semantic Layer Views for YouTube Analytics Data in APOS Live Data Gateway
Use the CData Connector for YouTube Analytics in APOS Live Data Gateway to build Semantic Layer Views for YouTube Analytics.
-
Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy
Connect to Google Ad Manager in MicroStrategy Developer using the CData Software JDBC Driver for Google Ad Manager.
-
Connect to Outlook Data in NetBeans
Connect to Outlook in NetBeans with the data source configuration wizard.
-
Automated Continuous Recurly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Recurly replication to PostgreSQL.
-
How to Work with Strava Data in ETL Validator JDBC
Connect to Strava from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from SAP Ariba Source to Databricks using CData SSIS Components.
Easily push SAP Ariba Source to Databricks using the CData SSIS Tasks for SAP Ariba Source and Databricks.
-
Integrate with Live Zoho CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoho CRM from the MuleSoft Anypoint Platform to integrate live Zoho CRM into custom reports and dashboards.
-
Automated Aircall Data Replication to Teradata
Use CData Sync to Customize and automate Aircall replication to Teradata.
-
Migrating data from Helpscout to Snowflake using CData SSIS Components.
Easily push Helpscout to Snowflake using the CData SSIS Tasks for Helpscout and Snowflake.
-
Build MVC Applications with Connectivity to CloudConvert Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CloudConvert from an ASP.NET MVC application.
-
Visualize Power BI XMLA Data in Tableau
The CData ODBC driver for Power BI XMLA enables you integrate Power BI XMLA into Tableau dashboards.
-
How to connect to Quickbase Data from IntelliJ
Integrate connectivity to Quickbase with wizards in IntelliJ.
-
Connect to and Visualize Live Onfleet Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Onfleet.
-
Publish Crystal Reports on ShipStation Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipStation.
-
Use the CData Software ODBC Driver for Perplexity in SAS for Real-Time Reporting and Analytics
Connect to real-time Perplexity in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Perplexity.
-
Connect to Adobe Commerce Data from a Connection Pool in JBoss
Integrate Adobe Commerce into Java servlets: Use the Management Console in JBoss to install the Adobe Commerce JDBC Driver.
-
Prepare, Blend, and Analyze Procore Data in Alteryx Designer (ODBC)
Build workflows to access live Procore for self-service data analytics.
-
Build Dashboards with Shippo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Shippo in Dundas BI.
-
Integrating OpenCode Terminal with Testmonitor 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.
-
Build Avro-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Avro.
-
How to connect to Zoho Books Data from Spring Boot
Connect to Zoho Books in a Spring Boot Application using the CData JDBC Driver for Zoho Books
-
How to Access HDFS Data Using Entity Framework
This article shows how to access Apache HDFS using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Deploy the ADO.NET Provider for Teamgate on an SSRS Report Server
Connect to Teamgate 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.
-
Automated Continuous Hubstaff Replication to SQLite
Use CData Sync for automated, continuous, customizable Hubstaff replication to SQLite.
-
Getting Started with the CData Python Connector for Moosend
Learn to install and license the CData Python Connector
-
Integrate Live Zoho Books Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Books from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Books.
-
Automate Wistia Data Replication to SAP HANA
Use CData Sync to customize and automate Wistia replication to SAP HANA.
-
Connect CircleCI Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CircleCI using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Sage 200 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sage 200 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import SAP SuccessFactors Data Using Azure Data Factory
Use CData Connect AI to connect to SAP SuccessFactors Data from Azure Data Factory and import live SAP SuccessFactors.
-
Build Aircall-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Aircall.
-
How to connect and process Gong from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Gong.
-
Integrate Workday with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Workday with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Workday.
-
Connect to and Query Microsoft Dataverse Data in QlikView over ODBC
Create data visualizations with Microsoft Dataverse (CDS) in QlikView.
-
Design BIRT Reports on Oracle Eloqua Data
Provide current Oracle Eloqua to your embedded analytics.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Avalara AvaTax to Power BI dashboards. Simply drag and drop Avalara AvaTax into data visuals on the Power BI canvas.
-
Connect to and Query SAP Ariba Procurement Data in QlikView over ODBC
Create data visualizations with SAP Ariba Procurement in QlikView.
-
Connect to Microsoft Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Ads from Filemaker Pro on Mac.
-
A PostgreSQL Interface for ZeroBounce Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZeroBounce JDBC Driver to create a PostgreSQL entry-point for data access.
-
FAQ: Licensing and Deploying Builds of Finished Applications
Follow these instructions to test, build, and distribute apps using the CData single developer, royalty-free license.
-
Connect to Apollo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Apollo to connect to Apollo and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Auth0 in MicroStrategy
Connect to Auth0 in MicroStrategy Developer using the CData Software JDBC Driver for Auth0.
-
Analyze LinkedIn Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LinkedIn Ads and visualize live LinkedIn Ads in Infragistics Reveal.
-
Build Dashboards with Yelp Data in DBxtra
Create dynamic dashboards and perform analytics based on Yelp in DBxtra.
-
Integrating LangChain with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Search within automated workflows.
-
How to Connect to Omnisend Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Omnisend. Leverage the pyodbc module for ODBC in Python.
-
Import Real-Time Excel Online Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Excel Online in ColdFusion.
-
Enable the LDAP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LDAP.
-
DataBind Mode Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mode to a chart.
-
Automate Adobe Analytics Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Adobe Analytics and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use CData Connect AI to Access Cosmos DB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Azure Cosmos DB in the Power Pivot business intelligence tool.
-
How to Create Power BI Visual Reports with Real-Time Gumroad Data
Use CData Power BI Connectors to visualize Gumroad in Power BI.
-
Integrate Factorial with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Factorial with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Factorial.
-
Access Live Scrapfly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Scrapfly into the statistical analysis tools available in SAS JMP. This article shows how to use Scrapfly in the Graph Builder and Query Builder.
-
How to connect to Zendesk Data from IntelliJ
Integrate connectivity to Zendesk with wizards in IntelliJ.
-
Integrate with Dropbox Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Dropbox in SnapLogic.
-
Integrating LlamaIndex with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle SCM in real time.
-
Connect to Adobe Target Data in RazorSQL
Connect to Adobe Target from wizards and query Adobe Target from the GUI in the RazorSQL database management tool.
-
Object-Relational Mapping (ORM) with DocuSign 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 DocuSign into a Java-based ORM framework, Hibernate.
-
Access Live Dotmailer Data in Coginiti Pro
Connect to and query live Dotmailer from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create MariaDB-Connected Dashboards in Grafana
Connect to MariaDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MariaDB.