CData Software - Knowledge Base
Recent Articles
-
Access Ontraport Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Ontraport from your Oracle system.
-
Connect to and Visualize Live Perigon Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Perigon.
-
How to Connect to Live ServiceNow 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 ServiceNow for you.
-
Import FreshBooks Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to FreshBooks Data and provide access to live FreshBooks for custom reports in the Power BI Service.
-
Connect and Visualize Live Oracle Service Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Service Cloud into the Databricks platform and create visualization dashboards with real-time Oracle Service Cloud.
-
Integrating GitHub Copilot CLI with Gorgias 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 Access Live Act-On Data in Visual Studio Code via Cline
Run CData MCP Server for Act-On on Windows Subsytem for Linux (WSL) and connect to live Act-On from the Cline extension in Visual Studio Code.
-
Integrate with Close Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Close to a JSON file on disk.
-
Automate Trello Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Trello and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Access Live Twitter Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twitter Ads from your Google Sheets.
-
ETL Power BI XMLA in Oracle Data Integrator
This article shows how to transfer Power BI XMLA into a data warehouse using Oracle Data Integrator.
-
Operational Reporting on SpaceX Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SpaceX.
-
Automated Continuous Amazon DynamoDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to OneLake in Microsoft Fabric.
-
How to Connect to & Open Redis Data in Microsoft Excel
This article uses the CData ODBC driver for Redis to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live Freshservice Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Freshservice.
-
Connect to Vimeo Data in RazorSQL
Connect to Vimeo from wizards and query Vimeo from the GUI in the RazorSQL database management tool.
-
ETL Salesforce Pardot in Oracle Data Integrator
This article shows how to transfer Salesforce Pardot into a data warehouse using Oracle Data Integrator.
-
Integrate ZendeskSell with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZendeskSell with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZendeskSell.
-
Connect to Acumatica Data in NetBeans
Connect to Acumatica ERP in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Freshsales in SAS for Real-Time Reporting and Analytics
Connect to real-time Freshsales in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Freshsales.
-
Build Apps with Live Jira Data Using the Low-Code Development Platform of Mendix
Connect Atlassian Jira with Mendix to build apps using the CData JDBC Driver for Jira.
-
Automated Continuous API Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable API replication to Google BigQuery.
-
How to publish and share GraphQL Data dashboards with Tableau Server
The CData ODBC driver for GraphQL enables you integrate GraphQL into Tableau dashboards.
-
How to Seamlessly Import Anaplan Data into IBM SPSS Modeler
Integrate Anaplan data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Semantic Layer Views for Couchbase Data in APOS Live Data Gateway
Use the CData Connector for Couchbase in APOS Live Data Gateway to build Semantic Layer Views for Couchbase.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy Web
Connect to Zoom in MicroStrategy Web using the CData Software JDBC Driver for Zoom.
-
Access Chargebee Data from MySQL in Amazon QuickSight
Connect to Chargebee and build visualizations of Chargebee using a MySQL Connection in Amazon QuickSight.
-
Model, Search, and Visualize Live Basecamp Data in ThoughtSpot
Use CData Connect AI to connect to live Basecamp for modeling, searching, and visualizing.
-
Seamlessly Bring Microsoft Planner Data into Retool Using CData Connect AI
Integrate Microsoft Planner data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Trigger SuiteCRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SuiteCRM with standard wizards in Logic Apps.
-
Automated Continuous DocuSign Replication to IBM DB2
Use CData Sync for automated, continuous, customizable DocuSign replication to IBM DB2.
-
Use the CData ODBC Driver for SAP HANA XS Advanced in Microsoft Power Query
You can use the CData SAP HANA XS Advanced ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP HANA XS Advanced into Microsoft Power Query.
-
How to connect and process SAP Ariba Source from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Ariba Source.
-
Work with Live Cosmos DB Data in Power Query
Use CData Connect AI to connect to Azure Cosmos DB and work with live Azure Cosmos DB in Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time Spark Data
Use CData Power BI Connectors to visualize Apache Spark SQL in Power BI.
-
Validate Reckon Accounts Hosted Data with QuerySurge
Access and validate Reckon Accounts Hosted in QuerySurge using the CData JDBC Driver.
-
Automated Continuous CapsuleCRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to IBM DB2.
-
Operational Reporting on Workday Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Workday.
-
Use Azure AI Foundry to Talk to Your Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Exact Online for you.
-
Query Nethunt Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Nethunt from Node.js.
-
Create Twilio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Twilio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Add Webex Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Webex with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query Live Eventbrite Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Eventbrite data in natural language using Python.
-
Natively Connect to Exa Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Exa. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Oracle Service Cloud Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Service Cloud in Birst.
-
Integrate with Toggl Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Toggl to a JSON file on disk.
-
Using the CData Software ODBC Driver for AlloyDB in PyCharm
Connect to AlloyDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for AlloyDB.
-
Build ConstantContact-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ConstantContact.
-
Natively Connect to Dropbox Data in PHP
The CData ODBC driver for Dropbox enables you to create PHP applications with connectivity to Dropbox. Leverage the native support for ODBC in PHP.
-
Using the CData Software ODBC Driver for Sybase in PyCharm
Connect to Sybase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sybase.
-
How to import Superchat Data into Apache Solr
Use the CData Software JDBC Driver for Superchat in Data Import Handler and create an automated import of Superchat to Apache Solr Enterprise Search platform.
-
Visualize Live Customer.io Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Customer.io.
-
Build an OLAP Cube in SSAS from Act CRM Data
Establish a connection to Act CRM data from SQL Server Analysis Services, and use the Act CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Drift Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Drift replication to Amazon S3.
-
Access Live Box Data in AWS Lambda
Connect to live Box in AWS Lambda using the CData JDBC Driver.
-
Work with Wistia Data in FoxPro
Load Wistia into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Excel Add-In for CouchDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CouchDB.
-
DataBind Controls to Power BI XMLA Data in C++Builder
DataBind to Power BI XMLA in C++Builder with standard components and controls.
-
How to Access Live Zoom Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoom enables you to integrate Zoom into workflows built using Microsoft Power Automate Desktop.
-
Manage ActiveCampaign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ActiveCampaign.
-
Getting Started with the CData Power BI Connector for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Sales.
-
Access Live Amazon Athena Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Amazon Athena through MCP integration.
-
Validate Sage Intacct Data with QuerySurge
Access and validate Sage Intacct in QuerySurge using the CData JDBC Driver.
-
How to Connect Neo4J 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 Neo4J data in real time using natural language.
-
Integrating Codex CLI with Active Directory 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.
-
Access Live PivotalTracker Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PivotalTracker into the statistical analysis tools available in SAS JMP. This article shows how to use PivotalTracker in the Graph Builder and Query Builder.
-
Connect to Google Spanner Data in Ruby
Connect to Google Spanner in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Controls to Cloudflare Data in Delphi
DataBind to Cloudflare in Delphi with standard data access components and controls.
-
Creating Azure DevOps-Connected Applications in Unqork
You can use CData Connect AI to feed Azure DevOps to Unqork and build custom business apps.
-
Integrating Kiro CLI with WooCommerce 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.
-
LINQ to Dynamics NAV 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 Dynamics NAV Data Provider.
-
Build Dashboards with Calendly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Calendly in Dundas BI.
-
Integrating Cursor CLI with WooCommerce 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.
-
Model, Search, and Visualize Live SAP HANA Data in ThoughtSpot
Use CData Connect AI to connect to live SAP HANA for modeling, searching, and visualizing.
-
Integrate Monday.com with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Monday.com with External Services.
-
Connect to Vault CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Veeva Vault & Vault CRM from PowerBuilder using the Vault CRM JDBC Driver.
-
Connect to Kintone Data in CloverDX (formerly CloverETL)
Transfer Kintone using the visual workflow in the CloverDX data integration tool.
-
Replicate Coinbase Data to Multiple Databases
Replicate Coinbase to disparate databases with a point-and-click configuration.
-
A PostgreSQL Interface for Jira Assets Data using the CData ODBC Driver
Use the SQL Gateway and Jira Assets ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build SAP Hybris C4C-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Hybris C4C.
-
Create Reports with Drift Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Drift.
-
Establish a Live Connection with Adobe Experience Manager Data using Tableau Bridge
The CData ODBC Driver for Adobe Experience Manager enables you to integrate live Adobe Experience Manager into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze SAP SuccessFactors LMS Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP SuccessFactors LMS from Power Pivot. You will use the Table Import Wizard to load SAP SuccessFactors LMS. You can visually build the import query or use any SQL supported by the driver.
-
How to Visualize Freshdesk 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 Freshdesk in Python.
-
Integrating Antigravity CLI with Timely via CData CLI
Connect Timely to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous ClickTime Replication to SingleStore
Use CData Sync for automated, continuous, customizable ClickTime replication to SingleStore.
-
Connecting Moonlit Workflow with Asana 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 Asana in real time.
-
Integrating GetResponse Data in Talend Cloud Data Management Platform
Connect GetResponse Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create SingleStore-Connected Business Apps in AppSheet
Connect to SingleStore Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SingleStore.
-
Connect to Instantly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Instantly in the Denodo Virtual DataPort Administrator.
-
How to load Optimizely data into Elasticsearch via Logstash
Introducing a simple method to load Optimizely data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Adobe Commerce Data from Crystal Reports
Use CData Connect AI to connect to and report on live Adobe Commerce from Crystal Reports.
-
Excel Spreadsheet Automation on Airtable Data with the QUERY Formula
Pull data from Airtable, automate spreadsheets, and more with the QUERY formula.
-
Create Dynamic SAP Fieldglass Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Fieldglass to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy Desktop
Connect to Workday in MicroStrategy Desktop using the CData Software JDBC Driver for Workday.
-
Connect to Zoho Projects Data in Ruby
Connect to Zoho Projects in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData SSIS Components for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics CRM.
-
Integrate Unbounce Data in the Pentaho Report Designer
Publish reports based on Unbounce in the Pentaho BI tool.
-
Connect to and Visualize Live Quaderno Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Quaderno.
-
Extract, Transform, and Load Square Data in Informatica PowerCenter
Create a simple Workflow for Square in Informatica PowerCenter.