CData Software - Knowledge Base
Recent Articles
-
Build Azure Synapse-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Synapse Data from Zoho Analytics and import live Azure Synapse.
-
LINQ to MarkLogic 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 MarkLogic Data Provider.
-
Connect to Confluence Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Atlassian Confluence in the Denodo Virtual DataPort Administrator.
-
Integrating Cursor CLI with SAP Concur 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.
-
Integrate Real-Time Access to Neo4J in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Neo4J in real time.
-
How to Create Power BI Visual Reports with Real-Time SAP Fieldglass Data
Use CData Power BI Connectors to visualize SAP Fieldglass in Power BI.
-
Access Live LDAP Objects in Coginiti Pro
Connect to and query live LDAP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Enable the Flowlu JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Flowlu.
-
Use the CData Software ODBC Driver for Stack Exchange in MicroStrategy Desktop
Connect to Stack Exchange in MicroStrategy Desktop using the CData Software ODBC Driver for Stack Exchange.
-
How to connect PolyBase to CockroachDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CockroachDB.
-
How to connect to RabbitMQ Data in DBVisualizer
Integrate RabbitMQ with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with BenchmarkEmail Data in JReport Designer
Create charts and reports based on BenchmarkEmail in JReport Designer.
-
Integrate Highrise Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Highrise CRM and integrate live Highrise CRM into your Power Automate tasks.
-
Connect to and Query Sage Cloud Accounting Data in QlikView over ODBC
Create data visualizations with Sage Business Cloud Accounting in QlikView.
-
Integrating Cursor CLI with CloudConvert 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.
-
How to Work with Elorus Data in AWS Glue Jobs Using JDBC
Connect to Elorus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Aweber in SAS for Real-Time Reporting and Analytics
Connect to real-time Aweber in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Aweber.
-
Connecting Mastra with DB2 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time IBM DB2, no replication required.
-
Integrating Codex CLI with Freshsales 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.
-
How to Create Power BI Visual Reports with Real-Time BenchmarkEmail Data
Use CData Power BI Connectors to visualize BenchmarkEmail in Power BI.
-
How to Access Reckon Accounts Hosted Data Using Entity Framework
This article shows how to access Reckon Accounts Hosted using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Work with Live GitHub Data in Power Query
Use CData Connect AI to connect to GitHub and work with live GitHub in Microsoft Power Query.
-
Access Freshservice Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Freshservice from your Oracle system.
-
Connect to Authorize.Net from Asprova with CData Software ODBC Driver for Authorize.Net
This article shows how to connect faster to Authorize.Net data from Asprova.
-
Use the CData ODBC Driver for Aircall from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Aircall to connect to Aircall from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Aircall in Excel.
-
Build Dashboards with SAP Business Warehouse Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Business Warehouse in DBxtra.
-
Connect to Paddle Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Paddle to connect to Paddle and execute queries in PowerBuilder.
-
Connect to CockroachDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for CockroachDB in FileMaker Pro to connect to CockroachDB and work with CockroachDB in your FileMaker applications.
-
Connect to MariaDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MariaDB as an External Source in Dremio.
-
Automated Continuous HBase Replication to MySQL
Use CData Sync for automated, continuous, customizable HBase replication to MySQL.
-
Import Facebook Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Facebook Data and provide access to live Facebook for custom reports in the Power BI Service.
-
How to Access Live SAP BusinessObjects BI Data in Visual Studio Code via Cline
Run CData MCP Server for SAP BusinessObjects BI on Windows Subsytem for Linux (WSL) and connect to live SAP BusinessObjects BI from the Cline extension in Visual Studio Code.
-
Connect to FormSite Data in Ruby
Connect to FormSite in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect WooCommerce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live WooCommerce using the CData Python MCP Server.
-
How to create SQL Analysis Services federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SQL Analysis Services in MySQL .
-
Connect to Google Forms from Asprova with CData Software ODBC Driver for Google Forms
This article shows how to connect faster to Google Forms data from Asprova.
-
Automated Continuous Spark Replication to Vertica
Use CData Sync for automated, continuous, customizable Spark replication to Vertica.
-
Build Semantic Layer Views for Samanage Data in APOS Live Data Gateway
Use the CData Connector for Samanage in APOS Live Data Gateway to build Semantic Layer Views for Samanage.
-
Automated Continuous Impala Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Impala replication to AlloyDB.
-
Automated Continuous Hive Replication to SQLite
Use CData Sync for automated, continuous, customizable Hive replication to SQLite.
-
Use the CData Software JDBC Driver for Snapchat Ads in MicroStrategy Desktop
Connect to Snapchat Ads in MicroStrategy Desktop using the CData Software JDBC Driver for Snapchat Ads.
-
Publish Google Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Analytics.
-
Integrating Claude Code with Google Drive Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Drive within assisted coding and automated development workflows.
-
Analyze Adobe Commerce Data in Cognos Analytics
Use CData Connect AI to connect to Adobe Commerce Data from Cognos Analytics and analyze live Adobe Commerce.
-
Connect and Query Live Zoho CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoho CRM into Databricks
-
How to Connect to Azure Data Catalog Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Azure Data Catalog. Leverage the pyodbc module for ODBC in Python.
-
Prepare, Blend, and Analyze Microsoft Entra ID Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Entra ID for self-service data analytics.
-
How to Use a Microsoft Access Database to Update Oracle Eloqua Data in Real Time
Update Oracle Eloqua data by creating a linked table in Microsoft Access with the CData Oracle Eloqua ODBC Driver.
-
Use the CData Software ODBC Driver for Salesloft in MicroStrategy Web
Connect to Salesloft in MicroStrategy Web using the CData Software ODBC Driver for Salesloft.
-
Access Live Oracle Sales Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Sales from your Excel spreadsheets.
-
Integrate Cursor with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache Cassandra from within the editor.
-
Build MVC Applications with Connectivity to Rootly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Rootly from an ASP.NET MVC application.
-
Configure the CData JDBC Driver for ZarMoney in a Connection Pool in Tomcat
Connect to ZarMoney from a connection pool in Tomcat.
-
Automate SharePoint Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft SharePoint from PowerShell? This article demonstrates how to utilize the SharePoint Cmdlets for tasks like connecting to Microsoft SharePoint, automating operations, downloading data, and more.
-
Access Live SAP SuccessFactors 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 SAP SuccessFactors through MCP integration.
-
Integrating Antigravity CLI with Instagram via CData CLI
Connect Instagram to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with live Certinia Data in Jitterbit
Use CData Connect AI to connect to and integrate live Certinia in Jitterbit.
-
Connect to Zoho Projects Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoho Projects Data and connect to Zoho Projects in Akorbi Digital RunMyProcess.
-
Connect to Real-Time Google Spanner Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Spanner and Dataflow to import and use Google Spanner in Power Apps.
-
Create Datasets from Azure Table in Domo Workbench and Build Visualizations of Azure Table Data in Domo
Use the CData Software ODBC Driver for Azure Table to create datasets from Azure Table Storage in Domo Workbench and then build visualizations in the Domo service.
-
Access Live SageHR Data in AWS Lambda
Connect to live SageHR in AWS Lambda using the CData JDBC Driver.
-
How to Connect the Power BI Service to Teradata: Complete Guide
Connect to the CData Software Power BI Connector for Teradata from PowerBI.com to provide real-time Teradata across the organization.
-
How to publish and share Gorgias Data dashboards with Tableau Server
The CData ODBC driver for Gorgias enables you integrate Gorgias into Tableau dashboards.
-
Access Dynamics CRM Data from MySQL in PHP
Connect to Dynamics CRM through the standard MySQL libraries in PHP.
-
Connect to Oracle Service Cloud from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle Service Cloud to connect to Oracle Service Cloud from Web applications running on WebLogic.
-
How to connect SharePoint with QuickBooks Online Data through external lists
Provide QuickBooks Online to SharePoint users as an external list.
-
Connect to ConvertKit Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ConvertKit as an External Source in Dremio.
-
Automated Continuous Mailgun Replication to SQLite
Use CData Sync for automated, continuous, customizable Mailgun replication to SQLite.
-
Getting Started with the CData Excel Add-In for Highrise
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Highrise.
-
Use Biml to Build SSIS Tasks to Replicate Aweber Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Aweber to SQL Server.
-
Choosing the Best Method to Connect Factorial to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Factorial from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Stack Exchange Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Stack Exchange to a chart.
-
Publish Azure Data Lake Storage-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Data Lake Storage.
-
Integrating Cursor CLI with ConvertKit 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.
-
Integrate Excel Online Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Excel Online from Informatica Cloud.
-
Add AlloyDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for AlloyDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Process & Analyze ZohoInvoice Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoInvoice Data.
-
Build Kintone-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Kintone to explore live Kintone Data in Claude Code to assist with building Kintone-powered applications.
-
Access ZarMoney Data from MySQL in Amazon QuickSight
Connect to ZarMoney and build visualizations of ZarMoney using a MySQL Connection in Amazon QuickSight.
-
DataBind Controls to Oracle Financials Cloud Data in Delphi
DataBind to Oracle Financials Cloud in Delphi with standard data access components and controls.
-
Automated Continuous Slack Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Slack replication to OneLake in Microsoft Fabric.
-
Connect to Basecamp Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Basecamp.
-
How to connect to Databricks Data from IntelliJ
Integrate connectivity to Databricks with wizards in IntelliJ.
-
How to create Dynamics NAV federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dynamics NAV in MySQL .
-
Object-Relational Mapping (ORM) with Mistral AI 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 Mistral AI into a Java-based ORM framework, Hibernate.
-
Build Apps with Live Humanity Data Using the Low-Code Development Platform of Mendix
Connect Humanity with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating Cursor CLI with Elasticsearch 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 Live Google Search Results in SAS Viya
Use CData Connect AI to connect to Google Search from SAS Viya and deploy self-service analytics using live Google Search.
-
Publish LeadDesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live LeadDesk.
-
Connecting GenSpark with SendGrid Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SendGrid without any replication or custom integration required.
-
Connect to Azure Analysis Services Data in JRuby
Create a simple JRuby app with access to live Azure Analysis Services.
-
Viewing Invoiced Data in RAD Studio Data Explorer
How to view Invoiced in RAD Studio Data Explorer using the CData ODBC Driver for Invoiced.
-
Automated Continuous Todoist Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Todoist replication to Google BigQuery.
-
Getting Started with the CData SSIS Components for Guru
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Guru.
-
Work with AdRoll Data in FoxPro
Load AdRoll into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate JSON Services in the Pentaho Report Designer
Publish reports based on JSON in the Pentaho BI tool.
-
Feed ShipStation Data into FineReport
How to set ShipStation as a JDBC data source in FineReport.
-
Enable the Redshift JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amazon Redshift.
-
DataBind Charts to AdRoll Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to AdRoll from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Publish MySQL-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MySQL.