CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Zuora Replication to MySQL
Use CData Sync for automated, continuous, customizable Zuora replication to MySQL.
-
Connect to Oracle Sales Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Sales to connect to Oracle Sales data and execute queries in PowerBuilder.
-
Integrate Live Marketo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Marketo data to Blue Prism using the CData ODBC Driver for Marketo to create automated workflows for repetitive business tasks.
-
Build Apps with Live Office 365 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Office 365 data into the Adalo platform and build custom mobile and web applications with real-time Office 365 data.
-
Use Biml to Build SSIS Tasks to Replicate Placid Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Placid data to SQL Server.
-
Use the CData ODBC Driver for Oracle Service Cloud from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Service Cloud to connect to Oracle Service Cloud data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Service Cloud data in Excel.
-
Access Live Azure Table Data in Excel 365 Online (Excel for the web)
Connect to Azure Table data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Search External Microsoft OneDrive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft OneDrive data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft OneDrive Data objects that you can access from apps and the dashboard.
-
Access Live Sugar CRM 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 Sugar CRM data through MCP integration.
-
Build Adobe Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Adobe Analytics data and build visualizations in Tableau Cloud.
-
How to create Visio diagrams from SuiteCRM Data
Automatically update SuiteCRM data with the changes you make to Visio master shapes.
-
Visualize Live AfterShip Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live AfterShip data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Cassandra Replication to MySQL
Use CData Sync for automated, continuous, customizable Cassandra replication to MySQL.
-
Connect to CouchDB Data in NetBeans
Connect to CouchDB data in NetBeans with the data source configuration wizard.
-
Query Live Mailjet Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Mailjet data directly from the development environment.
-
Apollo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Apollo facts in real time.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Adobe Target
Provide connectivity to Adobe Target data through an SAP BusinessObjects universe.
-
Automated Continuous CloudConvert Replication to SQLite
Use CData Sync for automated, continuous, customizable CloudConvert replication to SQLite.
-
Create Power BI Reports on Real-Time Facebook Ads Data
Use the CData ODBC Driver for Facebook Ads to visualize Facebook Ads data in Power BI Desktop.
-
Build SurveyMonkey-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SurveyMonkey data and build SurveyMonkey-connected web apps with Axios.
-
Create Dynamic xBase Grids Using the Infragistics XamDataGrid
Learn how you can connect xBase to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Okta Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Okta Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Shippo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Shippo data.
-
Access Live Oracle Eloqua Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle Eloqua data from your Excel spreadsheets.
-
Connect to Klaviyo Data from a Connection Pool in Jetty
The Klaviyo JDBC Driver supports connection pooling: This article shows how to connect faster to Klaviyo data from Web apps in Jetty.
-
A PostgreSQL Interface for Mode Data using the CData ODBC Driver
Use the SQL Gateway and Mode ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Create Power BI Visual Reports with Real-Time OnePageCrm Data
Use CData Power BI Connectors to visualize OnePageCrm data in Power BI.
-
Integrate Live WooCommerce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to WooCommerce data and integrate live WooCommerce data into apps built in Microsoft Power Apps.
-
How to connect to Wrike Data from Spring Boot
Connect to Wrike in a Spring Boot Application using the CData API Driver for JDBC
-
Moving Data from SingleStore to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SingleStore data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live Lakebase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Lakebase data from your Excel spreadsheets.
-
Natively Connect to SAP HANA XS Advanced Data in PHP
The CData ODBC driver for SAP HANA XS Advanced enables you to create PHP applications with connectivity to SAP HANA XS Advanced data. Leverage the native support for ODBC in PHP.
-
How to use SQLAlchemy ORM to access Nuclia Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Nuclia data.
-
Build Dashboards with Pinterest Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pinterest data in Dundas BI.
-
How to connect to Freshsales Data from Spring Boot
Connect to Freshsales in a Spring Boot Application using the CData API Driver for JDBC
-
Use the CData Software JDBC Driver for SurveyMonkey in MicroStrategy Desktop
Connect to SurveyMonkey data in MicroStrategy Desktop using the CData Software JDBC Driver for SurveyMonkey.
-
Integrating Cursor with Reckon Accounts Hosted 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 SAP Ariba Procurement Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Ariba Procurement data and visualize live SAP Ariba Procurement data in Infragistics Reveal.
-
Create Paylocity-Connected Applications in Appsmith
Connect to Paylocity Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Paylocity data.
-
Connect to Oracle Eloqua Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle Eloqua data from Crystal Reports.
-
Use Manus AI to Talk to Your Microsoft Ads 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 Microsoft Ads data.
-
Connect to Copper Data in Aqua Data Studio
Access Copper data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Provide OData Services of Oracle Eloqua Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Eloqua data by developing a WCF Service Application.
-
Use the CData Software JDBC Driver for Zoho CRM in MicroStrategy
Connect to Zoho CRM data in MicroStrategy Developer using the CData Software JDBC Driver for Zoho CRM.
-
LINQ to Superchat Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Superchat Data Provider.
-
Automated Continuous Airtable Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Airtable replication to Azure SQL Database.
-
Connect to IBM Informix Data from PowerBuilder via ADO.NET
This article demonstrates how to access IBM Informix data from Appeon PowerBuilder using the CData ADO.NET Provider for IBM Informix.
-
Provide OData Services of PayPal Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PayPal data by developing a WCF Service Application.
-
Integrate Open WebUI with Live Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Moosend data from within the chat interface.
-
Connect to Sentry Data in CloverDX (formerly CloverETL)
Transfer Sentry data using the visual workflow in the CloverDX data integration tool.
-
Use the CData ODBC Driver for Act-On in Microsoft Power Query
You can use the CData Act-On ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Act-On data into Microsoft Power Query.
-
How to Connect to Live Gmail Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Gmail data through natural language.
-
Create Nuclia Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Nuclia from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Mixpanel Data in Pentaho Data Integration
Build ETL pipelines based on Mixpanel data in the Pentaho Data Integration tool.
-
Automated Continuous Salesforce Marketing Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to SQL Server.
-
Getting Started with the CData JDBC Driver for FTP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FTP.
-
Integrating Gumloop with AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on AgileCRM data within automated workflows.
-
Connect to and Visualize Live Confluence Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Confluence data.
-
Create Informatica Mappings From/To an ODBC Data Source for Testmonitor
Create an ODBC connection to Testmonitor in Informatica and browse and transfer Testmonitor data.
-
Replicate Multiple Cohere Accounts
Replicate multiple Cohere accounts to one or many databases.
-
Connect to Parquet Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Parquet data using standard SQL.
-
Automated Continuous Oracle Service Cloud Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Apache Cassandra.
-
Use Grok to Talk to Your Exact Online 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 Exact Online data for you.
-
Integrate eBay with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate eBay with External Services.
-
DataBind Controls to Tanda Data in C++Builder
DataBind to Tanda data in C++Builder with standard components and controls.
-
Stream Microsoft Entra ID Data into Apache Kafka Topics
Access and stream Microsoft Entra ID data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Couchbase 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 Couchbase data.
-
Connect to Google Spanner from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Spanner to connect to Google Spanner data from Web applications running on WebLogic.
-
Connect to Redis Data from PowerBuilder via ADO.NET
This article demonstrates how to access Redis data from Appeon PowerBuilder using the CData ADO.NET Provider for Redis.
-
Process & Analyze Marketo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Marketo Data.
-
Integrate Microsoft Exchange with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Exchange with External Services.
-
Create Dynamic Vimeo Grids Using the Infragistics XamDataGrid
Learn how you can connect Vimeo to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Antigravity CLI with Freshsales data via CData CLI
Connect Freshsales data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream SQL Server Data into Apache Kafka Topics
Access and stream SQL Server data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Pipelines with Live Shopify Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Shopify from Google Cloud Data Fusion, enabling the integration of live Shopify data into the building and management of effective data pipelines.
-
Connect to Google Calendar Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Calendar data.
-
How to connect and process Twitter Ads data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Twitter Ads data.
-
Connecting GenSpark with Google Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Ads data without any replication or custom integration required.
-
How to Connect to Live Notion Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Notion data for you.
-
Connect to OpenWeatherMap Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for OpenWeatherMap data.
-
Configure the CData JDBC Driver for Epicor Kinetic in a Connection Pool in Tomcat
Connect to Epicor Kinetic data from a connection pool in Tomcat.
-
Work with Live SAP SuccessFactors Data in Power Query
Use CData Connect AI to connect to SAP SuccessFactors data and work with live SAP SuccessFactors data in Microsoft Power Query.
-
Natively Connect to SQL Analysis Services Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SQL Analysis Services data. Leverage the native support for ODBC in PHP.
-
Query, Visualize, and Share live AfterShip Data in Redash
Use CData Connect AI to connect to live AfterShip data in Redash for querying, visualizing, and sharing.
-
How to work with Autopilot Data in Apache Spark using SQL
Access and process Autopilot Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Live Mocean Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mocean data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access ActiveCampaign Data from MySQL in PHP
Connect to ActiveCampaign through the standard MySQL libraries in PHP.
-
How to Access Google Translate Data Using Entity Framework
This article shows how to access Google Translate data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Bannerbear Data in NetBeans
Connect to Bannerbear data in NetBeans with the data source configuration wizard.
-
Connect to ZohoInvoice Data in JRuby
Create a simple JRuby app with access to live ZohoInvoice data.
-
Seamlessly Bring ClickUp Data into Retool Using CData Connect AI
Integrate ClickUp data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Accelo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Accelo data.
-
Use ChatGPT to Talk to Your SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP BusinessObjects BI data for you.
-
Create Reports from Sybase Data in Looker Studio
Use CData Connect AI to gain access to live Sybase data and create custom reports in Looker Studio.
-
Use Microsoft Copilot Studio to talk to your Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Shopify data for you.
-
Connect to ChartMogul Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ChartMogul as an External Source in Dremio.
-
Integrate Live CSV Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live CSV data from within the IDE.
-
Connect to REST Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for REST to connect to REST data and execute queries in PowerBuilder.
-
Create SSAS Tabular Models from Sendwithus Data
How to build a SQL Server Analysis Service Tabular Model from Sendwithus data using CData drivers.
-
Use the CData Software ODBC Driver for Exact Online in MicroStrategy Desktop
Connect to Exact Online data in MicroStrategy Desktop using the CData Software ODBC Driver for Exact Online.