CData Software - Knowledge Base
Recent Articles
-
Import ShipStation Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ShipStation Data and provide access to live ShipStation data for custom reports in the Power BI Service.
-
Use JayDeBeApi to access QuickBooks Data in Python
Use standard Python scripting and the development environment of your choice to access live QuickBooks data.
-
Integrate Kafka with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Kafka with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Kafka data.
-
Visualize Live Printful Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Printful data.
-
Comprehensive Workday Connectivity through Workday WQL and Reports-as-a-Service
Walk through CData’s comprehensive workday connectivity and learn to configure your Workday instance to provide access to Workday Reports-as-a-Service.
-
Connect to Mailgun Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mailgun data in the Denodo Virtual DataPort Administrator.
-
Connect to Epicor Kinetic Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Epicor Kinetic data.
-
Import PingOne Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to PingOne Data and provide access to live PingOne data for custom reports in the Power BI Service.
-
How to Access MongoDB Data Using Entity Framework
This article shows how to access MongoDB data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Shortcut Data in Heroku for Use in Salesforce Connect
Replicate Shortcut data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
RSS Feeds Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to RSS feeds through CData Connect AI using different applications and tools.
-
Bridge Microsoft OneDrive Connectivity with Apache NiFi
Access and process Microsoft OneDrive data in Apache NiFi using the CData JDBC Driver.
-
Analyze Bannerbear Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bannerbear data with the CData JDBC Driver for Bannerbear.
-
Build AI/ML Models with Live Excel Data using Dataiku
Connect Excel Data with Dataiku using the CData JDBC Driver for Excel.
-
Integrate HDFS Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HDFS data from Informatica Cloud.
-
Create Power BI Reports on Real-Time iContact Data
Use the CData ODBC Driver for iContact to visualize iContact data in Power BI Desktop.
-
Integrate with Microsoft Exchange Data in JReport Designer
Create charts and reports based on Microsoft Exchange data in JReport Designer.
-
Use Agno to Talk to Your Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Salesforce CRM Analytics data for you.
-
Create SSAS Tabular Models from Office 365 Data
How to build a SQL Server Analysis Service Tabular Model from Office 365 data using CData drivers.
-
Create Datasets from JobNimbus in Domo Workbench and Build Visualizations of JobNimbus Data in Domo
Use the CData Software ODBC Driver for JobNimbus to create datasets from JobNimbus data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Samanage Data in HULFT Integrate
Connect to Samanage as a JDBC data source in HULFT Integrate
-
Access SQL Server Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SQL Server data from your Oracle system.
-
Build Google Cloud Storage-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Cloud Storage data.
-
Build Dashboards with FormSite Data in DBxtra
Create dynamic dashboards and perform analytics based on FormSite data in DBxtra.
-
Using the CData Software ODBC Driver for Oracle Sales in PyCharm
Connect to Oracle Sales as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Sales.
-
Visualize Epicor Kinetic Data in Tableau
The CData ODBC driver for Epicor Kinetic enables you integrate Epicor Kinetic data into Tableau dashboards.
-
Visualize Adobe Target Data in Tableau
The CData ODBC driver for Adobe Target enables you integrate Adobe Target data into Tableau dashboards.
-
Connect to MessageBird 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 MessageBird and work with MessageBird data in your FileMaker application.
-
Build Automated SFTP-Connected Workflows in Zapier
Use CData Connect AI to connect to live SFTP data and build automated workflows in Zapier.
-
Visualize Live Gong Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Gong data into custom reports in Power BI.
-
Visualize MariaDB Data in Tableau
The CData ODBC driver for MariaDB enables you integrate MariaDB data into Tableau dashboards.
-
Automated Continuous xBase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable xBase replication to Apache Kafka.
-
Automated Continuous PostgreSQL Replication to Databricks
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Databricks.
-
Access SharePoint Excel Services 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 SharePoint Excel Services data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CapsuleCRM
Provide connectivity to CapsuleCRM data through an SAP BusinessObjects universe.
-
ElevenLabs Reporting in OBIEE with the ElevenLabs JDBC Driver
Deploy the ElevenLabs JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Opsgenie Data in DataGrip
Create a Data Source for Opsgenie in DataGrip and use SQL to query live Opsgenie data.
-
Publish Crystal Reports on Recurly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Recurly data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Smartsheet
Provide connectivity to Smartsheet data through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Jodoo in MicroStrategy Desktop
Connect to Jodoo data in MicroStrategy Desktop using the CData Software ODBC Driver for Jodoo.
-
Connect and Visualize Live Confluence Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Confluence data into the Databricks platform and create visualization dashboards with real-time Confluence data.
-
Integrate with live ZohoMarketingHub Data in Jitterbit
Use CData Connect AI to connect to and integrate live ZohoMarketingHub data in Jitterbit.
-
Build Charts with Aweber Data in Clear Analytics
Create dynamic charts and perform analytics based on Aweber data in Clear Analytics.
-
Bridge Reckon Accounts Hosted Connectivity with Apache NiFi
Access and process Reckon Accounts Hosted data in Apache NiFi using the CData JDBC Driver.
-
How to Easily Query Front Data in OpenOffice Base
Connect to Front data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Zuora Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zuora from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Google Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Ads data and integrate live Google Ads data into apps built in Microsoft Power Apps.
-
Automate Reckon Accounts Hosted Data Replication to Azure Synapse
Use CData Sync to customize and automate Reckon Accounts Hosted data replication to Azure Synapse.
-
Access Live Blackbaud FE NXT Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Blackbaud FE NXT data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Building Dynamic Web Pages with SFTP Data Using AngularJS
Create single-page applications with live connectivity to SFTP using the CData API Server.
-
Prepare, Blend, and Analyze Coda Data in Alteryx Designer (Connect AI)
Build workflows to access live Coda data for self-service data analytics.
-
Connect to Zoho Projects Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoho Projects data in Airbyte.
-
Work with Live Vertica Data in Power Query
Use CData Connect AI to connect to Vertica data and work with live Vertica data in Microsoft Power Query.
-
Connect to Wrike Data in JRuby
Create a simple JRuby app with access to live Wrike data.
-
How to Easily Query Airtable Data in OpenOffice Base
Connect to Airtable data in OpenOffice Base using the CData ODBC Driver for Airtable and generate reports with live data insights.
-
Integrating LangChain with Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Avro data within automated workflows.
-
Query Splunk Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Splunk entities in PHP by modeling them as objects.
-
DataBind Charts to Grafana Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Grafana data 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.
-
Use Grok to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Salesforce Pardot data for you.
-
How to import Suadeo Data into Apache Solr
Use the CData Software JDBC Driver for Suadeo in Data Import Handler and create an automated import of Suadeo data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData JDBC Driver for SAP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP.
-
How to Connect to Live Vertica Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Vertica data for you.
-
Integrate Google Analytics Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Analytics data and integrate live Google Analytics data into your Power Automate tasks.
-
Integrating OpenCode with Kintone 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.
-
Connecting Pipedream with BenchmarkEmail 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 BenchmarkEmail data in real time.
-
How to Work with OpenWeatherMap Data in ETL Validator JDBC
Connect to OpenWeatherMap from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Dynamic Supabase Grids Using the Infragistics XamDataGrid
Learn how you can connect Supabase to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software JDBC Driver for Excel in MicroStrategy Desktop
Connect to Excel data in MicroStrategy Desktop using the CData Software JDBC Driver for Excel.
-
Connect to HCL Domino Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HCL Domino to connect to HCL Domino data and execute queries in PowerBuilder.
-
Access Live Greenplum Data in Coginiti Pro
Connect to and query live Greenplum data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to use SQLAlchemy ORM to access DocuSign Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of DocuSign data.
-
Use the CData Software JDBC Driver for Spotify in MicroStrategy Web
Connect to Spotify data in MicroStrategy Web using the CData Software JDBC Driver for Spotify.
-
SparkPost Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SparkPost facts in real time.
-
Integrate Trae with Live Salesforce CRM Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Salesforce CRM Analytics data from within the AI-powered IDE.
-
How to Connect to Live Amazon Marketplace Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Amazon Marketplace data for you.
-
Build Visualizations of Rootly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Rootly data in Birst.
-
Create Datasets from Coda in Domo Workbench and Build Visualizations of Coda Data in Domo
Use the CData Software ODBC Driver for Coda to create datasets from Coda data in Domo Workbench and then build visualizations in the Domo service.
-
Snapchat Ads Reporting in OBIEE with the Snapchat Ads JDBC Driver
Deploy the Snapchat Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Apps from Bullhorn CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Bullhorn CRM Data and build apps from live Bullhorn CRM data in Qlik Sense Cloud.
-
Query SAP HANA XS Advanced Data as a MySQL Database in Node.js
Execute MySQL queries against SAP HANA XS Advanced data from Node.js.
-
How to Work with Bright Data Data in AWS Glue Jobs Using JDBC
Connect to Bright Data from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
DataBind Charts to Contentful Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Contentful data 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.
-
How to Create Power BI Visual Reports with Real-Time Freshservice Data
Use CData Power BI Connectors to visualize Freshservice data in Power BI.
-
Query Square Data as a SQL Server Database in Node.js
Execute SQL Server queries against Square data from Node.js.
-
Connect to Oracle Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle and the SQL Gateway to access Oracle data from Google Apps Script.
-
Integrate SAP BusinessObjects BI with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP BusinessObjects BI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP BusinessObjects BI data.
-
How to Easily Query Eventbrite Data in OpenOffice Base
Connect to Eventbrite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automate FHIR Data Replication to Azure Data Lake
Use CData Sync to customize and automate FHIR data replication to Azure Data Lake.
-
Getting Started with the CData Excel Add-In for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Ad Manager.
-
Deploy the ADO.NET Provider for Azure DevOps on an SSRS Report Server
Connect to Azure DevOps 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.
-
Operational Reporting on Reckon Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Reckon data.
-
How to Access Live Recurly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Recurly enables you to integrate Recurly data into workflows built using Microsoft Power Automate Desktop.
-
Create Data Visualizations in Cognos BI with Mistral AI Data
Access Mistral AI data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to use SQLAlchemy ORM to access Kintone Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Kintone data.
-
Connect to Google Drive Data from a Connection Pool in Jetty
The Google Drive JDBC Driver supports connection pooling: This article shows how to connect faster to Google Drive data from Web apps in Jetty.
-
Integrate Live LaunchDarkly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LaunchDarkly data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate with Jira Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Jira data in SnapLogic.
-
How to use SQLAlchemy ORM to access PDFMonkey Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PDFMonkey data.
-
DataBind Charts to Guru Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Guru data 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.
-
Integrating GitHub Copilot with Twitter Ads 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.