CData Software - Knowledge Base
Recent Articles
-
Access Sage Cloud Accounting Data from MySQL in Amazon QuickSight
Connect to Sage Cloud Accounting and build visualizations of Sage Business Cloud Accounting using a MySQL Connection in Amazon QuickSight.
-
Build Voice Agents in ElevenLabs with access to Live Apollo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apollo.
-
How to Connect to Live QuickBooks Time Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live QuickBooks Time without replication.
-
Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy Web
Connect to Google Campaign Manager 360 in MicroStrategy Web using the CData Software JDBC Driver for Google Campaign Manager 360.
-
Connect to Shippo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Postmark Data in Tableau
The CData ODBC driver for Postmark enables you integrate Postmark into Tableau dashboards.
-
Building Dynamic Web Pages with Vimeo Data Using AngularJS
Create single-page applications with live connectivity to Vimeo using the CData API Server.
-
Create OData-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to OData Services from Klipfolio and build custom visualizations using live OData.
-
Connect to Salesforce CRM Analytics Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Salesforce CRM Analytics.
-
Access Live SageHR Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SageHR data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Replicate eBay Data to Multiple Databases via the CData Sync CLI
Replicate eBay to disparate databases with a single configuration.
-
How to Create Power BI Visual Reports with Real-Time SAP Netweaver Gateway Data
Use CData Power BI Connectors to visualize SAP Netweaver Gateway in Power BI.
-
Build a PostgreSQL Interface for Google Directory Data using the CData JDBC Driver
Use the Remoting features of the Google Directory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate CloudConvert Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CloudConvert to SQL Server.
-
Build Dashboards with ZarMoney Data in DBxtra
Create dynamic dashboards and perform analytics based on ZarMoney in DBxtra.
-
Getting Started with the CData Excel Add-In for Quaderno
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Quaderno.
-
Build Visualizations of Stripe Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Stripe in Birst.
-
How to use SQLAlchemy ORM to access Postmark Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Postmark.
-
Integrate Open WebUI with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoho Inventory from within the chat interface.
-
How to Connect to Unbounce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Unbounce. Leverage the pyodbc module for ODBC in Python.
-
How to create an RPA flow for Elasticsearch Data in UiPath Studio
Use the Elasticsearch ODBC Driver to create workflows that access real-time Elasticsearch without any coding.
-
Build a PostgreSQL Interface for Bitbucket Data using the CData JDBC Driver
Use the Remoting features of the Bitbucket JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live GraphQL 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 GraphQL through natural language.
-
Automated Continuous ConvertKit Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ConvertKit replication to Google Cloud SQL.
-
How to Connect to Google Tasks Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Tasks. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Live Dynamics 365 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 Microsoft Dynamics 365 for you.
-
Automated Continuous Authorize.Net Replication to MySQL
Use CData Sync for automated, continuous, customizable Authorize.Net replication to MySQL.
-
Use the CData Software ODBC Driver for Helpscout in MicroStrategy Web
Connect to Helpscout in MicroStrategy Web using the CData Software ODBC Driver for Helpscout.
-
Create SurveyMonkey Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SurveyMonkey from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Jira Data in Pentaho Data Integration
Build ETL pipelines based on Atlassian Jira in the Pentaho Data Integration tool.
-
Build Confluence-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Confluence to explore live Confluence Data in Cursor to assist with building Confluence-powered applications.
-
Excel Spreadsheet Automation on Pipeline CRM Data with the QUERY Formula
Pull data from Pipeline CRM, automate spreadsheets, and more with the QUERY formula.
-
Extract, Transform, and Load Printful Data in Informatica PowerCenter
Create a simple Workflow for Printful in Informatica PowerCenter.
-
Automated Continuous Redis Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Redis replication to AlloyDB.
-
Replicate Multiple Azure Blob Storage Accounts
Replicate multiple Azure Blob Storage accounts to one or many databases.
-
How to Visualize ZohoMarketingHub Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoMarketingHub in Python.
-
Integrate ZohoPeople Data in Pentaho Data Integration
Build ETL pipelines based on ZohoPeople in the Pentaho Data Integration tool.
-
How to Connect DBeaver to CockroachDB via a JDBC Driver
Manage CockroachDB with visual tools in DBeaver like the query browser.
-
Rapidly Develop Jira-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 Jira.
-
Build HBase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apache HBase and build visualizations in Tableau Cloud.
-
Connect to Databricks Data from HeidiSQL
Use CData Connect AI to connect to and query live Databricks from HeidiSQL.
-
Build Semantic Layer Views for Phoenix Data in APOS Live Data Gateway
Use the CData Connector for Phoenix in APOS Live Data Gateway to build Semantic Layer Views for Apache Phoenix.
-
Import Real-Time Microsoft Teams Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Teams in ColdFusion.
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy Web
Connect to SAS Data Sets in MicroStrategy Web using the CData Software JDBC Driver for SAS Data Sets.
-
How to Import Data from Shopify into Google Sheets
Import Shopify into a Google spreadsheet that is automatically refreshed.
-
How to publish and share HCL Domino Data dashboards with Tableau Server
The CData ODBC driver for HCL Domino enables you integrate HCL Domino into Tableau dashboards.
-
Integrating Claude Code CLI with Email 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.
-
Build Semantic Layer Views for Presto Data in APOS Live Data Gateway
Use the CData Connector for Presto in APOS Live Data Gateway to build Semantic Layer Views for Presto.
-
Connect to Phoenix Data in RapidMiner
Integrate Apache Phoenix with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Sage 300 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sage 300 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sage 300.
-
Connect to Pipeliner CRM in SpagoBI
Create reports featuring live Pipeliner CRM in SpagoBI Studio. Host Pipeliner CRM reports on SpagoBI Server.
-
Object-Relational Mapping (ORM) with Sage Cloud Accounting 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 Sage Business Cloud Accounting into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for PingOne in MicroStrategy Desktop
Connect to PingOne in MicroStrategy Desktop using the CData Software ODBC Driver for PingOne.
-
How to import Superchat Data into Apache Solr
Use the CData Software JDBC Driver for Superchat in Data Import Handler and create an automated import of Superchat to Apache Solr Enterprise Search platform.
-
Publish SharePoint-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft SharePoint.
-
Getting Started with the CData Tableau Connector for Bannerbear
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with AlloyDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google AlloyDB to a JSON file on disk.
-
How to Connect Flowise AI Agents to Live Dynamics CRM 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 Microsoft Dynamics CRM without replication.
-
Using the CData Software ODBC Driver for Snapchat Ads in PyCharm
Connect to Snapchat Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for Snapchat Ads.
-
Access Live Facebook Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Facebook Ads from your Google Sheets.
-
Connect to Trello from Asprova with CData Software ODBC Driver for Trello
This article shows how to connect faster to Trello data from Asprova.
-
Automate Copper Data Replication to Couchbase
Use CData Sync to Customize and automate Copper replication to Couchbase.
-
Automated Continuous Reckon Accounts Hosted Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Azure SQL Database.
-
How to Work with Kintone Data in AWS Glue Jobs Using JDBC
Connect to Kintone from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Gmail Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Gmail Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to SharePoint Data in RazorSQL
Connect to SharePoint from wizards and query Microsoft SharePoint from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for JobNimbus in MicroStrategy Web
Connect to JobNimbus in MicroStrategy Web using the CData Software ODBC Driver for JobNimbus.
-
Access Live WordPress Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to WordPress from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating LangGraph with Jira Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Atlassian Jira within automated workflows.
-
Connect to Google Spanner Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Spanner to connect to Google Spanner and execute queries in PowerBuilder.
-
Connect to Parquet Data from a Connection Pool in Jetty
The Parquet JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Parquet from Web apps in Jetty.
-
Publish Reports with Stack Exchange Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stack Exchange.
-
Build Dashboards with FreshBooks Data in DBxtra
Create dynamic dashboards and perform analytics based on FreshBooks in DBxtra.
-
DataBind Controls to Sentry Data in Delphi
DataBind to Sentry in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Mode from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mode to connect to Mode from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mode in Excel.
-
Import Real-Time Google Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Analytics in ColdFusion.
-
Provide OData Services of SAP Netweaver Gateway Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Netweaver Gateway by developing a WCF Service Application.
-
Connect to Real-Time Bugsnag Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Bugsnag in Power Apps.
-
Connect to Short.io Data in Aqua Data Studio
Access Short.io from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect Microsoft Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Ads using the CData Python MCP Server.
-
Getting Started with the CData JDBC Driver for Campaigner
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Campaigner.
-
Integrate with Invoiced Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Invoiced to a JSON file on disk.
-
Connect to Beeminder Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Beeminder using standard SQL.
-
Access Live SAS xpt Data in Excel 365 Online (Excel for the web)
Connect to SAS XPORT from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for JobNimbus in SAS for Real-Time Reporting and Analytics
Connect to real-time JobNimbus in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for JobNimbus.
-
Bidirectional Access to Aha! Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Aha! in Filemaker Pro for Mac or Windows.
-
Visualize Live Splunk Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Splunk into custom reports in Power BI.
-
Automated Continuous Oracle Eloqua Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to delimited files (CSV/TSV).
-
Connect to Microsoft Exchange Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Exchange from Appeon PowerBuilder using the CData ADO.NET Provider for Exchange.
-
Process & Analyze Bugsnag Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bugsnag Data.
-
DataBind Controls to ConstantContact Data in Delphi
DataBind to ConstantContact in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time ChargeOver Data
Use CData Power BI Connectors to visualize ChargeOver in Power BI.
-
Connect to Azure Data Lake Storage Data from a Connection Pool in Jetty
The Azure Data Lake Storage JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Data Lake Storage from Web apps in Jetty.
-
How to create SAP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP ERP/NetWeaver in MySQL .
-
How to Design SFTP Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SFTP from mobile and tablet Power Apps.
-
Create Power BI Reports on Real-Time Anaplan Data
Use the CData ODBC Driver for Anaplan to visualize Anaplan in Power BI Desktop.
-
A PostgreSQL Interface for Salesforce Pardot Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Pardot ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Mode Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mode as an External Source in Dremio.
-
Automated Continuous Twilio Replication to Oracle
Use CData Sync for automated, continuous, customizable Twilio replication to Oracle.
-
Integrating Stripe Data in Talend Cloud Data Management Platform
Connect Stripe Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Stripe.