CData Software - Knowledge Base
Recent Articles
-
Connect to and Query ElevenLabs Data in QlikView over ODBC
Create data visualizations with ElevenLabs data in QlikView.
-
Perform Batch Operations with Snowflake Data in Apache NiFi
Connect to Snowflake data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Creating SAP Netweaver Gateway-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Netweaver Gateway data to Unqork and build custom business apps.
-
How to connect to BigCommerce Data with Squirrel SQL client
Connect to BigCommerce data and execute queries in the Squirrel SQL Client.
-
Connect to Zoho Creator Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Creator as an External Source in Dremio.
-
Query Grafana Data as a SQL Server Database in Node.js
Execute SQL Server queries against Grafana data from Node.js.
-
Analyze LightSpeedRetail Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LightSpeedRetail from Power Pivot. You will use the Table Import Wizard to load LightSpeedRetail data. You can visually build the import query or use any SQL supported by the driver.
-
Easily Integrate Browserless Data in Lazarus Pascal IDE
Learn how to easily integrate live Browserless data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Object-Relational Mapping (ORM) with Zoho Projects 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 Zoho Projects data into a Java-based ORM framework, Hibernate.
-
Establish a Live Connection with Parquet Data using Tableau Bridge
The CData ODBC Driver for Parquet enables you to integrate live Parquet data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Claude to Talk to Your Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Zoho Inventory data for you.
-
Access Live Webflow Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Webflow data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import Real-Time SageHR Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SageHR data in ColdFusion.
-
Connect to BigCommerce Data from HeidiSQL
Use CData Connect AI to connect to and query live BigCommerce data from HeidiSQL.
-
Getting Started with the CData Excel Add-In for Azure Table
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Table.
-
Migrating data from PostgreSQL to Snowflake using CData SSIS Components.
Easily push PostgreSQL data to Snowflake using the CData SSIS Tasks for PostgreSQL and Snowflake.
-
DataBind Controls to Apollo Data in Delphi
DataBind to Apollo data in Delphi with standard data access components and controls.
-
Work with Wave Financial Data in FoxPro
Load Wave Financial data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connecting Pipedream with Spark 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 Spark data in real time.
-
Automate Twilio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Twilio data replication to Azure Data Lake.
-
Use the CData ODBC Driver for BambooHR in Microsoft Power Query
You can use the CData BambooHR ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import BambooHR data into Microsoft Power Query.
-
Connect to Highrise Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Highrise data.
-
Integrate Cline with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoho CRM data from within your IDE.
-
DataBind Jodoo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Jodoo data to a chart.
-
Create Dynamics 365 Business Central-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Dynamics 365 Business Central Data from OutSystems and build custom enterprise apps using live Dynamics 365 Business Central data.
-
Build Semantic Layer Views for SAP ByDesign Data in APOS Live Data Gateway
Use the CData Connector for SAP ByDesign in APOS Live Data Gateway to build Semantic Layer Views for SAP ByDesign data.
-
Connect to Autopilot Data in DBeaver
Use the CData ODBC Driver to connect to Autopilot data in DBeaver.
-
Build Semantic Layer Views for Phoenix Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Phoenix data.
-
Create Microsoft Exchange-Connected Applications in Appsmith
Connect to Microsoft Exchange Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Exchange data.
-
Connecting GenSpark with Cassandra Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Cassandra data without any replication or custom integration required.
-
Build Klipfolio-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Klipfolio Data from Zoho Analytics and import live Klipfolio data.
-
How to Connect DBeaver to Authorize.Net via a JDBC Driver
Manage Authorize.Net data with visual tools in DBeaver like the query browser.
-
Build Semantic Layer Views for Oracle Service Cloud Data in APOS Live Data Gateway
Use the CData Connector for Oracle Service Cloud in APOS Live Data Gateway to build Semantic Layer Views for Oracle Service Cloud data.
-
LINQ to SingleStore Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SingleStore Data Provider.
-
Automated Continuous Pingdom Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pingdom replication to Apache Kafka.
-
Use the CData Software JDBC Driver for Google Cloud Storage in MicroStrategy
Connect to Google Cloud Storage data in MicroStrategy Developer using the CData Software JDBC Driver for Google Cloud Storage.
-
Access Clio 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 Clio data.
-
Automated Continuous GitLab Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable GitLab replication to Azure SQL Database.
-
Integrate Google's Vertex AI Agent with Live Zoho Creator 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 Zoho Creator data within intelligent workflows.
-
How to integrate Metabase with Exa Data
Use CData Connect AI to connect to live Exa data and create an interactive dashboard in Metabase from Exa data.
-
Create Data Visualizations in Cognos BI with MailerLite Data
Access MailerLite data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to PayPal Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PayPal data.
-
Connect to Google Drive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Drive and the SQL Gateway to access Google Drive data from Google Apps Script.
-
Bind Live Square Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Square data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create a Data Access Object for SAP HANA XS Advanced Data using JDBI
A brief overview of creating a SQL Object API for SAP HANA XS Advanced data in JDBI.
-
How to Create Power BI Visual Reports with Real-Time Scrapfly Data
Use CData Power BI Connectors to visualize Scrapfly data in Power BI.
-
Analyze Sage Intacct Data in Cognos Analytics
Use CData Connect AI to connect to Sage Intacct Data from Cognos Analytics and analyze live Sage Intacct data.
-
How to Query Google Spanner Data in MySQL Workbench
Execute MySQL queries against live Google Spanner data from MySQL Workbench.
-
How to Build an ETL App for Mailjet Data in Python with CData Connect AI
Extract and transform live Mailjet data in Python with petl and the CData Connect AI Python SDK.
-
Build Zoho CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho CRM data and build visualizations in Tableau Cloud.
-
Replicate SendPulse Data in Heroku for Use in Salesforce Connect
Replicate SendPulse data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to import Stripe Data into Apache Solr
Use the CData Software JDBC Driver for Stripe in Data Import Handler and create an automated import of Stripe data to Apache Solr Enterprise Search platform.
-
Integrating Gumloop with AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on AfterShip data within automated workflows.
-
Manage Omnisend Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Omnisend.
-
Build Dashboards with Timely Data in DBxtra
Create dynamic dashboards and perform analytics based on Timely data in DBxtra.
-
Automated Continuous Bullhorn CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to AlloyDB.
-
How to connect to Highrise Data with Squirrel SQL client
Connect to Highrise data and execute queries in the Squirrel SQL Client.
-
Build an OLAP Cube in SSAS from WordPress Data
Establish a connection to WordPress data data from SQL Server Analysis Services, and use the WordPress Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create MailChimp-Connected Business Apps in AppSheet
Connect to MailChimp Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MailChimp data.
-
Natively Connect to Elorus Data in PHP
The CData ODBC driver for Elorus enables you to create PHP applications with connectivity to Elorus data. Leverage the native support for ODBC in PHP.
-
Trigger Stripe IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Stripe with standard wizards in Logic Apps.
-
Automated Continuous Gong Replication to MongoDB
Use CData Sync for automated, continuous, customizable Gong replication to MongoDB.
-
How to Easily Query Billsby Data in OpenOffice Base
Connect to Billsby data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live Redshift Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Redshift data from your Excel spreadsheets.
-
ETL Phoenix in Oracle Data Integrator
This article shows how to transfer Phoenix data into a data warehouse using Oracle Data Integrator.
-
Visualize Flowlu Data in Sisense
Create an ElastiCube in Sisense app with access to Flowlu data.
-
How to publish and share Toggl Data dashboards with Tableau Server
The CData ODBC driver for Toggl enables you integrate Toggl data into Tableau dashboards.
-
Integrate Jodoo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jodoo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Jodoo data.
-
Getting Started with the CData Tableau Connector for Hugging Face
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Reckon Replication to Oracle
Use CData Sync for automated, continuous, customizable Reckon replication to Oracle.
-
Use the CData Software ODBC Driver for Supabase in MicroStrategy Desktop
Connect to Supabase data in MicroStrategy Desktop using the CData Software ODBC Driver for Supabase.
-
How to Connect DBeaver to Adobe Analytics via a JDBC Driver
Manage Adobe Analytics data with visual tools in DBeaver like the query browser.
-
Build Dashboards with Blackbaud FE NXT Data in Dundas BI
Create dynamic dashboards and perform analytics based on Blackbaud FE NXT data in Dundas BI.
-
Analyze ShipStation Data in Cognos Analytics
Use CData Connect AI to connect to ShipStation Data from Cognos Analytics and analyze live ShipStation data.
-
Access Excel Online Data from MySQL in Amazon QuickSight
Connect to Excel Online and build visualizations of Excel Online data using a MySQL Connection in Amazon QuickSight.
-
Analyze Supabase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Supabase from Power Pivot. You will use the Table Import Wizard to load Supabase data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Printful Data in Sisense
Create an ElastiCube in Sisense app with access to Printful data.
-
Create Bugsnag Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Bugsnag data access from reports, embedded analytics, and more.
-
Visualize Tickspot Data in Sisense
Create an ElastiCube in Sisense app with access to Tickspot data.
-
Add Mode Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mode with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate GraphQL Data Replication to SAP HANA
Use CData Sync to customize and automate GraphQL data replication to SAP HANA.
-
Build Visualizations of PhantomBuster Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PhantomBuster data in Birst.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LinkedIn
Provide connectivity to LinkedIn data through an SAP BusinessObjects universe.
-
Analyze EnterpriseDB Data in Looker
Use CData Connect AI to connect to EnterpriseDB Data from Looker and build custom apps using live EnterpriseDB data.
-
Create Informatica Mappings From/To an ODBC Data Source for Quaderno
Create an ODBC connection to Quaderno in Informatica and browse and transfer Quaderno data.
-
Integrating Gumloop with Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Office 365 data within automated workflows.
-
DataBind Controls to Drip Data in C++Builder
DataBind to Drip data in C++Builder with standard components and controls.
-
Integrate Google's Antigravity Agent with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Splunk data using the Model Context Protocol.
-
Migrating data from Bannerbear to Google BigQuery using CData SSIS Components.
Easily push Bannerbear data to Google BigQuery using the CData SSIS Tasks for Bannerbear and Google BigQuery.
-
Prepare, Blend, and Analyze Oracle Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle data for self-service data analytics.
-
Use the CData Software JDBC Driver for Excel Online in MicroStrategy Desktop
Connect to Excel Online data in MicroStrategy Desktop using the CData Software JDBC Driver for Excel Online.
-
Connect to RSS Feeds in RazorSQL
Connect to RSS from wizards and query RSS feeds from the GUI in the RazorSQL database management tool.
-
DataBind Charts to eBay Analytics Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to eBay Analytics data 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.
-
How to integrate Monday.com with Apache Airflow
Access and process Monday.com data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Square Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Square replication to Google Cloud SQL.
-
Natively Connect to Google Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Ads data. Leverage the native support for ODBC in PHP.
-
Create SAP ByDesign-Connected Business Apps in AppSheet
Connect to SAP ByDesign Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP ByDesign data.
-
Build MVC Applications with Connectivity to Attio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Attio from an ASP.NET MVC application.
-
Connect to Quickbase Data in RapidMiner
Integrate Quickbase data with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of Templated Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Templated data by developing a WCF Service Application.