CData Software - Knowledge Base
Recent Articles
-
Integrating Jira Data in Talend Cloud Data Management Platform
Connect Jira Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Jira.
-
Connect to Clari Data in Aqua Data Studio
Access Clari from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize MYOB AccountRight Data in TIBCO Spotfire through OData
Integrate MYOB AccountRight into dashboards in TIBCO Spotfire.
-
Access ZohoMarketingHub Data from MySQL in Amazon QuickSight
Connect to ZohoMarketingHub and build visualizations of ZohoMarketingHub using a MySQL Connection in Amazon QuickSight.
-
Build Visualizations of PivotalTracker Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PivotalTracker in Birst.
-
Query Accelo Data as a MySQL Database in Node.js
Execute MySQL queries against Accelo from Node.js.
-
Build Apps with Live Shopify Data Using the Low-Code Development Platform of Mendix
Connect Shopify with Mendix to build apps using the CData JDBC Driver for Shopify.
-
How to Access Jira Assets Data Using Entity Framework
This article shows how to access Jira Assets using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Cloudant Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of IBM Cloudant and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Access Amazon DynamoDB Data Using Entity Framework
This article shows how to access Amazon DynamoDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Business One
Provide connectivity to SAP Business One through an SAP BusinessObjects universe.
-
Natively Connect to WooCommerce Data in PHP
The CData ODBC driver for WooCommerce enables you to create PHP applications with connectivity to WooCommerce. Leverage the native support for ODBC in PHP.
-
How to use SQLAlchemy ORM to access Zoho Projects Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Projects.
-
Connect to ConvertKit Data in CloverDX (formerly CloverETL)
Transfer ConvertKit using the visual workflow in the CloverDX data integration tool.
-
Access Live Salesforce 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 & Force.com through MCP integration.
-
How to create Visio diagrams from Oracle Eloqua Data
Automatically update Oracle Eloqua with the changes you make to Visio master shapes.
-
Automated Continuous MariaDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MariaDB replication to delimited files (CSV/TSV).
-
How to load Pingdom data into Elasticsearch via Logstash
Introducing a simple method to load Pingdom data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Stream Outlook Data into Apache Kafka Topics
Access and stream Outlook in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Load eBay Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load eBay to a database.
-
Connect Spark Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache Spark SQL using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for SendInBlue in MicroStrategy Web
Connect to SendInBlue in MicroStrategy Web using the CData Software JDBC Driver for SendInBlue.
-
Access Live Sendwithus Data in AWS Lambda
Connect to live Sendwithus in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Monday.com Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Monday.com.
-
How to use SQLAlchemy ORM to access Apollo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apollo.
-
Connect to Adobe Target in SpagoBI
Create reports featuring live Adobe Target in SpagoBI Studio. Host Adobe Target reports on SpagoBI Server.
-
Integrate Theia IDE with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Visualizations of SendGrid Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SendGrid in Birst.
-
Import Real-Time Shopify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Shopify in ColdFusion.
-
Create Facebook-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Facebook Data from OutSystems and build custom enterprise apps using live Facebook.
-
Build Dashboards with JotForm Data in DBxtra
Create dynamic dashboards and perform analytics based on JotForm in DBxtra.
-
Visualize Live Vertica Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Vertica into custom reports in Power BI.
-
A PostgreSQL Interface for Google Cloud Storage Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Cloud Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Add Miro Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Miro with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Pipelines with Live Sage Intacct Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sage Intacct from Google Cloud Data Fusion, enabling the integration of live Sage Intacct into the building and management of effective data pipelines.
-
Connect to Azure Data Lake Storage Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use Claude to Talk to Your Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Facebook for you.
-
Analyze Tally Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Tally ERP and visualize live Tally ERP in Infragistics Reveal.
-
How to publish and share DocuSign Data dashboards with Tableau Server
The CData ODBC driver for DocuSign enables you integrate DocuSign into Tableau dashboards.
-
Design BIRT Reports on Spotify Data
Provide current Spotify to your embedded analytics.
-
Automated Continuous MongoDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable MongoDB replication to Snowflake.
-
Connect to Vault CRM Data in DBArtisan
Use wizards in DBArtisan to configure Veeva Vault & Vault CRM as a data source.
-
Create Informatica Mappings From/To an ODBC Data Source for OneNote
Create an ODBC connection to OneNote in Informatica and browse and transfer Microsoft OneNote.
-
Access Live Acumatica Data in Coginiti Pro
Connect to and query live Acumatica ERP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize MariaDB Data in Sisense
Create an ElastiCube in Sisense app with access to MariaDB.
-
Create SSAS Tabular Models from ConvertAPI Data
How to build a SQL Server Analysis Service Tabular Model from ConvertAPI using CData drivers.
-
Bidirectional Access to Bitbucket Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bitbucket in Filemaker Pro for Mac or Windows.
-
Create Data Visualizations in Cognos BI with Presto Data
Access Presto as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Real-Time Google Campaign Manager 360 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Campaign Manager 360 in ColdFusion.
-
Integrating OpenCode Terminal with Salesforce Marketing 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 PhantomBuster Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PhantomBuster in Microsoft R Open.
-
Building a JDBC-based MCP Server: A Developer Guide
This guide explains the architecture, design, and purpose of the MCP Server for JDBC Drivers project.
-
How to Connect to Live Greenplum 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 Pivotal GreenPlum for you.
-
Build Semantic Layer Views for Azure Data Catalog Data in APOS Live Data Gateway
Use the CData Connector for Azure Data Catalog in APOS Live Data Gateway to build Semantic Layer Views for Azure Data Catalog.
-
Object-Relational Mapping (ORM) with Phoenix 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 Apache Phoenix into a Java-based ORM framework, Hibernate.
-
Trigger Freshdesk IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Freshdesk with standard wizards in Logic Apps.
-
Load Attio Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Attio to a database.
-
Natively Connect to GetResponse Data in PHP
The CData ODBC driver for GetResponse enables you to create PHP applications with connectivity to GetResponse. Leverage the native support for ODBC in PHP.
-
Replicate Sage 200 Data to Multiple Databases
Replicate Sage 200 to disparate databases with a point-and-click configuration.
-
Connect to Dynamics 365 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Dynamics 365 from Filemaker Pro on Mac.
-
How to publish and share Postmark Data dashboards with Tableau Server
The CData ODBC driver for Postmark enables you integrate Postmark into Tableau dashboards.
-
Automated Continuous Supabase Replication to SQLite
Use CData Sync for automated, continuous, customizable Supabase replication to SQLite.
-
Replicate Salesforce CRM Analytics Data to Multiple Databases via the CData Sync CLI
Replicate Salesforce CRM Analytics to disparate databases with a single configuration.
-
Build Visualizations of PagerDuty Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PagerDuty in Birst.
-
How to connect to Databricks Data with Squirrel SQL client
Connect to Databricks and execute queries in the Squirrel SQL Client.
-
Build Excel Online-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Excel Online to explore live Excel Online Data in Claude Code to assist with building Excel Online-powered applications.
-
Connect to Sage 200 from Asprova with CData Software ODBC Driver for Sage 200
This article shows how to connect faster to Sage 200 data from Asprova.
-
Getting Started with the CData ADO.NET Provider for Tanda
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Odoo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Odoo replication to AlloyDB.
-
Connect to Azure Synapse Data in NetBeans
Connect to Azure Synapse in NetBeans with the data source configuration wizard.
-
Access Live Google Contacts Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Contacts from your Google Sheets.
-
Connect to SendGrid Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SendGrid using standard SQL.
-
Replicate Multiple SAP Hybris C4C Accounts via the CData Sync CLI
Replicate multiple SAP Hybris C4C accounts to one or many databases.
-
Automate Shopify Data Replication to Couchbase
Use CData Sync to Customize and automate Shopify replication to Couchbase.
-
Build Agents in Relevance AI with Access to Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Adobe Analytics within intelligent agent workflows.
-
Create Zoom Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoom data access from reports, embedded analytics, and more.
-
Add MailChimp Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MailChimp with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query Live Reckon Accounts Hosted 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 Reckon Accounts Hosted directly from the development environment.
-
How to Access Simplesat Data Using Entity Framework
This article shows how to access Simplesat using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
DataBind Controls to SAP Business Warehouse Data in Delphi
DataBind to SAP Business Warehouse in Delphi with standard data access components and controls.
-
Getting Started with the CData Excel Add-In for FreshBooks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for FreshBooks.
-
Integrate Real-Time Access to Google Ad Manager in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Ad Manager in real time.
-
How to connect to Phoenix Data with Squirrel SQL client
Connect to Apache Phoenix and execute queries in the Squirrel SQL Client.
-
Build Charts with Cvent Data in Clear Analytics
Create dynamic charts and perform analytics based on Cvent in Clear Analytics.
-
Analyze Monday.com Data in Looker
Use CData Connect AI to connect to Monday.com Data from Looker and build custom apps using live Monday.com.
-
Getting Started with the CData ADO.NET Provider for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP BusinessObjects BI.
-
Access Live Zoho Books Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Books data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to connect PolyBase to ShipStation
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ShipStation.
-
Migrating data from Oracle Service Cloud to Databricks using CData SSIS Components.
Easily push Oracle Service Cloud to Databricks using the CData SSIS Tasks for Oracle Service Cloud and Databricks.
-
Query, Visualize, and Share live SAP Ariba Source Data in Redash
Use CData Connect AI to connect to live SAP Ariba Source in Redash for querying, visualizing, and sharing.
-
Access Mocean Data from MySQL in PHP
Connect to Mocean through the standard MySQL libraries in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Spark
Provide connectivity to Apache Spark SQL through an SAP BusinessObjects universe.
-
Import Real-Time SAP SuccessFactors Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP SuccessFactors in ColdFusion.
-
Query SAS Data Sets Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAS Data Sets from Node.js.
-
Connect to Delighted Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Delighted as an External Source in Dremio.
-
Provide OData Services of Mouseflow Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Mouseflow by developing a WCF Service Application.
-
ETL SpaceX in Oracle Data Integrator
This article shows how to transfer SpaceX into a data warehouse using Oracle Data Integrator.
-
Connect to Microsoft Exchange Data in Jaspersoft Studio
Execute SQL to remote Microsoft Exchange in Jaspersoft Studio.
-
DataBind Controls to Marketo Data in C++Builder
DataBind to Marketo in C++Builder with standard components and controls.
-
Connect to Beeminder Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Beeminder to connect to Beeminder and execute queries in PowerBuilder.