CData Software - Knowledge Base
Recent Articles
-
How to Query ConstantContact Data in MySQL Workbench
Execute MySQL queries against live ConstantContact data from MySQL Workbench.
-
Automated Continuous Aha! Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Aha! replication to Google Cloud SQL.
-
Build Redis-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Redis data and build Redis-connected web apps with Axios.
-
DataBind Charts to Humanity Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Humanity data 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.
-
Build SFTP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SFTP data and build web apps with connectivity to live SFTP data.
-
Automated Continuous PhantomBuster Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PhantomBuster replication to Apache Kafka.
-
Replicate Multiple Contentful Accounts
Replicate multiple Contentful accounts to one or many databases.
-
Automated Continuous CockroachDB Replication to MySQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to MySQL.
-
Integrate Live SAP Concur Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Concur data and integrate live SAP Concur data into apps built in Microsoft Power Apps.
-
Integrating Antigravity CLI with Power BI XMLA data via CData CLI
Connect Power BI XMLA data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Vercel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Vercel from Power Pivot. You will use the Table Import Wizard to load Vercel data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Power BI Connector for Vimeo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Create Power BI Visual Reports with Real-Time SAP ByDesign Data
Use CData Power BI Connectors to visualize SAP ByDesign data in Power BI.
-
DataBind Controls to Aha! Data in C++Builder
DataBind to Aha! data in C++Builder with standard components and controls.
-
DataBind Controls to Apify Data in Delphi
DataBind to Apify data in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for SparkPost in MicroStrategy
Connect to SparkPost data in MicroStrategy Developer using the CData Software ODBC Driver for SparkPost.
-
Integrate GetResponse Data into Power Automate Desktop using CData Connect
CData Connect for GetResponse Data enables you to integrate GetResponse data into workflows built using Microsoft Power Automate Desktop.
-
Access Live Zoho CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoho CRM data from your Excel spreadsheets.
-
How to Connect to & Open Oracle Eloqua Reporting Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Eloqua Reporting to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build SQL Server-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SQL Server data.
-
Automated Continuous SendInBlue Replication to Vertica
Use CData Sync for automated, continuous, customizable SendInBlue replication to Vertica.
-
How to Connect to Live FHIR Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your FHIR data for you.
-
Connect to Intercom Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Intercom data in the Denodo Virtual DataPort Administrator.
-
Connect to Highrise Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Highrise as an External Source in Dremio.
-
Build Data Flows from Amazon S3 to SQL Server using SSIS
Easily back up Amazon S3 data to SQL Server using the SSIS components for Amazon S3.
-
Automated Continuous Calendly Replication to MongoDB
Use CData Sync for automated, continuous, customizable Calendly replication to MongoDB.
-
Load Kintone Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Kintone data to a database.
-
Analyze Act-On Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Act-On from Power Pivot. You will use the Table Import Wizard to load Act-On data. You can visually build the import query or use any SQL supported by the driver.
-
Use Dash to Build to Web Apps on Factorial Data
Create Python applications that use pandas and Dash to build Factorial-connected web apps.
-
How to connect Amazon QuickSight to Grafana Data
Create a connection to Grafana data in CData Connect AI and insert Grafana data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build MongoDB-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live MongoDB data without replication.
-
Integrate with Google Campaign Manager 360 Data in JReport Designer
Create charts and reports based on Google Campaign Manager 360 data in JReport Designer.
-
Integrate Live Attio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Attio data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Nuclia Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Nuclia as an External Source in Dremio.
-
Replicate Multiple Google Directory Accounts
Replicate multiple Google Directory accounts to one or many databases.
-
Explore Geographical Relationships in Gmail Data with Power Map
Create data visualizations with Gmail data in Power Map.
-
How to Work with Rootly Data in ETL Validator JDBC
Connect to Rootly from ETL Validator jobs using the CData Software JDBC Driver.
-
Model, Search, and Visualize Live SAS xpt Data in ThoughtSpot
Use CData Connect AI to connect to live SAS xpt data for modeling, searching, and visualizing.
-
Analyze SQL Analysis Services Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SQL Analysis Services data with the CData JDBC Driver for SQL Analysis Services.
-
How to connect to SAS Data Sets Data from Spring Boot
Connect to SAS Data Sets in a Spring Boot Application using the CData JDBC Driver for SAS Data Sets
-
Use Azure AI Foundry to Talk to Your Gmail 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 Gmail data for you.
-
Build MVC Applications with Connectivity to Quickbase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Quickbase from an ASP.NET MVC application.
-
Access Live Twilio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Twilio data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Real-Time Google Tasks Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Google Tasks data in Power Apps.
-
Work with MarkLogic Data in FoxPro
Load MarkLogic data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to Live QuickBooks Time Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live QuickBooks Time data securely in real time.
-
Building Dynamic Web Pages with Microsoft Teams Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Teams using the CData API Server.
-
Access OData Services from MySQL in Amazon QuickSight
Connect to OData and build visualizations of OData services using a MySQL Connection in Amazon QuickSight.
-
Connect to Live Pinterest Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Pinterest in CData Connect AI and connect to your Pinterest data from PostgreSQL.
-
Object-Relational Mapping (ORM) with Greenhouse 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 Greenhouse data into a Java-based ORM framework, Hibernate.
-
Migrating data from Apify to Google BigQuery using CData SSIS Components.
Easily push Apify data to Google BigQuery using the CData SSIS Tasks for Apify and Google BigQuery.
-
Analyze Office 365 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Office 365 data and visualize live Office 365 data in Infragistics Reveal.
-
Query Workday Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Workday entities in PHP by modeling them as objects.
-
Automated Continuous Salesforce Marketing Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Google BigQuery.
-
Access Live Power BI XMLA Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Power BI XMLA data through MCP integration.
-
Integrate Unbounce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Unbounce with External Services.
-
How to Access Suadeo Data Using Entity Framework
This article shows how to access Suadeo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Rapidly Develop Qualaroo-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 Qualaroo.
-
Work with Salesforce Marketing Data in FoxPro
Load Salesforce Marketing data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Excel Spreadsheet Automation on Beeminder Data with the QUERY Formula
Pull data from Beeminder, automate spreadsheets, and more with the QUERY formula.
-
Import HCL Domino Data Using Azure Data Factory
Use CData Connect AI to connect to HCL Domino Data from Azure Data Factory and import live HCL Domino data.
-
Use Grok to Talk to Your Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Salesloft data for you.
-
Object-Relational Mapping (ORM) with Intercom 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 Intercom data into a Java-based ORM framework, Hibernate.
-
Build Oracle Sales-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle Sales Data and create custom apps in Bubble.
-
Create MailChimp Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MailChimp from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Controls to Missive Data in Delphi
DataBind to Missive data in Delphi with standard data access components and controls.
-
How to Visualize Tavily Data in Python with pandas
Use pandas and other modules to analyze and visualize live Tavily data in Python.
-
Integrating Dataiku with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live DocuSign data.
-
Visualize Live SFTP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SFTP data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Supabase Data to Multiple Databases via the CData Sync CLI
Replicate Supabase data to disparate databases with a single configuration.
-
Create Informatica Mappings From/To a JDBC Data Source for SuiteCRM
Create SuiteCRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating OpenCode with Retently 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.
-
Deploy the ADO.NET Provider for GitHub on an SSRS Report Server
Connect to GitHub data 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.
-
Publish Crystal Reports on Eventbrite Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Eventbrite data.
-
Integrate Salesforce Pardot Data into Power Automate Desktop using CData Connect
CData Connect for Salesforce Pardot Data enables you to integrate Salesforce Pardot data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Jira Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Jira data and integrate live Jira data into your Power Automate tasks.
-
Connect ChartMogul to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ChartMogul data using the CData Python MCP Server.
-
Use the CData Software JDBC Driver for Discord in MicroStrategy
Connect to Discord data in MicroStrategy Developer using the CData Software JDBC Driver for Discord.
-
Visualize Live QuickBooks Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live QuickBooks data.
-
Create Apps from Sybase IQ Data in Qlik Sense Cloud
Use CData Connect AI to connect to Sybase IQ Data and build apps from live Sybase IQ data in Qlik Sense Cloud.
-
Access Live SQL Server Data in Coginiti Pro
Connect to and query live SQL Server data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze JDBC-ODBC Bridge Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze JDBC-ODBC Bridge data with the CData JDBC Driver for JDBC-ODBC Bridge.
-
Use Databricks Agent Bricks to Talk to Your eBay Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your eBay Analytics data for you.
-
Access Live LDAP Objects in Excel 365 Online (Excel for the web)
Connect to LDAP objects from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Toggl Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Toggl from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Sybase Data from IntelliJ
Integrate connectivity to Sybase data with wizards in IntelliJ.
-
Operational Reporting on ZarMoney Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZarMoney data.
-
Use the CData Software ODBC Driver for Oracle Sales in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Sales data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Sales.
-
Create Datasets from Factorial in Domo Workbench and Build Visualizations of Factorial Data in Domo
Use the CData Software ODBC Driver for Factorial to create datasets from Factorial data in Domo Workbench and then build visualizations in the Domo service.
-
Provide OData Services of Attio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Attio data by developing a WCF Service Application.
-
How to Work with Azure DevOps Data in AWS Glue Jobs Using JDBC
Connect to Azure DevOps from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Slack Replication to Snowflake
Use CData Sync for automated, continuous, customizable Slack replication to Snowflake.
-
Build a PostgreSQL Interface for Excel Online Data using the CData JDBC Driver
Use the Remoting features of the Excel Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SharePoint Excel Services Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SharePoint Excel Services.
-
Access Oracle Service Cloud Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Service Cloud data from HeidiSQL.
-
Query ClickTime Data as a MySQL Database in Node.js
Execute MySQL queries against ClickTime data from Node.js.
-
Automated Continuous SAP BusinessObjects BI Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to IBM DB2.
-
Visualize SAP Netweaver Gateway Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Netweaver Gateway data.
-
Moosend Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Moosend data through CData Connect AI using different applications and tools.
-
Trigger Snowflake IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Snowflake with standard wizards in Logic Apps.