CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for Autopilot Data in Python with CData
Create ETL applications and real-time data pipelines for Autopilot data in Python with petl.
-
Import Real-Time Airtable Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Airtable data in ColdFusion.
-
Query Live Campaigner 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 Campaigner data directly from the development environment.
-
Connect to iContact in SpagoBI
Create reports featuring live iContact data in SpagoBI Studio. Host iContact reports on SpagoBI Server.
-
Connect to Microsoft Teams from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Teams to connect to Microsoft Teams data from Web applications running on WebLogic.
-
Enable the Reply.io JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Reply.io data.
-
Automate Mixpanel Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mixpanel data from PowerShell? This article demonstrates how to utilize the Mixpanel Cmdlets for tasks like connecting to Mixpanel data, automating operations, downloading data, and more.
-
Integrate Cursor with Live HubDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live HubDB data from within the editor.
-
Use the CData ODBC Driver for Tally from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Tally to connect to Tally data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Tally data in Excel.
-
How to integrate Active Directory with Apache Airflow
Access and process Active Directory data in Apache Airflow using the CData JDBC Driver.
-
Connect to SendGrid Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SendGrid as an External Source in Dremio.
-
Automated Continuous Oracle Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle replication to Apache Cassandra.
-
How to integrate Metabase with Oracle Sales Data
Use CData Connect AI to connect to live Oracle Sales data and create an interactive dashboard in Metabase from Oracle Sales data.
-
Connect to Live Sage Cloud Accounting Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage Cloud Accounting in CData Connect AI and connect to your Sage Cloud Accounting data from PostgreSQL.
-
Publish Elorus-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Elorus data.
-
Build Dashboards with Calendly Data in DBxtra
Create dynamic dashboards and perform analytics based on Calendly data in DBxtra.
-
Connecting Pipedream with Freshservice 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 Freshservice data in real time.
-
Use Agno to Talk to Your GetResponse 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 GetResponse data for you.
-
Connect to GitHub from a Connection Pool in WebLogic
Use the CData JDBC Driver for GitHub to connect to GitHub data from Web applications running on WebLogic.
-
Interact with Live Perplexity Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Perplexity data.
-
Access Bitbucket Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bitbucket data from HeidiSQL.
-
Automated Continuous Contentful Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Contentful replication to Amazon S3.
-
Use the CData ODBC Driver for Zoho Books in Microsoft Power Query
You can use the CData Zoho Books ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Books data into Microsoft Power Query.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Financials Cloud Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Financials Cloud data to SQL Server.
-
Build MySQL-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MySQL Data and create custom apps in Bubble.
-
Create Informatica Mappings From/To a JDBC Data Source for Discourse
Create Discourse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Pipelines with Live VWO Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to VWO from Google Cloud Data Fusion, enabling the integration of live VWO data into the building and management of effective data pipelines.
-
Connect to ZohoMarketingHub Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoMarketingHub data from PowerBuilder using the ZohoMarketingHub JDBC Driver.
-
Query Live Sybase 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 Sybase data directly from the development environment.
-
How to Connect DBeaver to Supabase via a JDBC Driver
Manage Supabase data with visual tools in DBeaver like the query browser.
-
Automated Continuous MailerLite Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MailerLite replication to Google BigQuery.
-
How to load Pinterest data into Elasticsearch via Logstash
Introducing a simple method to load Pinterest data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData ADO.NET Provider for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP SuccessFactors.
-
How to Connect Flowise AI Agents to Live HubDB 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 HubDB data without replication.
-
Visualize Nethunt Data in TIBCO Spotfire through ADO.NET
Integrate Nethunt data into dashboards in TIBCO Spotfire.
-
Build Google Search-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Search results.
-
Integrating FreeAgent Data in Talend Cloud Data Management Platform
Connect FreeAgent Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Shippo-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Shippo Data from Klipfolio and build custom visualizations using live Shippo data.
-
Automated Continuous Aweber Replication to Vertica
Use CData Sync for automated, continuous, customizable Aweber replication to Vertica.
-
Query Oracle Eloqua Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle Eloqua data from Node.js.
-
Use Microsoft Copilot Studio to talk to your SAS xpt 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 SAS xpt data for you.
-
Connecting GenSpark with Discord Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Discord data without any replication or custom integration required.
-
Visualize CapsuleCRM Data in Sisense
Create an ElastiCube in Sisense app with access to CapsuleCRM data.
-
Design BIRT Reports on Todoist Data
Provide current Todoist data to your embedded analytics.
-
Connect to FHIR Data in HULFT Integrate
Connect to FHIR as a JDBC data source in HULFT Integrate
-
Connect Mistral AI to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mistral AI with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Excel Online Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Excel Online with the DevExpress Windows Forms and Web controls to provide Excel Online data to a chart.
-
Query Cloudant Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Cloudant entities in PHP by modeling them as objects.
-
Build a Singer.io Tap for SQL Server With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SQL Server data using the CData Python Connector.
-
Automated Continuous REST Replication to MongoDB
Use CData Sync for automated, continuous, customizable REST replication to MongoDB.
-
Automated Continuous Neo4J Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Neo4J replication to delimited files (CSV/TSV).
-
Create Close Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Close from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build EnterpriseDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to EnterpriseDB data and build web apps with connectivity to live EnterpriseDB data.
-
Create Informatica Mappings From/To an ODBC Data Source for Phoenix
Create an ODBC connection to Phoenix in Informatica and browse and transfer Phoenix data.
-
Build Dashboards with Reckon Data in DBxtra
Create dynamic dashboards and perform analytics based on Reckon data in DBxtra.
-
ETL Calendly in Oracle Data Integrator
This article shows how to transfer Calendly data into a data warehouse using Oracle Data Integrator.
-
Analyze ADP Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ADP data in Microsoft R Open.
-
Automated Continuous WordPress Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable WordPress replication to delimited files (CSV/TSV).
-
Connect to Supabase Data in Jaspersoft Studio
Execute SQL to remote Supabase data in Jaspersoft Studio.
-
Query Kintone Data as a SQL Server Database in Node.js
Execute SQL Server queries against Kintone data from Node.js.
-
Connect to Perigon Data from a Connection Pool in JBoss
Integrate Perigon data into Java servlets: Use the Management Console in JBoss to install the Perigon JDBC Driver.
-
Query Optimizely Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Optimizely data from Node.js.
-
Load Printful Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Printful data to a database.
-
Create Data Visualizations Based On Azure Table Data in Mode
Use CData Connect AI to connect to Azure Table Data from Mode and build visualizations using live Azure Table data.
-
Getting Started with the CData ODBC Driver for Hacker News
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Hacker News.
-
Automated Continuous PayPal Replication to Databricks
Use CData Sync for automated, continuous, customizable PayPal replication to Databricks.
-
Analyze Vault CRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Vault CRM data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Replicate Multiple ChartMogul Accounts via the CData Sync CLI
Replicate multiple ChartMogul accounts to one or many databases.
-
Visualize Yelp Data in Tableau
The CData ODBC driver for Yelp enables you integrate Yelp data into Tableau dashboards.
-
Visualize Amplitude Data in Tableau
The CData ODBC driver for Amplitude enables you integrate Amplitude data into Tableau dashboards.
-
Natively Connect to DocuSign Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to DocuSign data. Leverage the native support for ODBC in PHP.
-
Integrate Real-Time Access to SAP SuccessFactors in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP SuccessFactors data in real time.
-
Bridge Sage 300 Connectivity with Apache NiFi
Access and process Sage 300 data in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for Cassandra
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cassandra.
-
Using the CData Software ODBC Driver for Pushbullet in PyCharm
Connect to Pushbullet as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pushbullet.
-
Replicate Multiple Zendesk Accounts
Replicate multiple Zendesk accounts to one or many databases.
-
Connect to Figshare 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 Figshare data.
-
Flowlu Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Flowlu facts in real time.
-
ETL AfterShip in Oracle Data Integrator
This article shows how to transfer AfterShip data into a data warehouse using Oracle Data Integrator.
-
Publish Oracle Eloqua Reporting-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle Eloqua Reporting data.
-
Create Reports from Anaplan Data in Looker Studio
Use CData Connect AI to gain access to live Anaplan data and create custom reports in Looker Studio.
-
Seamlessly Bring Asana Data into Retool Using CData Connect AI
Integrate Asana data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Using the CData Software ODBC Driver for Vercel in PyCharm
Connect to Vercel as an ODBC data source in PyCharm using the CData Software ODBC Driver for Vercel.
-
Use CData Connect AI to Access SQL Analysis Services Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SQL Analysis Services data in the Power Pivot business intelligence tool.
-
Visualize Live Bright Data Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bright Data data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build LDAP-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live LDAP objects.
-
Use the CData ODBC Driver for Bright Data in Microsoft Power Query
You can use the CData Bright Data ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bright Data data into Microsoft Power Query.
-
Automated Continuous Jira Assets Replication to MongoDB
Use CData Sync for automated, continuous, customizable Jira Assets replication to MongoDB.
-
Connecting GenSpark with MYOB AccountRight Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MYOB AccountRight data without any replication or custom integration required.
-
How to Seamlessly Import Email Data into IBM SPSS Modeler
Integrate Email data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Claude Code CLI with Insightly 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.
-
Build Apps with Live eBay data in Adalo using CData Connect AI
Use CData Connect AI to integrate live eBay data into the Adalo platform and build custom mobile and web applications with real-time eBay data.
-
Analyze ScrapingBee Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ScrapingBee data with the CData JDBC Driver for ScrapingBee.
-
Prepare, Blend, and Analyze ClickUp Data in Alteryx Designer (Connect AI)
Build workflows to access live ClickUp data for self-service data analytics.
-
Replicate FreeAgent Data to Multiple Databases
Replicate FreeAgent data to disparate databases with a point-and-click configuration.
-
Analyze Live LinkedIn Ads Data in SAS Viya
Use CData Connect AI to connect to LinkedIn Ads data from SAS Viya and deploy self-service analytics using live LinkedIn Ads data.
-
Import Real-Time Discourse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Discourse data in ColdFusion.
-
Connect to Jira Assets Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Jira Assets.
-
Replicate Retently Data from PowerShell
Write a quick PowerShell script to query Retently data. Use connectivity to the live data to replicate Retently data to SQL Server.
-
Consume Google Calendar OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Calendar feeds that reflect any changes in SAP Lumira.