CData Software - Knowledge Base
Recent Articles
-
Connect to ZohoSubscriptions Data in JRuby
Create a simple JRuby app with access to live ZohoSubscriptions data.
-
Analyze Perigon Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Perigon from Power Pivot. You will use the Table Import Wizard to load Perigon data. You can visually build the import query or use any SQL supported by the driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho Books
Provide connectivity to Zoho Books data through an SAP BusinessObjects universe.
-
Connect to SurveyMonkey Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SurveyMonkey data in the Denodo Virtual DataPort Administrator.
-
How to Seamlessly Import Paymo Data into IBM SPSS Modeler
Integrate Paymo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to IBM Informix Data from Crystal Reports
Use CData Connect AI to connect to and report on live IBM Informix data from Crystal Reports.
-
Use the CData Software ODBC Driver for OnePageCrm in MicroStrategy Web
Connect to OnePageCrm data in MicroStrategy Web using the CData Software ODBC Driver for OnePageCrm.
-
HubDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to HubDB data through CData Connect AI using different applications and tools.
-
Getting Started with the CData ODBC Driver for Kintone
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Kintone.
-
Access PolarTeamPro Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PolarTeamPro data from HeidiSQL.
-
Connecting Agentforce with MariaDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your MariaDB data for you.
-
Visualize Live Wave Financial Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Wave Financial data into custom reports in Power BI.
-
Connect to Bannerbear Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Bannerbear data using standard SQL.
-
Connect to AgileCRM Data from a Connection Pool in Jetty
The AgileCRM JDBC Driver supports connection pooling: This article shows how to connect faster to AgileCRM data from Web apps in Jetty.
-
Automated Continuous ADP Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ADP replication to AlloyDB.
-
Create a Data Access Object for Workable Data using JDBI
A brief overview of creating a SQL Object API for Workable data in JDBI.
-
Connect to and Query Factorial Data in QlikView over ODBC
Create data visualizations with Factorial data in QlikView.
-
Analyze Paymo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Paymo data and visualize Paymo data in SAP Analytics Cloud.
-
Deploying CData Sync in a Kubernetes Environment
Deploy CData Sync in a Containerized Kubernetes Environment.
-
Model SAP HANA XS Advanced Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP HANA XS Advanced, enabling the direct import of real-time SAP HANA XS Advanced data.
-
How to Query Live SFTP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SFTP data data in natural language using Python.
-
Build AI/ML Models with Live SAP HANA Data using Dataiku
Connect SAP HANA Data with Dataiku using the CData JDBC Driver for SAP HANA.
-
Write a Simple Go Application to work with Omnisend Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Omnisend data.
-
Connect to CSV Data in CloverDX (formerly CloverETL)
Transfer CSV data using the visual workflow in the CloverDX data integration tool.
-
Connect to RSS from a Connection Pool in WebLogic
Use the CData JDBC Driver for RSS to connect to RSS feeds from Web applications running on WebLogic.
-
Access Live Azure Data Lake Storage Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Data Lake Storage data from your Excel spreadsheets.
-
Model SQL Analysis Services Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SQL Analysis Services, enabling the direct import of real-time SQL Analysis Services data.
-
Integrate MailerSend with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MailerSend with External Services.
-
Visualize Strava Data in TIBCO Spotfire through ADO.NET
Integrate Strava data into dashboards in TIBCO Spotfire.
-
Integrate Live SparkPost Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SparkPost data from within the IDE.
-
Analyze LDAP Objects in Cognos Analytics
Use CData Connect AI to connect to LDAP Objects from Cognos Analytics and analyze live LDAP objects.
-
Automated Instantly Data Replication to Teradata
Use CData Sync to Customize and automate Instantly data replication to Teradata.
-
Visualize Live Salesforce Marketing Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce Marketing data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Goose with Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live CouchDB data from within the local AI agent.
-
Use Dash to Build Web Apps on Bitly Data via CData Connect AI
Build interactive Dash web apps on live Bitly data using pandas and the CData Connect AI Python SDK.
-
Build ActiveCampaign-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ActiveCampaign data.
-
Query Brex Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Brex data from Node.js.
-
Build Agents in Relevance AI with Access to Live Mailgun Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Mailgun data within intelligent agent workflows.
-
Automated Continuous eBay Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable eBay replication to Google Cloud SQL.
-
Automated Continuous Slack Replication to SQL Server
Use CData Sync for automated, continuous, customizable Slack replication to SQL Server.
-
Explore Geographical Relationships in Bugsnag Data with Power Map
Create data visualizations with Bugsnag data in Power Map.
-
Getting Started with the CData Tableau Connector for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Bullhorn CRM.
-
Oracle HCM Cloud Reporting in OBIEE with the Oracle HCM Cloud JDBC Driver
Deploy the Oracle HCM Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build PingOne-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live PingOne data without replication.
-
How to connect Amazon QuickSight to Microsoft OneDrive Data
Create a connection to Microsoft OneDrive data in CData Connect AI and insert Microsoft OneDrive data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating LangChain with LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on LinkedIn data within automated workflows.
-
Design BIRT Reports on LightSpeedRetail Data
Provide current LightSpeedRetail data to your embedded analytics.
-
Connect to MongoDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MongoDB data in Airbyte.
-
Replicate Mistral AI Data from PowerShell
Write a quick PowerShell script to query Mistral AI data. Use connectivity to the live data to replicate Mistral AI data to SQL Server.
-
Build an OLAP Cube in SSAS from Microsoft OneDrive Data
Establish a connection to Microsoft OneDrive data data from SQL Server Analysis Services, and use the Microsoft OneDrive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Consume SAP OData Feeds in PowerBuilder
This article demonstrates how to consume SAP data as OData feeds from PowerBuilder using the API Server.
-
Establish a Live Connection with Procore Data using Tableau Bridge
The CData ODBC Driver for Procore enables you to integrate live Procore data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to and Visualize Live Teradata Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Teradata data.
-
Connect to Mixpanel Data in DBeaver
Use the CData ODBC Driver to connect to Mixpanel data in DBeaver.
-
Use the CData ODBC Driver for Bitbucket in Microsoft Power Query
You can use the CData Bitbucket ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bitbucket data into Microsoft Power Query.
-
Connect to Invoiced Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Invoiced and work with Invoiced data in your FileMaker applications.
-
Automated Continuous Figshare Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Figshare replication to Amazon Redshift.
-
Use the CData Software ODBC Driver for MessageBird in SAS for Real-Time Reporting and Analytics
Connect to real-time MessageBird data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MessageBird.
-
Integrate Open WebUI with Live ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ZohoExpense data from within the chat interface.
-
Visualize PabblySubscriptions Data in Tableau
The CData ODBC driver for PabblySubscriptions enables you integrate PabblySubscriptions data into Tableau dashboards.
-
Build a Simple VCL Application for MailerLite Data
How to build a simple VCL Application to view MailerLite data in RAD Studio using the CData ODBC Driver for MailerLite.
-
Visualize Klipfolio Data in Tableau
The CData ODBC driver for Klipfolio enables you integrate Klipfolio data into Tableau dashboards.
-
Access Live SAP ByDesign Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP ByDesign data from your Excel spreadsheets.
-
Integrate with live Salesforce Pardot Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce Pardot data in Jitterbit.
-
Connecting Moonlit Workflow with Azure Analysis Services 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 Analysis Services data in real time.
-
Replicate Google Translate Data to Multiple Databases
Replicate Google Translate data to disparate databases with a point-and-click configuration.
-
Use the CData Software JDBC Driver for YouTube Analytics in MicroStrategy Web
Connect to YouTube Analytics data in MicroStrategy Web using the CData Software JDBC Driver for YouTube Analytics.
-
Use Dash to Build to Web Apps on FreeAgent Data
Create Python applications that use pandas and Dash to build FreeAgent-connected web apps.
-
Search External Timely Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Timely data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Timely Data objects that you can access from apps and the dashboard.
-
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.
-
Use the CData Software JDBC Driver for DocuSign in MicroStrategy
Connect to DocuSign data in MicroStrategy Developer using the CData Software JDBC Driver for DocuSign.
-
Automate Adobe Target Data Replication to Azure Synapse
Use CData Sync to customize and automate Adobe Target data replication to Azure Synapse.
-
Visualize Live Adobe Target Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Target data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting Agentforce with Google Campaign Manager 360 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google Campaign Manager 360 data for you.
-
Use Dash to Build to Web Apps on Jira Data
Create Python applications that use pandas and Dash to build Jira-connected web apps.
-
Connect to MongoDB Data in CloverDX (formerly CloverETL)
Transfer MongoDB data using the visual workflow in the CloverDX data integration tool.
-
Connect to GitHub Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live GitHub data.
-
Natively Connect to BigQuery Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to BigQuery data. Leverage the native support for ODBC in PHP.
-
Visualize Avro Data in Sisense
Create an ElastiCube in Sisense app with access to Avro data.
-
Use the CData ODBC Driver for YouTube Analytics in Microsoft Power Query
You can use the CData YouTube Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import YouTube Analytics data into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy
Connect to Dynamics 365 data in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics 365.
-
Getting Started with the CData Connect AI Python SDK for ServiceDesk Plus
Install the CData Connect AI Python SDK to read live ServiceDesk Plus data with standard DB-API 2.0 Python code.
-
Create RabbitMQ Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time RabbitMQ data access from reports, embedded analytics, and more.
-
Integrate Miro with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Miro with External Services.
-
Connect to NetSuite Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live NetSuite data.
-
Automate Grafana Data Replication to Azure Data Lake
Use CData Sync to customize and automate Grafana data replication to Azure Data Lake.
-
Connect to Tally Data in NetBeans
Connect to Tally data in NetBeans with the data source configuration wizard.
-
Integrate Azure Data Lake Storage with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Data Lake Storage with External Services.
-
Query Procore Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Procore data from Node.js.
-
Analyze Cvent Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Cvent data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Easily Integrate Insightly Data in Lazarus Pascal IDE
Learn how to easily integrate live Insightly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Power BI Reports on Real-Time MailerSend Data
Use the CData ODBC Driver for MailerSend to visualize MailerSend data in Power BI Desktop.
-
Connect to QuickBooks Online Data in RapidMiner
Integrate QuickBooks Online data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SQL Analysis Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SQL Analysis Services data in the Denodo Virtual DataPort Administrator.
-
Integrate Live MYOB AccountRight Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MYOB AccountRight data and integrate live MYOB AccountRight data 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 data.
-
Getting Started with the CData ODBC Driver for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Recruit.
-
Automated Continuous Google Sheets Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Sheets replication to Apache Kafka.
-
Connect to Reckon Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon data.
-
Use the CData ODBC Driver for Presto in Microsoft Power Query
You can use the CData Presto ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Presto data into Microsoft Power Query.