CData Software - Knowledge Base
Recent Articles
-
QuickBooks Time Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to QuickBooks Time through CData Connect AI using different applications and tools.
-
Build Productboard-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Productboard Data in Claude Code to assist with building Productboard-powered applications.
-
Build Visualizations of Calendly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Calendly in Birst.
-
Connecting Moonlit Workflow with Azure Data Lake Storage Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Azure Data Lake Storage in real time.
-
Creating API Driver API Profiles
Create a new API Profiles to enable SQL access to a new API.
-
Automated Continuous SAP HANA Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP HANA replication to Azure SQL Database.
-
Build a Singer.io Tap for Quaderno With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Quaderno data using
-
How to Easily Query Customer.io Data in OpenOffice Base
Connect to Customer.io data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Helpscout Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Helpscout to connect to Helpscout and execute queries in PowerBuilder.
-
Query Workable Data in DataGrip
Create a Data Source for Workable in DataGrip and use SQL to query live Workable.
-
Build JSON Visualizations in Tableau Desktop
Use CData Connect AI to connect to live JSON and build visualizations in Tableau.
-
Build AI/ML Models with Live Google Search Data using Dataiku
Connect Google Search Data with Dataiku using the CData JDBC Driver for Google Search.
-
Use the CData Software JDBC Driver for Opsgenie in MicroStrategy Web
Connect to Opsgenie in MicroStrategy Web using the CData Software JDBC Driver for Opsgenie.
-
Analyze Everhour Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Everhour from Power Pivot. You will use the Table Import Wizard to load Everhour. You can visually build the import query or use any SQL supported by the driver.
-
Design BIRT Reports on Redis Data
Provide current Redis to your embedded analytics.
-
Analyze Aweber Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Aweber and visualize live Aweber in Infragistics Reveal.
-
Object-Relational Mapping (ORM) with Kintone 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 Kintone into a Java-based ORM framework, Hibernate.
-
How to Work with Google Spanner Data in ETL Validator JDBC
Connect to Google Spanner from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with SuiteCRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SuiteCRM to a JSON file on disk.
-
Connect to Active Directory Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Active Directory from Filemaker Pro on Mac.
-
Import Real-Time ShipEngine Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ShipEngine in ColdFusion.
-
Automated Continuous NetSuite Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable NetSuite replication to Google Cloud SQL.
-
DataBind Controls to DocuSign Data in Delphi
DataBind to DocuSign in Delphi with standard data access components and controls.
-
Edit and Search Mode External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Mode to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Mode objects that you can access from apps and the dashboard.
-
Replicate Drift Data from PowerShell
Write a quick PowerShell script to query Drift. Use connectivity to the live data to replicate Drift to SQL Server.
-
Create Dashboards and Visualize Live SQL Analysis Services Data in Geckoboard
Use CData Connect AI to connect to live SQL Analysis Services and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Elasticsearch Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Elasticsearch data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Datasets from Nethunt in Domo Workbench and Build Visualizations of Nethunt Data in Domo
Use the CData Software ODBC Driver for Nethunt to create datasets from Nethunt in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Cline with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon Athena from within your IDE.
-
How to update MariaDB from Excel
This article explains how to transfer data from Excel to MariaDB using the Excel Add-In for MariaDB.
-
Process & Analyze CockroachDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CockroachDB Data.
-
Use the CData Software JDBC Driver for Slack in MicroStrategy Desktop
Connect to Slack in MicroStrategy Desktop using the CData Software JDBC Driver for Slack.
-
How to Query Live Dynamics CRM Data in Claude Desktop
Connect to and query live Dynamics CRM Data in Claude Desktop using CData MCP Server.
-
Publish OpenWeatherMap-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OpenWeatherMap.
-
Access Live Strava Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Strava data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Sendwithus Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sendwithus from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind REST Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for REST with the DevExpress Windows Forms and Web controls to provide REST to a chart.
-
Connect to and Query OnePageCrm Data in QlikView over ODBC
Create data visualizations with OnePageCrm in QlikView.
-
Query Google Forms Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Forms entities in PHP by modeling them as objects.
-
Rapidly Develop Amazon S3-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 Amazon S3.
-
Design BIRT Reports on LaunchDarkly Data
Provide current LaunchDarkly to your embedded analytics.
-
Connect to Perplexity Data in Ruby
Connect to Perplexity in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Outreach.io Data in NetBeans
Connect to Outreach.io in NetBeans with the data source configuration wizard.
-
Integrate Live SharePoint Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft SharePoint and integrate live Microsoft SharePoint into apps built in Microsoft Power Apps.
-
Connect to SAP SuccessFactors Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP SuccessFactors Data and connect to SAP SuccessFactors in Akorbi Digital RunMyProcess.
-
Build MVC Applications with Connectivity to TaxJar Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access TaxJar from an ASP.NET MVC application.
-
Automated Continuous Microsoft Entra ID Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to SQL Server.
-
Getting Started with the CData ODBC Driver for VWO
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for VWO.
-
Consume Google Forms OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Forms feeds that reflect any changes in SAP Lumira.
-
Access Live ZohoPeople Data in AWS Lambda
Connect to live ZohoPeople in AWS Lambda using the CData JDBC Driver.
-
Access Live eBay Analytics Data in TIBCO Data Virtualization
Use the eBay Analytics Tibco DV Adapter to create a eBay Analytics data source in TIBCO Data Virtualization Studio and gain access to live eBay Analytics from your TDV Server.
-
Visualize FHIR Data in TIBCO Spotfire through OData
Integrate FHIR into dashboards in TIBCO Spotfire.
-
Integrate Cloudflare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Cloudflare from Informatica Cloud.
-
Automate Google Contacts Data Replication to SAP HANA
Use CData Sync to customize and automate Google Contacts replication to SAP HANA.
-
How to publish and share Presto Data dashboards with Tableau Server
The CData ODBC driver for Presto enables you integrate Presto into Tableau dashboards.
-
Build Hubstaff-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Hubstaff and build web apps with connectivity to live Hubstaff.
-
How to Query Live Bullhorn CRM Data in Claude Desktop
Connect to and query live Bullhorn CRM Data in Claude Desktop using CData MCP Server.
-
Build MVC Applications with Connectivity to LaunchDarkly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LaunchDarkly from an ASP.NET MVC application.
-
Analyze GitHub Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for GitHub from Power Pivot. You will use the Table Import Wizard to load GitHub. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Avalara AvaTax Data in Aqua Data Studio
Access Avalara AvaTax from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Apps with Live ClickUp Data Using the Low-Code Development Platform of Mendix
Connect ClickUp with Mendix to build apps using the CData API Driver for JDBC.
-
Bind Live PingOne Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live PingOne data
-
Automated Continuous Xero Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Xero replication to PostgreSQL.
-
Visualize Strava Data in Sisense
Create an ElastiCube in Sisense app with access to Strava.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy Web
Connect to Sentry in MicroStrategy Web using the CData Software ODBC Driver for Sentry.
-
Use Agno to Talk to Your Dynamics 365 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 Microsoft Dynamics 365 for you.
-
How to Connect to SAP Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP ERP/NetWeaver. Leverage the pyodbc module for ODBC in Python.
-
Automate Aweber Data Replication to SAP HANA
Use CData Sync to customize and automate Aweber replication to SAP HANA.
-
Automated Continuous Salesloft Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesloft replication to Oracle.
-
Use the CData Software JDBC Driver for AfterShip in MicroStrategy
Connect to AfterShip in MicroStrategy Developer using the CData Software JDBC Driver for AfterShip.
-
Automated Continuous Teamgate Replication to Oracle
Use CData Sync for automated, continuous, customizable Teamgate replication to Oracle.
-
Build Amazon Marketplace-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Amazon Marketplace to explore live Amazon Marketplace Data in Cursor to assist with building Amazon Marketplace-powered applications.
-
Access Greenplum Data from MySQL in PHP
Connect to Greenplum through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Zoho Creator in MicroStrategy Desktop
Connect to Zoho Creator in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Creator.
-
Connect to Excel Online Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Excel Online from your AWS Glue jobs.
-
How to Access Live Paymo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Paymo enables you to integrate Paymo into workflows built using Microsoft Power Automate Desktop.
-
Connect to BenchmarkEmail in SpagoBI
Create reports featuring live BenchmarkEmail in SpagoBI Studio. Host BenchmarkEmail reports on SpagoBI Server.
-
Automate Facebook Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Facebook and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Informatica Mappings From/To a JDBC Data Source for Marketo
Create Marketo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to integrate Metabase with Cassandra Data
Use CData Connect AI to connect to live Apache Cassandra and create an interactive dashboard in Metabase from Apache Cassandra.
-
Bridge HelloSign Connectivity with Apache NiFi
Access and process HelloSign in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Neo4J in a Connection Pool in Tomcat
Connect to Neo4J from a connection pool in Tomcat.
-
Connect to FTP Data in Jaspersoft Studio
Execute SQL to remote FTP Servers in Jaspersoft Studio.
-
Integrate ADP Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ADP from Informatica Cloud.
-
Deploy the ADO.NET Provider for Rebilly on an SSRS Report Server
Connect to Rebilly 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.
-
Connect to and Visualize Live Office 365 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Office 365.
-
Visualize Zoho Inventory Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho Inventory.
-
Connect to Microsoft Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Ads to connect to Microsoft Ads and execute queries in PowerBuilder.
-
Model Hive Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Hive, enabling the direct import of real-time Apache Hive.
-
Automated Continuous Microsoft Exchange Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to MongoDB.
-
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.
-
Connect to Salesforce Data in Aqua Data Studio
Access Salesforce & Force.com from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from SAP Concur to Databricks using CData SSIS Components.
Easily push SAP Concur to Databricks using the CData SSIS Tasks for SAP Concur and Databricks.
-
Query Zoho Recruit Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho Recruit entities in PHP by modeling them as objects.
-
Integrating Kiro CLI with Browserless 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.
-
Visualize Miro Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Miro.
-
Integrating Boomi Agentstudio with Microsoft Entra ID Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Entra ID, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Shopify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Shopify from HeidiSQL.
-
Migrating data from Coda to Google BigQuery using CData SSIS Components.
Easily push Coda to Google BigQuery using the CData SSIS Tasks for Coda and Google BigQuery.
-
Publish Certinia-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Certinia.