CData Software - Knowledge Base
Recent Articles
-
Create SSAS Tabular Models from SAP Fieldglass Data
How to build a SQL Server Analysis Service Tabular Model from SAP Fieldglass data using CData drivers.
-
Automated Continuous OpenWeatherMap Replication to IBM DB2
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to IBM DB2.
-
Connect to Act-On Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Act-On Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Seamlessly Bring SAP SuccessFactors Data into Retool Using CData Connect AI
Integrate SAP SuccessFactors data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect Hacker News to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Hacker News with IBM WebSphere for seamless data integration and connectivity.
-
Google Drive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Drive data through CData Connect AI using different applications and tools.
-
Build Pipelines with Live Supabase Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Supabase from Google Cloud Data Fusion, enabling the integration of live Supabase data into the building and management of effective data pipelines.
-
Query Live API 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 API data directly from the development environment.
-
Connect to WordPress Data from Crystal Reports
Use CData Connect AI to connect to and report on live WordPress data from Crystal Reports.
-
Publish MariaDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MariaDB data.
-
How to Use a Microsoft Access Database to Update Email Data in Real Time
Update Email data by creating a linked table in Microsoft Access with the CData Email ODBC Driver.
-
Build Pipelines with Live MariaDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MariaDB from Google Cloud Data Fusion, enabling the integration of live MariaDB data into the building and management of effective data pipelines.
-
Integrate Trae with Live Yelp Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Yelp data from within the AI-powered IDE.
-
Automated Continuous MariaDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MariaDB replication to Apache Kafka.
-
Use Agno to Talk to Your MongoDB 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 MongoDB data for you.
-
Access Live Jira Assets Data in Coginiti Pro
Connect to and query live Jira Assets data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating OpenCode with Notion 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.
-
Configure the CData JDBC Driver for Zuora in a Connection Pool in Tomcat
Connect to Zuora data from a connection pool in Tomcat.
-
Build Data Flows from Active Directory to SQL Server using SSIS
Easily back up Active Directory data to SQL Server using the SSIS components for Active Directory.
-
Connect to eBay Analytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for eBay Analytics Data and connect to eBay Analytics data in Akorbi Digital RunMyProcess.
-
Replicate Multiple Hubstaff Accounts
Replicate multiple Hubstaff accounts to one or many databases.
-
Stream Zoho Recruit Data into Apache Kafka Topics
Access and stream Zoho Recruit data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Claude Code CLI with Optimizely 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 BenchmarkEmail Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for BenchmarkEmail data in the Denodo Virtual DataPort Administrator.
-
Connect to Coda Data from a Connection Pool in Jetty
The Coda JDBC Driver supports connection pooling: This article shows how to connect faster to Coda data from Web apps in Jetty.
-
How to Connect to Live Toggl Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Toggl data for you.
-
Design BIRT Reports on RSS Feeds
Provide current RSS feeds to your embedded analytics.
-
Integrate Dotmailer with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dotmailer with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dotmailer data.
-
Access Airtable Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Airtable data from your Oracle system.
-
Integrate Devin with Live Mailjet 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 Mailjet data.
-
Connecting Pipedream with Discord 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 Discord data in real time.
-
Analyze Recurly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Recurly data in Microsoft R Open.
-
Analyze Live Google Forms Data in SAS Viya
Use CData Connect AI to connect to Google Forms data from SAS Viya and deploy self-service analytics using live Google Forms data.
-
Access Live Acumatica Data in TIBCO Data Virtualization
Use the Acumatica Tibco DV Adapter to create a Acumatica data data source in TIBCO Data Virtualization Studio and gain access to live Acumatica data from your TDV Server.
-
Automated Continuous Omnisend Replication to MongoDB
Use CData Sync for automated, continuous, customizable Omnisend replication to MongoDB.
-
Object-Relational Mapping (ORM) with LightSpeedRetail 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 LightSpeedRetail data into a Java-based ORM framework, Hibernate.
-
Use Biml to Build SSIS Tasks to Replicate Teamgate Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Teamgate data to SQL Server.
-
Connect Google Forms Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Forms data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData SSIS Lookup Component to Insert New or Update Existing Salesforce Records from SQL Server
Easily push SQL Server data to Salesforce using the CData SSIS Components for Salesforce. This example uses an SSIS workflow to either insert new records into Salesforce or update existing records with data from a SQL Server database.
-
Access Superchat Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Superchat data.
-
How to connect and process Anaplan data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Anaplan data.
-
How to Query Live Copper Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Copper data data in natural language using Python.
-
How to Work with Perigon Data in ETL Validator JDBC
Connect to Perigon from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to GitLab from Asprova with CData Software ODBC Driver for GitLab
This article shows how to connect faster to GitLab data from Asprova.
-
Access Live OData Services in AWS Lambda
Connect to live OData services in AWS Lambda using the CData JDBC Driver.
-
How to publish and share ChargeOver Data dashboards with Tableau Server
The CData ODBC driver for ChargeOver enables you integrate ChargeOver data into Tableau dashboards.
-
Replicate Jodoo Data in Heroku for Use in Salesforce Connect
Replicate Jodoo data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Informatica Mappings From/To a JDBC Data Source for MYOB AccountRight
Create MYOB AccountRight data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating LlamaIndex with Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Guru data in real time.
-
How to update HBase from Excel
This article explains how to transfer data from Excel to HBase using the Excel Add-In for HBase.
-
Integrating Boomi Agentstudio with SAP BusinessObjects BI Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP BusinessObjects BI data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live Azure Data Lake Storage Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Data Lake Storage data into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Data Lake Storage data in the Graph Builder and Query Builder.
-
Connect to and Visualize Live Oracle Eloqua Reporting Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Eloqua Reporting data.
-
ETL Amplitude in Oracle Data Integrator
This article shows how to transfer Amplitude data into a data warehouse using Oracle Data Integrator.
-
Build Data Flows from Gong to SQL Server using SSIS
Easily back up Gong data to SQL Server using the SSIS components for Gong.
-
Use Dash to Build to Web Apps on DocuSign Data
Create Python applications that use pandas and Dash to build DocuSign-connected web apps.
-
Create Azure Analysis Services-Connected Dashboards in Grafana
Connect to Azure Analysis Services Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Analysis Services data.
-
How to Access Live Intercom Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Intercom enables you to integrate Intercom data into workflows built using Microsoft Power Automate Desktop.
-
Build Snapchat Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Snapchat Ads Data and create custom apps in Bubble.
-
Automate OneNote Data Replication to Azure Data Lake
Use CData Sync to customize and automate OneNote data replication to Azure Data Lake.
-
Visualize Mailjet Data in TIBCO Spotfire through ADO.NET
Integrate Mailjet data into dashboards in TIBCO Spotfire.
-
Automated Continuous Paddle Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Paddle replication to AlloyDB.
-
Build Data Flows from Impala to SQL Server using SSIS
Easily back up Impala data to SQL Server using the SSIS components for Impala.
-
Rapidly Develop Slack-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Slack.
-
Connect to HelloSign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HelloSign data in the Denodo Virtual DataPort Administrator.
-
Visualize Brex 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 Brex data into TIBCO Spotfire.
-
Prepare, Blend, and Analyze Recurly Data in Alteryx Designer (ODBC)
Build workflows to access live Recurly data for self-service data analytics.
-
Explore Geographical Relationships in Pinecone Data with Power Map
Create data visualizations with Pinecone data in Power Map.
-
Access Live Freshteam 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 Freshteam data through MCP integration.
-
Create FreshBooks-Connected Dashboards in Grafana
Connect to FreshBooks Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to FreshBooks data.
-
Access Live Quaderno Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Quaderno data into the statistical analysis tools available in SAS JMP. This article shows how to use Quaderno data in the Graph Builder and Query Builder.
-
How to Build an ETL App for SAP Business One Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Business One data in Python with petl and the CData Connect AI Python SDK.
-
DataBind Opsgenie Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Opsgenie data to a chart.
-
Use Databricks Agent Bricks to Talk to Your PolarTeamPro Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your PolarTeamPro data for you.
-
How to import Strava Data into Apache Solr
Use the CData Software JDBC Driver for Strava in Data Import Handler and create an automated import of Strava data to Apache Solr Enterprise Search platform.
-
How to Work with Freshservice Data in ETL Validator JDBC
Connect to Freshservice from ETL Validator jobs using the CData Software JDBC Driver.
-
SendPulse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SendPulse facts in real time.
-
Build Semantic Layer Views for Teamgate Data in APOS Live Data Gateway
Use the CData Connector for Teamgate in APOS Live Data Gateway to build Semantic Layer Views for Teamgate data.
-
Automated Continuous LaunchDarkly Replication to Snowflake
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Snowflake.
-
A Comparison of JDBC Drivers for BigQuery
A performance comparison of the CData JDBC Driver for Google BigQuery and the Google JDBC Driver for Google BigQuery (updated September 2019)
-
Integrating Kiro with QuickBooks Time 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.
-
Feed SAP Ariba Source Data into FineReport
How to set SAP Ariba Source data as a JDBC data source in FineReport.
-
Access Shippo Data from MySQL in Amazon QuickSight
Connect to Shippo and build visualizations of Shippo data using a MySQL Connection in Amazon QuickSight.
-
Use Manus AI to Talk to Your Presto 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 Presto data.
-
Connecting Mastra with ZohoSubscriptions Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time ZohoSubscriptions data, no replication required.
-
How to Connect to & Open Deel Data in Microsoft Excel
This article uses the CData ODBC driver for Deel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
View Reports on Real-Time Coda Data in Power BI Report Server
Use the CData ODBC Driver for Coda to visualize Coda data in Power BI Desktop and then publish them to Power BI Report Server.
-
Viewing Klaviyo Data in RAD Studio Data Explorer
How to view Klaviyo data in RAD Studio Data Explorer using the CData ODBC Driver for Klaviyo.
-
Use the CData Software JDBC Driver for Apollo in MicroStrategy Web
Connect to Apollo data in MicroStrategy Web using the CData Software JDBC Driver for Apollo.
-
Build Automated Workflows with Live Oracle Service Cloud Data in Workato
Use CData Connect AI to connect to live Oracle Service Cloud data and build automated workflows in Workato.
-
How to work with Splunk Data in Apache Spark using SQL
Access and process Splunk Data in Apache Spark using the CData Software JDBC Driver.
-
Create Google Ad Manager-Connected Dashboards in Grafana
Connect to Google Ad Manager Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Ad Manager data.
-
Viewing Excel Online Data in RAD Studio Data Explorer
How to view Excel Online data in RAD Studio Data Explorer using the CData ODBC Driver for Excel Online.
-
Automated Continuous SageHR Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SageHR replication to Google BigQuery.
-
Connect to Sybase Data in RapidMiner
Integrate Sybase data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData ODBC Driver for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ConvertAPI.
-
Use the CData Software ODBC Driver for Klipfolio in SAS for Real-Time Reporting and Analytics
Connect to real-time Klipfolio data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Klipfolio.
-
Connect to Live HBase Data in PostGresSQL Interface through CData Connect AI
Create a live connection to HBase in CData Connect AI and connect to your HBase data from PostgreSQL.
-
How to Query Live Gong Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Gong data data in natural language using Python.
-
How to Connect to Live Cloudflare Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Cloudflare data for you.