CData Software - Knowledge Base
Recent Articles
-
How to create Visio diagrams from PostgreSQL Data
Automatically update PostgreSQL with the changes you make to Visio master shapes.
-
Connect to Apollo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Apollo Data and connect to Apollo in Akorbi Digital RunMyProcess.
-
Replicate Datadog Data from PowerShell
Write a quick PowerShell script to query Datadog. Use connectivity to the live data to replicate Datadog to SQL Server.
-
Integrating Boomi Agentstudio with eBay Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to eBay, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Pipelines with Live Reckon Accounts Hosted Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Reckon Accounts Hosted from Google Cloud Data Fusion, enabling the integration of live Reckon Accounts Hosted into the building and management of effective data pipelines.
-
Build Dashboards with Google Sheets Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Sheets in Dundas BI.
-
Connect to Cosmos DB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Azure Cosmos DB from Filemaker Pro on Mac.
-
Integrating GitHub Copilot CLI with Reckon 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.
-
Automated Continuous Google Spanner Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Spanner replication to SQLite.
-
Analyze Klipfolio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Klipfolio from Power Pivot. You will use the Table Import Wizard to load Klipfolio. You can visually build the import query or use any SQL supported by the driver.
-
Design BIRT Reports on Invoiced Data
Provide current Invoiced to your embedded analytics.
-
Create Datasets from Teradata in Domo Workbench and Build Visualizations of Teradata Data in Domo
Use the CData Software ODBC Driver for Teradata to create datasets from Teradata in Domo Workbench and then build visualizations in the Domo service.
-
Automate SAS xpt Data Replication to Azure Synapse
Use CData Sync to customize and automate SAS XPORT replication to Azure Synapse.
-
Natively Connect to RabbitMQ Data in PHP
The CData ODBC driver for RabbitMQ enables you to create PHP applications with connectivity to RabbitMQ. Leverage the native support for ODBC in PHP.
-
Rapidly Develop Zoho Books-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 Zoho Books.
-
Integrate Live Google Cloud Storage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Cloud Storage to Blue Prism using the CData ODBC Driver for Google Cloud Storage to create automated workflows for repetitive business tasks.
-
Build Visualizations of Bannerbear Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bannerbear in Birst.
-
Getting Started with the CData Excel Add-In for LionDesk
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LionDesk.
-
Build a Simple VCL Application for AlloyDB Data
How to build a simple VCL Application to view Google AlloyDB in RAD Studio using the CData ODBC Driver for AlloyDB.
-
Use the CData Software ODBC Driver for Oracle SCM in MicroStrategy Desktop
Connect to Oracle SCM in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle SCM.
-
Getting Started with the CData Tableau Connector for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure DevOps.
-
Access Live WordPress Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live WordPress from your Excel spreadsheets.
-
How to integrate ConstantContact with Apache Airflow
Access and process ConstantContact in Apache Airflow using the CData JDBC Driver.
-
Excel Spreadsheet Automation on ActiveCampaign Data with the QUERY Formula
Pull data from ActiveCampaign, automate spreadsheets, and more with the QUERY formula.
-
Integrate with Zoho Projects Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho Projects in SnapLogic.
-
Integrate with DocuSign Data in SnapLogic
Use CData Connect AI to connect to and integrate with live DocuSign in SnapLogic.
-
Build ConstantContact-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ConstantContact and build web apps with connectivity to live ConstantContact.
-
How to Work with Microsoft Exchange Data in ETL Validator JDBC
Connect to Microsoft Exchange from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Email Replication to Databricks
Use CData Sync for automated, continuous, customizable Email replication to Databricks.
-
Connect to Real-Time Sybase IQ Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sybase IQ and Dataflow to import and use Sybase IQ in Power Apps.
-
Moving Data from Autopilot to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Autopilot data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Semantic Layer Views for Toggl Data in APOS Live Data Gateway
Use the CData Connector for Toggl in APOS Live Data Gateway to build Semantic Layer Views for Toggl.
-
Replicate Multiple ZarMoney Accounts
Replicate multiple ZarMoney accounts to one or many databases.
-
Create SparkPost Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SparkPost from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Real-Time PagerDuty Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PagerDuty in ColdFusion.
-
Integrate with Salesforce Data in JReport Designer
Create charts and reports based on Salesforce & Force.com in JReport Designer.
-
Automated Continuous Google Calendar Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Calendar replication to Vertica.
-
Query Live Salesforce Pardot 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 Salesforce Pardot directly from the development environment.
-
Automate Codat Data Replication to SAP HANA
Use CData Sync to customize and automate Codat replication to SAP HANA.
-
Operational Reporting on Teamgate Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Teamgate.
-
Build Cosmos DB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Cosmos DB.
-
Analyze Live Microsoft Dataverse Data in SAS Viya
Use CData Connect AI to connect to Microsoft Dataverse (CDS) from SAS Viya and deploy self-service analytics using live Microsoft Dataverse (CDS).
-
A PostgreSQL Interface for Kafka Data (MySQL Remoting via JDBC)
Use the Remoting features of the Kafka JDBC Driver to create a PostgreSQL entry-point for data access.
-
Model Power BI XMLA Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Power BI XMLA, enabling the direct import of real-time Power BI XMLA.
-
Build a Singer.io Tap for Sugar CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sugar CRM data using
-
Replicate Multiple Google Spanner Accounts via the CData Sync CLI
Replicate multiple Google Spanner accounts to one or many databases.
-
Validate Harvest Data with QuerySurge
Access and validate Harvest in QuerySurge using the CData JDBC Driver.
-
Create Power BI Reports on Real-Time JSON Services
Use the CData ODBC Driver for JSON to visualize JSON in Power BI Desktop.
-
Build Attio-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Attio Data in Cursor to assist with building Attio-powered applications.
-
Automated Continuous SAP ByDesign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to AlloyDB.
-
Automated Continuous Pipeline CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Google Cloud SQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Workable
Create Workable data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate HubDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HubDB with External Services.
-
Feed HubDB Data into FineReport
How to set HubDB as a JDBC data source in FineReport.
-
Getting Started with the CData JDBC Driver for Typeform
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Typeform.
-
Automated Continuous Shopify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Shopify replication to Google Cloud SQL.
-
Connect to Microsoft Teams Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Teams in Google Apps Script.
-
Enable the Pinterest JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pinterest.
-
How to use SQLAlchemy ORM to access ClickTime Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ClickTime.
-
Automated Continuous BenchmarkEmail Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Apache Cassandra.
-
Integrate Theia IDE with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating GitHub Copilot CLI with Rootly 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.
-
Integrating LangGraph with Oracle Sales Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Sales within automated workflows.
-
Build SpaceX-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live SpaceX Data in Claude Code to assist with building SpaceX-powered applications.
-
DataBind Controls to Productboard Data in Delphi
DataBind to Productboard in Delphi with standard data access components and controls.
-
Validate CockroachDB Data with QuerySurge
Access and validate CockroachDB in QuerySurge using the CData JDBC Driver.
-
DataBind SingleStore Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SingleStore with the DevExpress Windows Forms and Web controls to provide SingleStore to a chart.
-
How to load Oracle Eloqua data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Eloqua data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Square Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Square data access from reports, embedded analytics, and more.
-
Use the CData Software JDBC Driver for ActiveCampaign in MicroStrategy Desktop
Connect to ActiveCampaign in MicroStrategy Desktop using the CData Software JDBC Driver for ActiveCampaign.
-
Visualize Tickspot Data in TIBCO Spotfire through OData
Integrate Tickspot into dashboards in TIBCO Spotfire.
-
Prepare, Blend, and Analyze ADP Data in Alteryx Designer (ODBC)
Build workflows to access live ADP for self-service data analytics.
-
Publish Crystal Reports on MySQL Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MySQL.
-
Build an OLAP Cube in SSAS from Gmail Data
Establish a connection to Gmail data from SQL Server Analysis Services, and use the Gmail Data Provider to build OLAP cubes for use in analytics and reporting.
-
Back Up Workday to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Workday. In this article, we will employ an SSIS workflow to populate a database with Workday data.
-
Connect to and Visualize Live OneNote Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft OneNote.
-
Getting Started with the CData Tableau Connector for Freshservice
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData API Server to Access NASA Data in Microsoft PowerPivot
Use the CData API Server to connect to live NASA in the Power Pivot business intelligence tool.
-
Connect to Redshift Data in DBeaver
Use the CData ODBC Driver to connect to Amazon Redshift in DBeaver.
-
Integrate Cursor with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Inventory from within the editor.
-
HCL Domino REST API Part 4: Connecting from Tableau using CData Tableau Connector
The last article in an article series that goes over the HCL Domino REST API. This article is an overview and guide for the CData HCL Domino Drivers and Connectors.
-
Access Amazon DynamoDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon DynamoDB from your Oracle system.
-
Getting Started with the CData JDBC Driver for ConvertKit
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ConvertKit.
-
Automate Harvest Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Harvest and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Add Oracle Eloqua Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Eloqua with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with Live Microsoft Entra ID Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Entra ID from the MuleSoft Anypoint Platform to integrate live Microsoft Entra ID into custom reports and dashboards.
-
Integrate Live Avalara AvaTax Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build MVC Applications with Connectivity to Splunk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Splunk from an ASP.NET MVC application.
-
Configure the CData JDBC Driver for Adobe Analytics in a Connection Pool in Tomcat
Connect to Adobe Analytics from a connection pool in Tomcat.
-
Build Semantic Layer Views for Microsoft Entra ID Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Entra ID.
-
Build Automated Workflows with Live Active Directory Data in Workato
Use CData Connect AI to connect to live Active Directory and build automated workflows in Workato.
-
Automated Continuous SpaceX Replication to Oracle
Use CData Sync for automated, continuous, customizable SpaceX replication to Oracle.
-
Build MarkLogic-Connected Apps in Choreo
Use CData Connect AI to connect to MarkLogic Data from Choreo and build custom apps using live MarkLogic.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Suadeo to Power BI dashboards. Simply drag and drop Suadeo into data visuals on the Power BI canvas.
-
Integrate Cursor with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Shopify from within the editor.
-
How to Connect DBeaver to MessageBird via a JDBC Driver
Manage MessageBird with visual tools in DBeaver like the query browser.
-
A PostgreSQL Interface for QuickBooks Data (MySQL Remoting via JDBC)
Use the Remoting features of the QuickBooks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code CLI with CockroachDB 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.
-
Access Calendly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Calendly from your Oracle system.
-
Access Live LinkedIn Ads Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live LinkedIn Ads from your Excel spreadsheets.