CData Software - Knowledge Base
Recent Articles
-
Connect to Gong Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gong data using standard SQL.
-
Automated Continuous YouTube Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to PostgreSQL.
-
How to Query Live Oracle SCM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle SCM data data in natural language using Python.
-
Automated DB2 Data Replication to Teradata
Use CData Sync to Customize and automate DB2 data replication to Teradata.
-
Connect to Presto Data in NetBeans
Connect to Presto data in NetBeans with the data source configuration wizard.
-
Model, Search, and Visualize Live Box Data in ThoughtSpot
Use CData Connect AI to connect to live Box data for modeling, searching, and visualizing.
-
How to update Exact Online from Excel
This article explains how to transfer data from Excel to Exact Online using the Excel Add-In for Exact Online.
-
Neo4J Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Neo4J data through CData Connect AI using different applications and tools.
-
Automate Google Directory Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Directory data replication to Azure Synapse.
-
Integrate with SendPulse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SendPulse data to a JSON file on disk.
-
Connect to Live Microsoft Dataverse Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Dataverse Data in CData Connect AI and connect to your Microsoft Dataverse data from MicroStrategy.
-
Connect to Samanage Data from HeidiSQL
Use CData Connect AI to connect to and query live Samanage data from HeidiSQL.
-
Automated Continuous Blackbaud FE NXT Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to PostgreSQL.
-
Build AI/ML Models with Live Zoho Recruit Data using Dataiku
Connect Zoho Recruit Data with Dataiku using the CData API Driver for JDBC.
-
Connect to CircleCI Data in Aqua Data Studio
Access CircleCI data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create YouTube Analytics-Connected Business Apps in AppSheet
Connect to YouTube Analytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to YouTube Analytics data.
-
Create Dashboards and Visualize Live Zendesk Data in Geckoboard
Use CData Connect AI to connect to live Zendesk data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Access Live Postmark Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Postmark enables you to integrate Postmark data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Quickbase Data in Heroku for Use in Salesforce Connect
Replicate Quickbase data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
ETL Adobe Analytics in Oracle Data Integrator
This article shows how to transfer Adobe Analytics data into a data warehouse using Oracle Data Integrator.
-
DataBind Controls to AgileCRM Data in C++Builder
DataBind to AgileCRM data in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for Chargebee in MicroStrategy
Connect to Chargebee data in MicroStrategy Developer using the CData Software ODBC Driver for Chargebee.
-
Create HBase-Connected Business Apps in AppSheet
Connect to HBase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to HBase data.
-
Build AI/ML Models with Live Klipfolio Data using Dataiku
Connect Klipfolio Data with Dataiku using the CData API Driver for JDBC.
-
Connect to ActiveCampaign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ActiveCampaign data in the Denodo Virtual DataPort Administrator.
-
Import BigCommerce Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to BigCommerce Data and provide access to live BigCommerce data for custom reports in the Power BI Service.
-
Design BIRT Reports on Templated Data
Provide current Templated data to your embedded analytics.
-
Object-Relational Mapping (ORM) with Act-On Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Act-On data into a Java-based ORM framework, Hibernate.
-
Connect to Sage Cloud Accounting Data in Jaspersoft Studio
Execute SQL to remote Sage Cloud Accounting data in Jaspersoft Studio.
-
Access Brex Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Brex data from your Oracle system.
-
Connect to HCL Domino Data in Ruby
Connect to HCL Domino data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Automated Workflows with Live Apollo Data in Workato
Use CData Connect AI to connect to live Apollo data and build automated workflows in Workato.
-
Visualize Telegram Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Telegram data into TIBCO Spotfire.
-
Migrating data from SFTP to Snowflake using CData SSIS Components.
Easily push SFTP data to Snowflake using the CData SSIS Tasks for SFTP and Snowflake.
-
Automated Continuous Jumpseller Replication to Oracle
Use CData Sync for automated, continuous, customizable Jumpseller replication to Oracle.
-
How to connect to ZohoMarketingHub Data in DBVisualizer
Integrate ZohoMarketingHub data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous SAP HANA XS Advanced Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Apache Cassandra.
-
Build Office 365-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Office 365 data without replication.
-
Use Dash to Build Web Apps on Avro Data via CData Connect AI
Build interactive Dash web apps on live Avro data using pandas and the CData Connect AI Python SDK.
-
Integrate Trae with Live Apollo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Apollo data from within the AI-powered IDE.
-
Build MVC Applications with Connectivity to Browserless Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Browserless from an ASP.NET MVC application.
-
Create Planio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Planio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData Excel Add-In for Oracle SCM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle SCM.
-
How to Access Live Stripe Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Stripe enables you to integrate Stripe data into workflows built using Microsoft Power Automate Desktop.
-
Use Biml to Build SSIS Tasks to Replicate ZohoExpense Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoExpense data to SQL Server.
-
Access Live NASA Data in AWS Lambda
Connect to live NASA data in AWS Lambda using the CData JDBC Driver.
-
Integrate Cursor with Live Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Timely data from within the editor.
-
How to Build an ETL App for Tally Data in Python with CData Connect AI
Extract and transform live Tally data in Python with petl and the CData Connect AI Python SDK.
-
ETL LinkedIn Ads in Oracle Data Integrator
This article shows how to transfer LinkedIn Ads data into a data warehouse using Oracle Data Integrator.
-
Access Live Zuora Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zuora data into the statistical analysis tools available in SAS JMP. This article shows how to use Zuora data in the Graph Builder and Query Builder.
-
Integrating LangChain with Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sybase data within automated workflows.
-
How to Work with ZohoInvoice Data in ETL Validator JDBC
Connect to ZohoInvoice from ETL Validator jobs using the CData Software JDBC Driver.
-
Transfer Google Calendars to SharePoint in Talend
Access SharePoint data in Talend using the CData JDBC Driver for SharePoint.
-
Integrating OpenCode with LaunchDarkly 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.
-
Connect to Jumpseller from Asprova with CData Software ODBC Driver for Jumpseller
This article shows how to connect faster to Jumpseller data from Asprova.
-
Prepare, Blend, and Analyze GitHub Data in Alteryx Designer (Connect AI)
Build workflows to access live GitHub data for self-service data analytics.
-
Integrating Gumloop with Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Marketo data within automated workflows.
-
Automated Continuous eBay Analytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Amazon S3.
-
Use the CData Software ODBC Driver for Cloudant in SAS for Real-Time Reporting and Analytics
Connect to real-time Cloudant data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cloudant.
-
Automated Continuous SpaceX Replication to SQLite
Use CData Sync for automated, continuous, customizable SpaceX replication to SQLite.
-
Connect to ServiceNow Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ServiceNow data using standard SQL.
-
Load SAP BusinessObjects BI Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP BusinessObjects BI data to a database.
-
How to Visualize Zoho Books Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Books data in Python.
-
Work with Elorus Data in FoxPro
Load Elorus data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Oracle SCM Data in DBeaver
Use the CData ODBC Driver to connect to Oracle SCM data in DBeaver.
-
Publish Reckon-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Reckon data.
-
Process & Analyze Calendly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Calendly Data.
-
Connect to Spotify Data in JRuby
Create a simple JRuby app with access to live Spotify data.
-
Integrate Live Sage Intacct Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sage Intacct data to Blue Prism using the CData ODBC Driver for Sage Intacct to create automated workflows for repetitive business tasks.
-
Integrate with eBay Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy eBay data to a JSON file on disk.
-
Automated Continuous Mistral AI Replication to MySQL
Use CData Sync for automated, continuous, customizable Mistral AI replication to MySQL.
-
Integrate Devin with Live OData Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live OData services.
-
Use the CData Software JDBC Driver for Vercel in MicroStrategy Desktop
Connect to Vercel data in MicroStrategy Desktop using the CData Software JDBC Driver for Vercel.
-
Build Apps with Live Miro Data Using the Low-Code Development Platform of Mendix
Connect Miro data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Yelp Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Yelp data.
-
Prepare, Blend, and Analyze Outlook Data in Alteryx Designer (ODBC)
Build workflows to access live Outlook data for self-service data analytics.
-
Using the CData Software ODBC Driver for MailerLite in PyCharm
Connect to MailerLite as an ODBC data source in PyCharm using the CData Software ODBC Driver for MailerLite.
-
Analyze Live SAP HANA Data in SAS Viya
Use CData Connect AI to connect to SAP HANA data from SAS Viya and deploy self-service analytics using live SAP HANA data.
-
Integrate Google's Vertex AI Agent with Live Quickbase 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 Quickbase data within intelligent workflows.
-
Use Biml to Build SSIS Tasks to Replicate Freshsales Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshsales data to SQL Server.
-
Integrating LangChain with Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Ads data within automated workflows.
-
Connecting Agentforce with Slack 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 Slack data for you.
-
Use Biml to Build SSIS Tasks to Replicate Calendly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Calendly data to SQL Server.
-
How to Query Live Phoenix Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Phoenix data data in natural language using Python.
-
Automated Continuous Exa Replication to SQLite
Use CData Sync for automated, continuous, customizable Exa replication to SQLite.
-
Access Live Webflow Data in AWS Lambda
Connect to live Webflow data in AWS Lambda using the CData JDBC Driver.
-
Connect to Square Data in DBeaver
Use the CData ODBC Driver to connect to Square data in DBeaver.
-
Analyze Omnisend Data in Looker
Use CData Connect AI to connect to Omnisend Data from Looker and build custom apps using live Omnisend data.
-
Import Real-Time Short.io Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Short.io data in ColdFusion.
-
Getting Started with the CData SSIS Components for Campaigner
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Campaigner.
-
Connect to and Query Instantly Data in QlikView over ODBC
Create data visualizations with Instantly data in QlikView.
-
Query JotForm Data as a MySQL Database in Node.js
Execute MySQL queries against JotForm data from Node.js.
-
Connect to Live Impala Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Impala in CData Connect AI and connect to your Impala data from PostgreSQL.
-
How to load Figshare data into Elasticsearch via Logstash
Introducing a simple method to load Figshare data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to import ZohoExpense Data into Apache Solr
Use the CData Software JDBC Driver for ZohoExpense in Data Import Handler and create an automated import of ZohoExpense data to Apache Solr Enterprise Search platform.
-
Build Google Spanner-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Spanner data.
-
Integrate Dify with Live Apify Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Apify data.
-
Use the CData ODBC Driver for Google Campaign Manager 360 in Microsoft Power Query
You can use the CData Google Campaign Manager 360 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Campaign Manager 360 data into Microsoft Power Query.
-
Access Live XML Data in AWS Lambda (with IntelliJ IDEA)
Connect to live XML data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Google Spanner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Spanner replication to Apache Cassandra.