CData Software - Knowledge Base
Recent Articles
-
Import Real-Time AlloyDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google AlloyDB in ColdFusion.
-
How to Access GitHub Data Using Entity Framework
This article shows how to access GitHub using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import and Visualize ActiveCampaign Data in Power View
Create data visualizations based on ActiveCampaign in Excel.
-
How to create an RPA flow for Gorgias Data in UiPath Studio
Use the Gorgias ODBC Driver to create workflows that access real-time Gorgias without any coding.
-
Deploy the ADO.NET Provider for AfterShip on an SSRS Report Server
Connect to AfterShip 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.
-
Automate Quaderno Data Replication to Azure Data Lake
Use CData Sync to customize and automate Quaderno replication to Azure Data Lake.
-
Integrate Theia IDE with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Sage 300-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage 300.
-
How to Seamlessly Import Pinterest Data into IBM SPSS Modeler
Integrate Pinterest data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Gmail Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Gmail. Leverage the pyodbc module for ODBC in Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Neo4J within intelligent workflows.
-
Build SAP BusinessObjects BI-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP BusinessObjects BI.
-
DataBind Azure Data Lake Storage Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure Data Lake Storage with the DevExpress Windows Forms and Web controls to provide Azure Data Lake Storage to a chart.
-
Access Landbot Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Landbot from HeidiSQL.
-
Integrate Theia IDE with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to create an RPA flow for ZohoDesk Data in UiPath Studio
Use the ZohoDesk ODBC Driver to create workflows that access real-time ZohoDesk without any coding.
-
Process & Analyze Outlook Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Outlook Data.
-
Automate Adobe Commerce Data Replication to SAP HANA
Use CData Sync to customize and automate Adobe Commerce replication to SAP HANA.
-
Enable the Azure Data Lake Storage JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure Data Lake Storage.
-
Integrating Claude Code CLI with DB2 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 integrate Discourse with Apache Airflow
Access and process Discourse in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData Python Connector for Oracle Eloqua Reporting
Learn to install and license the CData Python Connector
-
How to Easily Query Procore Data in OpenOffice Base
Connect to Procore data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Excel Spreadsheet Automation on ServiceDesk Plus Data with the QUERY Formula
Pull data from ServiceDesk Plus, automate spreadsheets, and more with the QUERY formula.
-
Access Live Basecamp Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Basecamp from your Google Sheets.
-
Choosing the Best Method to Connect PolarTeamPro to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PolarTeamPro from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate ZohoDesk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoDesk with External Services.
-
Automated Continuous HBase Replication to SQL Server
Use CData Sync for automated, continuous, customizable HBase replication to SQL Server.
-
Use the CData ODBC Driver for Cloudant from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cloudant to connect to IBM Cloudant from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring IBM Cloudant in Excel.
-
Build Facebook Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Facebook Ads Data from Zoho Analytics and import live Facebook Ads.
-
Natively Connect to Google Forms Data in PHP
The CData ODBC driver for Google Forms enables you to create PHP applications with connectivity to Google Forms. Leverage the native support for ODBC in PHP.
-
Connect to SAP Ariba Source Data in RapidMiner
Integrate SAP Ariba Source with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Real-Time JotForm Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use JotForm in Power Apps.
-
Use the CData SSIS Components to Insert New or Update Existing Google Sheets Records from SQL Server
Easily push SQL Server data to Google Sheets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Sheets or update existing records with data from a SQL Server database.
-
Establish a Live Connection with GetResponse Data using Tableau Bridge
The CData ODBC Driver for GetResponse enables you to integrate live GetResponse into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for Odoo in Microsoft Power Query
You can use the CData Odoo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Odoo ERP into Microsoft Power Query.
-
Integrate Real-Time Access to Salesforce Data 360 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Data 360 in real time.
-
Integrating Antigravity CLI with Rootly via CData CLI
Connect Rootly to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connecting Agentforce with CockroachDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your CockroachDB for you.
-
Work with Planio Data in FoxPro
Load Planio into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect DBeaver to GitLab via a JDBC Driver
Manage GitLab with visual tools in DBeaver like the query browser.
-
Visualize YouTube Analytics Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load YouTube Analytics into TIBCO Spotfire.
-
Query Live Redshift 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 Amazon Redshift directly from the development environment.
-
Build a PostgreSQL Interface for Humanity Data using the CData JDBC Driver
Use the Remoting features of the Humanity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live SharePoint Data in Coginiti Pro
Connect to and query live Microsoft SharePoint from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Certinia Data in Talend Cloud Data Management Platform
Connect Certinia Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Certinia.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Ontraport
Provide connectivity to Ontraport through an SAP BusinessObjects universe.
-
Consume Parquet OData Feeds in PowerBuilder
This article demonstrates how to consume Apache Parquet as OData feeds from PowerBuilder using the API Server.
-
Access SAP Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP ERP/NetWeaver from your Oracle system.
-
Connect to Sage Cloud Accounting Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sage Business Cloud Accounting from Appeon PowerBuilder using the CData ADO.NET Provider for Sage Cloud Accounting.
-
How to create an RPA flow for SAP Business One Data in UiPath Studio
Use the SAP Business One ODBC Driver to create workflows that access real-time SAP Business One without any coding.
-
How to Easily Query ServiceNow Data in OpenOffice Base
Connect to ServiceNow data in OpenOffice Base using the CData ODBC Driver for ServiceNow and generate reports with live data insights.
-
Work with Workday Data in FoxPro
Load Workday into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Dynamics 365 Data in DBVisualizer
Integrate Microsoft Dynamics 365 with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Datasets from Google Drive in Domo Workbench and Build Visualizations of Google Drive Data in Domo
Use the CData Software ODBC Driver for Google Drive to create datasets from Google Drive in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Salesforce CRM Analytics from Asprova with CData Software ODBC Driver for Salesforce CRM Analytics
This article shows how to connect faster to Salesforce CRM Analytics data from Asprova.
-
How to Seamlessly Import Freshservice Data into IBM SPSS Modeler
Integrate Freshservice data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query SAP SuccessFactors LMS Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP SuccessFactors LMS from Node.js.
-
Connect to Google Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Ads to connect to Google Ads and execute queries in PowerBuilder.
-
Automate MailChimp Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live MailChimp and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
DataBind Controls to Printify Data in Delphi
DataBind to Printify in Delphi with standard data access components and controls.
-
Connect to and Query Coinbase Data in QlikView over ODBC
Create data visualizations with Coinbase in QlikView.
-
Automated Continuous CockroachDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CockroachDB replication to Amazon S3.
-
Enable the Instagram JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Instagram.
-
Rapidly Develop Spotify-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 Spotify.
-
Automate MessageBird Data Replication to SAP HANA
Use CData Sync to customize and automate MessageBird replication to SAP HANA.
-
Analyze Live GitHub Data in SAS Viya
Use CData Connect AI to connect to GitHub from SAS Viya and deploy self-service analytics using live GitHub.
-
Integrate with IBM Informix Data in SnapLogic
Use CData Connect AI to connect to and integrate with live IBM Informix in SnapLogic.
-
How to create Box federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Box in MySQL .
-
Use JayDeBeApi to access EmailOctopus Data in Python
Use standard Python scripting and the development environment of your choice to access live EmailOctopus.
-
Process & Analyze Pingdom Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pingdom Data.
-
Connect to AgileCRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for AgileCRM to connect to AgileCRM from Web applications running on WebLogic.
-
How to connect and process LaunchDarkly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live LaunchDarkly.
-
Automated Continuous CSV Replication to SingleStore
Use CData Sync for automated, continuous, customizable CSV replication to SingleStore.
-
Import and Visualize Codat Data in Power View
Create data visualizations based on Codat in Excel.
-
Feed Instantly Data into FineReport
How to set Instantly as a JDBC data source in FineReport.
-
Access Suadeo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Suadeo from your Oracle system.
-
Access Live Oracle HCM Cloud Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle HCM Cloud into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle HCM Cloud in the Graph Builder and Query Builder.
-
Connect to Gorgias Data from a Connection Pool in JBoss
Integrate Gorgias into Java servlets: Use the Management Console in JBoss to install the Gorgias JDBC Driver.
-
Create a Data Access Object for Cloudant Data using JDBI
A brief overview of creating a SQL Object API for IBM Cloudant in JDBI.
-
Use the CData Software JDBC Driver for Freshservice in MicroStrategy
Connect to Freshservice in MicroStrategy Developer using the CData Software JDBC Driver for Freshservice.
-
Model Cosmos DB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Cosmos DB, enabling the direct import of real-time Azure Cosmos DB.
-
How to Connect to Live Google Analytics Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Analytics for you.
-
Query, Visualize, and Share live Exact Online Data in Redash
Use CData Connect AI to connect to live Exact Online in Redash for querying, visualizing, and sharing.
-
Use Claude to Talk to Your Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Office 365 for you.
-
Connect to Quaderno Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Quaderno and work with Quaderno in your FileMaker application.
-
How to Query Live Spark Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache Spark SQL data in natural language using Python.
-
How to connect to HelloSign Data from Spring Boot
Connect to HelloSign in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Microsoft OneLake Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to SingleStore.
-
Integrating Claude Code with WooCommerce Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on WooCommerce within assisted coding and automated development workflows.
-
Connecting Mastra with CSV 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 CSV/TSV Files, no replication required.
-
Integrate Open WebUI with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Atlassian Jira from within the chat interface.
-
Automate Exa Data Replication to Couchbase
Use CData Sync to Customize and automate Exa replication to Couchbase.
-
Connect to Google Ads Data in Ruby
Connect to Google Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Work with Live ActiveCampaign Data in Power Query
Use CData Connect AI to connect to ActiveCampaign and work with live ActiveCampaign in Microsoft Power Query.
-
How to connect to eBay Data in DBVisualizer
Integrate eBay with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports with Power BI XMLA Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Power BI XMLA.
-
Connect to Oracle SCM Data in RapidMiner
Integrate Oracle SCM with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live EnterpriseDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live EnterpriseDB from your Google Sheets.
-
Query Avro Data in DataGrip
Create a Data Source for Avro in DataGrip and use SQL to query live Apache Avro.