CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Grafana Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Grafana data in ColdFusion.
-
Connect to Salesforce Marketing from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Salesforce Marketing data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Excel Add-In for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bullhorn CRM.
-
Getting Started with the CData Excel Add-In for Teamgate
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Teamgate.
-
Design BIRT Reports on Bugsnag Data
Provide current Bugsnag data to your embedded analytics.
-
How to connect Amazon QuickSight to Bitly Data
Create a connection to Bitly data in CData Connect AI and insert Bitly data into Amazon QuickSight SPICE to build interactive dashboards.
-
LINQ to ServiceNow 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 ServiceNow Data Provider.
-
Create Datasets from ZohoInvoice in Domo Workbench and Build Visualizations of ZohoInvoice Data in Domo
Use the CData Software ODBC Driver for ZohoInvoice to create datasets from ZohoInvoice data in Domo Workbench and then build visualizations in the Domo service.
-
Build Charts with Perplexity Data in Clear Analytics
Create dynamic charts and perform analytics based on Perplexity data in Clear Analytics.
-
Automate SAP Netweaver Gateway Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Netweaver Gateway data replication to SAP HANA.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zuora
Provide connectivity to Zuora data through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for Paylocity from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Paylocity to connect to Paylocity data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Paylocity data in Excel.
-
How to connect to ADP Data with Squirrel SQL client
Connect to ADP data and execute queries in the Squirrel SQL Client.
-
Access Live BigCommerce Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to BigCommerce data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build PolarTeamPro-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PolarTeamPro data and build web apps with connectivity to live PolarTeamPro data.
-
How to Visualize Redis 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 Redis data in Python.
-
Visualize Live JobNimbus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JobNimbus data.
-
Automated Continuous Google Cloud Storage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to delimited files (CSV/TSV).
-
Connect to Zoho Projects Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Projects data using standard SQL.
-
Creating DB2-Connected Applications in Unqork
You can use CData Connect AI to feed DB2 data to Unqork and build custom business apps.
-
A PostgreSQL Interface for Google Forms Data using the CData ODBC Driver
Use the SQL Gateway and Google Forms ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with live ClickUp Data in Jitterbit
Use CData Connect AI to connect to and integrate live ClickUp data in Jitterbit.
-
Automated Continuous Zoho Books Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Books replication to Google BigQuery.
-
Getting Started with the CData ADO.NET Provider for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate with Live ZohoPeople Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ZohoPeople from the MuleSoft Anypoint Platform to integrate live ZohoPeople data into custom reports and dashboards.
-
Moving Data from Grafana to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Grafana data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Model, Search, and Visualize Live MySQL Data in ThoughtSpot
Use CData Connect AI to connect to live MySQL data for modeling, searching, and visualizing.
-
A PostgreSQL Interface for Oracle Financials Cloud Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Financials Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP HANA XS Advanced Data in Jaspersoft Studio
Execute SQL to remote SAP HANA XS Advanced data in Jaspersoft Studio.
-
Operational Reporting on Elasticsearch Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Elasticsearch data.
-
How to Create Power BI Visual Reports with Real-Time Oracle Data
Use CData Power BI Connectors to visualize Oracle data in Power BI.
-
How to Work with SendGrid Data in AWS Glue Jobs Using JDBC
Connect to SendGrid from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Using the CData Software ODBC Driver for Gorgias in PyCharm
Connect to Gorgias as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gorgias.
-
How to connect to Zoho Creator Data from Spring Boot
Connect to Zoho Creator in a Spring Boot Application using the CData JDBC Driver for Zoho Creator
-
How to Work with Paylocity Data in ETL Validator JDBC
Connect to Paylocity from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Simplesat Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Simplesat data to a chart.
-
How to create Visio diagrams from MongoDB Data
Automatically update MongoDB data with the changes you make to Visio master shapes.
-
Natively Connect to Act-On Data in PHP
The CData ODBC driver for Act-On enables you to create PHP applications with connectivity to Act-On data. Leverage the native support for ODBC in PHP.
-
A PostgreSQL Interface for OneNote Data using the CData ODBC Driver
Use the SQL Gateway and OneNote ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Oracle HCM Cloud Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle HCM Cloud data to a JSON file on disk.
-
Create a Data Access Object for SageHR Data using JDBI
A brief overview of creating a SQL Object API for SageHR data in JDBI.
-
Automate Paymo Data Replication to Azure Synapse
Use CData Sync to customize and automate Paymo data replication to Azure Synapse.
-
Connect to RabbitMQ Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for RabbitMQ and the SQL Gateway to access RabbitMQ data from Google Apps Script.
-
Automated Continuous SAP Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP replication to Google Cloud SQL.
-
Integrate Clockify Data in the Pentaho Report Designer
Publish reports based on Clockify data in the Pentaho BI tool.
-
Build Sage Cloud Accounting-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Sage Cloud Accounting data without replication.
-
Connect to SQL Analysis Services Data from a Connection Pool in Jetty
The SQL Analysis Services JDBC Driver supports connection pooling: This article shows how to connect faster to SQL Analysis Services data from Web apps in Jetty.
-
Connecting Pipedream with CapsuleCRM 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 CapsuleCRM data in real time.
-
Deploy the ADO.NET Provider for Acumatica on an SSRS Report Server
Connect to Acumatica 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.
-
How to Access Live LDAP Objects in Power Automate Desktop via ODBC
The CData ODBC Driver for LDAP enables you to integrate LDAP objects into workflows built using Microsoft Power Automate Desktop.
-
Automate Excel Online Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Excel Online data from PowerShell? This article demonstrates how to utilize the Excel Online Cmdlets for tasks like connecting to Excel Online data, automating operations, downloading data, and more.
-
Connect to Live Moosend Data in MicroStrategy through CData Connect AI
Create a live connection to Moosend Data in CData Connect AI and connect to your Moosend data from MicroStrategy.
-
Getting Started with the CData Connect AI Python SDK for Greenplum
Install the CData Connect AI Python SDK to read and write live Greenplum data with standard DB-API 2.0 Python code.
-
Rapidly Develop Oracle Eloqua-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 Oracle Eloqua.
-
Analyze BigQuery Data in Looker
Use CData Connect AI to connect to BigQuery Data from Looker and build custom apps using live BigQuery data.
-
Integrate with Google Ad Manager Data in JReport Designer
Create charts and reports based on Google Ad Manager data in JReport Designer.
-
Connect to Outreach.io Data from Crystal Reports
Use CData Connect AI to connect to and report on live Outreach.io data from Crystal Reports.
-
Automate AgileCRM Data Replication to SAP HANA
Use CData Sync to customize and automate AgileCRM data replication to SAP HANA.
-
DataBind Charts to Typeform Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Typeform 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.
-
Natively Connect to QuickBooks Data in PHP
The CData ODBC driver for QuickBooks enables you to create PHP applications with connectivity to QuickBooks data. Leverage the native support for ODBC in PHP.
-
Use Dash to Build Web Apps on AgileCRM Data via CData Connect AI
Build interactive Dash web apps on live AgileCRM data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Scrapfly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Scrapfly replication to Apache Cassandra.
-
Replicate Keap Data to Multiple Databases
Replicate Keap data to disparate databases with a point-and-click configuration.
-
Connect to TaxJar from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from TaxJar data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze XML Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of XML data and visualize live XML data in Infragistics Reveal.
-
Publish MailerSend-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MailerSend data.
-
Using the CData Software ODBC Driver for Browserless in PyCharm
Connect to Browserless as an ODBC data source in PyCharm using the CData Software ODBC Driver for Browserless.
-
How to connect to Superchat Data from Spring Boot
Connect to Superchat in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating Claude Code CLI with LaunchDarkly 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 IBM Cloud Object Storage with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate IBM Cloud Object Storage with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to IBM Cloud Object Storage data.
-
View Reports on Real-Time ClickUp Data in Power BI Report Server
Use the CData ODBC Driver for ClickUp to visualize ClickUp data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query Rootly Data in MySQL Workbench
Execute MySQL queries against live Rootly data from MySQL Workbench.
-
Use the CData Software ODBC Driver for Keap in MicroStrategy
Connect to Keap data in MicroStrategy Developer using the CData Software ODBC Driver for Keap.
-
Access Live ZeroBounce Data in Coginiti Pro
Connect to and query live ZeroBounce data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Controls to Landbot Data in Delphi
DataBind to Landbot data in Delphi with standard data access components and controls.
-
Manage Airtable Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Airtable.
-
Load SAP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP data to a database.
-
Integrate Cline with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Analytics data from within your IDE.
-
Query Elasticsearch Data as a MySQL Database in Node.js
Execute MySQL queries against Elasticsearch data from Node.js.
-
Deploy the ADO.NET Provider for BambooHR on an SSRS Report Server
Connect to BambooHR 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.
-
Visualize Hive Data in Tableau
The CData ODBC driver for Hive enables you integrate Hive data into Tableau dashboards.
-
How to connect and process Redis data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Redis data.
-
Access Highrise Data from MySQL in Amazon QuickSight
Connect to Highrise and build visualizations of Highrise data using a MySQL Connection in Amazon QuickSight.
-
Using the CData Software ODBC Driver for Vimeo in PyCharm
Connect to Vimeo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Vimeo.
-
Load xBase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load xBase data to a database.
-
Use the CData Software JDBC Driver for Close in MicroStrategy
Connect to Close data in MicroStrategy Developer using the CData Software JDBC Driver for Close.
-
Query Zuora Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zuora data from Node.js.
-
Build Power BI XMLA Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Power BI XMLA data and build visualizations in Tableau Cloud.
-
Connect to PabblySubscriptions Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PabblySubscriptions data using standard SQL.
-
Automated Continuous Mouseflow Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mouseflow replication to IBM DB2.
-
Visualize Redis Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Redis data.
-
How to load TaxJar data into Elasticsearch via Logstash
Introducing a simple method to load TaxJar data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Databricks Agent Bricks to Talk to Your SAS Data Sets Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAS Data Sets data for you.
-
Publish Crystal Reports on Mocean Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mocean data.
-
How to Query Neo4J Data in MySQL Workbench
Execute MySQL queries against live Neo4J data from MySQL Workbench.
-
Automate Avalara AvaTax Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Avalara AvaTax data from PowerShell? This article demonstrates how to utilize the Avalara AvaTax Cmdlets for tasks like connecting to Avalara AvaTax data, automating operations, downloading data, and more.
-
Connect Excel Online to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Excel Online data using the CData Python MCP Server.
-
Migrating data from Perigon to Snowflake using CData SSIS Components.
Easily push Perigon data to Snowflake using the CData SSIS Tasks for Perigon and Snowflake.
-
Integrate Google's Vertex AI Agent with Live HubDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live HubDB data within intelligent workflows.
-
Build Google Cloud Storage-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Cloud Storage data and build Google Cloud Storage-connected web apps with Axios.