CData Software - Knowledge Base
Recent Articles
-
Load Ontraport Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Ontraport data to a database.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy Web
Connect to Zoho Projects data in MicroStrategy Web using the CData Software ODBC Driver for Zoho Projects.
-
Establish a Live Connection with Stack Exchange Data using Tableau Bridge
The CData ODBC Driver for Stack Exchange enables you to integrate live Stack Exchange data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for Okta from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Okta to connect to Okta data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Okta data in Excel.
-
Back Up Monday.com data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Monday.com. In this article, we will employ an SSIS workflow to populate a database with Monday.com data data.
-
Create Data Visualizations in Cognos BI with Twilio Data
Access Twilio data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Mocean Data in CloverDX (formerly CloverETL)
Transfer Mocean data using the visual workflow in the CloverDX data integration tool.
-
Add Toggl Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Toggl with the Informatica Enterprise Data Catalog to classify and organize data.
-
Airtable Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Airtable facts in real time.
-
Connect Typeform to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Typeform with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SharePoint Data in JRuby
Create a simple JRuby app with access to live SharePoint data.
-
Integrate Trae with Live CSV Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live CSV data from within the AI-powered IDE.
-
Integrate Aha! Data in the Pentaho Report Designer
Publish reports based on Aha! data in the Pentaho BI tool.
-
Connect to Freshdesk Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Freshdesk Data and connect to Freshdesk data in Akorbi Digital RunMyProcess.
-
How to connect to MariaDB Data from Spring Boot
Connect to MariaDB in a Spring Boot Application using the CData JDBC Driver for MariaDB
-
Use the CData Software ODBC Driver for HubSpot in MicroStrategy Web
Connect to HubSpot data in MicroStrategy Web using the CData Software ODBC Driver for HubSpot.
-
Connect to Greenplum Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Greenplum to connect to Greenplum data and execute queries in PowerBuilder.
-
Integrating Claude Code CLI with Campaigner 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 Gong Data in Excel 365 Online (Excel for the web)
Connect to Gong data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Multiple NASA Accounts
Replicate multiple NASA accounts to one or many databases.
-
Integrating Kiro with Zoho Creator 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.
-
Automated Continuous Demio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Demio replication to SQL Server.
-
Connecting GenSpark with Klaviyo Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Klaviyo data without any replication or custom integration required.
-
Build Dashboards with Dynamics CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Dynamics CRM data in Dundas BI.
-
Connect to Jumpseller Data in JRuby
Create a simple JRuby app with access to live Jumpseller data.
-
Visualize Freshteam Data in Sisense
Create an ElastiCube in Sisense app with access to Freshteam data.
-
Viewing ZohoSubscriptions Data in RAD Studio Data Explorer
How to view ZohoSubscriptions data in RAD Studio Data Explorer using the CData ODBC Driver for ZohoSubscriptions.
-
Connect to Monday.com Data in JRuby
Create a simple JRuby app with access to live Monday.com data.
-
Model Pipedrive Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Pipedrive, enabling the direct import of real-time Pipedrive data.
-
Integrating Claude Code CLI with BigQuery 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 OneNote Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live OneNote data from HeidiSQL.
-
Automated Continuous Adobe Target Replication to SQL Server
Use CData Sync for automated, continuous, customizable Adobe Target replication to SQL Server.
-
Visualize FHIR Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FHIR data.
-
Access SQL Analysis Services Data from MySQL in Amazon QuickSight
Connect to SQL Analysis Services and build visualizations of SQL Analysis Services data using a MySQL Connection in Amazon QuickSight.
-
Create Datasets from Bugsnag in Domo Workbench and Build Visualizations of Bugsnag Data in Domo
Use the CData Software ODBC Driver for Bugsnag to create datasets from Bugsnag data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Power BI Connector for SendGrid
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SendGrid.
-
Connect to SAP SuccessFactors LMS Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP SuccessFactors LMS Data and connect to SAP SuccessFactors LMS data in Akorbi Digital RunMyProcess.
-
How to create an RPA flow for ServiceDesk Plus Data in UiPath Studio
Use the ServiceDesk Plus ODBC Driver to create workflows that access real-time ServiceDesk Plus data without any coding.
-
Connect to Telegram Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Telegram data using standard SQL.
-
Integrate Open WebUI with Live QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live QuickBooks data from within the chat interface.
-
Automated Continuous TaxJar Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable TaxJar replication to Apache Kafka.
-
Getting Started with the CData ADO.NET Provider for Contentful
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build AlloyDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live AlloyDB data and build visualizations in Tableau Cloud.
-
Visualize Billsby Data in TIBCO Spotfire through ADO.NET
Integrate Billsby data into dashboards in TIBCO Spotfire.
-
Access Live CapsuleCRM Data in AWS Lambda
Connect to live CapsuleCRM data in AWS Lambda using the CData JDBC Driver.
-
Publish BigQuery-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BigQuery data.
-
Integrate with Azure DevOps Data in JReport Designer
Create charts and reports based on Azure DevOps data in JReport Designer.
-
Connect to and Visualize Live SAP HANA XS Advanced Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP HANA XS Advanced data.
-
Integrate Google's Antigravity Agent with Live Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Guru data using the Model Context Protocol.
-
Create Dynamic Excel Grids Using the Infragistics XamDataGrid
Learn how you can connect Excel to Infragistics XamDataGrid to build dynamic grids.
-
Helpscout Reporting in OBIEE with the Helpscout JDBC Driver
Deploy the Helpscout JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Splunk Data in RapidMiner
Integrate Splunk data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build an OLAP Cube in SSAS from ADP Data
Establish a connection to ADP data data from SQL Server Analysis Services, and use the ADP Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live Cloudant 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 Cloudant data for you.
-
Visualize Zoho Recruit Data in Tableau
The CData ODBC driver for Zoho Recruit enables you integrate Zoho Recruit data into Tableau dashboards.
-
Create Apollo-Connected Nintex Workflows
Use CData Connect AI to connect to Apollo Data from Nintex Workflow Cloud and build custom workflows using live Apollo data.
-
How to Connect Flowise AI Agents to Live SingleStore 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 SingleStore data without replication.
-
Analyze Live MailerLite Data in SAS Viya
Use CData Connect AI to connect to MailerLite data from SAS Viya and deploy self-service analytics using live MailerLite data.
-
Process & Analyze Jira Assets Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Jira Assets Data.
-
Visualize Live Dynamics 365 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Dynamics 365 data.
-
Create Power BI Reports on Real-Time Flowlu Data
Use the CData ODBC Driver for Flowlu to visualize Flowlu data in Power BI Desktop.
-
Publish Reports with Azure Data Catalog Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Data Catalog data.
-
Microsoft Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Ads data through CData Connect AI using different applications and tools.
-
Visualize Cvent Data in TIBCO Spotfire through OData
Integrate Cvent data into dashboards in TIBCO Spotfire.
-
Connect to Azure Table Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Table data.
-
Configure the CData JDBC Driver for Workable in a Connection Pool in Tomcat
Connect to Workable data from a connection pool in Tomcat.
-
Work with Parquet Data in FoxPro
Load Parquet data into a FoxPro database. This article includes full code and a walk-through of the process.
-
A PostgreSQL Interface for Mixpanel Data using the CData ODBC Driver
Use the SQL Gateway and Mixpanel ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Apify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apify data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Replicate Multiple Cloudflare Accounts via the CData Sync CLI
Replicate multiple Cloudflare accounts to one or many databases.
-
Create a Data Access Object for eBay Analytics Data using JDBI
A brief overview of creating a SQL Object API for eBay Analytics data in JDBI.
-
How to connect to Facebook Data from IntelliJ
Integrate connectivity to Facebook data with wizards in IntelliJ.
-
Getting Started with the CData JDBC Driver for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CapsuleCRM.
-
Create Redshift Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Redshift from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect PolyBase to BambooHR
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live BambooHR data.
-
How to work with QuickBooks Online Data in Apache Spark using SQL
Access and process QuickBooks Online Data in Apache Spark using the CData Software JDBC Driver.
-
Design BIRT Reports on Odoo Data
Provide current Odoo data to your embedded analytics.
-
Create Pinterest-Connected Nintex Workflows
Use CData Connect AI to connect to Pinterest Data from Nintex Workflow Cloud and build custom workflows using live Pinterest data.
-
Visualize Confluence Data in Tableau
The CData ODBC driver for Confluence enables you integrate Confluence data into Tableau dashboards.
-
How to import LightSpeedRetail Data into Apache Solr
Use the CData Software JDBC Driver for LightSpeedRetail in Data Import Handler and create an automated import of LightSpeedRetail data to Apache Solr Enterprise Search platform.
-
How to load Microsoft OneDrive data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft OneDrive data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous IBM Cloud Object Storage Replication to Oracle
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Oracle.
-
Automated Continuous Lakebase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Lakebase replication to Apache Cassandra.
-
Query Live PingOne Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live PingOne data through a conversational interface.
-
DataBind Controls to PingOne Data in Delphi
DataBind to PingOne data in Delphi with standard data access components and controls.
-
How to Connect to Live LinkedIn Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your LinkedIn data for you.
-
Connect to Lakebase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Lakebase data using standard SQL.
-
Build AI/ML Models with Live Factorial Data using Dataiku
Connect Factorial Data with Dataiku using the CData API Driver for JDBC.
-
Automate Facebook Data Replication to Couchbase
Use CData Sync to Customize and automate Facebook data replication to Couchbase.
-
Integrate OpenCode with Live Marketo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Marketo data from within your AI coding agent.
-
Connect to MariaDB Data in DBeaver
Use the CData ODBC Driver to connect to MariaDB data in DBeaver.
-
Automated Continuous Cassandra Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cassandra replication to Apache Kafka.
-
Explore Geographical Relationships in Twitter Ads Data with Power Map
Create data visualizations with Twitter Ads data in Power Map.
-
Connect to iContact Data as an External Source in Dremio
Use the CData JDBC Driver to connect to iContact as an External Source in Dremio.
-
Integrate Live Vertica Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Vertica from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Vertica data.
-
Integrate Webex Data in Pentaho Data Integration
Build ETL pipelines based on Webex data in the Pentaho Data Integration tool.
-
How to Query SQL Analysis Services Data in MySQL Workbench
Execute MySQL queries against live SQL Analysis Services data from MySQL Workbench.
-
Integrating Claude Code CLI with Harvest 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.
-
Natively Connect to Avaza Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Avaza data. Leverage the native support for ODBC in PHP.
-
Bridge Airtable Connectivity with Apache NiFi
Access and process Airtable data in Apache NiFi using the CData JDBC Driver.