CData Software - Knowledge Base
Recent Articles
-
Analyze Google Sheets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Sheets data and visualize live Google Sheets data in Infragistics Reveal.
-
Visualize Rebilly 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 Rebilly data into TIBCO Spotfire.
-
How to connect and process Zoho Books data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Books data.
-
Access Notion Data from MySQL in Amazon QuickSight
Connect to Notion and build visualizations of Notion data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous HubDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HubDB replication to Amazon S3.
-
Integrate with Vertica Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Vertica data in SnapLogic.
-
Visualize Google Campaign Manager 360 Data in TIBCO Spotfire through ADO.NET
Integrate Google Campaign Manager 360 data into dashboards in TIBCO Spotfire.
-
Working with Shortcut Data in LINQPad
Execute LINQ queries to Shortcut data in LINQPad.
-
Work with Live Highrise Data in Power Query
Use CData Connect AI to connect to Highrise data and work with live Highrise data in Microsoft Power Query.
-
Create Simplesat Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Simplesat from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Hive Data from AWS Glue
Use CData Connect AI to gain access to live Hive data from your AWS Glue jobs.
-
Load SAP HANA XS Advanced Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP HANA XS Advanced data to a database.
-
Integrating Kiro with Office 365 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.
-
Publish Reports with Sybase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sybase data.
-
Connect Azure Data Lake Storage to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Data Lake Storage with IBM WebSphere for seamless data integration and connectivity.
-
Migrating data from PingOne to Google BigQuery using CData SSIS Components.
Easily push PingOne data to Google BigQuery using the CData SSIS Tasks for PingOne and Google BigQuery.
-
Use Dash to Build to Web Apps on OneNote Data
Create Python applications that use pandas and Dash to build OneNote-connected web apps.
-
How to Use a Microsoft Access Database to Update ADP Data in Real Time
Update ADP data by creating a linked table in Microsoft Access with the CData ADP ODBC Driver.
-
Create Todoist Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Todoist from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous AfterShip Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AfterShip replication to IBM DB2.
-
Connect to SingleStore Data from PowerBuilder via ADO.NET
This article demonstrates how to access SingleStore data from Appeon PowerBuilder using the CData ADO.NET Provider for SingleStore.
-
Connect to GitLab Data from a Connection Pool in JBoss
Integrate GitLab data into Java servlets: Use the Management Console in JBoss to install the GitLab JDBC Driver.
-
Query Paddle Data in ColdFusion
Write standard ColdFusion data access code to connect to Paddle data.
-
Getting Started with the CData Python Connector for AdRoll
Learn to install and license the CData Python Connector and configure a connection to live AdRoll data.
-
Validate Apify Data with QuerySurge
Access and validate Apify data in QuerySurge using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for SpaceX
Create an ODBC connection to SpaceX in Informatica and browse and transfer SpaceX data.
-
Integrate Live Acumatica 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 Acumatica data from within the IDE.
-
How to Connect Flowise AI Agents to Live Odoo 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 Odoo data without replication.
-
Connecting Pipedream with Egnyte Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Egnyte data in real time.
-
Build Power BI XMLA-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Power BI XMLA Data from Zoho Analytics and import live Power BI XMLA data.
-
Build MVC Applications with Connectivity to QuickBooks Online Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access QuickBooks Online from an ASP.NET MVC application.
-
Automated Continuous SharePoint Excel Services Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to IBM DB2.
-
How to connect to Optimizely Data from Spring Boot
Connect to Optimizely in a Spring Boot Application using the CData API Driver for JDBC
-
How to Connect to ZohoSubscriptions Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoSubscriptions data. Leverage the pyodbc module for ODBC in Python.
-
Create GraphQL Dataflows on PowerBI.com
Connect to the CData Power BI Connector for GraphQL from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Apps with Live Apollo Data Using the Low-Code Development Platform of Mendix
Connect Apollo data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating Cursor with FormSite 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.
-
Connect to Amazon S3 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon S3 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Live Aweber 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 Aweber data for you.
-
Build an OLAP Cube in SSAS from Adobe Experience Manager Data
Establish a connection to Adobe Experience Manager data data from SQL Server Analysis Services, and use the Adobe Experience Manager Data Provider to build OLAP cubes for use in analytics and reporting.
-
Email Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Email facts in real time.
-
Back Up Teamgate data 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 Teamgate data data.
-
How to Connect to Live BigQuery 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 BigQuery data for you.
-
Use Manus AI to Talk to Your Zendesk 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 Zendesk data.
-
How to Connect to Live Mailgun Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Mailgun data securely in real time.
-
How to Connect to Live Sage Intacct Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Sage Intacct data for you.
-
Import and Visualize ConvertAPI Data in Power View
Create data visualizations based on ConvertAPI data in Excel.
-
Connect AlloyDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AlloyDB with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Elasticsearch Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Elasticsearch Data and connect to Elasticsearch data in Akorbi Digital RunMyProcess.
-
Moving Data from Salesforce Data 360 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce Data 360 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Build an ETL App for ZendeskSell Data in Python with CData
Create ETL applications and real-time data pipelines for ZendeskSell data in Python with petl.
-
Use Dash to Build Web Apps on Presto Data via CData Connect AI
Build interactive Dash web apps on live Presto data using pandas and the CData Connect AI Python SDK.
-
Access Sybase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sybase data from your Oracle system.
-
Use the CData Software ODBC Driver for Certinia in MicroStrategy Desktop
Connect to Certinia data in MicroStrategy Desktop using the CData Software ODBC Driver for Certinia.
-
Analyze Sage 300 Data in Cognos Analytics
Use CData Connect AI to connect to Sage 300 Data from Cognos Analytics and analyze live Sage 300 data.
-
How to connect to Mode Data from IntelliJ
Integrate connectivity to Mode data with wizards in IntelliJ.
-
Natively Connect to Todoist Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Todoist data. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for RabbitMQ in SAS for Real-Time Reporting and Analytics
Connect to real-time RabbitMQ data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for RabbitMQ.
-
Create Power BI Reports on Real-Time XML Data
Use the CData ODBC Driver for XML to visualize XML data in Power BI Desktop.
-
Connect Impala Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Impala data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Rootly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Rootly.
-
How to integrate Bitbucket with Apache Airflow
Access and process Bitbucket data in Apache Airflow using the CData JDBC Driver.
-
Build Automated Workflows with Live SAS xpt Data in Workato
Use CData Connect AI to connect to live SAS xpt data and build automated workflows in Workato.
-
Integrating Boomi Agentstudio with API Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to API data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Google Campaign Manager 360 Data in ACL Analytics
Connect to Google Campaign Manager 360 data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Campaign Manager 360 data.
-
Build Facebook-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Facebook Data and create custom apps in Mendix.
-
Create GetResponse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time GetResponse data access from reports, embedded analytics, and more.
-
Access Live Salesforce Marketing 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 Salesforce Marketing data through MCP integration.
-
Visualize Live Sentry Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sentry data.
-
Connect to Lakebase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Lakebase and the Script function in FileMaker Pro to connect to Lakebase and work with Lakebase data in your FileMaker application.
-
Interact with Live Salesforce CRM Analytics Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Salesforce CRM Analytics data.
-
Automated Continuous Dynamics CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Amazon Redshift.
-
Build Oracle HCM Cloud-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 Oracle HCM Cloud data without replication.
-
Connect Greenhouse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Greenhouse data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous OData Replication to AlloyDB
Use CData Sync for automated, continuous, customizable OData replication to AlloyDB.
-
Connect to Zoho Books Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho Books Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Perform Batch Operations with IBM Informix Data in Apache NiFi
Connect to IBM Informix data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Live Attio Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Attio data and integrate live Attio data into apps built in Microsoft Power Apps.
-
Automate MessageBird Data Replication to Azure Data Lake
Use CData Sync to customize and automate MessageBird data replication to Azure Data Lake.
-
Build Visualizations of Oracle SCM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle SCM data in Birst.
-
Integrating Claude Code CLI with Aweber 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.
-
Connect to Testmonitor Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Testmonitor Data and connect to Testmonitor data in Akorbi Digital RunMyProcess.
-
Getting Started with the CData SSIS Components for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData SSIS Components for YouTube Analytics.
-
Connect to Hacker News from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hacker News to connect to Hacker News data from Web applications running on WebLogic.
-
Use the CData ODBC Driver for CockroachDB in Microsoft Power Query
You can use the CData CockroachDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CockroachDB data into Microsoft Power Query.
-
How to Easily Query SAP Concur Data in OpenOffice Base
Connect to SAP Concur data in OpenOffice Base using the CData ODBC Driver for SAP Concur and generate reports with live data insights.
-
Connect to Suadeo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Suadeo in FileMaker Pro to connect to Suadeo and work with Suadeo data in your FileMaker applications.
-
Connect Shortcut Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Shortcut data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Google Translate Data to Multiple Databases via the CData Sync CLI
Replicate Google Translate data to disparate databases with a single configuration.
-
Use ChatGPT to Talk to Your MarkLogic 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 MarkLogic data for you.
-
Connect to Google Campaign Manager 360 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Campaign Manager 360 data using standard SQL.
-
Publish Zoho Creator-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Creator data.
-
Access Live Xero Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Xero data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Twilio Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Twilio replication to delimited files (CSV/TSV).
-
View Reports on Real-Time CircleCI Data in Power BI Report Server
Use the CData ODBC Driver for CircleCI to visualize CircleCI data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Manus AI to Talk to Your Lakebase 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 Lakebase data.
-
Build SharePoint Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SharePoint data and build visualizations in Tableau.
-
Integrate Real-Time Access to Cassandra in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Cassandra data in real time.
-
How to import JotForm Data into Apache Solr
Use the CData Software JDBC Driver for JotForm in Data Import Handler and create an automated import of JotForm data to Apache Solr Enterprise Search platform.
-
Build Apps with Live Box data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Box data into the Adalo platform and build custom mobile and web applications with real-time Box data.