CData Software - Knowledge Base
Recent Articles
-
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. 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 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 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 Apache Parquet 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 for you.
-
Access Live Webflow Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Webflow 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 in ColdFusion.
-
Connect to BigCommerce Data from HeidiSQL
Use CData Connect AI to connect to and query live BigCommerce 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 to Snowflake using the CData SSIS Tasks for PostgreSQL and Snowflake.
-
DataBind Controls to Apollo Data in Delphi
DataBind to Apollo in Delphi with standard data access components and controls.
-
Work with Wave Financial Data in FoxPro
Load Wave Financial 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 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 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 CRM.
-
Build SharePoint Excel Services-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SharePoint Excel Services to explore live SharePoint Excel Services Data in Claude Code to assist with building SharePoint Excel Services-powered applications.
-
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 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 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.
-
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 Business ByDesign.
-
Connect to Autopilot Data in DBeaver
Use the CData ODBC Driver to connect to Autopilot 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 Apache Phoenix.
-
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.
-
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 Apache Cassandra without any replication or custom integration required.
-
How to Connect DBeaver to Authorize.Net via a JDBC Driver
Manage Authorize.Net 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.
-
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 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.
-
Automated Continuous GitLab Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable GitLab replication to Azure SQL Database.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho Creator within intelligent workflows.
-
Create Data Visualizations in Cognos BI with MailerLite Data
Access MailerLite 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.
-
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 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
-
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 in JDBI.
-
Connect to Real-Time Drift Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Drift in Power Apps.
-
How to Create Power BI Visual Reports with Real-Time Scrapfly Data
Use CData Power BI Connectors to visualize Scrapfly 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.
-
How to Query Google Spanner Data in MySQL Workbench
Execute MySQL queries against live Google Spanner from MySQL Workbench.
-
Build Zoho CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho CRM and build visualizations in Tableau Cloud.
-
Replicate SendPulse Data in Heroku for Use in Salesforce Connect
Replicate SendPulse 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 to Apache Solr Enterprise Search platform.
-
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 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 CRM and execute queries in the Squirrel SQL Client.
-
Build an OLAP Cube in SSAS from WordPress Data
Establish a connection to WordPress 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.
-
Build Excel Online-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Excel Online to explore live Excel Online Data in Gemini Code Assist to assist with building Excel Online-powered applications.
-
Natively Connect to Elorus Data in PHP
The CData ODBC driver for Elorus enables you to create PHP applications with connectivity to Elorus. 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.
-
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 Amazon Redshift from your Excel spreadsheets.
-
Analyze Active Directory Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Active Directory and visualize live Active Directory in Infragistics Reveal.
-
Automate eBay Analytics Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live eBay Analytics and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
ETL Phoenix in Oracle Data Integrator
This article shows how to transfer Apache Phoenix into a data warehouse using Oracle Data Integrator.
-
Visualize Flowlu Data in Sisense
Create an ElastiCube in Sisense app with access to Flowlu.
-
How to publish and share Toggl Data dashboards with Tableau Server
The CData ODBC driver for Toggl enables you integrate Toggl 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.
-
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 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 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 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.
-
Access Excel Online Data from MySQL in Amazon QuickSight
Connect to Excel Online and build visualizations of Microsoft Excel Online 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. 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.
-
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.
-
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 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 in Birst.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LinkedIn
Provide connectivity to LinkedIn 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Quaderno
Create an ODBC connection to Quaderno in Informatica and browse and transfer Quaderno.
-
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 Microsoft Office 365 within automated workflows.
-
DataBind Controls to Drip Data in C++Builder
DataBind to Drip in C++Builder with standard components and controls.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Splunk using the Model Context Protocol.
-
Migrating data from Bannerbear to Google BigQuery using CData SSIS Components.
Easily push Bannerbear 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 Database for self-service data analytics.
-
Use the CData Software JDBC Driver for Excel Online in MicroStrategy Desktop
Connect to Microsoft Excel Online 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 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 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. 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 Business ByDesign.
-
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 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 by developing a WCF Service Application.
-
How to Work with Reckon Data in ETL Validator JDBC
Connect to Reckon from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Open WebUI with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SendGrid from within the chat interface.
-
Integrate Theia IDE with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData Software ODBC Driver for Tanda in SAS for Real-Time Reporting and Analytics
Connect to real-time Tanda in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Tanda.
-
Access Live Workday Data in TIBCO Data Virtualization
Use the Workday Tibco DV Adapter to create a Workday data source in TIBCO Data Virtualization Studio and gain access to live Workday from your TDV Server.
-
Replicate Multiple Slack Accounts via the CData Sync CLI
Replicate multiple Slack accounts to one or many databases.