CData Software - Knowledge Base
Recent Articles
-
Visualize Live Neo4J Data in the Power BI Service
Use CData Connect AI to connect to live Neo4J and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Square Data from MySQL in Amazon QuickSight
Connect to Square and build visualizations of Square using a MySQL Connection in Amazon QuickSight.
-
How to create an RPA flow for Missive Data in UiPath Studio
Use the Missive ODBC Driver to create workflows that access real-time Missive without any coding.
-
Back Up BambooHR to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with BambooHR data.
-
Automated Continuous Google Calendar Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Calendar replication to Oracle.
-
DataBind Controls to Parquet Data in Delphi
DataBind to Apache Parquet in Delphi with standard data access components and controls.
-
Visualize Pingdom Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pingdom.
-
Bridge Discourse Connectivity with Apache NiFi
Access and process Discourse in Apache NiFi using the CData JDBC Driver.
-
Build Reckon-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Reckon to explore live Reckon Data in Claude Code to assist with building Reckon-powered applications.
-
Build Visualizations of Figshare Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Figshare in Birst.
-
Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy Web
Connect to Azure Synapse in MicroStrategy Web using the CData Software JDBC Driver for Azure Synapse.
-
Import and Visualize Smartsheet Data in Power View
Create data visualizations based on Smartsheet in Excel.
-
Feed Act-On Data into FineReport
How to set Act-On as a JDBC data source in FineReport.
-
Connect to Suadeo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Suadeo.
-
Use ChatGPT to Talk to Your Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Monday.com for you.
-
Moving Data from Bitbucket to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bitbucket data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Enable the Google Sheets JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Sheets.
-
Connect to Twitter Ads Data in CloverDX (formerly CloverETL)
Transfer Twitter Ads using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData ADO.NET Provider for GraphQL
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for GraphQL.
-
How to Connect to Live Microsoft Dataverse 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 Microsoft Dataverse (CDS) for you.
-
Integrating GitHub Copilot CLI with Pingdom 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 Oracle Financials Cloud 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 Oracle Financials Cloud into TIBCO Spotfire.
-
Integrate Microsoft Dataverse Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Dataverse (CDS) in the Pentaho Data Integration tool.
-
Automated Databricks Data Replication to Teradata
Use CData Sync to Customize and automate Databricks replication to Teradata.
-
Automated Continuous Oracle Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle replication to IBM DB2.
-
Manage CapsuleCRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CapsuleCRM.
-
Build MVC Applications with Connectivity to Shippo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Shippo from an ASP.NET MVC application.
-
Use JayDeBeApi to access Greenplum Data in Python
Use standard Python scripting and the development environment of your choice to access live Pivotal GreenPlum.
-
How to integrate SAP Fieldglass with Apache Airflow
Access and process SAP Fieldglass in Apache Airflow using the CData JDBC Driver.
-
Connect to Zoho Books Data in HULFT Integrate
Connect to Zoho Books as a JDBC data source in HULFT Integrate
-
Analyze ZendeskSell Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZendeskSell with the CData JDBC Driver for ZendeskSell.
-
Replicate Timely Data from PowerShell
Write a quick PowerShell script to query Timely. Use connectivity to the live data to replicate Timely to SQL Server.
-
Automated Continuous Cvent Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cvent replication to SQL Server.
-
Use Dash to Build to Web Apps on Pipeline CRM Data
Create Python applications that use pandas and Dash to build Pipeline CRM-connected web apps.
-
Moving Data from ScrapingBee to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ScrapingBee data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to QuickBooks Time Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time QuickBooks Time using standard SQL.
-
Use the CData ODBC Driver for Wave Financial in Microsoft Power Query
You can use the CData Wave Financial ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Wave Financial into Microsoft Power Query.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon S3 within intelligent workflows.
-
How to Connect to Front Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Front. Leverage the pyodbc module for ODBC in Python.
-
Build Cloudant-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cloudant Data from Zoho Analytics and import live IBM Cloudant.
-
Bidirectional Access to BigCommerce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate BigCommerce in Filemaker Pro for Mac or Windows.
-
Connect to Paymo Data in Ruby
Connect to Paymo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Float Replication to Oracle
Use CData Sync for automated, continuous, customizable Float replication to Oracle.
-
Migrating data from PDFMonkey to Google BigQuery using CData SSIS Components.
Easily push PDFMonkey to Google BigQuery using the CData SSIS Tasks for PDFMonkey and Google BigQuery.
-
Operational Reporting on Snowflake Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Snowflake.
-
Create Data Visualizations in Cognos BI with Printify Data
Access Printify as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Moving Data from Hive to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Hive data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Validate Shortcut Data with QuerySurge
Access and validate Shortcut in QuerySurge using the CData JDBC Driver.
-
Visualize LightSpeedRetail 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 LightSpeedRetail into TIBCO Spotfire.
-
How to Connect to Live Sage 200 Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Sage 200 for you.
-
Connect to Pushbullet Data from a Connection Pool in Jetty
The Pushbullet JDBC Driver supports connection pooling: This article shows how to connect faster to Pushbullet from Web apps in Jetty.
-
DataBind Charts to Pipeline CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Pipeline CRM 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.
-
Visualize Access Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Access.
-
Integrate Live API Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to API from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live API.
-
Connect to ShipStation Data in Ruby
Connect to ShipStation in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Pipedrive Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipedrive replication to IBM DB2.
-
Extract, Transform, and Load AfterShip Data in Informatica PowerCenter
Create a simple Workflow for AfterShip in Informatica PowerCenter.
-
Edit and Search Adobe Commerce External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Adobe Commerce to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Adobe Commerce objects that you can access from apps and the dashboard.
-
How to Connect Raisers Edge NXT 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 Raisers Edge NXT data in real time using natural language.
-
Use the CData ODBC Driver for Timely in Microsoft Power Query
You can use the CData Timely ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Timely into Microsoft Power Query.
-
Create Data Visualizations in Cognos BI with DB2 Data
Access IBM DB2 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Elasticsearch Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Elasticsearch Data and provide access to live Elasticsearch for custom reports in the Power BI Service.
-
Object-Relational Mapping (ORM) with XML 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 XML Files into a Java-based ORM framework, Hibernate.
-
Access Anaplan Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Anaplan from your Oracle system.
-
Build Agents in Relevance AI with Access to Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Highrise CRM within intelligent agent workflows.
-
Provide OData Services of Productboard Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Productboard by developing a WCF Service Application.
-
Work with Live Xero Data in Power Query
Use CData Connect AI to connect to Xero Accounting and work with live Xero Accounting in Microsoft Power Query.
-
Viewing ShipEngine Data in RAD Studio Data Explorer
How to view ShipEngine in RAD Studio Data Explorer using the CData ODBC Driver for ShipEngine.
-
Connect PhantomBuster Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PhantomBuster using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect the Power BI Service to Pipeliner CRM: Complete Guide
Connect to the CData Software Power BI Connector for Pipeliner CRM from PowerBI.com to provide real-time Pipeliner CRM across the organization.
-
Visualize Live Presto Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Presto using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Cvent Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Cvent and visualize live Cvent in Infragistics Reveal.
-
Bridge Google Contacts Connectivity with Apache NiFi
Access and process Google Contacts in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live HBase 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 Apache HBase for you.
-
Use the CData Software JDBC Driver for QuickBooks Online in MicroStrategy Web
Connect to QuickBooks Online in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks Online.
-
How to Easily Query SAP ByDesign Data in OpenOffice Base
Connect to SAP ByDesign data in OpenOffice Base using the CData ODBC Driver for SAP ByDesign and generate reports with live data insights.
-
Connect to Autopilot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Autopilot.
-
How to connect SharePoint with SAP Concur Data through external lists
Provide SAP Concur to SharePoint users as an external list.
-
Build AdRoll-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to AdRoll and build web apps with connectivity to live AdRoll.
-
Connect to AlloyDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google AlloyDB from Filemaker Pro on Mac.
-
Import and Visualize Freshservice Data in Power View
Create data visualizations based on Freshservice in Excel.
-
Query Jira Data in DataGrip
Create a Data Source for Jira in DataGrip and use SQL to query live Atlassian Jira.
-
Integrate LibreChat with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Marketo from within the chat interface.
-
Explore Geographical Relationships in Oracle Data with Power Map
Create data visualizations with Oracle Database in Power Map.
-
Automated Continuous SAP HANA Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP HANA replication to Oracle.
-
Connect and Query Live Apollo Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apollo into Databricks
-
Create Dynamic Grafana Grids Using the Infragistics XamDataGrid
Learn how you can connect Grafana to Infragistics XamDataGrid to build dynamic grids.
-
Build Visualizations of SAP HANA Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA in Birst.
-
Viewing Google Drive Data in RAD Studio Data Explorer
How to view Google Drive in RAD Studio Data Explorer using the CData ODBC Driver for Google Drive.
-
Integrating Vimeo Data in Talend Cloud Data Management Platform
Connect Vimeo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Google Spanner-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Spanner to explore live Google Spanner Data in Claude Code to assist with building Google Spanner-powered applications.
-
Import Real-Time SAP Netweaver Gateway Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Netweaver Gateway in ColdFusion.
-
Integrate Live Jumpseller Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Jumpseller to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Bright Data Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bright Data and the SQL Gateway to access Bright Data from Google Apps Script.
-
How to Connect to Live Cassandra 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 Apache Cassandra for you.
-
Access Live Mailjet Data in Coginiti Pro
Connect to and query live Mailjet from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Reckon Data in CloverDX (formerly CloverETL)
Transfer Reckon using the visual workflow in the CloverDX data integration tool.
-
Load Aweber Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Aweber to a database.
-
Integrating GitHub Copilot CLI with Hacker News 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 Freshservice Data in AWS Glue Jobs Using JDBC
Connect to Freshservice from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.