CData Software - Knowledge Base
Recent Articles
-
How to integrate Metabase with SAP Hybris C4C Data
Use CData Connect AI to connect to live SAP Hybris C4C data and create an interactive dashboard in Metabase from SAP Hybris C4C data.
-
Connect to Xero Data from a Connection Pool in Jetty
The Xero JDBC Driver supports connection pooling: This article shows how to connect faster to Xero data from Web apps in Jetty.
-
Build Charts with OneNote Data in Clear Analytics
Create dynamic charts and perform analytics based on OneNote data in Clear Analytics.
-
Integrate Cosmos DB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cosmos DB with External Services.
-
Automated Continuous Attio Replication to MySQL
Use CData Sync for automated, continuous, customizable Attio replication to MySQL.
-
Automate iContact Data Replication to Azure Data Lake
Use CData Sync to customize and automate iContact data replication to Azure Data Lake.
-
How to import Couchbase Data into Apache Solr
Use the CData Software JDBC Driver for Couchbase in Data Import Handler and create an automated import of Couchbase data to Apache Solr Enterprise Search platform.
-
Natively Connect to Printful Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Printful data. Leverage the native support for ODBC in PHP.
-
Use Agno to Talk to Your ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your ServiceDesk Plus data for you.
-
How to connect PolyBase to Gorgias
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Gorgias data.
-
Create Power BI Reports on Real-Time Miro Data
Use the CData ODBC Driver for Miro to visualize Miro data in Power BI Desktop.
-
Working with Splunk Data in LINQPad
Execute LINQ queries to Splunk data in LINQPad.
-
Connecting Pipedream with Google Forms Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Forms data in real time.
-
How to Connect to Live FHIR 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 FHIR data through natural language.
-
How to create ConvertKit federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ConvertKit data in MySQL .
-
A PostgreSQL Interface for Act CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Act CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to PayPal Data from a Connection Pool in JBoss
Integrate PayPal data into Java servlets: Use the Management Console in JBoss to install the PayPal JDBC Driver.
-
How to Visualize OData Data in Python with pandas
Use pandas and other modules to analyze and visualize live OData services in Python.
-
Use Agno to Talk to Your Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Ads data for you.
-
Access Live Azure Data Catalog 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 Azure Data Catalog data through MCP integration.
-
How to import Power BI XMLA Data into Apache Solr
Use the CData Software JDBC Driver for Power BI XMLA in Data Import Handler and create an automated import of Power BI XMLA data to Apache Solr Enterprise Search platform.
-
Build Automated Pinterest-Connected Workflows in Zapier
Use CData Connect AI to connect to live Pinterest data and build automated workflows in Zapier.
-
Integrate Real-Time Access to ShipStation in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to ShipStation data in real time.
-
Automated Continuous Couchbase Replication to Vertica
Use CData Sync for automated, continuous, customizable Couchbase replication to Vertica.
-
Analyze Zoho Projects Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Projects Data from Cognos Analytics and analyze live Zoho Projects data.
-
Query CapsuleCRM Data in DataGrip
Create a Data Source for CapsuleCRM in DataGrip and use SQL to query live CapsuleCRM data.
-
Analyze Lakebase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Lakebase data and visualize live Lakebase data in Infragistics Reveal.
-
Integrate with Live PingOne Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to PingOne from the MuleSoft Anypoint Platform to integrate live PingOne data into custom reports and dashboards.
-
Use the CData Software ODBC Driver for Impala in MicroStrategy Desktop
Connect to Impala data in MicroStrategy Desktop using the CData Software ODBC Driver for Impala.
-
Create SSAS Tabular Models from Customer.io Data
How to build a SQL Server Analysis Service Tabular Model from Customer.io data using CData drivers.
-
Automated Continuous Active Directory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Active Directory replication to Google BigQuery.
-
Access Presto Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Presto data from HeidiSQL.
-
Build a Singer.io Tap for ConstantContact With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ConstantContact data using the CData Python Connector.
-
Connect to and Visualize Live Sage 200 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 200 data.
-
Access Live Moosend 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 Moosend data through MCP integration.
-
Analyze Act CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Act CRM from Power Pivot. You will use the Table Import Wizard to load Act CRM data. You can visually build the import query or use any SQL supported by the driver.
-
How to Query Datadog Data in MySQL Workbench
Execute MySQL queries against live Datadog data from MySQL Workbench.
-
Access Live Google Campaign Manager 360 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Campaign Manager 360 data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Tally Data in RapidMiner
Integrate Tally data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Apollo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Apollo replication to Apache Cassandra.
-
Integrate Live Twitter Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Twitter Ads data and integrate live Twitter Ads data into apps built in Microsoft Power Apps.
-
How to Work with MySQL Data in ETL Validator JDBC
Connect to MySQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Tavily-Connected Business Apps in AppSheet
Connect to Tavily Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Tavily data.
-
Create Sage 200-Connected Applications in Appsmith
Connect to Sage 200 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sage 200 data.
-
Trigger Reckon Accounts Hosted IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Reckon Accounts Hosted with standard wizards in Logic Apps.
-
Use Microsoft Copilot Studio to talk to your SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SQL Server data for you.
-
Consume Google Spanner OData Feeds in PowerBuilder
This article demonstrates how to consume Google Spanner data as OData feeds from PowerBuilder using the API Server.
-
Access Klaviyo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Klaviyo data from your Oracle system.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Retently
Provide connectivity to Retently data through an SAP BusinessObjects universe.
-
Integrate CSV with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CSV with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CSV data.
-
Replicate Multiple Tavily Accounts via the CData Sync CLI
Replicate multiple Tavily accounts to one or many databases.
-
Stream Exact Online Data into Apache Kafka Topics
Access and stream Exact Online data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Power BI Connector for Testmonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Freshteam
Provide connectivity to Freshteam data through an SAP BusinessObjects universe.
-
Integrate Trae with Live ZohoDesk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ZohoDesk data from within the AI-powered IDE.
-
Use Azure AI Foundry to Talk to Your BambooHR 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 BambooHR data for you.
-
Connect to FreeAgent Data in Ruby
Connect to FreeAgent data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Microsoft Copilot Studio to talk to your MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your MailerLite data for you.
-
Build a Simple VCL Application for EnterpriseDB Data
How to build a simple VCL Application to view EnterpriseDB data in RAD Studio using the CData ODBC Driver for EnterpriseDB.
-
Build Teamgate-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Teamgate data and build web apps with connectivity to live Teamgate data.
-
Build Airtable Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Airtable data and build visualizations in Tableau Cloud.
-
Connect to PabblySubscriptions from Asprova with CData Software ODBC Driver for PabblySubscriptions
This article shows how to connect faster to PabblySubscriptions data from Asprova.
-
DataBind Databricks Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Databricks with the DevExpress Windows Forms and Web controls to provide Databricks data to a chart.
-
Build Landbot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Landbot data and build web apps with connectivity to live Landbot data.
-
Model, Search, and Visualize Live Azure Table Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Table data for modeling, searching, and visualizing.
-
Integrate Cline with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Exchange data from within your IDE.
-
How to import Flowlu Data into Apache Solr
Use the CData Software JDBC Driver for Flowlu in Data Import Handler and create an automated import of Flowlu data to Apache Solr Enterprise Search platform.
-
Automated Continuous Mistral AI Replication to Vertica
Use CData Sync for automated, continuous, customizable Mistral AI replication to Vertica.
-
Automated Continuous Xero Replication to Snowflake
Use CData Sync for automated, continuous, customizable Xero replication to Snowflake.
-
Automated Continuous GraphQL Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable GraphQL replication to PostgreSQL.
-
Use Biml to Build SSIS Tasks to Replicate Missive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Missive data to SQL Server.
-
Connect to Bitly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Bitly and work with Bitly data in your FileMaker application.
-
How to Use a Microsoft Access Database to Update REST Data in Real Time
Update REST data by creating a linked table in Microsoft Access with the CData REST ODBC Driver.
-
Create Apps from Google Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Ads Data and build apps from live Google Ads data in Qlik Sense Cloud.
-
Access Live Power BI XMLA Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Power BI XMLA data from your Google Sheets.
-
Connect to Eventbrite Data in RapidMiner
Integrate Eventbrite data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Power BI Connector for TaxJar
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for TaxJar.
-
How to Connect to Printify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Printify data. Leverage the pyodbc module for ODBC in Python.
-
How to connect PolyBase to Zoho Inventory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Inventory data.
-
Explore Geographical Relationships in Cloudant Data with Power Map
Create data visualizations with Cloudant data in Power Map.
-
Use Databricks Agent Bricks to Talk to Your SparkPost Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SparkPost data for you.
-
Connect to Wrike Data from PowerBuilder via ADO.NET
This article demonstrates how to access Wrike data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Live WooCommerce 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 WooCommerce data through natural language.
-
Consume Pipedrive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Pipedrive feeds that reflect any changes in SAP Lumira.
-
Prepare, Blend, and Analyze Dropbox Data in Alteryx Designer (ODBC)
Build workflows to access live Dropbox data for self-service data analytics.
-
Getting Started with the CData Excel Add-In for ClickUp
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ClickUp.
-
How to Visualize Slack Data in Python with pandas
Use pandas and other modules to analyze and visualize live Slack data in Python.
-
Connect to OneNote Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to OneNote.
-
Connect to Facebook Ads Data in RapidMiner
Integrate Facebook Ads data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Live SAP Business One Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Business One data securely in real time.
-
Automated Continuous Front Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Front replication to AlloyDB.
-
Visualize Live Freshservice Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Freshservice data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Write a Simple Go Application to work with Foursquare Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Foursquare data.
-
Link iContact with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate iContact data in Filemaker Pro for Mac or Windows.
-
Analyze Sugar CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sugar CRM data in Microsoft R Open.
-
Access Live MarkLogic 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 MarkLogic data through MCP integration.
-
How to Connect to Xero Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Xero data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Mouseflow from a Connection Pool in WebLogic
Use the CData JDBC Driver for Mouseflow to connect to Mouseflow data from Web applications running on WebLogic.
-
Migrating data from GetResponse to Google BigQuery using CData SSIS Components.
Easily push GetResponse data to Google BigQuery using the CData SSIS Tasks for GetResponse and Google BigQuery.
-
Link LightSpeedRetail with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LightSpeedRetail data in Filemaker Pro for Mac or Windows.