CData Software - Knowledge Base
Recent Articles
-
Load HBase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HBase data to a database.
-
How to load Teradata data into Elasticsearch via Logstash
Introducing a simple method to load Teradata data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live Phoenix Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Phoenix data without replication.
-
Build Semantic Layer Views for Zendesk Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zendesk data.
-
Connect to Brex Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Brex data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Google Tasks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Tasks replication to IBM DB2.
-
Use the CData ODBC Driver for FHIR from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FHIR to connect to FHIR data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FHIR data in Excel.
-
Build SageHR-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SageHR Data and create custom apps in Mendix.
-
Automated Continuous Access Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Access replication to Apache Cassandra.
-
Integrating LlamaIndex with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Certinia data in real time.
-
Import Real-Time Foursquare Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Foursquare data in ColdFusion.
-
Connect to and Query ZohoPeople Data in QlikView over ODBC
Create data visualizations with ZohoPeople data in QlikView.
-
Use the CData Software JDBC Driver for ScrapingBee in MicroStrategy Desktop
Connect to ScrapingBee data in MicroStrategy Desktop using the CData Software JDBC Driver for ScrapingBee.
-
Connecting Agentforce with MailChimp 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 MailChimp data for you.
-
Automated Continuous Pipedrive Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pipedrive replication to SingleStore.
-
Build Charts with Zoho CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoho CRM data in Clear Analytics.
-
Build Gmail Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Gmail data and build visualizations in Tableau Cloud.
-
Query Live Pipedrive Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Pipedrive data directly from the development environment.
-
Getting Started with the CData Tableau Connector for Contentful
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData ODBC Driver for Drip in Microsoft Power Query
You can use the CData Drip ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Drip data into Microsoft Power Query.
-
Choosing the Best Method to Connect DB2 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use DB2 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Manus AI to Talk to Your Quickbase 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 Quickbase data.
-
How to Connect to Live Google Ads Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Ads data through natural language.
-
Replicate Multiple Onfleet Accounts via the CData Sync CLI
Replicate multiple Onfleet accounts to one or many databases.
-
Automated Continuous Spotify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Spotify replication to PostgreSQL.
-
Integrating Gumloop with Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Twitter Ads data within automated workflows.
-
How to Connect to Mocean Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mocean data. Leverage the pyodbc module for ODBC in Python.
-
Working with ConstantContact Data in LINQPad
Execute LINQ queries to ConstantContact data in LINQPad.
-
Publish Brex-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Brex data.
-
Access Chargebee Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Chargebee data from your Oracle system.
-
Build MVC Applications with Connectivity to CouchDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CouchDB from an ASP.NET MVC application.
-
Work with Oracle Sales Data in FoxPro
Load Oracle Sales data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Bugsnag Data in RazorSQL
Connect to Bugsnag from wizards and query Bugsnag data from the GUI in the RazorSQL database management tool.
-
Use the CData ODBC Driver for Adobe Commerce in Microsoft Power Query
You can use the CData Adobe Commerce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Commerce data into Microsoft Power Query.
-
Connect to Zoho Creator Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Creator as an External Source in Dremio.
-
Connecting Mastra with SAP HANA XS Advanced Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP HANA XS Advanced data, no replication required.
-
Access Oracle Eloqua Reporting Data from MySQL in Amazon QuickSight
Connect to Oracle Eloqua Reporting and build visualizations of Oracle Eloqua Reporting data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Rebilly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Rebilly replication to Azure SQL Database.
-
Enable the Moosend JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Moosend data.
-
How to Connect Flowise AI Agents to Live MariaDB Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live MariaDB data without replication.
-
Use Claude to Talk to Your Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Zoho Inventory data for you.
-
Model AlloyDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and AlloyDB, enabling the direct import of real-time AlloyDB data.
-
Connect and Visualize Live Paylocity Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Paylocity data into the Databricks platform and create visualization dashboards with real-time Paylocity data.
-
Connecting Moonlit Workflow with MongoDB 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 MongoDB data in real time.
-
Model, Search, and Visualize Live Shopify Data in ThoughtSpot
Use CData Connect AI to connect to live Shopify data for modeling, searching, and visualizing.
-
Getting Started with the CData Excel Add-In for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for YouTube Analytics.
-
Analyze Microsoft Entra ID Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Entra ID data and visualize Microsoft Entra ID data in SAP Analytics Cloud.
-
DataBind Productboard Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Productboard data to a chart.
-
Viewing Front Data in RAD Studio Data Explorer
How to view Front data in RAD Studio Data Explorer using the CData ODBC Driver for Front.
-
Connect to Oracle Sales Data in HULFT Integrate
Connect to Oracle Sales as a JDBC data source in HULFT Integrate
-
Build MVC Applications with Connectivity to CircleCI Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CircleCI from an ASP.NET MVC application.
-
Work with Sugar CRM Data in FoxPro
Load Sugar CRM data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Operational Reporting on MailerSend Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MailerSend data.
-
Access Live Oracle Sales Data in TIBCO Data Virtualization
Use the Oracle Sales Tibco DV Adapter to create a Oracle Sales data data source in TIBCO Data Virtualization Studio and gain access to live Oracle Sales data from your TDV Server.
-
Use Dash to Build to Web Apps on ClickUp Data
Create Python applications that use pandas and Dash to build ClickUp-connected web apps.
-
Automated Continuous Pingdom Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pingdom replication to Apache Kafka.
-
Getting Started with the CData ADO.NET Provider for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Synapse.
-
Create Dynamic GraphQL Grids Using the Infragistics XamDataGrid
Learn how you can connect GraphQL to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData ODBC Driver for Confluence in Microsoft Power Query
You can use the CData Confluence ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Confluence data into Microsoft Power Query.
-
How to connect and process PDFMonkey data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PDFMonkey data.
-
Work with Recurly Data in FoxPro
Load Recurly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Pushbullet Data in ColdFusion
Write standard ColdFusion data access code to connect to Pushbullet data.
-
Create Apollo-Connected Dashboards in Grafana
Connect to Apollo Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apollo data.
-
Getting Started with the CData SSIS Components for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData SSIS Components for QuickBooks Online.
-
Automated Continuous Azure Synapse Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Databricks.
-
Integrate Google's Vertex AI Agent with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho Creator data within intelligent workflows.
-
How to Query Live OnePageCrm Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live OnePageCrm data data in natural language using Python.
-
Connect to SAP SuccessFactors LMS Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP SuccessFactors LMS.
-
Automated Continuous ZohoSubscriptions Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Snowflake.
-
Analyze HubSpot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HubSpot from Power Pivot. You will use the Table Import Wizard to load HubSpot data. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Mailjet Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Mailjet data through MCP integration.
-
Connect to Drip Data from PowerBuilder via ADO.NET
This article demonstrates how to access Drip data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Data Flows from Excel Online to SQL Server using SSIS
Easily back up Excel Online data to SQL Server using the SSIS components for Excel Online.
-
Link Dotmailer with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Dotmailer data in Filemaker Pro for Mac or Windows.
-
Build a Singer.io Tap for Nuclia With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Nuclia data using the CData Python Connector.
-
Connect to TaxJar Data from AWS Glue
Use CData Connect AI to gain access to live TaxJar data from your AWS Glue jobs.
-
Create SSAS Tabular Models from ChartMogul Data
How to build a SQL Server Analysis Service Tabular Model from ChartMogul data using CData drivers.
-
Connect to Redshift from a Connection Pool in WebLogic
Use the CData JDBC Driver for Redshift to connect to Redshift data from Web applications running on WebLogic.
-
How to Connect to Qualaroo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Qualaroo data. Leverage the pyodbc module for ODBC in Python.
-
Visualize LinkedIn Data in TIBCO Spotfire through ADO.NET
Integrate LinkedIn data into dashboards in TIBCO Spotfire.
-
Connecting Agentforce with ZohoInvoice 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 ZohoInvoice data for you.
-
How to Connect Flowise AI Agents to Live Google Forms Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Forms data without replication.
-
Build a Simple VCL Application for Reckon Data
How to build a simple VCL Application to view Reckon data in RAD Studio using the CData ODBC Driver for Reckon.
-
Create Dynamic Hugging Face Grids Using the Infragistics XamDataGrid
Learn how you can connect Hugging Face to Infragistics XamDataGrid to build dynamic grids.
-
Migrating data from SAP Business Warehouse to Databricks using CData SSIS Components.
Easily push SAP Business Warehouse data to Databricks using the CData SSIS Tasks for SAP Business Warehouse and Databricks.
-
Use Grok to Talk to Your Amazon S3 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 Amazon S3 data for you.
-
Build Zoho CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho CRM data and build visualizations in Tableau Cloud.
-
Replicate SendPulse Data in Heroku for Use in Salesforce Connect
Replicate SendPulse data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software JDBC Driver for SAP Business One in MicroStrategy
Connect to SAP Business One data in MicroStrategy Developer using the CData Software JDBC Driver for SAP Business One.
-
Build Dashboards with Timely Data in DBxtra
Create dynamic dashboards and perform analytics based on Timely data in DBxtra.
-
Automated Continuous Pushbullet Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pushbullet replication to delimited files (CSV/TSV).
-
How to connect SharePoint with Spark Data through external lists
Provide Spark data to SharePoint users as an external list.
-
Create MailChimp-Connected Business Apps in AppSheet
Connect to MailChimp Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MailChimp data.
-
Analyze Oracle Eloqua Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Eloqua from Power Pivot. You will use the Table Import Wizard to load Oracle Eloqua data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Okta Data in Sisense
Create an ElastiCube in Sisense app with access to Okta data.
-
Extract, Transform, and Load ConvertKit Data in Informatica PowerCenter
Create a simple Workflow for ConvertKit data in Informatica PowerCenter.
-
Replicate Multiple OpenWeatherMap Accounts
Replicate multiple OpenWeatherMap accounts to one or many databases.
-
Integrating Salesforce Marketing Data in Talend Cloud Data Management Platform
Connect Salesforce Marketing Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Salesforce Marketing.
-
How to Connect Flowise AI Agents to Live WooCommerce Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live WooCommerce data without replication.
-
How to connect to Epicor Kinetic Data from IntelliJ
Integrate connectivity to Epicor Kinetic data with wizards in IntelliJ.