CData Software - Knowledge Base
Recent Articles
-
Validate eBay Analytics Data with QuerySurge
Access and validate eBay Analytics in QuerySurge using the CData JDBC Driver.
-
Replicate Multiple ZohoExpense Accounts via the CData Sync CLI
Replicate multiple ZohoExpense accounts to one or many databases.
-
Integrate with live GraphQL Data in Jitterbit
Use CData Connect AI to connect to and integrate live GraphQL in Jitterbit.
-
Build Salesforce Pardot-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce Pardot Data and create custom apps in Bubble.
-
How to Connect to & Open MailChimp Data in Microsoft Excel
This article uses the CData ODBC driver for MailChimp to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Oracle HCM Cloud Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle HCM Cloud from PowerShell? This article demonstrates how to utilize the Oracle HCM Cloud Cmdlets for tasks like connecting to Oracle HCM Cloud, automating operations, downloading data, and more.
-
Build Microsoft Dataverse-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Dataverse (CDS).
-
Access Live Salesforce Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce & Force.com from your Excel spreadsheets.
-
Viewing AlloyDB Data in RAD Studio Data Explorer
How to view Google AlloyDB in RAD Studio Data Explorer using the CData ODBC Driver for AlloyDB.
-
Connect to Qualaroo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Qualaroo in the Denodo Virtual DataPort Administrator.
-
Create Dynamic FHIR Grids Using the Infragistics XamDataGrid
Learn how you can connect FHIR to Infragistics XamDataGrid to build dynamic grids.
-
Connect to and Query SAP Concur Data in QlikView over ODBC
Create data visualizations with SAP Concur in QlikView.
-
Integrating Antigravity CLI with Facebook Ads via CData CLI
Connect Facebook Ads to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build AI/ML Models with Live BambooHR Data using Dataiku
Connect BambooHR Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Timely Data in Talend Cloud Data Management Platform
Connect Timely Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Bidirectional Access to Certinia Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Certinia in Filemaker Pro for Mac or Windows.
-
Build Data Flows from Templated to SQL Server using SSIS
Easily back up Templated to SQL Server using the SSIS components for Templated.
-
How to Connect to Live IBM Cloud Object Storage 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 IBM Cloud Object Storage for you.
-
Access Live Microsoft Dataverse Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Dataverse (CDS) from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate ZohoInvoice Data to Multiple Databases
Replicate ZohoInvoice to disparate databases with a point-and-click configuration.
-
Create Google Drive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Drive from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Blackbaud FE NXT Data in Google Apps Script via Connect AI
Use CData Connect AI to access Blackbaud FE NXT in Google Apps Script.
-
Connect to Real-Time Hacker News Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Hacker News in Power Apps.
-
Viewing Workday Data in RAD Studio Data Explorer
How to view Workday in RAD Studio Data Explorer using the CData ODBC Driver for Workday.
-
Connect to Outreach.io Data in DBeaver
Use the CData ODBC Driver to connect to Outreach.io in DBeaver.
-
Automated Continuous Lakebase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Lakebase replication to Amazon Redshift.
-
Automated Continuous VWO Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable VWO replication to Azure SQL Database.
-
How to work with Zoho CRM Data in Apache Spark using SQL
Access and process Zoho CRM Data in Apache Spark using the CData Software JDBC Driver.
-
How to import GraphQL Data into Apache Solr
Use the CData Software JDBC Driver for GraphQL in Data Import Handler and create an automated import of GraphQL to Apache Solr Enterprise Search platform.
-
Stream CloudConvert Data into Apache Kafka Topics
Access and stream CloudConvert in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Semantic Layer Views for Missive Data in APOS Live Data Gateway
Use the CData Connector for Missive in APOS Live Data Gateway to build Semantic Layer Views for Missive.
-
Access MariaDB Data from MySQL in Amazon QuickSight
Connect to MariaDB and build visualizations of MariaDB using a MySQL Connection in Amazon QuickSight.
-
Build Google Tasks-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Tasks and build web apps with connectivity to live Google Tasks.
-
Bridge Bullhorn CRM Connectivity with Apache NiFi
Access and process Bullhorn CRM in Apache NiFi using the CData JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live Act-On Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Act-On.
-
Access Live SAP Ariba Source Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Ariba Source from your Google Sheets.
-
Rapidly Develop AdRoll-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 AdRoll.
-
Integrating Kiro CLI with Presto 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.
-
Visualize Oracle Eloqua Reporting Data in TIBCO Spotfire through OData
Integrate Oracle Eloqua Reporting into dashboards in TIBCO Spotfire.
-
Getting Started with the CData ADO.NET Provider for Jira
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Jira.
-
Edit and Search External SurveyMonkey Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SurveyMonkey to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SurveyMonkey Data objects that you can access from apps and the dashboard.
-
Use the CData Software ODBC Driver for Redshift in MicroStrategy
Connect to Amazon Redshift in MicroStrategy Developer using the CData Software ODBC Driver for Redshift.
-
How to connect SharePoint with Reckon Accounts Hosted Data through external lists
Provide Reckon Accounts Hosted to SharePoint users as an external list.
-
Integrate Attio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Attio with External Services.
-
How to Work with Deel Data in ETL Validator JDBC
Connect to Deel from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze PostgreSQL Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PostgreSQL with the CData JDBC Driver for PostgreSQL.
-
Getting Started with the CData Tableau Connector for Invoiced
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with Apollo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apollo to a JSON file on disk.
-
Analyze Live Redis Data in SAS Viya
Use CData Connect AI to connect to Redis from SAS Viya and deploy self-service analytics using live Redis.
-
Use Manus AI to Talk to Your GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on GitLab.
-
Create QuickBooks Online-Connected Nintex Workflows
Use CData Connect AI to connect to QuickBooks Online Data from Nintex Workflow Cloud and build custom workflows using live QuickBooks Online.
-
Connect to Real-Time JobNimbus Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use JobNimbus in Power Apps.
-
Connect to Live SQL Analysis Services Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SQL Analysis Services in CData Connect AI and connect to your SQL Analysis Services from PostgreSQL.
-
Automate Redis Data Replication to Azure Data Lake
Use CData Sync to customize and automate Redis replication to Azure Data Lake.
-
Model, Search, and Visualize Live Act-On Data in ThoughtSpot
Use CData Connect AI to connect to live Act-On for modeling, searching, and visualizing.
-
Import Real-Time ZohoDesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoDesk in ColdFusion.
-
Feed Harvest Data into FineReport
How to set Harvest as a JDBC data source in FineReport.
-
How to Connect DBeaver to HubSpot via a JDBC Driver
Manage HubSpot with visual tools in DBeaver like the query browser.
-
Visualize Rebilly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Rebilly.
-
Query Opsgenie Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Opsgenie from Node.js.
-
Using the CData Software ODBC Driver for ChargeOver in PyCharm
Connect to ChargeOver as an ODBC data source in PyCharm using the CData Software ODBC Driver for ChargeOver.
-
Integrating Antigravity CLI with LaunchDarkly via CData CLI
Connect LaunchDarkly to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a Simple VCL Application for Mailgun Data
How to build a simple VCL Application to view Mailgun in RAD Studio using the CData ODBC Driver for Mailgun.
-
Explore Geographical Relationships in RabbitMQ Data with Power Map
Create data visualizations with RabbitMQ in Power Map.
-
Build MVC Applications with Connectivity to Salesforce CRM Analytics Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesforce CRM Analytics from an ASP.NET MVC application.
-
Publish Crystal Reports on ServiceDesk Plus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ServiceDesk Plus.
-
Visualize Beeminder 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 Beeminder into TIBCO Spotfire.
-
Build Visualizations of Zoho Creator Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Creator in Birst.
-
Build MVC Applications with Connectivity to Billsby Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Billsby from an ASP.NET MVC application.
-
Analyze Azure Table Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Table Storage and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to ServiceDesk Plus Data in Jaspersoft Studio
Execute SQL to remote ServiceDesk Plus in Jaspersoft Studio.
-
Build Asana-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Asana to explore live Asana Data in Gemini Code Assist to assist with building Asana-powered applications.
-
Automate Google Spanner Data Replication to Couchbase
Use CData Sync to Customize and automate Google Spanner replication to Couchbase.
-
Integrate xBase Data in Pentaho Data Integration
Build ETL pipelines based on xBase in the Pentaho Data Integration tool.
-
Build Databricks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Databricks Data and create custom apps in Bubble.
-
Query Coda Data as a MySQL Database in Node.js
Execute MySQL queries against Coda from Node.js.
-
Integrate Real-Time Access to Phoenix in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Phoenix in real time.
-
How to Work with GraphQL Data in AWS Glue Jobs Using JDBC
Connect to GraphQL from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Migrating data from Google Ad Manager to Databricks using CData SSIS Components.
Easily push Google Ad Manager to Databricks using the CData SSIS Tasks for Google Ad Manager and Databricks.
-
Query CapsuleCRM Data from Node.js
Use the OData endpoint of the CData API Server to connect to your CapsuleCRM and perform CRUD operations on CapsuleCRM from Node.js.
-
Visualize Live LinkedIn Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live LinkedIn Ads into custom reports in Power BI.
-
Visualize Live LeadDesk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LeadDesk.
-
Create Reports from Slack Data in Looker Studio
Use CData Connect AI to gain access to live Slack and create custom reports in Looker Studio.
-
Build Agents in Relevance AI with Access to Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on QuickBooks Time within intelligent agent workflows.
-
Connect to BenchmarkEmail Data from PowerBuilder via JDBC
This article demonstrates how to access BenchmarkEmail from PowerBuilder using the BenchmarkEmail JDBC Driver.
-
Connect SAP Business One to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Business One with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to Airtable Data from IntelliJ
Integrate connectivity to Airtable with wizards in IntelliJ.
-
Creating Redis-Connected Applications in Unqork
You can use CData Connect AI to feed Redis to Unqork and build custom business apps.
-
Analyze ZohoExpense Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoExpense from Power Pivot. You will use the Table Import Wizard to load ZohoExpense. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Live RabbitMQ Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live RabbitMQ to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating Kiro CLI with PabblySubscriptions 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 Build an ETL App for Avro Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Avro in Python with petl.
-
Create SSAS Tabular Models from SAP Ariba Source Data
How to build a SQL Server Analysis Service Tabular Model from SAP Ariba Source using CData drivers.
-
Connect to CapsuleCRM Data from a Connection Pool in JBoss
Integrate CapsuleCRM into Java servlets: Use the Management Console in JBoss to install the CapsuleCRM JDBC Driver.
-
How to connect to RSS Feeds in DBVisualizer
Integrate RSS Feeds with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Figshare Replication to SQL Server
Use CData Sync for automated, continuous, customizable Figshare replication to SQL Server.
-
Access Live Microsoft Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Data Visualizations in Cognos BI with Toggl Data
Access Toggl as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Theia IDE with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Impala Replication to Vertica
Use CData Sync for automated, continuous, customizable Impala replication to Vertica.