CData Software - Knowledge Base
Recent Articles
-
How to use SQLAlchemy ORM to access Elorus Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Elorus.
-
Natively Connect to ADP Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ADP. Leverage the native support for ODBC in PHP.
-
Analyze Google Directory Data in Cognos Analytics
Use CData Connect AI to connect to Google Directory Data from Cognos Analytics and analyze live Google Directory.
-
Access HCL Domino Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HCL Domino from HeidiSQL.
-
Connect to SendInBlue Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SendInBlue in the Denodo Virtual DataPort Administrator.
-
Build Dashboards with Cloudant Data in DBxtra
Create dynamic dashboards and perform analytics based on IBM Cloudant in DBxtra.
-
Use Dash to Build to Web Apps on SAS Data Sets Data
Create Python applications that use pandas and Dash to build SAS Data Sets-connected web apps.
-
Create Data Visualizations in Cognos BI with YouTube Analytics Data
Access YouTube Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Avaza Data in ColdFusion
Write standard ColdFusion data access code to connect to Avaza.
-
How to Access Google Sheets Data Using Entity Framework
This article shows how to access Google Sheets using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Working with ConvertKit Data in LINQPad
Execute LINQ queries to ConvertKit in LINQPad.
-
Use the CData API Server to Access Microsoft Entra ID Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Entra ID in the Power Pivot business intelligence tool.
-
How to load Discord data into Elasticsearch via Logstash
Introducing a simple method to load Discord data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Query Live Databricks Data in Claude Desktop
Connect to and query live Databricks Data in Claude Desktop using CData MCP Server.
-
Integrating OpenCode Terminal with AgileCRM 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 Bright Data Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bright Data from HeidiSQL.
-
Getting Started with the CData ADO.NET Provider for CircleCI
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SharePoint Excel Services
Provide connectivity to SharePoint Excel Services through an SAP BusinessObjects universe.
-
Analyze QuickBooks Online Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of QuickBooks Online and visualize live QuickBooks Online in Infragistics Reveal.
-
How to Query Live Cloudant Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live IBM Cloudant data in natural language using Python.
-
Write a Simple Go Application to work with FreshBooks Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to FreshBooks.
-
Build WordPress-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live WordPress and build WordPress-connected web apps with Axios.
-
How to connect to Gorgias Data with Squirrel SQL client
Connect to Gorgias and execute queries in the Squirrel SQL Client.
-
Connect to SFTP Data in NetBeans
Connect to SFTP in NetBeans with the data source configuration wizard.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live IBM Cloud Object Storage using the Model Context Protocol.
-
Object-Relational Mapping (ORM) with Google Forms 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 Google Forms into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for Reply.io in SAS for Real-Time Reporting and Analytics
Connect to real-time Reply.io in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Reply.io.
-
Deploy the ADO.NET Provider for QuickBooks on an SSRS Report Server
Connect to QuickBooks Desktop from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Access Live Avro Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Avro enables you to integrate Apache Avro into workflows built using Microsoft Power Automate Desktop.
-
Build OData-Connected Apps in Choreo
Use CData Connect AI to connect to OData Services from Choreo and build custom apps using live OData.
-
Integrate SAP Business One Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Business One from Informatica Cloud.
-
How to connect Amazon QuickSight to OData Services
Create a connection to OData in CData Connect AI and insert OData into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData ODBC Driver for Figshare in Microsoft Power Query
You can use the CData Figshare ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Figshare into Microsoft Power Query.
-
Rapidly Develop Teradata-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 Teradata.
-
Integrate Live AlloyDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google AlloyDB to Blue Prism using the CData ODBC Driver for AlloyDB to create automated workflows for repetitive business tasks.
-
A PostgreSQL Interface for Unbounce Data (MySQL Remoting via JDBC)
Use the Remoting features of the Unbounce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Stream xBase Data into Apache Kafka Topics
Access and stream xBase in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
A PostgreSQL Interface for Avalara AvaTax Data (MySQL Remoting via JDBC)
Use the Remoting features of the Avalara AvaTax JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query, Visualize, and Share live Odoo Data in Redash
Use CData Connect AI to connect to live Odoo ERP in Redash for querying, visualizing, and sharing.
-
Replicate LaunchDarkly Data to Multiple Databases
Replicate LaunchDarkly to disparate databases with a point-and-click configuration.
-
Prepare, Blend, and Analyze Mailjet Data in Alteryx Designer (ODBC)
Build workflows to access live Mailjet for self-service data analytics.
-
Replicate Couchbase Data to Multiple Databases via the CData Sync CLI
Replicate Couchbase to disparate databases with a single configuration.
-
Object-Relational Mapping (ORM) with OnePageCrm 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 OnePageCrm into a Java-based ORM framework, Hibernate.
-
Connect to Beeminder from Asprova with CData Software ODBC Driver for Beeminder
This article shows how to connect faster to Beeminder data from Asprova.
-
Integrating Claude Code with Square Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Square within assisted coding and automated development workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Bright Data
Create an ODBC connection to Bright Data in Informatica and browse and transfer Bright Data.
-
Connect to Dynamics 365 Business Central Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Dynamics 365 Business Central from Filemaker Pro on Mac.
-
Connect and Visualize Live BigQuery Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google BigQuery into the Databricks platform and create visualization dashboards with real-time Google BigQuery.
-
How to Create Power BI Visual Reports with Real-Time Copper Data
Use CData Power BI Connectors to visualize Copper in Power BI.
-
DataBind Controls to Outlook Data in C++Builder
DataBind to Outlook in C++Builder with standard components and controls.
-
Paymo Reporting in OBIEE with the Paymo JDBC Driver
Deploy the Paymo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting Pipedream with Cloudant 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 Cloudant data in real time.
-
Automated Continuous Couchbase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Couchbase replication to Snowflake.
-
Build Freshservice-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Freshservice Data and create custom apps in Mendix.
-
Create EnterpriseDB-Connected Dashboards in Grafana
Connect to EnterpriseDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to EnterpriseDB.
-
Getting Started with the CData Connect AI Python SDK for Google Drive
Install the CData Connect AI Python SDK to read and write live Google Drive with standard DB-API 2.0 Python code.
-
Connect to Power BI XMLA Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Power BI XMLA and the Script function in FileMaker Pro to connect to Power BI XMLA and work with Power BI XMLA in your FileMaker application.
-
Integrate Theia IDE with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Easily Query Chargebee Data in OpenOffice Base
Connect to Chargebee data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live Apollo Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apollo from your Excel spreadsheets.
-
Automated Continuous ZohoExpense Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Vertica.
-
Visualize Quickbase 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 Quickbase into TIBCO Spotfire.
-
Process & Analyze PostgreSQL Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PostgreSQL Data.
-
Use the CData Software ODBC Driver for Salesloft in MicroStrategy Desktop
Connect to Salesloft in MicroStrategy Desktop using the CData Software ODBC Driver for Salesloft.
-
Build Azure DevOps Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Azure DevOps and build visualizations in Tableau.
-
Integrate Open WebUI with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Basecamp from within the chat interface.
-
Build Airtable Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Airtable and build visualizations in Tableau.
-
Salesforce Marketing Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce Marketing facts in real time.
-
Bridge Dynamics 365 Connectivity with Apache NiFi
Access and process Microsoft Dynamics 365 in Apache NiFi using the CData JDBC Driver.
-
Automate SageHR Data Replication to Couchbase
Use CData Sync to Customize and automate SageHR replication to Couchbase.
-
Work with Live Epicor Kinetic Data in Power Query
Use CData Connect AI to connect to Epicor Kinetic and work with live Epicor Kinetic in Microsoft Power Query.
-
Query SAS Data Sets Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAS Data Sets entities in PHP by modeling them as objects.
-
Access Live Reckon Accounts Hosted Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Reckon Accounts Hosted from your Excel spreadsheets.
-
Moving Data from Clockify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Clockify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate ConstantContact Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ConstantContact from Informatica Cloud.
-
Bind Live Oracle Sales Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Sales data
-
Integrating Codex CLI with Microsoft Entra ID 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.
-
Working with ServiceNow Data in LINQPad
Execute LINQ queries to ServiceNow in LINQPad.
-
Connect to Billsby Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Billsby to connect to Billsby and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Parallel in MicroStrategy
Connect to Parallel in MicroStrategy Developer using the CData Software ODBC Driver for Parallel.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Onfleet
Provide connectivity to Onfleet through an SAP BusinessObjects universe.
-
How to Connect ActiveCampaign Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live ActiveCampaign data in real time using natural language.
-
Extract, Transform, and Load SendPulse Data in Informatica PowerCenter
Create a simple Workflow for SendPulse in Informatica PowerCenter.
-
How to Access Database Data from an AI Client : CData API Server + MCP Server
A guide on using CData API Server to create an API for a database and MCP Server to access the database from an AI client (Claude Desktop).
-
Integrating LlamaIndex with Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on IBM Cloudant in real time.
-
Create SQL Analysis Services-Connected Applications in Appsmith
Connect to SQL Analysis Services Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SQL Analysis Services.
-
How to Connect the Power BI Service to Freshteam: Complete Guide
Connect to the CData Software Power BI Connector for Freshteam from PowerBI.com to provide real-time Freshteam across the organization.
-
Connect to Klaviyo Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Klaviyo in Airbyte.
-
How to Import Data from ServiceNow into Google Sheets
Import ServiceNow into a Google spreadsheet that is automatically refreshed.
-
Use the CData ODBC Driver for Google Sheets from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Sheets to connect to Google Sheets from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Sheets in Excel.
-
How to create Visio diagrams from MySQL Data
Automatically update MySQL with the changes you make to Visio master shapes.
-
Manage Sentry Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sentry.
-
Replicate Kafka Data to Multiple Databases
Replicate Apache Kafka to disparate databases with a point-and-click configuration.
-
How to Create Power BI Visual Reports with Real-Time Mocean Data
Use CData Power BI Connectors to visualize Mocean in Power BI.
-
ETL ElevenLabs in Oracle Data Integrator
This article shows how to transfer ElevenLabs into a data warehouse using Oracle Data Integrator.
-
Create Informatica Mappings From/To an ODBC Data Source for Gumroad
Create an ODBC connection to Gumroad in Informatica and browse and transfer Gumroad.
-
Build Apollo-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Apollo Data and create custom apps in Bubble.
-
Integrate SAP Fieldglass Data in the Pentaho Report Designer
Publish reports based on SAP Fieldglass in the Pentaho BI tool.
-
Visualize Missive Data in TIBCO Spotfire through ADO.NET
Integrate Missive into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Amazon Marketplace in MicroStrategy Desktop
Connect to Amazon Marketplace in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon Marketplace.