CData Software - Knowledge Base
Recent Articles
-
Integrate LibreChat with Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Quickbase from within the chat interface.
-
Build an OLAP Cube in SSAS from Webflow Data
Establish a connection to Webflow data from SQL Server Analysis Services, and use the Webflow Data Provider to build OLAP cubes for use in analytics and reporting.
-
View Reports on Real-Time LightSpeedRetail Data in Power BI Report Server
Use the CData ODBC Driver for LightSpeedRetail to visualize LightSpeedRetail in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous SuiteCRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Google BigQuery.
-
Bind Live OData Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live OData data
-
How to connect to Clio Data in DBVisualizer
Integrate Clio with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze QuickBooks Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze QuickBooks Desktop with the CData JDBC Driver for QuickBooks.
-
How to Work with Facebook Data in AWS Glue Jobs Using JDBC
Connect to Facebook from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Choosing the Best Method to Connect BigCommerce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use BigCommerce from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData JDBC Driver for Marketo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Marketo.
-
Connect to and Query Impala Data in QlikView over ODBC
Create data visualizations with Apache Impala in QlikView.
-
Build Neo4J-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Neo4J to explore live Neo4J Data in Gemini Code Assist to assist with building Neo4J-powered applications.
-
Automate ConstantContact Data Replication to SAP HANA
Use CData Sync to customize and automate ConstantContact replication to SAP HANA.
-
Connect to HubDB Data from a Connection Pool in JBoss
Integrate HubDB into Java servlets: Use the Management Console in JBoss to install the HubDB JDBC Driver.
-
Connect to Humanity from a Connection Pool in WebLogic
Use the CData JDBC Driver for Humanity to connect to Humanity from Web applications running on WebLogic.
-
Use Databricks Agent Bricks to Talk to Your SQL Server Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft SQL Server for you.
-
Analyze OneNote Data in Looker
Use CData Connect AI to connect to OneNote Data from Looker and build custom apps using live Microsoft OneNote.
-
How to load Bitly data into Elasticsearch via Logstash
Introducing a simple method to load Bitly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access GitHub Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access GitHub from your Oracle system.
-
Build Charts with Postmark Data in Clear Analytics
Create dynamic charts and perform analytics based on Postmark in Clear Analytics.
-
Integrate Theia IDE with Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Cursor CLI with Google Search Results 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.
-
Migrating data from Spark to Google BigQuery using CData SSIS Components.
Easily push Apache Spark SQL to Google BigQuery using the CData SSIS Tasks for Spark and Google BigQuery.
-
Configure the CData JDBC Driver for Float in a Connection Pool in Tomcat
Connect to Float from a connection pool in Tomcat.
-
Access Live SAS xpt Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAS XPORT from your Excel spreadsheets.
-
Enable the Facebook Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Facebook Ads.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Paylocity actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Amazon Athena Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon Athena replication to AlloyDB.
-
Visualize Live Deel Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Deel.
-
Import Real-Time Bugsnag Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bugsnag in ColdFusion.
-
Automated Continuous EmailOctopus Replication to IBM DB2
Use CData Sync for automated, continuous, customizable EmailOctopus replication to IBM DB2.
-
Use ChatGPT to Talk to Your Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Facebook for you.
-
Connect to Wrike from a Connection Pool in WebLogic
Use the CData JDBC Driver for Wrike to connect to Wrike from Web applications running on WebLogic.
-
Create SSAS Tabular Models from Mixpanel Data
How to build a SQL Server Analysis Service Tabular Model from Mixpanel using CData drivers.
-
Integrate Live MYOB AccountRight Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MYOB AccountRight and integrate live MYOB AccountRight into apps built in Microsoft Power Apps.
-
Publish Onfleet-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Onfleet.
-
Add ZeroBounce Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZeroBounce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Working with ElevenLabs Data in LINQPad
Execute LINQ queries to ElevenLabs in LINQPad.
-
How to Connect to Live Cassandra Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache Cassandra without replication.
-
Integrating Cosmos DB Data in Talend Cloud Data Management Platform
Connect Cosmos DB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Cosmos DB.
-
How to connect PolyBase to Rebilly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Rebilly.
-
How to Connect to & Open Microsoft Ads Data in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to and Visualize Live Attio Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Attio.
-
Automated Continuous EmailOctopus Replication to Vertica
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Vertica.
-
Access Live OpenWeatherMap Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate OpenWeatherMap into the statistical analysis tools available in SAS JMP. This article shows how to use OpenWeatherMap in the Graph Builder and Query Builder.
-
Moving Data from SAP SuccessFactors to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP SuccessFactors data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Query Live PayPal Data in Claude Desktop
Connect to and query live PayPal Data in Claude Desktop using CData MCP Server.
-
Working with Chargebee Data in LINQPad
Execute LINQ queries to Chargebee in LINQPad.
-
Create ZohoMarketingHub Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoMarketingHub from PowerBI.com to create Power BI Dataflows with real-time data.
-
Trigger Zoho CRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zoho CRM with standard wizards in Logic Apps.
-
Access Live Autopilot Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Autopilot in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Google Tasks Data in RapidMiner
Integrate Google Tasks with standard components and data source configuration wizards in RapidMiner Studio.
-
Deploy the ADO.NET Provider for GetResponse on an SSRS Report Server
Connect to GetResponse 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.
-
Build Charts with JotForm Data in Clear Analytics
Create dynamic charts and perform analytics based on JotForm in Clear Analytics.
-
Moving Data from SurveyMonkey to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SurveyMonkey data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Import Couchbase Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Couchbase Data and provide access to live Couchbase for custom reports in the Power BI Service.
-
Automated Continuous Salesforce Marketing Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to SingleStore.
-
Integrate with live Oracle Eloqua Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle Eloqua in Jitterbit.
-
Connect to Access Data in Ruby
Connect to Microsoft Access in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software JDBC Driver for HBase in MicroStrategy Web
Connect to Apache HBase in MicroStrategy Web using the CData Software JDBC Driver for HBase.
-
Query Float Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Float from Node.js.
-
Query Mistral AI Data in DataGrip
Create a Data Source for Mistral AI in DataGrip and use SQL to query live Mistral AI.
-
DataBind Sage 300 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Sage 300 with the DevExpress Windows Forms and Web controls to provide Sage 300 to a chart.
-
How to Connect to GraphQL Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to GraphQL. Leverage the pyodbc module for ODBC in Python.
-
ETL JobNimbus in Oracle Data Integrator
This article shows how to transfer JobNimbus into a data warehouse using Oracle Data Integrator.
-
Analyze Tally Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Tally ERP and visualize live Tally ERP in Infragistics Reveal.
-
Replicate Azure Data Catalog Data from PowerShell
Write a quick PowerShell script to query Azure Data Catalog. Use connectivity to the live data to replicate Azure Data Catalog to SQL Server.
-
Integrating Claude Code with Azure Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Azure Analysis Services within assisted coding and automated development workflows.
-
Access Dynamics 365 Data from MySQL in Amazon QuickSight
Connect to Dynamics 365 and build visualizations of Microsoft Dynamics 365 using a MySQL Connection in Amazon QuickSight.
-
Manage LionDesk Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LionDesk.
-
Integrating Claude Code with Twilio Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Twilio within assisted coding and automated development workflows.
-
How to connect to Microsoft Entra ID Data from IntelliJ
Integrate connectivity to Microsoft Entra ID with wizards in IntelliJ.
-
Connect to HBase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for HBase and the Script function in FileMaker Pro to connect to HBase and work with Apache HBase in your FileMaker application.
-
Getting Started with the CData ADO.NET Provider for SendPulse
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to SageHR Data from PowerBuilder via JDBC
This article demonstrates how to access SageHR from PowerBuilder using the SageHR JDBC Driver.
-
Use the CData Software ODBC Driver for Microsoft Ads in MicroStrategy Desktop
Connect to Microsoft Ads in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Ads.
-
Visualize Live Google Drive Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Drive.
-
Import Azure Synapse Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Azure Synapse. In this article, you will use the OData format to import Azure Synapse into Microsoft Power Query.
-
Automated Continuous Drip Replication to Oracle
Use CData Sync for automated, continuous, customizable Drip replication to Oracle.
-
Use the CData Software JDBC Driver for PolarTeamPro in MicroStrategy
Connect to PolarTeamPro in MicroStrategy Developer using the CData Software JDBC Driver for PolarTeamPro.
-
Use the CData Software JDBC Driver for Dynamics NAV in MicroStrategy Desktop
Connect to Microsoft Dynamics NAV in MicroStrategy Desktop using the CData Software JDBC Driver for Dynamics NAV.
-
Connect to Microsoft Teams Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Teams from Crystal Reports.
-
Automated Continuous ClickTime Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ClickTime replication to Google Cloud SQL.
-
A PostgreSQL Interface for ConvertAPI Data using the CData ODBC Driver
Use the SQL Gateway and ConvertAPI ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Paylocity Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Paylocity for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Quickbase
Provide connectivity to Quickbase through an SAP BusinessObjects universe.
-
Connect to Real-Time XML Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for XML and Dataflow to import and use XML Files in Power Apps.
-
How to integrate Marketo with Apache Airflow
Access and process Marketo in Apache Airflow using the CData JDBC Driver.
-
Email Reporting in OBIEE with the Email JDBC Driver
Deploy the Email JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Semantic Layer Views for SAP Netweaver Gateway Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Netweaver Gateway.
-
Create AfterShip Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time AfterShip data access from reports, embedded analytics, and more.
-
How to Connect to Live Workday 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 Workday for you.
-
Connect to Dynamics 365 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics 365.
-
Automate Tasks in Power Automate Using the CData API Server
Automate BigQuery actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Oracle Eloqua Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Eloqua from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Eloqua.
-
Create Apps from Sage Intacct Data in Qlik Sense Cloud
Use CData Connect AI to connect to Sage Intacct Data and build apps from live Sage Intacct in Qlik Sense Cloud.
-
Connect to Customer.io Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Customer.io using standard SQL.
-
Build Semantic Layer Views for Facebook Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Facebook.
-
Rapidly Develop VWO-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 VWO.
-
Integrate Notion Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Notion from Informatica Cloud.