CData Software - Knowledge Base
Recent Articles
-
Connect to Confluence Data in DBeaver
Use the CData ODBC Driver to connect to Confluence data in DBeaver.
-
Validate Cloudflare Data with QuerySurge
Access and validate Cloudflare data in QuerySurge using the CData JDBC Driver.
-
Connect to Grafana Data in Jaspersoft Studio
Execute SQL to remote Grafana data in Jaspersoft Studio.
-
Import and Visualize Apollo Data in Power View
Create data visualizations based on Apollo data in Excel.
-
Access SendInBlue 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 SendInBlue data.
-
How to Connect Flowise AI Agents to Live Smartsheet Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Smartsheet data without replication.
-
Use the CData Software JDBC Driver for Freshdesk in MicroStrategy Desktop
Connect to Freshdesk data in MicroStrategy Desktop using the CData Software JDBC Driver for Freshdesk.
-
Establish a Live Connection with OData Services using Tableau Bridge
The CData ODBC Driver for OData enables you to integrate live OData services into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Supabase Data in Sisense
Create an ElastiCube in Sisense app with access to Supabase data.
-
How to Query Live Clari Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Clari data data in natural language using Python.
-
Replicate Keap Data from PowerShell
Write a quick PowerShell script to query Keap data. Use connectivity to the live data to replicate Keap data to SQL Server.
-
Object-Relational Mapping (ORM) with JSON Services 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 JSON services into a Java-based ORM framework, Hibernate.
-
Choosing the Best Method to Connect Clari to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Clari data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query Cosmos DB Data in DataGrip
Create a Data Source for Cosmos DB in DataGrip and use SQL to query live Cosmos DB data.
-
Connect Google Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Ads data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Power BI Reports on Real-Time Amazon S3 Data
Use the CData ODBC Driver for Amazon S3 to visualize Amazon S3 data in Power BI Desktop.
-
Visualize Workday Data in TIBCO Spotfire through OData
Integrate Workday data into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for BambooHR in MicroStrategy
Connect to BambooHR data in MicroStrategy Developer using the CData Software JDBC Driver for BambooHR.
-
Automated Continuous ShipStation Replication to MySQL
Use CData Sync for automated, continuous, customizable ShipStation replication to MySQL.
-
Design BIRT Reports on REST Data
Provide current REST data to your embedded analytics.
-
Create Freshsales Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Freshsales data access from reports, embedded analytics, and more.
-
Connect to Strava Data from PowerBuilder via ADO.NET
This article demonstrates how to access Strava data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect the Power BI Service to Sentry: Complete Guide
Connect to the CData Software Power BI Connector for Sentry from PowerBI.com to provide real-time Sentry data across the organization.
-
Access Live Klaviyo Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Klaviyo data through MCP integration.
-
Build AI/ML Models with Live Parallel Data using Dataiku
Connect Parallel Data with Dataiku using the CData API Driver for JDBC.
-
Access Marketo 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 Marketo data.
-
Model, Search, and Visualize Live Reckon Data in ThoughtSpot
Use CData Connect AI to connect to live Reckon data for modeling, searching, and visualizing.
-
Replicate Azure Data Lake Storage Data in Heroku for Use in Salesforce Connect
Replicate Azure Data Lake Storage data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
LINQ to SageHR 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 SageHR Data Provider.
-
Automated Continuous Pingdom Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pingdom replication to SQL Server.
-
Build Semantic Layer Views for Qualaroo Data in APOS Live Data Gateway
Use the CData Connector for Qualaroo in APOS Live Data Gateway to build Semantic Layer Views for Qualaroo data.
-
Create Twilio-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Twilio Data from OutSystems and build custom enterprise apps using live Twilio data.
-
Integrate Devin with Live Marketo Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Marketo data.
-
Connect to Google Forms Data in DBeaver
Use the CData ODBC Driver to connect to Google Forms data in DBeaver.
-
Connect to Bullhorn CRM Data in JRuby
Create a simple JRuby app with access to live Bullhorn CRM data.
-
Use the CData Software ODBC Driver for SAP HANA XS Advanced in MicroStrategy Desktop
Connect to SAP HANA XS Advanced data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP HANA XS Advanced.
-
Use CData Connect AI to Access Egnyte Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Egnyte data in the Power Pivot business intelligence tool.
-
Create Data Visualizations Based On Cvent Data in Mode
Use CData Connect AI to connect to Cvent Data from Mode and build visualizations using live Cvent data.
-
Use the CData Software ODBC Driver for Discourse in MicroStrategy Desktop
Connect to Discourse data in MicroStrategy Desktop using the CData Software ODBC Driver for Discourse.
-
Connect to Real-Time Wave Financial Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Wave Financial and Dataflow to import and use Wave Financial data in Power Apps.
-
Create Reports from Grafana Data in Looker Studio
Use CData Connect AI to gain access to live Grafana data and create custom reports in Looker Studio.
-
Automate Aircall Data Replication to Azure Data Lake
Use CData Sync to customize and automate Aircall data replication to Azure Data Lake.
-
Publish Demio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Demio data.
-
Connect to SAP HANA XS Advanced Data in DBArtisan
Use wizards in DBArtisan to configure SAP HANA XS Advanced data as a data source.
-
Create Informatica Mappings From/To a JDBC Data Source for Autopilot
Create Autopilot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Tableau Connector for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Teams.
-
Create a Data Access Object for Box Data using JDBI
A brief overview of creating a SQL Object API for Box data in JDBI.
-
Integrating Claude Code CLI with ServiceDesk Plus 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.
-
View Reports on Real-Time SharePoint Data in Power BI Report Server
Use the CData ODBC Driver for SharePoint to visualize SharePoint data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to GraphQL Data in JRuby
Create a simple JRuby app with access to live GraphQL data.
-
Access Live QuickBooks Data in Excel 365 Online (Excel for the web)
Connect to QuickBooks data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to & Open Blackbaud FE NXT Data in Microsoft Excel
This article uses the CData ODBC driver for Blackbaud FE NXT to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Migrating data from HubDB to Snowflake using CData SSIS Components.
Easily push HubDB data to Snowflake using the CData SSIS Tasks for HubDB and Snowflake.
-
Create a Data Access Object for Reckon Data using JDBI
A brief overview of creating a SQL Object API for Reckon data in JDBI.
-
Connect to Zoho Inventory Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Inventory and the SQL Gateway to access Zoho Inventory data from Google Apps Script.
-
Access BigQuery Data from MySQL in Amazon QuickSight
Connect to BigQuery and build visualizations of BigQuery data using a MySQL Connection in Amazon QuickSight.
-
How to connect to Demio Data with Squirrel SQL client
Connect to Demio data and execute queries in the Squirrel SQL Client.
-
Build Google Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Analytics data.
-
Integrating GitHub Copilot with Cvent 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.
-
Use the CData Software ODBC Driver for Bitly in MicroStrategy
Connect to Bitly data in MicroStrategy Developer using the CData Software ODBC Driver for Bitly.
-
A PostgreSQL Interface for CouchDB Data using the CData ODBC Driver
Use the SQL Gateway and CouchDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Paymo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Paymo data to a chart.
-
Natively Connect to Rebilly Data in PHP
The CData ODBC driver for Rebilly enables you to create PHP applications with connectivity to Rebilly data. Leverage the native support for ODBC in PHP.
-
Connect to Procore Data in CloverDX (formerly CloverETL)
Transfer Procore data using the visual workflow in the CloverDX data integration tool.
-
Integrate with ZohoPeople Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ZohoPeople data in SnapLogic.
-
How to use SQLAlchemy ORM to access HDFS Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HDFS data.
-
Automated Continuous SAP Hybris C4C Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to PostgreSQL.
-
Build Agents in Relevance AI with Access to Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SurveyMonkey data within intelligent agent workflows.
-
Create Reports from Wave Financial Data in Looker Studio
Use CData Connect AI to gain access to live Wave Financial data and create custom reports in Looker Studio.
-
Connect to Coinbase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Coinbase as an External Source in Dremio.
-
DataBind Access Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Access with the DevExpress Windows Forms and Web controls to provide Access data to a chart.
-
Connect to AfterShip Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to AfterShip.
-
Integrate OpenCode with Live QuickBooks Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live QuickBooks data from within your AI coding agent.
-
Create Data Visualizations in Cognos BI with MongoDB Data
Access MongoDB data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Hive Data in Talend Cloud Data Management Platform
Connect Hive Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Hive.
-
Access Greenplum Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Greenplum data from your Oracle system.
-
DataBind Charts to Datadog Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Datadog 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.
-
Connect and Query Live Grafana Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Grafana data into Databricks and enable direct, live querying and analysis without replication.
-
Automate Flowlu Data Replication to Azure Synapse
Use CData Sync to customize and automate Flowlu data replication to Azure Synapse.
-
Extract, Transform, and Load Azure Data Lake Storage Data in Informatica PowerCenter
Create a simple Workflow for Azure Data Lake Storage data in Informatica PowerCenter.
-
Automated Continuous Qualaroo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Qualaroo replication to delimited files (CSV/TSV).
-
Getting Started with the CData ADO.NET Provider for Tavily
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to integrate Apify with Apache Airflow
Access and process Apify data in Apache Airflow using the CData JDBC Driver.
-
Connect to SAP Netweaver Gateway Data in NetBeans
Connect to SAP Netweaver Gateway data in NetBeans with the data source configuration wizard.
-
Connect to and Query Square Data in QlikView over ODBC
Create data visualizations with Square data in QlikView.
-
Access Live Email Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Email data from your Excel spreadsheets.
-
Connect and Visualize Live Tally Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Tally data into the Databricks platform and create visualization dashboards with real-time Tally data.
-
Automated Continuous Apollo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Apollo replication to Apache Kafka.
-
Automated Continuous PayPal Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable PayPal replication to Apache Cassandra.
-
Connect to Beeminder Data in NetBeans
Connect to Beeminder data in NetBeans with the data source configuration wizard.
-
Manage Mocean Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mocean.
-
How to connect to SAP HANA Data with Squirrel SQL client
Connect to SAP HANA data and execute queries in the Squirrel SQL Client.
-
Use the CData Software ODBC Driver for Outreach.io in SAS for Real-Time Reporting and Analytics
Connect to real-time Outreach.io data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Outreach.io.
-
Build Vault CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Vault CRM data and build web apps with connectivity to live Vault CRM data.
-
How to Connect Flowise AI Agents to Live SAS xpt Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live SAS xpt data without replication.
-
Query FHIR Data as a MySQL Database in Node.js
Execute MySQL queries against FHIR data from Node.js.
-
Build HBase-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to HBase Data from Zoho Analytics and import live HBase data.
-
Bullhorn CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bullhorn CRM facts in real time.
-
Replicate Multiple ConvertKit Accounts
Replicate multiple ConvertKit accounts to one or many databases.
-
Integrating Claude Code CLI with Rebilly 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.