CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Aweber Replication to SingleStore
Use CData Sync for automated, continuous, customizable Aweber replication to SingleStore.
-
Use the CData Software ODBC Driver for Brex in MicroStrategy Web
Connect to Brex in MicroStrategy Web using the CData Software ODBC Driver for Brex.
-
Build MVC Applications with Connectivity to eBay Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access eBay from an ASP.NET MVC application.
-
How to Connect DBeaver to Jira Assets via a JDBC Driver
Manage Jira Assets with visual tools in DBeaver like the query browser.
-
Access Live Oracle Eloqua Reporting Data in Coginiti Pro
Connect to and query live Oracle Eloqua Reporting from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build an OLAP Cube in SSAS from EmailOctopus Data
Establish a connection to EmailOctopus data from SQL Server Analysis Services, and use the EmailOctopus Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish Reports with Oracle Financials Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Financials Cloud.
-
Integrate Goose with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Kintone from within the local AI agent.
-
Automated Continuous LeadDesk Replication to Databricks
Use CData Sync for automated, continuous, customizable LeadDesk replication to Databricks.
-
Build Access-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Access and build web apps with connectivity to live Microsoft Access.
-
Create a Data Access Object for Testmonitor Data using JDBI
A brief overview of creating a SQL Object API for Testmonitor in JDBI.
-
Connect to Amazon S3 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Amazon S3 to connect to Amazon S3 and execute queries in PowerBuilder.
-
Manage Stack Exchange Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Stack Exchange.
-
Access Live SAP Ariba Procurement 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 SAP Ariba Procurement through MCP integration.
-
Getting Started with the CData Python Connector for XML
Learn to install and license the CData Python Connector
-
How to Work with Microsoft Planner Data in AWS Glue Jobs Using JDBC
Connect to Microsoft Planner from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Building Dynamic Web Pages with Zoho Creator Data Using AngularJS
Create single-page applications with live connectivity to Zoho Creator using the CData API Server.
-
How to Query Live Salesloft Data in Perplexity MacOS Desktop
Connect to and query live Salesloft Data in Perplexity Desktop using CData MCP Server.
-
Excel Spreadsheet Automation on Trello Data with the QUERY Formula
Pull data from Trello, automate spreadsheets, and more with the QUERY formula.
-
Publish MariaDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MariaDB.
-
Build MVC Applications with Connectivity to FreshBooks Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FreshBooks from an ASP.NET MVC application.
-
Create SSAS Tabular Models from ActiveCampaign Data
How to build a SQL Server Analysis Service Tabular Model from ActiveCampaign using CData drivers.
-
Build Semantic Layer Views for Egnyte Data in APOS Live Data Gateway
Use the CData Connector for Egnyte in APOS Live Data Gateway to build Semantic Layer Views for Egnyte.
-
Connect Cosmos DB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Cosmos DB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for Reply.io
Create Reply.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access PabblySubscriptions Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PabblySubscriptions from HeidiSQL.
-
Build Data Flows from SQL Server to QuickBooks Online through SSIS
Easily push SQL Server data to QuickBooks Online using the CData SSIS Tasks for QuickBooks Online.
-
Access Qualaroo Data from MySQL in Amazon QuickSight
Connect to Qualaroo and build visualizations of Qualaroo using a MySQL Connection in Amazon QuickSight.
-
Bridge Redis Connectivity with Apache NiFi
Access and process Redis in Apache NiFi using the CData JDBC Driver.
-
Replicate Pipedrive Data to Multiple Databases via the CData Sync CLI
Replicate Pipedrive to disparate databases with a single configuration.
-
Access Teradata Data from MySQL in Amazon QuickSight
Connect to Teradata and build visualizations of Teradata using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software ODBC Driver for RabbitMQ in MicroStrategy
Connect to RabbitMQ in MicroStrategy Developer using the CData Software ODBC Driver for RabbitMQ.
-
Integrate Cursor with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle HCM Cloud from within the editor.
-
Access Live Apify Data in AWS Lambda
Connect to live Apify in AWS Lambda using the CData JDBC Driver.
-
Query Mocean Data in DataGrip
Create a Data Source for Mocean in DataGrip and use SQL to query live Mocean.
-
Getting Started with the CData JDBC Driver for ZarMoney
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZarMoney.
-
Access Live Excel Online Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Excel Online from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Query Hacker News Data in MySQL Workbench
Execute MySQL queries against live Hacker News from MySQL Workbench.
-
Connect to Live MailChimp Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MailChimp in CData Connect AI and connect to your MailChimp from PostgreSQL.
-
Build MVC Applications with Connectivity to Freshdesk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Freshdesk from an ASP.NET MVC application.
-
Create Data Visualizations in Cognos BI with SAP SuccessFactors Data
Access SAP SuccessFactors as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Paddle Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Paddle to a chart.
-
Analyze Sybase IQ Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sybase IQ and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to GitLab from Asprova with CData Software ODBC Driver for GitLab
This article shows how to connect faster to GitLab data from Asprova.
-
How to connect to Odoo Data from Spring Boot
Connect to Odoo in a Spring Boot Application using the CData JDBC Driver for Odoo
-
Build AI/ML Models with Live Hubstaff Data using Dataiku
Connect Hubstaff Data with Dataiku using the CData API Driver for JDBC.
-
How to import SharePoint Data into Apache Solr
Use the CData Software JDBC Driver for SharePoint in Data Import Handler and create an automated import of Microsoft SharePoint to Apache Solr Enterprise Search platform.
-
Build Mouseflow-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mouseflow.
-
Microsoft Access to Remove Built-in Salesforce Connector — Migrate to the CData Salesforce ODBC Driver
Microsoft is deprecating the built in Salesforce ODBC connector in Access in October 2025. Use the CData Salesforce ODBC connector instead — here’s how to configure it and link tables in Access.
-
Access Live Azure Data Lake Storage Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Data Lake Storage into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Data Lake Storage in the Graph Builder and Query Builder.
-
Extract, Transform, and Load Autopilot Data in Informatica PowerCenter
Create a simple Workflow for Autopilot in Informatica PowerCenter.
-
Connect to Real-Time DocuSign Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for DocuSign and Dataflow to import and use DocuSign in Power Apps.
-
How to Access Live Moosend Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Moosend enables you to integrate Moosend into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous PostgreSQL Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PostgreSQL replication to AlloyDB.
-
Build Snapchat Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Snapchat Ads Data and create custom apps in Bubble.
-
Replicate Multiple Odoo Accounts
Replicate multiple Odoo accounts to one or many databases.
-
Connect to Wrike 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 Wrike and work with Wrike in your FileMaker application.
-
Write a Simple Go Application to work with Rootly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Rootly.
-
View Reports on Real-Time LeadDesk Data in Power BI Report Server
Use the CData ODBC Driver for LeadDesk to visualize LeadDesk in Power BI Desktop and then publish them to Power BI Report Server.
-
Build MVC Applications with Connectivity to Hacker News Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Hacker News from an ASP.NET MVC application.
-
Automate IBM Cloud Object Storage Integration Tasks from PowerShell
Are you in search of a quick and easy way to access IBM Cloud Object Storage from PowerShell? This article demonstrates how to utilize the IBM Cloud Object Storage Cmdlets for tasks like connecting to IBM Cloud Object Storage, automating operations, downloading data, and more.
-
Write a Simple Go Application to work with Placid Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Placid.
-
SendPulse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SendPulse facts in real time.
-
Connect to DocuSign in SpagoBI
Create reports featuring live DocuSign in SpagoBI Studio. Host DocuSign reports on SpagoBI Server.
-
Load Vimeo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Vimeo to a database.
-
Create Data Visualizations in Cognos BI with Twitter Ads Data
Access Twitter Ads as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy Desktop
Connect to Reckon Accounts Hosted in MicroStrategy Desktop using the CData Software JDBC Driver for Reckon Accounts Hosted.
-
Object-Relational Mapping (ORM) with Zoom 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 Zoom into a Java-based ORM framework, Hibernate.
-
Automated Continuous LaunchDarkly Replication to Snowflake
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Snowflake.
-
Query Google Campaign Manager 360 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Campaign Manager 360 from Node.js.
-
Automate Act CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Act CRM replication to SAP HANA.
-
View Reports on Real-Time Coda Data in Power BI Report Server
Use the CData ODBC Driver for Coda to visualize Coda in Power BI Desktop and then publish them to Power BI Report Server.
-
How to update Gmail from Excel
This article explains how to transfer data from Excel to Gmail using the Excel Add-In for Gmail.
-
Viewing Klaviyo Data in RAD Studio Data Explorer
How to view Klaviyo in RAD Studio Data Explorer using the CData ODBC Driver for Klaviyo.
-
Use the CData Software ODBC Driver for Gumroad in MicroStrategy Web
Connect to Gumroad in MicroStrategy Web using the CData Software ODBC Driver for Gumroad.
-
Automated Continuous LionDesk Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LionDesk replication to Apache Cassandra.
-
How to connect to Elorus Data in DBVisualizer
Integrate Elorus with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect the Power BI Service to Demio: Complete Guide
Connect to the CData Software Power BI Connector for Demio from PowerBI.com to provide real-time Demio across the organization.
-
Automate MongoDB Data Replication to Azure Synapse
Use CData Sync to customize and automate MongoDB replication to Azure Synapse.
-
Explore Geographical Relationships in Hive Data with Power Map
Create data visualizations with Apache Hive in Power Map.
-
Connect to Real-Time SurveyMonkey Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SurveyMonkey and Dataflow to import and use SurveyMonkey in Power Apps.
-
Use the CData ODBC Driver for Bullhorn CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bullhorn CRM to connect to Bullhorn CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bullhorn CRM in Excel.
-
Automated Continuous Toggl Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Toggl replication to Google BigQuery.
-
Create OData Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time OData data access from reports, embedded analytics, and more.
-
Build Visualizations of Reckon Accounts Hosted Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Reckon Accounts Hosted in Birst.
-
Connect Vault CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Veeva Vault & Vault CRM using the CData Python MCP Server.
-
How to Easily Query FreeAgent Data in OpenOffice Base
Connect to FreeAgent data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Excel Spreadsheet Automation on Toggl Data with the QUERY Formula
Pull data from Toggl, automate spreadsheets, and more with the QUERY formula.
-
Load ConvertKit Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ConvertKit to a database.
-
Publish Crystal Reports on Sage 200 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage 200.
-
A PostgreSQL Interface for Bugsnag Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bugsnag JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Qualaroo Data in Ruby
Connect to Qualaroo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Invoiced-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Invoiced.
-
Connect to Google Cloud Storage Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Cloud Storage in Airbyte.
-
Connect to Oracle Sales Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Sales using standard SQL.
-
Connect to Google Sheets Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Sheets in Google Apps Script.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Jira Assets to Power BI dashboards. Simply drag and drop Jira Assets into data visuals on the Power BI canvas.
-
Build a Simple VCL Application for Dynamics NAV Data
How to build a simple VCL Application to view Microsoft Dynamics NAV in RAD Studio using the CData ODBC Driver for Dynamics NAV.
-
Create SSAS Tabular Models from ConvertKit Data
How to build a SQL Server Analysis Service Tabular Model from ConvertKit using CData drivers.
-
Connect to Odoo Data in CloverDX (formerly CloverETL)
Transfer Odoo ERP using the visual workflow in the CloverDX data integration tool.