CData Software - Knowledge Base
Recent Articles
-
Connect to Xero Data in ACL Analytics
Connect to Xero data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Xero data.
-
Getting Started with the CData JDBC Driver for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle HCM Cloud.
-
How to Visualize SuiteCRM 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 SuiteCRM data in Python.
-
How to Connect to Live Vault CRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Vault CRM data securely in real time.
-
Replicate Templated Data to Multiple Databases via the CData Sync CLI
Replicate Templated data to disparate databases with a single configuration.
-
Create CouchDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CouchDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Paymo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Paymo data from HeidiSQL.
-
Connect to and Visualize Live Google Spanner Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Spanner data.
-
Use the CData ODBC Driver for Jumpseller in Microsoft Power Query
You can use the CData Jumpseller ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Jumpseller data into Microsoft Power Query.
-
Getting Started with the CData Tableau Connector for Azure Table
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure Table.
-
How to connect PolyBase to BigQuery
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live BigQuery data.
-
Automate Act CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Act CRM data from PowerShell? This article demonstrates how to utilize the Act CRM Cmdlets for tasks like connecting to Act CRM data, automating operations, downloading data, and more.
-
Integrate Grafana Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Grafana data and integrate live Grafana data into your Power Automate tasks.
-
Connect to Azure Table Data in JRuby
Create a simple JRuby app with access to live Azure Table data.
-
Connect to Zoom Data in NetBeans
Connect to Zoom data in NetBeans with the data source configuration wizard.
-
Automated Continuous Coinbase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Coinbase replication to Snowflake.
-
Automate Google Contacts Data Replication to Couchbase
Use CData Sync to Customize and automate Google Contacts data replication to Couchbase.
-
Create SAP SuccessFactors Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP SuccessFactors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Azure Table Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Table data.
-
Visualize Live Outlook Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Outlook data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Object-Relational Mapping (ORM) with Gorgias 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 Gorgias data into a Java-based ORM framework, Hibernate.
-
Query Live SAP Concur 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 SAP Concur data through a conversational interface.
-
Integrating LlamaIndex with SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Business Warehouse data in real time.
-
Create Data Visualizations in Cognos BI with Shippo Data
Access Shippo data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Samanage Data in Jaspersoft Studio
Execute SQL to remote Samanage data in Jaspersoft Studio.
-
Rapidly Develop Marketo-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 Marketo.
-
Use Claude to Talk to Your Campaigner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Campaigner data for you.
-
Deploy the ADO.NET Provider for Microsoft Entra ID on an SSRS Report Server
Connect to Microsoft Entra ID 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.
-
Connect to SAP Business Warehouse Data in NetBeans
Connect to SAP Business Warehouse data in NetBeans with the data source configuration wizard.
-
DataBind Controls to Front Data in Delphi
DataBind to Front data in Delphi with standard data access components and controls.
-
How to Visualize ADP 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 ADP data in Python.
-
Connect to PDFMonkey Data in RapidMiner
Integrate PDFMonkey data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Cursor with Wave Financial 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.
-
Visualize Live Adobe Commerce Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Commerce data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to ConvertKit
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ConvertKit data.
-
Bridge GitLab Connectivity with Apache NiFi
Access and process GitLab data in Apache NiFi using the CData JDBC Driver.
-
Publish Pinecone-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pinecone data.
-
Create Azure Table-Connected Dashboards in Grafana
Connect to Azure Table Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Table data.
-
Integrate SAP Business One Data in Pentaho Data Integration
Build ETL pipelines based on SAP Business One data in the Pentaho Data Integration tool.
-
How to Connect DBeaver to Confluence via a JDBC Driver
Manage Confluence data with visual tools in DBeaver like the query browser.
-
Integrate Blackbaud FE NXT with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Blackbaud FE NXT with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Blackbaud FE NXT data.
-
Connect to ClickUp Data in NetBeans
Connect to ClickUp data in NetBeans with the data source configuration wizard.
-
Access Live Redis Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Redis data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to and Query PolarTeamPro Data in QlikView over ODBC
Create data visualizations with PolarTeamPro data in QlikView.
-
Integrating Claude Code with Discord Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Discord data within assisted coding and automated development workflows.
-
How to Access Oracle HCM Cloud Data Using Entity Framework
This article shows how to access Oracle HCM Cloud data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Google Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Ads replication to Google BigQuery.
-
Create Power BI Reports on Real-Time Missive Data
Use the CData ODBC Driver for Missive to visualize Missive data in Power BI Desktop.
-
Visualize Live ZarMoney Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZarMoney data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Codex with Google Contacts 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.
-
Validate ChartMogul Data with QuerySurge
Access and validate ChartMogul data in QuerySurge using the CData JDBC Driver.
-
Integrating Dataiku with Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Timely data.
-
Connect to Bitly Data in RapidMiner
Integrate Bitly data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Create Power BI Visual Reports with Real-Time SingleStore Data
Use CData Power BI Connectors to visualize SingleStore data in Power BI.
-
Write a Simple Go Application to work with Elasticsearch Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Elasticsearch data.
-
How to publish and share Freshdesk Data dashboards with Tableau Server
The CData ODBC driver for Freshdesk enables you integrate Freshdesk data into Tableau dashboards.
-
Visualize Hugging Face 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 Hugging Face data into TIBCO Spotfire.
-
Consume Salesforce Marketing OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce Marketing feeds that reflect any changes in SAP Lumira.
-
Creating Raisers Edge NXT-Connected Applications in Unqork
You can use CData Connect AI to feed Raisers Edge NXT data to Unqork and build custom business apps.
-
VWO Reporting in OBIEE with the VWO JDBC Driver
Deploy the VWO JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a Simple VCL Application for BigCommerce Data
How to build a simple VCL Application to view BigCommerce data in RAD Studio using the CData ODBC Driver for BigCommerce.
-
Integrating LlamaIndex with Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Campaign Manager 360 data in real time.
-
How to connect to SAP SuccessFactors LMS Data from IntelliJ
Integrate connectivity to SAP SuccessFactors LMS data with wizards in IntelliJ.
-
Analyze Acumatica Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Acumatica data and visualize live Acumatica data in Infragistics Reveal.
-
Analyze FreshBooks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FreshBooks from Power Pivot. You will use the Table Import Wizard to load FreshBooks data. You can visually build the import query or use any SQL supported by the driver.
-
Deploy the ADO.NET Provider for Dotmailer on an SSRS Report Server
Connect to Dotmailer 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.
-
Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy Desktop
Connect to SAP Ariba Source data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Source.
-
Connect to Workable Data in RapidMiner
Integrate Workable data with standard components and data source configuration wizards in RapidMiner Studio.
-
LINQ to Authorize.Net 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 Authorize.Net Data Provider.
-
Connect to OneNote Data in Claris FileMaker Pro
Use the CData ODBC Driver for OneNote in FileMaker Pro to connect to OneNote and work with OneNote data in your FileMaker applications.
-
Automated Continuous Excel Online Replication to SingleStore
Use CData Sync for automated, continuous, customizable Excel Online replication to SingleStore.
-
How to use SQLAlchemy ORM to access HBase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HBase data.
-
Connect to OpenWeatherMap Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for OpenWeatherMap data in the Denodo Virtual DataPort Administrator.
-
Enable the Perplexity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Perplexity data.
-
Automated Continuous Highrise Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Highrise replication to Google BigQuery.
-
Analyze EnterpriseDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze EnterpriseDB data in Microsoft R Open.
-
Automated Continuous SpaceX Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SpaceX replication to delimited files (CSV/TSV).
-
Migrating data from Oracle Eloqua Reporting to Snowflake using CData SSIS Components.
Easily push Oracle Eloqua Reporting data to Snowflake using the CData SSIS Tasks for Oracle Eloqua Reporting and Snowflake.
-
Access Live Omnisend Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Omnisend data from your Google Sheets.
-
Perform Batch Operations with Paylocity Data in Apache NiFi
Connect to Paylocity data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Add Flowlu Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Flowlu with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Discourse Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Discourse replication to Apache Cassandra.
-
Automated Continuous Attio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Attio replication to Google BigQuery.
-
Visualize Typeform 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 Typeform data into TIBCO Spotfire.
-
Integrate Bullhorn CRM Data into Power Automate Desktop using CData Connect
CData Connect for Bullhorn CRM Data enables you to integrate Bullhorn CRM data into workflows built using Microsoft Power Automate Desktop.
-
Use Claude to Talk to Your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Freshservice data for you.
-
Replicate MYOB AccountRight Data from PowerShell
Write a quick PowerShell script to query MYOB AccountRight data. Use connectivity to the live data to replicate MYOB AccountRight data to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bitbucket
Provide connectivity to Bitbucket data through an SAP BusinessObjects universe.
-
Access Live SAP Data in TIBCO Data Virtualization
Use the SAP Tibco DV Adapter to create a SAP data data source in TIBCO Data Virtualization Studio and gain access to live SAP data from your TDV Server.
-
How to publish and share Apify Data dashboards with Tableau Server
The CData ODBC driver for Apify enables you integrate Apify data into Tableau dashboards.
-
Build Voice Agents in ElevenLabs with access to Live BambooHR Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live BambooHR data.
-
Connect to Real-Time Sybase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sybase and Dataflow to import and use Sybase data in Power Apps.
-
How to Build an ETL App for Oracle Eloqua Reporting Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Eloqua Reporting data in Python with petl.
-
Build Dashboards with Microsoft Entra ID Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Entra ID data in DBxtra.
-
Build AI/ML Models with Live Gong Data using Dataiku
Connect Gong Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to SAP Hybris C4C Data from IntelliJ
Integrate connectivity to SAP Hybris C4C data with wizards in IntelliJ.
-
Add Cassandra Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cassandra with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Impala-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Impala data.
-
Use Manus AI to Talk to Your SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SAP ByDesign data.
-
Automated Continuous Google Analytics Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Analytics replication to SQLite.