CData Software - Knowledge Base
Recent Articles
-
Access Live Azure Synapse Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Synapse from your Excel spreadsheets.
-
How to Create Power BI Visual Reports with Real-Time Twilio Data
Use CData Power BI Connectors to visualize Twilio in Power BI.
-
Extract, Transform, and Load Google Search Results in Informatica PowerCenter
Create a simple Workflow for Google Search in Informatica PowerCenter.
-
How to create HubSpot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HubSpot in MySQL .
-
Query Bugsnag Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Bugsnag and perform CRUD operations on Bugsnag from Node.js.
-
Build Zoho CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zoho CRM.
-
Integrating GitHub Copilot CLI with Act-On 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 EmailOctopus Data in Tableau
The CData ODBC driver for EmailOctopus enables you integrate EmailOctopus into Tableau dashboards.
-
Automated Continuous Basecamp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Basecamp replication to IBM DB2.
-
Build Apps with Live Moosend Data Using the Low-Code Development Platform of Mendix
Connect Moosend with Mendix to build apps using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with SQL Server Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft SQL Server.
-
Integrating Antigravity CLI with Mouseflow via CData CLI
Connect Mouseflow to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Dynamic REST Grids Using the Infragistics XamDataGrid
Learn how you can connect REST to Infragistics XamDataGrid to build dynamic grids.
-
How to Use a Microsoft Access Database to Update Stripe Data in Real Time
Update Stripe data by creating a linked table in Microsoft Access with the CData Stripe ODBC Driver.
-
Operational Reporting on Zoho Projects Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Projects.
-
Use the CData Software JDBC Driver for Harvest in MicroStrategy Desktop
Connect to Harvest in MicroStrategy Desktop using the CData Software JDBC Driver for Harvest.
-
Integrating Claude Code with Google Search Results via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Search within assisted coding and automated development workflows.
-
Oracle Eloqua Reporting Reporting in OBIEE with the Oracle Eloqua Reporting JDBC Driver
Deploy the Oracle Eloqua Reporting JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Write a Simple Go Application to work with MailerLite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailerLite.
-
How to integrate Metabase with Adobe Analytics Data
Use CData Connect AI to connect to live Adobe Analytics and create an interactive dashboard in Metabase from Adobe Analytics.
-
Connect to Tally Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Tally ERP using standard SQL.
-
Integrating OpenCode Terminal with Shippo 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.
-
Connect to Demio Data in RazorSQL
Connect to Demio from wizards and query Demio from the GUI in the RazorSQL database management tool.
-
Automate Typeform Data Replication to Couchbase
Use CData Sync to Customize and automate Typeform replication to Couchbase.
-
Object-Relational Mapping (ORM) with Workday 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 Workday into a Java-based ORM framework, Hibernate.
-
Integrate Real-Time Access to Okta in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Okta in real time.
-
Use the CData ODBC Driver for Foursquare in Microsoft Power Query
You can use the CData Foursquare ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Foursquare into Microsoft Power Query.
-
Replicate Float Data from PowerShell
Write a quick PowerShell script to query Float. Use connectivity to the live data to replicate Float to SQL Server.
-
Connect to SAP Concur Data in Aqua Data Studio
Access SAP Concur from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Theia IDE with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create a Data Access Object for Mocean Data using JDBI
A brief overview of creating a SQL Object API for Mocean in JDBI.
-
Connect to and Visualize Live Gong Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Gong.
-
Connect to Suadeo Data in Ruby
Connect to Suadeo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for ElevenLabs in MicroStrategy Desktop
Connect to ElevenLabs in MicroStrategy Desktop using the CData Software ODBC Driver for ElevenLabs.
-
Use Grok to Talk to Your Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Spanner for you.
-
Connect to Brex Data from a Connection Pool in Jetty
The Brex JDBC Driver supports connection pooling: This article shows how to connect faster to Brex from Web apps in Jetty.
-
Rapidly Develop Samanage-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 Samanage.
-
How to create OneNote federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft OneNote in MySQL .
-
Integrate with Klipfolio Data in JReport Designer
Create charts and reports based on Klipfolio in JReport Designer.
-
Visualize Live Power BI XMLA Data in the Power BI Service
Use CData Connect AI to connect to live Power BI XMLA and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Factorial Data in Pentaho Data Integration
Build ETL pipelines based on Factorial in the Pentaho Data Integration tool.
-
Build BambooHR-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live BambooHR Data in Claude Code to assist with building BambooHR-powered applications.
-
Access Live ConvertAPI Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a ConvertAPI data source in TIBCO Data Virtualization Studio and gain access to live ConvertAPI from your TDV Server.
-
Bind Live Billsby Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Billsby data
-
Replicate Gong Data from PowerShell
Write a quick PowerShell script to query Gong. Use connectivity to the live data to replicate Gong to SQL Server.
-
Connect to HubSpot Data in HULFT Integrate
Connect to HubSpot as a JDBC data source in HULFT Integrate
-
Access Live ServiceDesk Plus Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a ServiceDesk Plus data source in TIBCO Data Virtualization Studio and gain access to live ServiceDesk Plus from your TDV Server.
-
How to Create Power BI Visual Reports with Real-Time Discord Data
Use CData Power BI Connectors to visualize Discord in Power BI.
-
Jodoo Reporting in OBIEE with the Jodoo JDBC Driver
Deploy the Jodoo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Microsoft Dataverse Data to Multiple Databases
Replicate Microsoft Dataverse (CDS) to disparate databases with a point-and-click configuration.
-
Integrate Customer.io Data in Pentaho Data Integration
Build ETL pipelines based on Customer.io in the Pentaho Data Integration tool.
-
Migrating data from Delighted to Snowflake using CData SSIS Components.
Easily push Delighted to Snowflake using the CData SSIS Tasks for Delighted and Snowflake.
-
Connect to Cvent Data in DBeaver
Use the CData ODBC Driver to connect to Cvent in DBeaver.
-
How to Connect to Live Bullhorn CRM 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 Bullhorn CRM for you.
-
Consume IBM Cloud Object Storage OData Feeds in PowerBuilder
This article demonstrates how to consume IBM Cloud Object Storage as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData SSIS Components for XML
Complete guide to installing, licensing, and connecting with the CData SSIS Components for XML.
-
Build Dashboards with Aha! Data in DBxtra
Create dynamic dashboards and perform analytics based on Aha! in DBxtra.
-
Query SAP HANA XS Advanced Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP HANA XS Advanced from Node.js.
-
Visualize Lakebase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Lakebase.
-
Integrate Real-Time Access to Zoom in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoom in real time.
-
Configuring Oracle Autonomous Database as a CData Sync Destination
A basic guide to configuring Oracle Autonomous Database as a destination for enterprise replication in CData Sync.
-
View Reports on Real-Time Keap Data in Power BI Report Server
Use the CData ODBC Driver for Keap to visualize Keap in Power BI Desktop and then publish them to Power BI Report Server.
-
Explore Geographical Relationships in iContact Data with Power Map
Create data visualizations with iContact in Power Map.
-
Access Live SendInBlue Data in Coginiti Pro
Connect to and query live SendInBlue from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Cursor with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live DocuSign from within the editor.
-
Deploy the ADO.NET Provider for Odoo on an SSRS Report Server
Connect to Odoo ERP 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.
-
Access Live Redshift Data in Excel 365 Online (Excel for the web)
Connect to Amazon Redshift from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for Pipedrive in MicroStrategy Desktop
Connect to Pipedrive in MicroStrategy Desktop using the CData Software ODBC Driver for Pipedrive.
-
Work with Vercel Data in FoxPro
Load Vercel into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Work with ZohoExpense Data in ETL Validator JDBC
Connect to ZohoExpense from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish Salesforce CRM Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce CRM Analytics.
-
How to Build an ETL App for Sentry Data in Python with CData
Create ETL applications and real-time data pipelines for Sentry in Python with petl.
-
Edit and Search External SQL Analysis Services Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SQL Analysis Services to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SQL Analysis Services Data objects that you can access from apps and the dashboard.
-
Use Manus AI to Talk to Your BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on BigCommerce.
-
A PostgreSQL Interface for Cloudflare Data using the CData ODBC Driver
Use the SQL Gateway and Cloudflare ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Microsoft Ads in Microsoft Power Query
You can use the CData Microsoft Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Ads into Microsoft Power Query.
-
Create Reports from SQL Analysis Services Data in Looker Studio
Use CData Connect AI to gain access to live SQL Analysis Services and create custom reports in Looker Studio.
-
Use JayDeBeApi to access Amplitude Data in Python
Use standard Python scripting and the development environment of your choice to access live Amplitude.
-
Analyze Office 365 Data in Looker
Use CData Connect AI to connect to Office 365 Data from Looker and build custom apps using live Microsoft Office 365.
-
Extract, Transform, and Load Insightly Data in Informatica PowerCenter
Create a simple Workflow for Insightly in Informatica PowerCenter.
-
View Reports on Real-Time Okta Data in Power BI Report Server
Use the CData ODBC Driver for Okta to visualize Okta in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Microsoft Teams Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Teams to disparate databases with a single configuration.
-
How to Connect to Live GraphQL Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live GraphQL securely in real time.
-
Connect to ClickTime Data from a Connection Pool in JBoss
Integrate ClickTime into Java servlets: Use the Management Console in JBoss to install the ClickTime JDBC Driver.
-
Getting Started with the CData Excel Add-In for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Teams.
-
Automate HDFS Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache HDFS replication to Azure Data Lake.
-
Integrate Live Placid Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Placid to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Getting Started with the CData Python Connector for JSON
Learn to install and license the CData Python Connector
-
How to Connect DBeaver to ServiceNow via a JDBC Driver
Manage ServiceNow with visual tools in DBeaver like the query browser.
-
How to publish and share Amazon DynamoDB Data dashboards with Tableau Server
The CData ODBC driver for Amazon DynamoDB enables you integrate Amazon DynamoDB into Tableau dashboards.
-
Connect to Live FHIR Data in MicroStrategy through CData Connect AI
Create a live connection to FHIR Data in CData Connect AI and connect to your FHIR from MicroStrategy.
-
How to integrate TigerGraph with Apache Airflow
Access and process TigerGraph in Apache Airflow using the CData JDBC Driver.
-
Integrate with Zendesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zendesk to a JSON file on disk.
-
Integrate Act CRM Data in Pentaho Data Integration
Build ETL pipelines based on Act CRM in the Pentaho Data Integration tool.
-
How to Connect the Power BI Service to Sendwithus: Complete Guide
Connect to the CData Software Power BI Connector for Sendwithus from PowerBI.com to provide real-time Sendwithus across the organization.
-
DataBind Charts to GitLab Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to GitLab 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.
-
Getting Started with the CData JDBC Driver for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Twitter Ads.
-
How to Seamlessly Import LionDesk Data into IBM SPSS Modeler
Integrate LionDesk data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live ADP Data in Perplexity MacOS Desktop
Connect to and query live ADP Data in Perplexity Desktop using CData MCP Server.
-
Connect to Dynamics 365 Data in Aqua Data Studio
Access Microsoft Dynamics 365 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.