CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Google Spanner Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Spanner securely in real time.
-
Connect to Wave Financial Data in DBArtisan
Use wizards in DBArtisan to configure Wave Financial as a data source.
-
Integrate with Live SingleStore Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SingleStore from the MuleSoft Anypoint Platform to integrate live SingleStore into custom reports and dashboards.
-
Natively Connect to Dynamics 365 Data in PHP
The CData ODBC driver for Dynamics 365 enables you to create PHP applications with connectivity to Microsoft Dynamics 365. Leverage the native support for ODBC in PHP.
-
Model SAP Concur Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Concur, enabling the direct import of real-time SAP Concur.
-
Build Charts with Freshsales Data in Clear Analytics
Create dynamic charts and perform analytics based on Freshsales in Clear Analytics.
-
Use the CData Software ODBC Driver for ZohoInvoice in MicroStrategy
Connect to ZohoInvoice in MicroStrategy Developer using the CData Software ODBC Driver for ZohoInvoice.
-
Analyze Confluence Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Atlassian Confluence and visualize live Atlassian Confluence in Infragistics Reveal.
-
Use Databricks Agent Bricks to Talk to Your Azure Synapse Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Synapse for you.
-
Connect to Everhour Data in RazorSQL
Connect to Everhour from wizards and query Everhour from the GUI in the RazorSQL database management tool.
-
Connect to Accelo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Configure the CData JDBC Driver for Zoho Books in a Connection Pool in Tomcat
Connect to Zoho Books from a connection pool in Tomcat.
-
Connect to FHIR in SpagoBI
Create reports featuring live FHIR in SpagoBI Studio. Host FHIR reports on SpagoBI Server.
-
Integrate Exact Online Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Exact Online from Informatica Cloud.
-
Automated Continuous Hubstaff Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Hubstaff replication to Apache Cassandra.
-
Access Live Quickbase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Quickbase into the statistical analysis tools available in SAS JMP. This article shows how to use Quickbase in the Graph Builder and Query Builder.
-
Analyze SAP Ariba Procurement Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Ariba Procurement from Power Pivot. You will use the Table Import Wizard to load SAP Ariba Procurement. You can visually build the import query or use any SQL supported by the driver.
-
Manage GetResponse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for GetResponse.
-
How to Connect DBeaver to Tickspot via a JDBC Driver
Manage Tickspot with visual tools in DBeaver like the query browser.
-
Prepare, Blend, and Analyze Microsoft Entra ID Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Entra ID for self-service data analytics.
-
Import and Visualize Adobe Commerce Data in Power View
Create data visualizations based on Adobe Commerce in Excel.
-
Build SAP SuccessFactors-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAP SuccessFactors to explore live SAP SuccessFactors Data in Cursor to assist with building SAP SuccessFactors-powered applications.
-
Connect to Vercel Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Procore Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Procore from your Google Sheets.
-
Create Avro-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Avro Data from Klipfolio and build custom visualizations using live Apache Avro.
-
Use the CData ODBC Driver for Scrapfly in Microsoft Power Query
You can use the CData Scrapfly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Scrapfly into Microsoft Power Query.
-
Automated Continuous Monday.com Replication to SQLite
Use CData Sync for automated, continuous, customizable Monday.com replication to SQLite.
-
Back Up ServiceDesk Plus to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ServiceDesk Plus data.
-
Build Dashboards with Avro Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Avro in Dundas BI.
-
Deploy the ADO.NET Provider for PingOne on an SSRS Report Server
Connect to PingOne 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 Build an ETL App for HDFS Data in Python with CData
Create ETL applications and real-time data pipelines for Apache HDFS in Python with petl.
-
Automated Continuous Timely Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Timely replication to Google Cloud SQL.
-
Creating Adobe Commerce-Connected Applications in Unqork
You can use CData Connect AI to feed Adobe Commerce to Unqork and build custom business apps.
-
Automate ADP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ADP from PowerShell? This article demonstrates how to utilize the ADP Cmdlets for tasks like connecting to ADP, automating operations, downloading data, and more.
-
Replicate Highrise Data in Heroku for Use in Salesforce Connect
Replicate Highrise CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software ODBC Driver for Scrapfly in MicroStrategy Desktop
Connect to Scrapfly in MicroStrategy Desktop using the CData Software ODBC Driver for Scrapfly.
-
Query Oracle Financials Cloud Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle Financials Cloud from Node.js.
-
Integrating Codex CLI with iContact 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.
-
Excel Spreadsheet Automation on MessageBird Data with the QUERY Formula
Pull data from MessageBird, automate spreadsheets, and more with the QUERY formula.
-
Connect to Instantly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect Amazon QuickSight to CockroachDB Data
Create a connection to CockroachDB in CData Connect AI and insert CockroachDB into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Dataiku with OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live OData.
-
Replicate Klaviyo Data to Multiple Databases
Replicate Klaviyo to disparate databases with a point-and-click configuration.
-
Import Real-Time Greenplum Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pivotal GreenPlum in ColdFusion.
-
Integrate Cursor with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Epicor Kinetic from within the editor.
-
Create Teamwork Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Teamwork from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build AI/ML Models with Live QuickBooks Time Data using Dataiku
Connect QuickBooks Time Data with Dataiku using the CData JDBC Driver for QuickBooks Time.
-
Integrate Real-Time Access to MailChimp in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MailChimp in real time.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in MicroStrategy Desktop
Connect to Salesforce Data 360 in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce Data 360.
-
Using the CData Software ODBC Driver for Google Tasks in PyCharm
Connect to Google Tasks as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Tasks.
-
Getting Started with the CData ADO.NET Provider for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft Ads.
-
Integrate LibreChat with Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SQL Analysis Services from within the chat interface.
-
Visualize Live ZarMoney Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZarMoney.
-
Connect to Pinecone Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pinecone from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate Basecamp Data in Pentaho Data Integration
Build ETL pipelines based on Basecamp in the Pentaho Data Integration tool.
-
Connect to Google Directory Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Directory in FileMaker Pro to connect to Google Directory and work with Google Directory in your FileMaker applications.
-
Automated Continuous VWO Replication to SingleStore
Use CData Sync for automated, continuous, customizable VWO replication to SingleStore.
-
Connect to Twitter Ads Data in DBArtisan
Use wizards in DBArtisan to configure Twitter Ads as a data source.
-
Integrating Antigravity CLI with HCL Domino via CData CLI
Connect HCL Domino to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Lakebase Data in Ruby
Connect to Lakebase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Use a Microsoft Access Database to Update SingleStore Data in Real Time
Update SingleStore data by creating a linked table in Microsoft Access with the CData SingleStore ODBC Driver.
-
Create Dynamic Parallel Grids Using the Infragistics XamDataGrid
Learn how you can connect Parallel to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Gumloop with Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Epicor Kinetic within automated workflows.
-
Visualize Google Cloud Storage Data in TIBCO Spotfire through ADO.NET
Integrate Google Cloud Storage into dashboards in TIBCO Spotfire.
-
Connect to HDFS Data in Claris FileMaker Pro
Use the CData ODBC Driver for HDFS in FileMaker Pro to connect to HDFS and work with Apache HDFS in your FileMaker applications.
-
Use the CData Software JDBC Driver for Avaza in MicroStrategy
Connect to Avaza in MicroStrategy Developer using the CData Software JDBC Driver for Avaza.
-
Create Informatica Mappings From/To an ODBC Data Source for Cloudant
Create an ODBC connection to Cloudant in Informatica and browse and transfer IBM Cloudant.
-
Connect to SQL Analysis Services Data in HULFT Integrate
Connect to SQL Analysis Services as a JDBC data source in HULFT Integrate
-
Create Data Visualizations Based On Azure Analysis Services Data in Mode
Use CData Connect AI to connect to Azure Analysis Services Data from Mode and build visualizations using live
-
Connect to Azure Table from Asprova with CData Software ODBC Driver for Azure Table
This article shows how to connect faster to Azure Table data from Asprova.
-
Automated Continuous Shortcut Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Shortcut replication to Google BigQuery.
-
Visualize Hive 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 Apache Hive into TIBCO Spotfire.
-
Manage Wistia Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Wistia.
-
Build IBM Cloud Object Storage-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live IBM Cloud Object Storage and build IBM Cloud Object Storage-connected web apps with Axios.
-
Load SendPulse Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SendPulse to a database.
-
Automated Continuous Hubstaff Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Hubstaff replication to Amazon Redshift.
-
Connect to iContact Data from PowerBuilder via JDBC
This article demonstrates how to access iContact from PowerBuilder using the iContact JDBC Driver.
-
Automated Continuous ClickTime Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ClickTime replication to Amazon S3.
-
Automated Continuous Helpscout Replication to Snowflake
Use CData Sync for automated, continuous, customizable Helpscout replication to Snowflake.
-
Connect to and Visualize Live Outlook Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Outlook.
-
Connect to SAP Concur Data in Jaspersoft Studio
Execute SQL to remote SAP Concur in Jaspersoft Studio.
-
Build Pipelines with Live Amazon DynamoDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Amazon DynamoDB from Google Cloud Data Fusion, enabling the integration of live Amazon DynamoDB into the building and management of effective data pipelines.
-
Import and Visualize PingOne Data in Power View
Create data visualizations based on PingOne in Excel.
-
Publish Salesforce Pardot-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesforce Pardot.
-
Access Mistral AI 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 Mistral AI.
-
Connect to GetResponse Data in CloverDX (formerly CloverETL)
Transfer GetResponse using the visual workflow in the CloverDX data integration tool.
-
How to Connect Flowise AI Agents to Live Redshift Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Amazon Redshift without replication.
-
DataBind Charts to SAP Concur Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Concur 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.
-
Viewing SharePoint Excel Services Data in RAD Studio Data Explorer
How to view SharePoint Excel Services in RAD Studio Data Explorer using the CData ODBC Driver for SharePoint Excel Services.
-
How to Easily Query Cvent Data in OpenOffice Base
Connect to Cvent data in OpenOffice Base using the CData ODBC Driver for Cvent and generate reports with live data insights.
-
Consume Couchbase OData Feeds in PowerBuilder
This article demonstrates how to consume Couchbase as OData feeds from PowerBuilder using the API Server.
-
Connect to Salesloft Data in Ruby
Connect to Salesloft in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build a Simple VCL Application for Float Data
How to build a simple VCL Application to view Float in RAD Studio using the CData ODBC Driver for Float.
-
Consume eBay Analytics OData Feeds in PowerBuilder
This article demonstrates how to consume eBay Analytics as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software JDBC Driver for IBM Cloud Object Storage in MicroStrategy
Connect to IBM Cloud Object Storage in MicroStrategy Developer using the CData Software JDBC Driver for IBM Cloud Object Storage.
-
Provide OData Services of Oracle HCM Cloud Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle HCM Cloud by developing a WCF Service Application.
-
Build Voice Agents in ElevenLabs with access to Live Xero Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Xero Accounting.
-
Access Tickspot Data from MySQL in Amazon QuickSight
Connect to Tickspot and build visualizations of Tickspot using a MySQL Connection in Amazon QuickSight.
-
Integrating Beeminder Data in Talend Cloud Data Management Platform
Connect Beeminder Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to work with Optimizely Data in Apache Spark using SQL
Access and process Optimizely Data in Apache Spark using the CData Software JDBC Driver.