CData Software - Knowledge Base
Recent Articles
-
Build SFTP-Connected Apps in Choreo
Use CData Connect AI to connect to SFTP Data from Choreo and build custom apps using live SFTP data.
-
Automated Continuous Amazon Athena Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Azure SQL Database.
-
Integrate with Amazon S3 Data in JReport Designer
Create charts and reports based on Amazon S3 data in JReport Designer.
-
Use Microsoft Copilot Studio to talk to your Amazon Athena 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 Amazon Athena data for you.
-
Query Oracle SCM Data in DataGrip
Create a Data Source for Oracle SCM in DataGrip and use SQL to query live Oracle SCM data.
-
Choosing the Best Method to Connect Dotmailer to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dotmailer data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Tableau Connector for MailerLite
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect to Freshservice Data from Spring Boot
Connect to Freshservice in a Spring Boot Application using the CData API Driver for JDBC
-
Create Apps from Azure Data Catalog Data in Qlik Sense Cloud
Use CData Connect AI to connect to Azure Data Catalog Data and build apps from live Azure Data Catalog data in Qlik Sense Cloud.
-
A PostgreSQL Interface for Insightly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Insightly JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Yelp Data in Python with CData Connect AI
Extract and transform live Yelp data in Python with petl and the CData Connect AI Python SDK.
-
ETL Splunk in Oracle Data Integrator
This article shows how to transfer Splunk data into a data warehouse using Oracle Data Integrator.
-
Migrating data from Attio to Google BigQuery using CData SSIS Components.
Easily push Attio data to Google BigQuery using the CData SSIS Tasks for Attio and Google BigQuery.
-
How to integrate DB2 with Apache Airflow
Access and process DB2 data in Apache Airflow using the CData JDBC Driver.
-
How to connect to Microsoft Planner Data with Squirrel SQL client
Connect to Microsoft Planner data and execute queries in the Squirrel SQL Client.
-
Dropbox Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Dropbox data through CData Connect AI using different applications and tools.
-
How to import Cassandra Data into Apache Solr
Use the CData Software JDBC Driver for Cassandra in Data Import Handler and create an automated import of Cassandra data to Apache Solr Enterprise Search platform.
-
Analyze Freshdesk Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Freshdesk data and visualize live Freshdesk data in Infragistics Reveal.
-
Connect to Mixpanel Data in DBArtisan
Use wizards in DBArtisan to configure Mixpanel data as a data source.
-
Building Dynamic Web Pages with SQL Analysis Services Data Using AngularJS
Create single-page applications with live connectivity to SQL Analysis Services using the CData API Server.
-
Model Microsoft Planner Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Planner, enabling the direct import of real-time Microsoft Planner data.
-
Getting Started with the CData ODBC Driver for Typeform
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Typeform.
-
Access PingOne Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PingOne data from HeidiSQL.
-
Build Apps with Live Supabase data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Supabase data into the Adalo platform and build custom mobile and web applications with real-time Supabase data.
-
How to connect to Autopilot Data from Spring Boot
Connect to Autopilot in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Google's Antigravity Agent with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP ByDesign data using the Model Context Protocol.
-
Build Apps with Live Telegram Data Using the Low-Code Development Platform of Mendix
Connect Telegram data with Mendix to build apps using the CData API Driver for JDBC.
-
Stream Suadeo Data into Apache Kafka Topics
Access and stream Suadeo data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Demio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Demio replication to Apache Kafka.
-
Integrate with Gumroad Data in JReport Designer
Create charts and reports based on Gumroad data in JReport Designer.
-
How to Access Live ZarMoney Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZarMoney enables you to integrate ZarMoney data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData ODBC Driver for Telegram from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Telegram to connect to Telegram data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Telegram data in Excel.
-
Automated Continuous SAP Concur Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Concur replication to AlloyDB.
-
How to connect to RabbitMQ Data from Spring Boot
Connect to RabbitMQ in a Spring Boot Application using the CData API Driver for JDBC
-
Build Gorgias-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gorgias data.
-
How to connect to Pushbullet Data with Squirrel SQL client
Connect to Pushbullet data and execute queries in the Squirrel SQL Client.
-
How to Connect Redshift Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Redshift data in real time using natural language.
-
Connect to and Query Missive Data in QlikView over ODBC
Create data visualizations with Missive data in QlikView.
-
How to Connect DBeaver to Reckon via a JDBC Driver
Manage Reckon data with visual tools in DBeaver like the query browser.
-
Integrate with Live Gong Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Gong from the MuleSoft Anypoint Platform to integrate live Gong data into custom reports and dashboards.
-
Work with HDFS Data in FoxPro
Load HDFS data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Gmail Data from Spring Boot
Connect to Gmail in a Spring Boot Application using the CData JDBC Driver for Gmail
-
Integrating Antigravity CLI with HubDB data via CData CLI
Connect HubDB data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live NetSuite Data in the Power BI Service
Use CData Connect AI to connect to live NetSuite data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from Hacker News to SQL Server using SSIS
Easily back up Hacker News data to SQL Server using the SSIS components for Hacker News.
-
Connect to HubSpot Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for HubSpot Data and connect to HubSpot data in Akorbi Digital RunMyProcess.
-
Access Live Aha! Data in AWS Lambda
Connect to live Aha! data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for REST
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for REST.
-
Integrating LlamaIndex with Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Bitbucket data in real time.
-
How to Connect to Live Jira 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 Jira data for you.
-
Automated Continuous Google Cloud Storage Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Vertica.
-
Integrating Codex with Microsoft Teams 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.
-
Access Live Paddle Data in Coginiti Pro
Connect to and query live Paddle data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Azure Blob Storage Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Amazon S3.
-
How to connect to Snowflake Data from Spring Boot
Connect to Snowflake in a Spring Boot Application using the CData JDBC Driver for Snowflake
-
Analyze Campaigner Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Campaigner data and visualize live Campaigner data in Infragistics Reveal.
-
Connect to Reckon Accounts Hosted Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Reckon Accounts Hosted as an External Source in Dremio.
-
Query Reckon Accounts Hosted Data in ColdFusion
Write standard ColdFusion data access code to connect to Reckon Accounts Hosted data.
-
How to connect and process ShipStation data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ShipStation data.
-
How to Query Live Marketo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Marketo data data in natural language using Python.
-
Integrate OpenCode with Live MongoDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live MongoDB data from within your AI coding agent.
-
Connect and Query Live Kintone Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Kintone data into Databricks and enable direct, live querying and analysis without replication.
-
Build Data Flows from Browserless to SQL Server using SSIS
Easily back up Browserless data to SQL Server using the SSIS components for Browserless.
-
Automated Continuous API Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable API replication to PostgreSQL.
-
Model, Search, and Visualize Live PostgreSQL Data in ThoughtSpot
Use CData Connect AI to connect to live PostgreSQL data for modeling, searching, and visualizing.
-
Migrating data from Humanity to Databricks using CData SSIS Components.
Easily push Humanity data to Databricks using the CData SSIS Tasks for Humanity and Databricks.
-
Use the CData Software JDBC Driver for Guru in MicroStrategy
Connect to Guru data in MicroStrategy Developer using the CData Software JDBC Driver for Guru.
-
Automated Continuous Adobe Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Google BigQuery.
-
How to create an RPA flow for Customer.io Data in UiPath Studio
Use the Customer.io ODBC Driver to create workflows that access real-time Customer.io data without any coding.
-
Connect to Adobe Commerce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Commerce data using standard SQL.
-
Stream PabblySubscriptions Data into Apache Kafka Topics
Access and stream PabblySubscriptions data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Real-Time Oracle HCM Cloud Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle HCM Cloud and Dataflow to import and use Oracle HCM Cloud data in Power Apps.
-
Viewing Rebilly Data in RAD Studio Data Explorer
How to view Rebilly data in RAD Studio Data Explorer using the CData ODBC Driver for Rebilly.
-
Access Live SAP ByDesign Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP ByDesign data from your Excel spreadsheets.
-
A PostgreSQL Interface for JobNimbus Data (MySQL Remoting via JDBC)
Use the Remoting features of the JobNimbus JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to Acumatica Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Acumatica data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to Gumroad Data in JRuby
Create a simple JRuby app with access to live Gumroad data.
-
How to Seamlessly Import SendPulse Data into IBM SPSS Modeler
Integrate SendPulse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Quaderno Data as a MySQL Database in Node.js
Execute MySQL queries against Quaderno data from Node.js.
-
Connect to Workable Data from a Connection Pool in JBoss
Integrate Workable data into Java servlets: Use the Management Console in JBoss to install the Workable JDBC Driver.
-
Automated Continuous Reply.io Replication to Vertica
Use CData Sync for automated, continuous, customizable Reply.io replication to Vertica.
-
Feed Mocean Data into FineReport
How to set Mocean data as a JDBC data source in FineReport.
-
Getting Started with the CData Tableau Connector for Paymo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData Software ODBC Driver for Intercom in MicroStrategy Web
Connect to Intercom data in MicroStrategy Web using the CData Software ODBC Driver for Intercom.
-
How to connect PolyBase to Avaza
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Avaza data.
-
Automated Continuous Cvent Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cvent replication to Snowflake.
-
Replicate Multiple Azure Data Lake Storage Accounts
Replicate multiple Azure Data Lake Storage accounts to one or many databases.
-
Integrating Boomi Agentstudio with Sugar CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sugar CRM data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
ETL Short.io in Oracle Data Integrator
This article shows how to transfer Short.io data into a data warehouse using Oracle Data Integrator.
-
How to Use a Microsoft Access Database to Update Twilio Data in Real Time
Update Twilio data by creating a linked table in Microsoft Access with the CData Twilio ODBC Driver.
-
Migrating data from HCL Domino to Databricks using CData SSIS Components.
Easily push HCL Domino data to Databricks using the CData SSIS Tasks for HCL Domino and Databricks.
-
Connect to HBase Data in Ruby
Connect to HBase data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Apps with Live Jumpseller Data Using the Low-Code Development Platform of Mendix
Connect Jumpseller data with Mendix to build apps using the CData API Driver for JDBC.
-
Build HubDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to HubDB data and build web apps with connectivity to live HubDB data.
-
Build SAP HANA XS Advanced-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP HANA XS Advanced data.
-
Load JotForm Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load JotForm data to a database.
-
Query ChargeOver Data as a MySQL Database in Node.js
Execute MySQL queries against ChargeOver data from Node.js.
-
How to Connect the Power BI Service to Exact Online: Complete Guide
Connect to the CData Software Power BI Connector for Exact Online from PowerBI.com to provide real-time Exact Online data across the organization.
-
Edit and Search External Sugar CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sugar CRM data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sugar CRM Data objects that you can access from apps and the dashboard.
-
Automate Todoist Data Replication to Azure Data Lake
Use CData Sync to customize and automate Todoist data replication to Azure Data Lake.