CData Software - Knowledge Base
Recent Articles
-
Connect to ZeroBounce Data in DBArtisan
Use wizards in DBArtisan to configure ZeroBounce as a data source.
-
Use Databricks Agent Bricks to Talk to Your Office 365 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Office 365 for you.
-
DataBind Charts to Cloudant Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to IBM Cloudant 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.
-
Access IBM Cloud Object Storage Data from MySQL in PHP
Connect to IBM Cloud Object Storage through the standard MySQL libraries in PHP.
-
Google Campaign Manager 360 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Campaign Manager 360 through CData Connect AI using different applications and tools.
-
Connect to Sage Cloud Accounting Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sage Cloud Accounting Data and connect to Sage Business Cloud Accounting in Akorbi Digital RunMyProcess.
-
Connect to Neo4J Data in RapidMiner
Integrate Neo4J with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to and Visualize Live Oracle Financials Cloud Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Financials Cloud.
-
Connect to Presto Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Presto and the Script function in FileMaker Pro to connect to Presto and work with Presto in your FileMaker application.
-
Integrating LangGraph with Oracle Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Database within automated workflows.
-
Establish a Live Connection with Gmail Data using Tableau Bridge
The CData ODBC Driver for Gmail enables you to integrate live Gmail into Tableau Cloud dashboards using the Tableau Bridge.
-
Easily Integrate Tally Data in Lazarus Pascal IDE
Learn how to easily integrate live Tally ERP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize WordPress 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 WordPress into TIBCO Spotfire.
-
Connect to and Query Sybase IQ Data in QlikView over ODBC
Create data visualizations with Sybase IQ in QlikView.
-
How to Build an ETL App for Zoho Books Data in Python with CData Connect AI
Build ETL pipelines that read and write live Zoho Books in Python with petl and the CData Connect AI Python SDK.
-
How to Build an ETL App for Jira Assets Data in Python with CData
Create ETL applications and real-time data pipelines for Jira Assets in Python with petl.
-
Replicate Multiple Raisers Edge NXT Accounts via the CData Sync CLI
Replicate multiple Raisers Edge NXT accounts to one or many databases.
-
Integrate Printful Data in the Pentaho Report Designer
Publish reports based on Printful in the Pentaho BI tool.
-
Automated Continuous HDFS Replication to Vertica
Use CData Sync for automated, continuous, customizable HDFS replication to Vertica.
-
Connect to Aha! Data from a Connection Pool in JBoss
Integrate Aha! into Java servlets: Use the Management Console in JBoss to install the Aha! JDBC Driver.
-
Build a Singer.io Tap for Vault CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Vault CRM data using
-
Integrating Gumloop with BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google BigQuery within automated workflows.
-
Viewing Google Sheets Data in RAD Studio Data Explorer
How to view Google Sheets in RAD Studio Data Explorer using the CData ODBC Driver for Google Sheets.
-
Build MVC Applications with Connectivity to Reckon Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Reckon from an ASP.NET MVC application.
-
Automated Continuous SAP Fieldglass Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to MySQL.
-
Qualaroo Reporting in OBIEE with the Qualaroo JDBC Driver
Deploy the Qualaroo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect DBeaver to SharePoint Excel Services via a JDBC Driver
Manage SharePoint Excel Services with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for Procore in MicroStrategy Desktop
Connect to Procore in MicroStrategy Desktop using the CData Software ODBC Driver for Procore.
-
Automated Continuous Adobe Commerce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Google Cloud SQL.
-
Import Real-Time MessageBird Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MessageBird in ColdFusion.
-
ZarMoney Reporting in OBIEE with the ZarMoney JDBC Driver
Deploy the ZarMoney JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Query Live SAP Business Warehouse Data in Claude Desktop
Connect to and query live SAP Business Warehouse Data in Claude Desktop using CData MCP Server.
-
Connect to SparkPost Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SparkPost as an External Source in Dremio.
-
Connect to ClickTime in SpagoBI
Create reports featuring live ClickTime in SpagoBI Studio. Host ClickTime reports on SpagoBI Server.
-
Connect to Gumroad Data in HULFT Integrate
Connect to Gumroad as a JDBC data source in HULFT Integrate
-
Access ZohoSubscriptions Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZohoSubscriptions from your Oracle system.
-
How to connect to WooCommerce Data from Spring Boot
Connect to WooCommerce in a Spring Boot Application using the CData JDBC Driver for WooCommerce
-
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.
-
Create Datasets from SparkPost in Domo Workbench and Build Visualizations of SparkPost Data in Domo
Use the CData Software ODBC Driver for SparkPost to create datasets from SparkPost in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Query Google Drive Data in QlikView over ODBC
Create data visualizations with Google Drive in QlikView.
-
Access Live Zoho CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoho CRM 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.
-
How to connect to LightSpeedRetail Data in DBVisualizer
Integrate LightSpeedRetail with visual data analysis tools and data connection wizards in DBVisualizer
-
Extract, Transform, and Load Onfleet Data in Informatica PowerCenter
Create a simple Workflow for Onfleet in Informatica PowerCenter.
-
LINQ to Grafana 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 Grafana Data Provider.
-
Access Live WooCommerce Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live WooCommerce from your Excel spreadsheets.
-
Integrate Cloudflare Data in the Pentaho Report Designer
Publish reports based on Cloudflare in the Pentaho BI tool.
-
Load Kintone Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Kintone to a database.
-
Automated Continuous LinkedIn Replication to Vertica
Use CData Sync for automated, continuous, customizable LinkedIn replication to Vertica.
-
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.
-
Prepare, Blend, and Analyze Databricks Data in Alteryx Designer (Connect AI)
Build workflows to access live Databricks for self-service data analytics.
-
Integrating Cursor CLI with Parquet 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics CRM
Provide connectivity to Microsoft Dynamics CRM through an SAP BusinessObjects universe.
-
Automated Printful Data Replication to Teradata
Use CData Sync to Customize and automate Printful replication to Teradata.
-
Automated Continuous Sage 200 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sage 200 replication to AlloyDB.
-
Build Visualizations of Templated Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Templated in Birst.
-
Extract, Transform, and Load Mouseflow Data in Informatica PowerCenter
Create a simple Workflow for Mouseflow in Informatica PowerCenter.
-
Process & Analyze Teradata Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Teradata Data.
-
How to Build an ETL App for Notion Data in Python with CData
Create ETL applications and real-time data pipelines for Notion in Python with petl.
-
How to Connect to Live Xero 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 Xero Accounting for you.
-
Access Nuclia Data from MySQL in Amazon QuickSight
Connect to Nuclia and build visualizations of Nuclia using a MySQL Connection in Amazon QuickSight.
-
Migrating data from QuickBooks to Databricks using CData SSIS Components.
Easily push QuickBooks Desktop to Databricks using the CData SSIS Tasks for QuickBooks and Databricks.
-
Analyze EnterpriseDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze EnterpriseDB with the CData JDBC Driver for EnterpriseDB.
-
Use the CData Software JDBC Driver for Helpscout in MicroStrategy Desktop
Connect to Helpscout in MicroStrategy Desktop using the CData Software JDBC Driver for Helpscout.
-
Build AI/ML Models with Live Amazon DynamoDB Data using Dataiku
Connect Amazon DynamoDB Data with Dataiku using the CData JDBC Driver for Amazon DynamoDB.
-
Create Power BI Reports on Real-Time Twitter Ads Data
Use the CData ODBC Driver for Twitter Ads to visualize Twitter Ads in Power BI Desktop.
-
Migrating data from BigCommerce to Databricks using CData SSIS Components.
Easily push BigCommerce to Databricks using the CData SSIS Tasks for BigCommerce and Databricks.
-
Build Data Flows from MYOB AccountRight to SQL Server using SSIS
Easily back up MYOB AccountRight to SQL Server using the SSIS components for MYOB AccountRight.
-
Automated Continuous Clari Replication to SQLite
Use CData Sync for automated, continuous, customizable Clari replication to SQLite.
-
Analyze Office 365 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Office 365 and visualize live Microsoft Office 365 in Infragistics Reveal.
-
Integrating Gumloop with OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on OData within automated workflows.
-
How to Design Xero Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Xero from mobile and tablet Power Apps.
-
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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZohoInvoice
Provide connectivity to ZohoInvoice through an SAP BusinessObjects universe.
-
Automate Bugsnag Data Replication to Azure Data Lake
Use CData Sync to customize and automate Bugsnag replication to Azure Data Lake.
-
Integrating Antigravity CLI with PolarTeamPro via CData CLI
Connect PolarTeamPro to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Elorus Data in Sisense
Create an ElastiCube in Sisense app with access to Elorus.
-
Integrate with Exact Online Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Exact Online in SnapLogic.
-
How to Create Power BI Visual Reports with Real-Time LinkedIn Data
Use CData Power BI Connectors to visualize LinkedIn in Power BI.
-
A PostgreSQL Interface for Instantly Data using the CData ODBC Driver
Use the SQL Gateway and Instantly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Teamgate Data in Pentaho Data Integration
Build ETL pipelines based on Teamgate in the Pentaho Data Integration tool.
-
Connect EnterpriseDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect EnterpriseDB with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to & Open Google Directory Data in Microsoft Excel
This article uses the CData ODBC driver for Google Directory to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live SharePoint 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 Microsoft SharePoint through MCP integration.
-
Use Azure AI Foundry to Talk to Your Power BI XMLA 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 Power BI XMLA for you.
-
Build Voice Agents in ElevenLabs with access to Live Oracle Financials Cloud Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle Financials Cloud.
-
Explore Geographical Relationships in Teradata Data with Power Map
Create data visualizations with Teradata in Power Map.
-
Automate Zoom Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoom replication to Azure Synapse.
-
Integrating Cursor CLI with TaxJar 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.
-
Provide OData Services of Bitbucket Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Bitbucket by developing a WCF Service Application.
-
How to Query Lakebase Data in MySQL Workbench
Execute MySQL queries against live Lakebase from MySQL Workbench.
-
Connect to Oracle Eloqua Data from a Connection Pool in JBoss
Integrate Oracle Eloqua into Java servlets: Use the Management Console in JBoss to install the Oracle Eloqua JDBC Driver.
-
Connect to GitHub Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for GitHub in Airbyte.
-
How to Create Power BI Visual Reports with Real-Time SuiteCRM Data
Use CData Power BI Connectors to visualize SuiteCRM in Power BI.
-
Visualize Live QuickBooks Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live QuickBooks Desktop.
-
Process & Analyze Grafana Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Grafana Data.
-
Bidirectional Access to LDAP Objects from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LDAP in Filemaker Pro for Mac or Windows.
-
Automated Continuous Cloudant Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Cloudant replication to Azure SQL Database.
-
Integrate Live Zuora Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zuora from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zuora.
-
Flowlu Reporting in OBIEE with the Flowlu JDBC Driver
Deploy the Flowlu JDBC driver on OBIEE to provide real-time reporting across the enterprise.