CData Software - Knowledge Base
Recent Articles
-
Access Live SAP Data in TIBCO Data Virtualization
Use the SAP Tibco DV Adapter to create a SAP ERP/NetWeaver data source in TIBCO Data Virtualization Studio and gain access to live SAP ERP/NetWeaver from your TDV Server.
-
How to publish and share Apify Data dashboards with Tableau Server
The CData ODBC driver for Apify enables you integrate Apify into Tableau dashboards.
-
Build Voice Agents in ElevenLabs with access to Live BambooHR Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live BambooHR.
-
Connect to Real-Time Sybase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sybase and Dataflow to import and use Sybase in Power Apps.
-
How to Build an ETL App for Oracle Eloqua Reporting Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Eloqua Reporting in Python with petl.
-
Build Dashboards with Microsoft Entra ID Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Entra ID in DBxtra.
-
Build AI/ML Models with Live Gong Data using Dataiku
Connect Gong Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to SAP Hybris C4C Data from IntelliJ
Integrate connectivity to SAP Hybris C4C with wizards in IntelliJ.
-
Add Cassandra Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cassandra with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Impala-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Impala.
-
Use Manus AI to Talk to Your SAP ByDesign 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 SAP Business ByDesign.
-
Automated Continuous Google Analytics Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Analytics replication to SQLite.
-
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 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 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.
-
Choosing the Best Method to Connect Dotmailer to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dotmailer 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
-
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.
-
ETL Splunk in Oracle Data Integrator
This article shows how to transfer Splunk into a data warehouse using Oracle Data Integrator.
-
Migrating data from Attio to Google BigQuery using CData SSIS Components.
Easily push Attio to Google BigQuery using the CData SSIS Tasks for Attio and Google BigQuery.
-
How to integrate DB2 with Apache Airflow
Access and process IBM DB2 in Apache Airflow using the CData JDBC Driver.
-
How to connect to Microsoft Planner Data with Squirrel SQL client
Connect to Microsoft Planner 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 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 Apache Cassandra 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 and visualize live Freshdesk in Infragistics Reveal.
-
Connect to Mixpanel Data in DBArtisan
Use wizards in DBArtisan to configure Mixpanel 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.
-
Getting Started with the CData ODBC Driver for Typeform
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Typeform.
-
Connect to PostgreSQL Data from HeidiSQL
Use CData Connect AI to connect to and query live PostgreSQL from HeidiSQL.
-
Access PingOne Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PingOne from HeidiSQL.
-
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
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Business ByDesign using the Model Context Protocol.
-
Build Apps with Live Telegram Data Using the Low-Code Development Platform of Mendix
Connect Telegram with Mendix to build apps using the CData API Driver for JDBC.
-
Stream Suadeo Data into Apache Kafka Topics
Access and stream Suadeo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate with Gumroad Data in JReport Designer
Create charts and reports based on Gumroad 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 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Telegram 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.
-
How to connect to Pushbullet Data with Squirrel SQL client
Connect to Pushbullet 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 in QlikView.
-
How to Connect DBeaver to Reckon via a JDBC Driver
Manage Reckon 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 into custom reports and dashboards.
-
Work with HDFS Data in FoxPro
Load Apache HDFS 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 via CData CLI
Connect HubDB 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 CRM & ERP 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 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 in Akorbi Digital RunMyProcess.
-
Access Live Aha! Data in AWS Lambda
Connect to live Aha! 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.
-
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 Atlassian Jira 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 CLI with Microsoft Teams 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 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
-
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.
-
How to connect and process ShipStation from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ShipStation.
-
How to Query Live Marketo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Marketo data in natural language using Python.
-
Connect and Query Live Kintone Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Kintone into Databricks
-
Build Data Flows from Browserless to SQL Server using SSIS
Easily back up Browserless 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 for modeling, searching, and visualizing.
-
Migrating data from Humanity to Databricks using CData SSIS Components.
Easily push Humanity to Databricks using the CData SSIS Tasks for Humanity and Databricks.
-
Use the CData Software JDBC Driver for Guru in MicroStrategy
Connect to Guru 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 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 using standard SQL.
-
Stream PabblySubscriptions Data into Apache Kafka Topics
Access and stream PabblySubscriptions 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 in Power Apps.
-
Automate SQL Server Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft SQL Server and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Viewing Rebilly Data in RAD Studio Data Explorer
How to view Rebilly 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 Business ByDesign 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 ERP 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.
-
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 from Node.js.
-
Connect to Workable Data from a Connection Pool in JBoss
Integrate Workable into Java servlets: Use the Management Console in JBoss to install the Workable JDBC Driver.
-
Feed Mocean Data into FineReport
How to set Mocean 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 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.
-
Back Up Drift to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Drift 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, 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 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 to Databricks using the CData SSIS Tasks for HCL Domino and Databricks.
-
Connect to HBase Data in Ruby
Connect to Apache HBase 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 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 and build web apps with connectivity to live HubDB.