CData Software - Knowledge Base
Recent Articles
-
Build Google Directory-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Directory Data from Zoho Analytics and import live Google Directory.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Data Lake Storage using the Model Context Protocol.
-
Connect to Avaza Data in RapidMiner
Integrate Avaza with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for Mixpanel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mixpanel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Printify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Printify replication to AlloyDB.
-
How to Import Data from Pipedrive into Google Sheets
Import Pipedrive into a Google spreadsheet that is automatically refreshed.
-
Connect to Basecamp Data in RazorSQL
Connect to Basecamp from wizards and query Basecamp from the GUI in the RazorSQL database management tool.
-
Create SSAS Tabular Models from Supabase Data
How to build a SQL Server Analysis Service Tabular Model from Supabase using CData drivers.
-
Back Up Oracle Eloqua to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Eloqua. In this article, we will employ an SSIS workflow to populate a database with Oracle Eloqua data.
-
Access Live SAP Ariba Procurement Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Ariba Procurement from your Excel spreadsheets.
-
Query Cloudflare Data as a MySQL Database in Node.js
Execute MySQL queries against Cloudflare from Node.js.
-
Integrate Mixpanel with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mixpanel with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mixpanel.
-
Working with ZohoExpense Data in LINQPad
Execute LINQ queries to ZohoExpense in LINQPad.
-
Integrating Claude Code with Microsoft Dataverse Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Dataverse (CDS) within assisted coding and automated development workflows.
-
How to Seamlessly Import SAP ByDesign Data into IBM SPSS Modeler
Integrate SAP ByDesign data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software JDBC Driver for Teamwork in MicroStrategy
Connect to Teamwork in MicroStrategy Developer using the CData Software JDBC Driver for Teamwork.
-
Integrating Antigravity CLI with Exa via CData CLI
Connect Exa to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Tableau Connector for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Planner.
-
Connect to Freshteam Data in DBeaver
Use the CData ODBC Driver to connect to Freshteam in DBeaver.
-
Build Semantic Layer Views for Paylocity Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Paylocity.
-
Build Pipelines with Live Trello Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Trello from Google Cloud Data Fusion, enabling the integration of live Trello into the building and management of effective data pipelines.
-
Getting Started with the CData Excel Add-In for Testmonitor
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Testmonitor.
-
Import Real-Time Oracle Eloqua Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle Eloqua in ColdFusion.
-
Automated Continuous QuickBooks Time Replication to Vertica
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Vertica.
-
Create Data Visualizations in Cognos BI with Hugging Face Data
Access Hugging Face as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Claude Code CLI with Contentful 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.
-
Model, Search, and Visualize Live Cvent Data in ThoughtSpot
Use CData Connect AI to connect to live Cvent for modeling, searching, and visualizing.
-
Azure Data Lake Storage Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure Data Lake Storage through CData Connect AI using different applications and tools.
-
Access Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics through MCP integration.
-
How to connect to Beeminder Data with Squirrel SQL client
Connect to Beeminder and execute queries in the Squirrel SQL Client.
-
Model YouTube Analytics Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and YouTube Analytics, enabling the direct import of real-time YouTube Analytics.
-
Working with Dropbox Data in LINQPad
Execute LINQ queries to Dropbox in LINQPad.
-
Automate Wistia Data Replication to Azure Synapse
Use CData Sync to customize and automate Wistia replication to Azure Synapse.
-
Build MVC Applications with Connectivity to HCL Domino Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HCL Domino from an ASP.NET MVC application.
-
Analyze Gong Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Gong and visualize live Gong in Infragistics Reveal.
-
Build Data Flows from Telegram to SQL Server using SSIS
Easily back up Telegram to SQL Server using the SSIS components for Telegram.
-
Connect to and Visualize Live Cloudflare Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Cloudflare.
-
Build Dashboards with Drift Data in DBxtra
Create dynamic dashboards and perform analytics based on Drift in DBxtra.
-
Connect to BenchmarkEmail Data from PowerBuilder via ADO.NET
This article demonstrates how to access BenchmarkEmail from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Bind Live Redis Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Redis data
-
Connect to Azure Data Lake Storage Data in DBeaver
Use the CData ODBC Driver to connect to Azure Data Lake Storage in DBeaver.
-
How to create Google Spanner federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Spanner in MySQL .
-
Automated Continuous Greenplum Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Greenplum replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for Google Translate in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Translate in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Translate.
-
Visualize Google Sheets Data in Tableau
The CData ODBC driver for Google Sheets enables you integrate Google Sheets into Tableau dashboards.
-
Use the CData ODBC Driver for Avalara AvaTax from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Avalara AvaTax to connect to Avalara AvaTax from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Avalara AvaTax in Excel.
-
Connect to Suadeo Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Suadeo and the Script function in FileMaker Pro to connect to Suadeo and work with Suadeo in your FileMaker application.
-
Getting Started with the CData SSIS Components for Klaviyo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Klaviyo.
-
Stream Google Ad Manager Data into Apache Kafka Topics
Access and stream Google Ad Manager in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create SAP HANA-Connected Dashboards in Grafana
Connect to SAP HANA Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP HANA.
-
How to Import Data from BigQuery into Google Sheets
Import Google BigQuery into a Google spreadsheet that is automatically refreshed.
-
Access ShipStation 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 ShipStation.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Ad Manager using the Model Context Protocol.
-
Automated Continuous Paylocity Replication to SingleStore
Use CData Sync for automated, continuous, customizable Paylocity replication to SingleStore.
-
Insightly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Insightly facts in real time.
-
How to Query Live Greenplum Data in Perplexity MacOS Desktop
Connect to and query live Greenplum Data in Perplexity Desktop using CData MCP Server.
-
Build Charts with Nuclia Data in Clear Analytics
Create dynamic charts and perform analytics based on Nuclia in Clear Analytics.
-
Extend Google Sheets with Asana Data
Make calls to Asana from Google Apps Script via the API Server.
-
Automate Oracle Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Database replication to Azure Data Lake.
-
Build Pipeliner CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Pipeliner CRM and build web apps with connectivity to live Pipeliner CRM.
-
Automated Continuous Workday Replication to MySQL
Use CData Sync for automated, continuous, customizable Workday replication to MySQL.
-
Access Live Sage 200 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage 200 into the statistical analysis tools available in SAS JMP. This article shows how to use Sage 200 in the Graph Builder and Query Builder.
-
DataBind Charts to Kafka Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Kafka 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.
-
Integrate Real-Time Access to REST in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to REST in real time.
-
Model SAP Ariba Source Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Ariba Source, enabling the direct import of real-time SAP Ariba Source.
-
Bidirectional Access to Stack Exchange Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Stack Exchange in Filemaker Pro for Mac or Windows.
-
Automated Continuous GetResponse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GetResponse replication to Google Cloud SQL.
-
Integrating Kiro CLI with Guru 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.
-
Model, Search, and Visualize Live SAP Hybris C4C Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Hybris C4C for modeling, searching, and visualizing.
-
Visualize Live Freshservice Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Freshservice into custom reports in Power BI.
-
Getting Started with the CData Tableau Connector for Drip
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Apps with Live Shopify in Adalo using CData Connect AI
Use CData Connect AI to integrate live Shopify into the Adalo platform and build custom mobile and web applications with real-time Shopify.
-
Natively Connect to ShipStation Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ShipStation. Leverage the native support for ODBC in PHP.
-
How to integrate Metabase with SAP Netweaver Gateway Data
Use CData Connect AI to connect to live SAP Netweaver Gateway and create an interactive dashboard in Metabase from SAP Netweaver Gateway.
-
Visualize Avro Data in TIBCO Spotfire through ADO.NET
Integrate Apache Avro into dashboards in TIBCO Spotfire.
-
Connect and Query Live Google Sheets Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Sheets into Databricks
-
Excel Spreadsheet Automation on AdRoll Data with the QUERY Formula
Pull data from AdRoll, automate spreadsheets, and more with the QUERY formula.
-
Connect to Rebilly in SpagoBI
Create reports featuring live Rebilly in SpagoBI Studio. Host Rebilly reports on SpagoBI Server.
-
Migrating data from Omnisend to Databricks using CData SSIS Components.
Easily push Omnisend to Databricks using the CData SSIS Tasks for Omnisend and Databricks.
-
Integrating Codex CLI with ElevenLabs 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.
-
How to import Confluence Data into Apache Solr
Use the CData Software JDBC Driver for Confluence in Data Import Handler and create an automated import of Atlassian Confluence to Apache Solr Enterprise Search platform.
-
Perform Batch Operations with FTP Data in Apache NiFi
Connect to FTP Servers and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for Teamgate Data using the CData JDBC Driver
Use the Remoting features of the Teamgate JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to API Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live API from Filemaker Pro on Mac.
-
Consume Certinia OData Feeds in PowerBuilder
This article demonstrates how to consume Certinia as OData feeds from PowerBuilder using the API Server.
-
How to Build an ETL App for Amazon Marketplace Data in Python with CData
Create ETL applications and real-time data pipelines for Amazon Marketplace in Python with petl.
-
Build BigCommerce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BigCommerce and build web apps with connectivity to live BigCommerce.
-
Build MVC Applications with Connectivity to Optimizely Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Optimizely from an ASP.NET MVC application.
-
Create Data Visualizations in Cognos BI with Supabase Data
Access Supabase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Parallel from Asprova with CData Software ODBC Driver for Parallel
This article shows how to connect faster to Parallel data from Asprova.
-
ETL Onfleet in Oracle Data Integrator
This article shows how to transfer Onfleet into a data warehouse using Oracle Data Integrator.
-
Integrate Cline with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Blackbaud FE NXT from within your IDE.
-
Migrating data from Blackbaud FE NXT to Google BigQuery using CData SSIS Components.
Easily push Blackbaud FE NXT to Google BigQuery using the CData SSIS Tasks for Blackbaud FE NXT and Google BigQuery.
-
Use Biml to Build SSIS Tasks to Replicate Flowlu Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Flowlu to SQL Server.
-
Integrating Claude Code CLI with Amazon S3 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 Hive Data in Ruby
Connect to Apache Hive in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Query Live Trello Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Trello data in natural language using Python.
-
Object-Relational Mapping (ORM) with Reckon 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 Reckon into a Java-based ORM framework, Hibernate.
-
Automated Continuous Box Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Box replication to Azure SQL Database.
-
Rapidly Develop Placid-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 Placid.