CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code with Toggl Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Toggl data within assisted coding and automated development workflows.
-
Access Live Zendesk 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 Zendesk data through MCP integration.
-
Build Dashboards with PagerDuty Data in DBxtra
Create dynamic dashboards and perform analytics based on PagerDuty data in DBxtra.
-
Connect to Live Google Search Results in MicroStrategy through CData Connect AI
Create a live connection to Google Search Results in CData Connect AI and connect to your Google Search results from MicroStrategy.
-
How to connect PolyBase to Typeform
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Typeform data.
-
Viewing Exa Data in RAD Studio Data Explorer
How to view Exa data in RAD Studio Data Explorer using the CData ODBC Driver for Exa.
-
Connect to Blackbaud FE NXT Data in DBeaver
Use the CData ODBC Driver to connect to Blackbaud FE NXT data in DBeaver.
-
Import Real-Time CapsuleCRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CapsuleCRM data in ColdFusion.
-
How to Connect to Live PostgreSQL Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live PostgreSQL data without replication.
-
Access Live Oracle Eloqua Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Oracle Eloqua data through MCP integration.
-
Integrate Dify with Live Google Directory Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Directory data.
-
Connect to Intercom Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Intercom and work with Intercom data in your FileMaker application.
-
Integrate with iContact Data in JReport Designer
Create charts and reports based on iContact data in JReport Designer.
-
Integrating Claude Code CLI with Jodoo 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 Informatica Mappings From/To a JDBC Data Source for Quaderno
Create Quaderno data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
LINQ to Google Spanner 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 Google Spanner Data Provider.
-
Getting Started with the CData Power BI Connector for Gong
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Publish Crystal Reports on Productboard Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Productboard data.
-
Connect Redis Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Redis data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous OnePageCrm Replication to MongoDB
Use CData Sync for automated, continuous, customizable OnePageCrm replication to MongoDB.
-
Deploy the ADO.NET Provider for Dropbox on an SSRS Report Server
Connect to Dropbox data 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.
-
Connecting to Amazon DocumentDB with MongoDB Drivers
Set up an Amazon DocumentDB cluster and connect using any CData Software Driver for MongoDB.
-
Bridge Optimizely Connectivity with Apache NiFi
Access and process Optimizely data in Apache NiFi using the CData JDBC Driver.
-
Manage Productboard Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Productboard.
-
How to Work with Google Tasks Data in ETL Validator JDBC
Connect to Google Tasks from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Pingdom in MicroStrategy Desktop
Connect to Pingdom data in MicroStrategy Desktop using the CData Software JDBC Driver for Pingdom.
-
Integrate with Acumatica Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Acumatica data to a JSON file on disk.
-
Replicate Templated Data to Multiple Databases
Replicate Templated data to disparate databases with a point-and-click configuration.
-
Visualize Live Mailjet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mailjet data.
-
Connect to QuickBooks Data in Google Apps Script via Connect AI
Use CData Connect AI to access QuickBooks data in Google Apps Script.
-
Build Dashboards with SharePoint Data in Dundas BI
Create dynamic dashboards and perform analytics based on SharePoint data in Dundas BI.
-
Deploy the ADO.NET Provider for Nethunt on an SSRS Report Server
Connect to Nethunt data 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.
-
Integrate Kafka Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Kafka data and integrate live Kafka data into your Power Automate tasks.
-
How to Access Mailjet Data Using Entity Framework
This article shows how to access Mailjet data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to load Contentful data into Elasticsearch via Logstash
Introducing a simple method to load Contentful data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect and process Egnyte data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Egnyte data.
-
Integrating Claude Code CLI with Moosend 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.
-
Connect to Email Data in JRuby
Create a simple JRuby app with access to live Email data.
-
How to Visualize Coda Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Coda data in Python.
-
How to create SAP BusinessObjects BI federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP BusinessObjects BI data in MySQL .
-
Build Dashboards with Oracle Sales Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Sales data in Dundas BI.
-
Integrate Box Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Box data and integrate live Box data into your Power Automate tasks.
-
Build Data Flows from SQL Server to SAP Business One through SSIS
Easily push SQL Server data to SAP Business One using the CData SSIS Tasks for SAP Business One.
-
Access Amazon Athena Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Amazon Athena data.
-
Integrate Cursor with Live SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Business Warehouse data from within the editor.
-
Connect to Elasticsearch Data from AWS Glue
Use CData Connect AI to gain access to live Elasticsearch data from your AWS Glue jobs.
-
Visualize FreeAgent 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 FreeAgent data into TIBCO Spotfire.
-
Build Charts with Oracle Financials Cloud Data in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Financials Cloud data in Clear Analytics.
-
Prepare, Blend, and Analyze TigerGraph Data in Alteryx Designer (ODBC)
Build workflows to access live TigerGraph data for self-service data analytics.
-
Connect to SageHR Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SageHR data in the Denodo Virtual DataPort Administrator.
-
Publish Reports with Insightly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Insightly data.
-
Connect to Klaviyo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Klaviyo data in the Denodo Virtual DataPort Administrator.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce Data 360
Create Salesforce Data 360 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Aweber Data Using Entity Framework
This article shows how to access Aweber data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Data Flows from Salesforce to SQL Server using SSIS
Easily back up Salesforce data to SQL Server using the SSIS components for Salesforce.
-
Getting Started with the CData Python Connector for Amazon S3
Learn to install and license the CData Python Connector and configure a connection to live Amazon S3 data.
-
ETL SuiteCRM in Oracle Data Integrator
This article shows how to transfer SuiteCRM data into a data warehouse using Oracle Data Integrator.
-
How to Easily Query MYOB AccountRight Data in OpenOffice Base
Connect to MYOB AccountRight data in OpenOffice Base using the CData ODBC Driver for MYOB AccountRight and generate reports with live data insights.
-
Integrating OpenCode with Perigon 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.
-
Replicate Multiple ClickUp Accounts
Replicate multiple ClickUp accounts to one or many databases.
-
Viewing Avaza Data in RAD Studio Data Explorer
How to view Avaza data in RAD Studio Data Explorer using the CData ODBC Driver for Avaza.
-
Query Amazon Athena Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon Athena data from Node.js.
-
Microsoft Dataverse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft Dataverse facts in real time.
-
Build Data Flows from Square to SQL Server using SSIS
Easily back up Square data to SQL Server using the SSIS components for Square.
-
Automated Continuous Oracle Eloqua Reporting Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to MySQL.
-
Analyze LDAP Objects with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LDAP from Power Pivot. You will use the Table Import Wizard to load LDAP objects. You can visually build the import query or use any SQL supported by the driver.
-
SpaceX Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SpaceX facts in real time.
-
Query Live Presto Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Presto data through a conversational interface.
-
Connect to ConvertKit Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ConvertKit data.
-
Load eBay Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load eBay Analytics data to a database.
-
How to integrate LeadDesk with Apache Airflow
Access and process LeadDesk data in Apache Airflow using the CData JDBC Driver.
-
Connecting GenSpark with Oracle Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle data without any replication or custom integration required.
-
How to Access Live Qualaroo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Qualaroo enables you to integrate Qualaroo data into workflows built using Microsoft Power Automate Desktop.
-
Connecting Moonlit Workflow with Azure Table Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Azure Table data in real time.
-
Work with Adobe Experience Manager Data in FoxPro
Load Adobe Experience Manager data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Microsoft Exchange Data from MySQL in PHP
Connect to Microsoft Exchange through the standard MySQL libraries in PHP.
-
Stream Acumatica Data into Apache Kafka Topics
Access and stream Acumatica data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Manage iContact Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for iContact.
-
Integrate Devin with Live HubSpot Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live HubSpot data.
-
Use the CData Software JDBC Driver for Act CRM in MicroStrategy Desktop
Connect to Act CRM data in MicroStrategy Desktop using the CData Software JDBC Driver for Act CRM.
-
Rapidly Develop SparkPost-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 SparkPost.
-
How to Connect to Aircall Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Aircall data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Eventbrite Replication to SingleStore
Use CData Sync for automated, continuous, customizable Eventbrite replication to SingleStore.
-
How to Connect IBM Cloud Object Storage 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 IBM Cloud Object Storage data in real time using natural language.
-
Query Odoo Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Odoo entities in PHP by modeling them as objects.
-
Build Visualizations of Bitbucket Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bitbucket data in Birst.
-
Connect to Facebook Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Facebook Ads data using standard SQL.
-
Visualize Live Templated Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Templated data.
-
Build Dashboards with Google Ad Manager Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Ad Manager data in DBxtra.
-
Access Live Impala Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Impala data into the statistical analysis tools available in SAS JMP. This article shows how to use Impala data in the Graph Builder and Query Builder.
-
Use the CData Software JDBC Driver for Oracle SCM in MicroStrategy Web
Connect to Oracle SCM data in MicroStrategy Web using the CData Software JDBC Driver for Oracle SCM.
-
How to Work with Bitly Data in AWS Glue Jobs Using JDBC
Connect to Bitly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Suadeo Data in Talend Cloud Data Management Platform
Connect Suadeo Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Suadeo.
-
Build Bitbucket-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Bitbucket data.
-
Integrate Goose with Live Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Typeform data from within the local AI agent.
-
Create IBM Cloud Object Storage Dataflows on PowerBI.com
Connect to the CData Power BI Connector for IBM Cloud Object Storage from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access DocuSign Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live DocuSign data from HeidiSQL.
-
Create Greenhouse-Connected Dashboards in Grafana
Connect to Greenhouse Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Greenhouse data.
-
Integrating Claude Code CLI with Google Tasks 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.
-
View Reports on Real-Time Oracle Data in Power BI Report Server
Use the CData ODBC Driver for Oracle to visualize Oracle data in Power BI Desktop and then publish them to Power BI Report Server.