CData Software - Knowledge Base
Recent Articles
-
Connect Workable to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Workable with IBM WebSphere for seamless data integration and connectivity.
-
Access Harvest Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Harvest from your Oracle system.
-
Integrate Live Amazon Athena Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Amazon Athena and integrate live Amazon Athena into apps built in Microsoft Power Apps.
-
Import HBase Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache HBase. In this article, you will use the OData format to import Apache HBase into Microsoft Power Query.
-
Build Semantic Layer Views for CockroachDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for CockroachDB.
-
Replicate Webflow Data from PowerShell
Write a quick PowerShell script to query Webflow. Use connectivity to the live data to replicate Webflow to SQL Server.
-
Integrating Antigravity CLI with Anaplan via CData CLI
Connect Anaplan to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to BigQuery from Asprova with CData Software ODBC Driver for BigQuery
This article shows how to connect faster to BigQuery data from Asprova.
-
How to connect PolyBase to Ontraport
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Ontraport.
-
How to Build an ETL App for JSON Services in Python with CData Connect AI
Build ETL pipelines that read and write live JSON in Python with petl and the CData Connect AI Python SDK.
-
Connect to Brex Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Brex in the Denodo Virtual DataPort Administrator.
-
Working with Certinia Data in LINQPad
Execute LINQ queries to Certinia in LINQPad.
-
Create Data Visualizations in Cognos BI with Monday.com Data
Access Monday.com as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Claude Code CLI with Everhour 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.
-
Integrating LlamaIndex with CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on CockroachDB in real time.
-
Bidirectional Access to Cloudflare Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Cloudflare in Filemaker Pro for Mac or Windows.
-
Analyze Cloudant Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze IBM Cloudant with the CData JDBC Driver for Cloudant.
-
Analyze Sybase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sybase and visualize live Sybase in Infragistics Reveal.
-
How to Create Power BI Visual Reports with Real-Time Everhour Data
Use CData Power BI Connectors to visualize Everhour in Power BI.
-
Build an OLAP Cube in SSAS from Wrike Data
Establish a connection to Wrike data from SQL Server Analysis Services, and use the Wrike Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Connect AI Python SDK for Smartsheet
Install the CData Connect AI Python SDK to read and write live Smartsheet with standard DB-API 2.0 Python code.
-
DataBind Scrapfly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Scrapfly to a chart.
-
Import Certinia Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Certinia Data and provide access to live Certinia for custom reports in the Power BI Service.
-
How to Build an ETL App for BigCommerce Data in Python with CData
Create ETL applications and real-time data pipelines for BigCommerce in Python with petl.
-
Feed Billsby Data into FineReport
How to set Billsby as a JDBC data source in FineReport.
-
Viewing OnePageCrm Data in RAD Studio Data Explorer
How to view OnePageCrm in RAD Studio Data Explorer using the CData ODBC Driver for OnePageCrm.
-
Build Apps with Live Google Cloud Storage in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Cloud Storage into the Adalo platform and build custom mobile and web applications with real-time Google Cloud Storage.
-
Add CockroachDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CockroachDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to create Confluence federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Atlassian Confluence in MySQL .
-
Integrating LangGraph with GraphQL Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on GraphQL within automated workflows.
-
How to Connect DBeaver to Intercom via a JDBC Driver
Manage Intercom with visual tools in DBeaver like the query browser.
-
Access Live CockroachDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CockroachDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to LinkedIn Ads Data in Google Apps Script via Connect AI
Use CData Connect AI to access LinkedIn Ads in Google Apps Script.
-
Connect to SAP SuccessFactors Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP SuccessFactors from Crystal Reports.
-
Integrate Live Email Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Email and integrate live Email into apps built in Microsoft Power Apps.
-
DataBind Controls to SendPulse Data in Delphi
DataBind to SendPulse in Delphi with standard data access components and controls.
-
How to Use a Microsoft Access Database to Update Zoho Projects Data in Real Time
Update Zoho Projects data by creating a linked table in Microsoft Access with the CData Zoho Projects ODBC Driver.
-
Integrating GitHub Copilot CLI with Certinia 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 Tasks in Power Automate Using the CData API Server
Automate CockroachDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to update Elasticsearch from Excel
This article explains how to transfer data from Excel to Elasticsearch using the Excel Add-In for Elasticsearch.
-
Automated Continuous Blackbaud FE NXT Replication to MySQL
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to MySQL.
-
How to Work with CloudConvert Data in ETL Validator JDBC
Connect to CloudConvert from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Testmonitor Data in Pentaho Data Integration
Build ETL pipelines based on Testmonitor in the Pentaho Data Integration tool.
-
Access ConstantContact Data from MySQL in PHP
Connect to ConstantContact through the standard MySQL libraries in PHP.
-
Connect to Bitbucket Data in Jaspersoft Studio
Execute SQL to remote Bitbucket in Jaspersoft Studio.
-
Build SAP HANA Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP HANA and build visualizations in Tableau Cloud.
-
How to create an RPA flow for Sybase IQ Data in UiPath Studio
Use the Sybase IQ ODBC Driver to create workflows that access real-time Sybase IQ without any coding.
-
Connect Intercom to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Intercom using the CData Python MCP Server.
-
Connect to MYOB AccountRight Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MYOB AccountRight in Airbyte.
-
Use the CData Software ODBC Driver for VWO in MicroStrategy Web
Connect to VWO in MicroStrategy Web using the CData Software ODBC Driver for VWO.
-
Use Agno to Talk to Your Sugar CRM 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 Sugar CRM for you.
-
Integrate Supabase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Supabase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Supabase.
-
Connect to Paddle Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Paddle and the SQL Gateway to access Paddle from Google Apps Script.
-
Connect to Postmark Data in NetBeans
Connect to Postmark in NetBeans with the data source configuration wizard.
-
Access Live Twitter Ads Data in AWS Lambda
Connect to live Twitter Ads in AWS Lambda using the CData JDBC Driver.
-
Analyze Sybase IQ Data in Looker
Use CData Connect AI to connect to Sybase IQ Data from Looker and build custom apps using live Sybase IQ.
-
Build Pipelines with Live SAP Concur Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Concur from Google Cloud Data Fusion, enabling the integration of live SAP Concur into the building and management of effective data pipelines.
-
How to Create Power BI Visual Reports with Real-Time Zendesk Data
Use CData Power BI Connectors to visualize Zendesk in Power BI.
-
Publish Reports with Shortcut Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shortcut.
-
Integrate Placid Data in the Pentaho Report Designer
Publish reports based on Placid in the Pentaho BI tool.
-
Obfuscate Live Salesforce PII Data in Power BI using CData Connect AI
Obfuscate live Salesforce PII before it reaches Power BI using CData Connect AI Workspaces and Derived Views. Works for any connected source.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon DynamoDB using the Model Context Protocol.
-
Access Live BigCommerce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BigCommerce into the statistical analysis tools available in SAS JMP. This article shows how to use BigCommerce in the Graph Builder and Query Builder.
-
Replicate Certinia Data in Heroku for Use in Salesforce Connect
Replicate Certinia to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Charts to Zoho Inventory Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Inventory 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.
-
Validate Browserless Data with QuerySurge
Access and validate Browserless in QuerySurge using the CData JDBC Driver.
-
Use Azure AI Foundry to Talk to Your Google Drive 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 Google Drive for you.
-
Getting Started with the CData Connect AI Python SDK for Monday.com
Install the CData Connect AI Python SDK to read and write live Monday.com with standard DB-API 2.0 Python code.
-
Build Zoho Books-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoho Books and build Zoho Books-connected web apps with Axios.
-
Query SAP Business One Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Business One from Node.js.
-
Access ZarMoney Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZarMoney from your Oracle system.
-
Connect to Sage 200 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage 200.
-
Access Jodoo 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 Jodoo.
-
Feed Google Translate Data into FineReport
How to set Google Translate as a JDBC data source in FineReport.
-
How to create an RPA flow for Toggl Data in UiPath Studio
Use the Toggl ODBC Driver to create workflows that access real-time Toggl without any coding.
-
Replicate IBM Informix Data in Heroku for Use in Salesforce Connect
Replicate IBM Informix to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish Excel Online-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Excel Online.
-
Configure the CData JDBC Driver for Amazon Marketplace in a Connection Pool in Tomcat
Connect to Amazon Marketplace from a connection pool in Tomcat.
-
Use the CData Software JDBC Driver for Xero in MicroStrategy
Connect to Xero Accounting in MicroStrategy Developer using the CData Software JDBC Driver for Xero.
-
Build Dashboards with Optimizely Data in Dundas BI
Create dynamic dashboards and perform analytics based on Optimizely in Dundas BI.
-
Integrate BambooHR Data in Pentaho Data Integration
Build ETL pipelines based on BambooHR in the Pentaho Data Integration tool.
-
Integrating LangGraph with GitLab Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on GitLab within automated workflows.
-
Automate LeadDesk Data Replication to Azure Data Lake
Use CData Sync to customize and automate LeadDesk replication to Azure Data Lake.
-
Replicate Multiple Google Ads Accounts
Replicate multiple Google Ads accounts to one or many databases.
-
Build Charts with Gumroad Data in Clear Analytics
Create dynamic charts and perform analytics based on Gumroad in Clear Analytics.
-
How to Connect to Live Zuora 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 Zuora without replication.
-
How to Query Live Epicor Kinetic Data in Perplexity MacOS Desktop
Connect to and query live Epicor Kinetic Data in Perplexity Desktop using CData MCP Server.
-
Connect to Cvent Data in HULFT Integrate
Connect to Cvent as a JDBC data source in HULFT Integrate
-
Access RSS Feeds from MySQL in PHP
Connect to RSS through the standard MySQL libraries in PHP.
-
Connect Google Search to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Search with IBM WebSphere for seamless data integration and connectivity.
-
Import Real-Time Snowflake Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Snowflake in ColdFusion.
-
Automated Continuous SharePoint Excel Services Replication to SingleStore
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to SingleStore.
-
A PostgreSQL Interface for Hacker News Data (MySQL Remoting via JDBC)
Use the Remoting features of the Hacker News JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Aweber Data in AWS Lambda
Connect to live Aweber in AWS Lambda using the CData JDBC Driver.
-
Integrating OpenCode Terminal with Mocean 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.
-
Analyze Live HBase Data in SAS Viya
Use CData Connect AI to connect to Apache HBase from SAS Viya and deploy self-service analytics using live Apache HBase.
-
How to create Shopify federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Shopify in MySQL .
-
Build Oracle Eloqua-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle Eloqua Data and create custom apps in Bubble.
-
Use the CData ODBC Driver for SAP Netweaver Gateway from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Netweaver Gateway to connect to SAP Netweaver Gateway from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Netweaver Gateway in Excel.
-
Build MVC Applications with Connectivity to Humanity Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Humanity from an ASP.NET MVC application.