CData Software - Knowledge Base
Recent Articles
-
Connecting Agentforce with Google Directory Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google Directory data for you.
-
Design BIRT Reports on Omnisend Data
Provide current Omnisend data to your embedded analytics.
-
Add FreshBooks Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for FreshBooks with the Informatica Enterprise Data Catalog to classify and organize data.
-
View Reports on Real-Time Jumpseller Data in Power BI Report Server
Use the CData ODBC Driver for Jumpseller to visualize Jumpseller data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with Webex Data in DBxtra
Create dynamic dashboards and perform analytics based on Webex data in DBxtra.
-
A PostgreSQL Interface for SAP Business One Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Business One JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Avro Data in Python with CData Connect AI
Extract and transform live Avro data in Python with petl and the CData Connect AI Python SDK.
-
Create Azure Analysis Services-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Analysis Services Data from OutSystems and build custom enterprise apps using live Azure Analysis Services data.
-
Query Salesforce CRM Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Salesforce CRM Analytics data from Node.js.
-
Use the CData Software JDBC Driver for Missive in MicroStrategy Web
Connect to Missive data in MicroStrategy Web using the CData Software JDBC Driver for Missive.
-
Automated Continuous SageHR Replication to MySQL
Use CData Sync for automated, continuous, customizable SageHR replication to MySQL.
-
How to Create Power BI Visual Reports with Real-Time Adobe Target Data
Use CData Power BI Connectors to visualize Adobe Target data in Power BI.
-
Visualize PDFMonkey 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 PDFMonkey data into TIBCO Spotfire.
-
Integrating LlamaIndex with Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sage 200 data in real time.
-
How to Work with PagerDuty Data in ETL Validator JDBC
Connect to PagerDuty from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Browserless Replication to SQL Server
Use CData Sync for automated, continuous, customizable Browserless replication to SQL Server.
-
Build an OLAP Cube in SSAS from TaxJar Data
Establish a connection to TaxJar data data from SQL Server Analysis Services, and use the TaxJar Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build AI Agents with Freshservice Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Freshservice data through CData Connect AI.
-
Build Agents in Relevance AI with Access to Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Drive data within intelligent agent workflows.
-
Getting Started with the CData Python Connector for xBase
Learn to install and license the CData Python Connector and configure a connection to live xBase data.
-
Integrate Dify with Live Excel Online 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 Excel Online data.
-
Build Zendesk-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zendesk data and build web apps with connectivity to live Zendesk data.
-
Access Live GitHub Data in AWS Lambda
Connect to live GitHub data in AWS Lambda using the CData JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Highrise Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Highrise data for you.
-
Replicate Stack Exchange Data to Multiple Databases
Replicate Stack Exchange data to disparate databases with a point-and-click configuration.
-
Analyze Google Directory Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Directory data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Extract, Transform, and Load AdRoll Data in Informatica PowerCenter
Create a simple Workflow for AdRoll data in Informatica PowerCenter.
-
Connect to Adobe Target Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Adobe Target.
-
Visualize Spotify Data in Tableau
The CData ODBC driver for Spotify enables you integrate Spotify data into Tableau dashboards.
-
Build AI/ML Models with Live Blackbaud FE NXT Data using Dataiku
Connect Blackbaud FE NXT Data with Dataiku using the CData JDBC Driver for Blackbaud FE NXT.
-
Stream HCL Domino Data into Apache Kafka Topics
Access and stream HCL Domino data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Perplexity from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Perplexity data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Flowlu Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Flowlu from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Charts to SAS xpt Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAS xpt 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.
-
LINQ to Suadeo 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 Suadeo Data Provider.
-
Getting Started with the CData Excel Add-In for Dropbox
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dropbox.
-
Feed Procore Data into FineReport
How to set Procore data as a JDBC data source in FineReport.
-
Connect to CockroachDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live CockroachDB data.
-
Build MVC Applications with Connectivity to Azure Data Lake Storage Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Data Lake Storage from an ASP.NET MVC application.
-
How to integrate Metabase with Outreach.io Data
Use CData Connect AI to connect to live Outreach.io data and create an interactive dashboard in Metabase from Outreach.io data.
-
Query Clio Data in ColdFusion
Write standard ColdFusion data access code to connect to Clio data.
-
How to Visualize Figshare Data in Python with pandas
Use pandas and other modules to analyze and visualize live Figshare data in Python.
-
Integrate Cursor with Live SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Fieldglass data from within the editor.
-
Model, Search, and Visualize Live ShipStation Data in ThoughtSpot
Use CData Connect AI to connect to live ShipStation data for modeling, searching, and visualizing.
-
Automated Continuous Gumroad Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Gumroad replication to Google Cloud SQL.
-
How to Connect to & Open Zoho Creator Data in Microsoft Excel
This article uses the CData ODBC driver for Zoho Creator to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create a Data Access Object for Egnyte Data using JDBI
A brief overview of creating a SQL Object API for Egnyte data in JDBI.
-
Rapidly Develop Suadeo-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 Suadeo.
-
View Reports on Real-Time SendPulse Data in Power BI Report Server
Use the CData ODBC Driver for SendPulse to visualize SendPulse data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live Oracle Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Oracle data for you.
-
LINQ to CockroachDB 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 CockroachDB Data Provider.
-
Connect to Placid Data in NetBeans
Connect to Placid data in NetBeans with the data source configuration wizard.
-
Feed Bullhorn CRM Data into FineReport
How to set Bullhorn CRM data as a JDBC data source in FineReport.
-
How to connect PolyBase to Klipfolio
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Klipfolio data.
-
Use the CData Software ODBC Driver for ChargeOver in MicroStrategy
Connect to ChargeOver data in MicroStrategy Developer using the CData Software ODBC Driver for ChargeOver.
-
Integrate Google's Antigravity Agent with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Planner data using the Model Context Protocol.
-
Create Tickspot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tickspot data access from reports, embedded analytics, and more.
-
Integrate OpenCode with Live Zuora Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zuora data from within your AI coding agent.
-
Connect to Real-Time Apollo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Apollo data in Power Apps.
-
How to Access Live AgileCRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for AgileCRM enables you to integrate AgileCRM data into workflows built using Microsoft Power Automate Desktop.
-
Build Dashboards with Basecamp Data in DBxtra
Create dynamic dashboards and perform analytics based on Basecamp data in DBxtra.
-
Create Dashboards and Visualize Live SparkPost Data in Geckoboard
Use CData Connect AI to connect to live SparkPost data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData Tableau Connector for Jira Assets
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Jira Assets.
-
Connect to HDFS Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for HDFS data in Airbyte.
-
How to Connect to Live Microsoft Dataverse Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Dataverse data securely in real time.
-
Build Data Flows from Mailgun to SQL Server using SSIS
Easily back up Mailgun data to SQL Server using the SSIS components for Mailgun.
-
Automated Continuous Wistia Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Wistia replication to Amazon S3.
-
How to use SQLAlchemy ORM to access Power BI XMLA Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Power BI XMLA data.
-
How to Connect to Google Drive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Drive data. Leverage the pyodbc module for ODBC in Python.
-
Create SSAS Tabular Models from Tally Data
How to build a SQL Server Analysis Service Tabular Model from Tally data using CData drivers.
-
Access Live Bugsnag Data in Coginiti Pro
Connect to and query live Bugsnag data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData ODBC Driver for Slack from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Slack to connect to Slack data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Slack data in Excel.
-
Create Facebook Ads-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Facebook Ads Data from OutSystems and build custom enterprise apps using live Facebook Ads data.
-
Connect to Clari Data in Jaspersoft Studio
Execute SQL to remote Clari data in Jaspersoft Studio.
-
How to integrate Microsoft Entra ID with Apache Airflow
Access and process Microsoft Entra ID data in Apache Airflow using the CData JDBC Driver.
-
Connect to QuickBooks Data in JRuby
Create a simple JRuby app with access to live QuickBooks data.
-
DataBind Charts to SAP Netweaver Gateway Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Netweaver Gateway 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.
-
Create ServiceDesk Plus-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ServiceDesk Plus Data from Klipfolio and build custom visualizations using live ServiceDesk Plus data.
-
How to connect to Sage 300 Data from IntelliJ
Integrate connectivity to Sage 300 data with wizards in IntelliJ.
-
How to Connect to & Open Act CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Act CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dynamic Twitter Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Twitter Ads to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Spark Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Spark data.
-
Visualize HBase Data in Tableau
The CData ODBC driver for HBase enables you integrate HBase data into Tableau dashboards.
-
Connect Oracle Eloqua Reporting to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Eloqua Reporting data using the CData Python MCP Server.
-
Extract, Transform, and Load Excel Data in Informatica PowerCenter
Create a simple Workflow for Excel data in Informatica PowerCenter.
-
Automate Rebilly Data Replication to Azure Synapse
Use CData Sync to customize and automate Rebilly data replication to Azure Synapse.
-
Connect to BigQuery Data in DBArtisan
Use wizards in DBArtisan to configure BigQuery data as a data source.
-
Connect to and Query Cosmos DB Data in QlikView over ODBC
Create data visualizations with Cosmos DB data in QlikView.
-
Access Live SAP Netweaver Gateway Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Netweaver Gateway data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Enable the Miro JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Miro data.
-
Analyze Samanage Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Samanage data and visualize Samanage data in SAP Analytics Cloud.
-
How to Connect to Live Omnisend 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 Omnisend data for you.
-
Build a Simple VCL Application for Webex Data
How to build a simple VCL Application to view Webex data in RAD Studio using the CData ODBC Driver for Webex.
-
Integrating Claude Code CLI with Drip 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 Visualize Redshift Data in Python with pandas
Use pandas and other modules to analyze and visualize live Redshift data in Python.
-
Connect to JotForm Data in NetBeans
Connect to JotForm data in NetBeans with the data source configuration wizard.
-
Choosing the Best Method to Connect SharePoint to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SharePoint data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Work with eBay Data in AWS Glue Jobs Using JDBC
Connect to eBay from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with HDFS Data in JReport Designer
Create charts and reports based on HDFS data in JReport Designer.
-
Connect Productboard Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Productboard data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.