CData Software - Knowledge Base
Recent Articles
-
Analyze Google Calendar Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Calendar and visualize live Google Calendar in Infragistics Reveal.
-
Extend Google Sheets with Microsoft Exchange Data
Make calls to Microsoft Exchange from Google Apps Script via the API Server.
-
Automated Continuous Shopify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Shopify replication to Google Cloud SQL.
-
Connect to Microsoft Teams Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Teams in Google Apps Script.
-
Create Gmail-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Gmail Data from Klipfolio and build custom visualizations using live Gmail.
-
Connect to Datadog Data in HULFT Integrate
Connect to Datadog as a JDBC data source in HULFT Integrate
-
Query LightSpeedRetail Data in ColdFusion
Write standard ColdFusion data access code to connect to LightSpeedRetail.
-
Enable the Pinterest JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pinterest.
-
Connecting Agentforce with Twitter Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Twitter Ads for you.
-
Create a Data Access Object for Timely Data using JDBI
A brief overview of creating a SQL Object API for Timely in JDBI.
-
Integrating GitHub Copilot CLI with Rootly 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.
-
Building Dynamic Web Pages with Snapchat Ads Data Using AngularJS
Create single-page applications with live connectivity to Snapchat Ads using the CData API Server.
-
DataBind Controls to Productboard Data in Delphi
DataBind to Productboard in Delphi with standard data access components and controls.
-
Query, Visualize, and Share live HCL Domino Data in Redash
Use CData Connect AI to connect to live HCL Domino in Redash for querying, visualizing, and sharing.
-
Getting Started with the CData Python Connector for Oracle Sales
Learn to install and license the CData Python Connector
-
How to load Oracle Eloqua data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Eloqua data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software JDBC Driver for ActiveCampaign in MicroStrategy Desktop
Connect to ActiveCampaign in MicroStrategy Desktop using the CData Software JDBC Driver for ActiveCampaign.
-
Connect to HelloSign from a Connection Pool in WebLogic
Use the CData JDBC Driver for HelloSign to connect to HelloSign from Web applications running on WebLogic.
-
Publish Crystal Reports on MySQL Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MySQL.
-
Integrate Live Drift Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Drift to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Getting Started with the CData JDBC Driver for ZohoExpense
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoExpense.
-
Create Data Visualizations in Cognos BI with ZarMoney Data
Access ZarMoney as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to and Visualize Live OneNote Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft OneNote.
-
Create Apps from Highrise Data in Qlik Sense Cloud
Use CData Connect AI to connect to Highrise Data and build apps from live Highrise CRM in Qlik Sense Cloud.
-
Connect to Real-Time SAP Ariba Procurement Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP Ariba Procurement and Dataflow to import and use SAP Ariba Procurement in Power Apps.
-
Build Data Flows from SQL Server to HBase through SSIS
Easily push SQL Server data to HBase using the CData SSIS Tasks for HBase.
-
Use the CData Software ODBC Driver for Adobe Commerce in MicroStrategy Desktop
Connect to Adobe Commerce in MicroStrategy Desktop using the CData Software ODBC Driver for Adobe Commerce.
-
Query Redis Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Redis from Node.js.
-
Integrate Cursor with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Inventory from within the editor.
-
Stream Unbounce Data into Apache Kafka Topics
Access and stream Unbounce in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData JDBC Driver for ConvertKit
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ConvertKit.
-
Connect Missive Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Missive using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze ClickUp Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ClickUp with the CData JDBC Driver for ClickUp.
-
Integrate Live Avalara AvaTax Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build MVC Applications with Connectivity to Splunk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Splunk from an ASP.NET MVC application.
-
Analyze Hacker News Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hacker News from Power Pivot. You will use the Table Import Wizard to load Hacker News. You can visually build the import query or use any SQL supported by the driver.
-
Query Delighted Data as a MySQL Database in Node.js
Execute MySQL queries against Delighted from Node.js.
-
Automate ZohoMarketingHub Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoMarketingHub replication to Azure Synapse.
-
Build an OLAP Cube in SSAS from Pushbullet Data
Establish a connection to Pushbullet data from SQL Server Analysis Services, and use the Pushbullet Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Automated Workflows with Live Active Directory Data in Workato
Use CData Connect AI to connect to live Active Directory and build automated workflows in Workato.
-
Automated Continuous SpaceX Replication to Oracle
Use CData Sync for automated, continuous, customizable SpaceX replication to Oracle.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Suadeo to Power BI dashboards. Simply drag and drop Suadeo into data visuals on the Power BI canvas.
-
Integrate Cursor with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Shopify from within the editor.
-
How to Connect DBeaver to MessageBird via a JDBC Driver
Manage MessageBird with visual tools in DBeaver like the query browser.
-
Replicate Multiple Jumpseller Accounts
Replicate multiple Jumpseller accounts to one or many databases.
-
A PostgreSQL Interface for QuickBooks Data (MySQL Remoting via JDBC)
Use the Remoting features of the QuickBooks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live LinkedIn Ads Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live LinkedIn Ads from your Excel spreadsheets.
-
How to Connect to Live Asana Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Asana securely in real time.
-
AlloyDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on AlloyDB facts in real time.
-
Extract, Transform, and Load Front Data in Informatica PowerCenter
Create a simple Workflow for Front in Informatica PowerCenter.
-
Visualize Adobe Analytics Data in TIBCO Spotfire through OData
Integrate Adobe Analytics into dashboards in TIBCO Spotfire.
-
Build Data Flows from Copper to SQL Server using SSIS
Easily back up Copper to SQL Server using the SSIS components for Copper.
-
Natively Connect to Sentry Data in PHP
The CData ODBC driver for Sentry enables you to create PHP applications with connectivity to Sentry. Leverage the native support for ODBC in PHP.
-
Publish Samanage-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Samanage.
-
Getting Started with the CData Power BI Connector for Oracle
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle.
-
How to connect and process Jumpseller from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Jumpseller.
-
Connect to Invoiced Data in RazorSQL
Connect to Invoiced from wizards and query Invoiced from the GUI in the RazorSQL database management tool.
-
Import Real-Time Exact Online Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Exact Online in ColdFusion.
-
Connect to GraphQL Data from PowerBuilder via JDBC
This article demonstrates how to access GraphQL from PowerBuilder using the GraphQL JDBC Driver.
-
Object-Relational Mapping (ORM) with Okta 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 Okta into a Java-based ORM framework, Hibernate.
-
Build QuickBooks Time-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to QuickBooks Time and build web apps with connectivity to live QuickBooks Time.
-
Create Informatica Mappings From/To a JDBC Data Source for HBase
Create HBase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData ODBC Driver for MailerLite in Microsoft Power Query
You can use the CData MailerLite ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MailerLite into Microsoft Power Query.
-
How to Build an ETL App for PabblySubscriptions Data in Python with CData
Create ETL applications and real-time data pipelines for PabblySubscriptions in Python with petl.
-
Build Odoo Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Odoo ERP and build visualizations in Tableau Cloud.
-
How to Visualize Sage Intacct Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Sage Intacct in Python.
-
How to Access Live MarkLogic Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MarkLogic enables you to integrate MarkLogic into workflows built using Microsoft Power Automate Desktop.
-
Connect to Odoo Data from HeidiSQL
Use CData Connect AI to connect to and query live Odoo ERP from HeidiSQL.
-
Choosing the Best Method to Connect Jira Assets to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Jira Assets from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Access Live Teradata Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Teradata enables you to integrate Teradata into workflows built using Microsoft Power Automate Desktop.
-
Integrating GitHub Copilot CLI with Elasticsearch 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 Close Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Close and work with Close in your FileMaker applications.
-
Connect to Access Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Access using standard SQL.
-
How to Create Power BI Visual Reports with Real-Time VWO Data
Use CData Power BI Connectors to visualize VWO in Power BI.
-
Automated Continuous Sage 200 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage 200 replication to PostgreSQL.
-
Use the CData ODBC Driver for IBM Informix from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for IBM Informix to connect to IBM Informix from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring IBM Informix in Excel.
-
Automated Continuous Elorus Replication to SQLite
Use CData Sync for automated, continuous, customizable Elorus replication to SQLite.
-
Connect to Stack Exchange Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Stack Exchange using standard SQL.
-
Build a Simple VCL Application for Reckon Accounts Hosted Data
How to build a simple VCL Application to view Reckon Accounts Hosted in RAD Studio using the CData ODBC Driver for Reckon Accounts Hosted.
-
Manage Avro Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Avro.
-
Work with Live HCL Domino Data in Power Query
Use CData Connect AI to connect to HCL Domino and work with live HCL Domino in Microsoft Power Query.
-
DataBind Controls to Amazon Marketplace Data in C++Builder
DataBind to Amazon Marketplace in C++Builder with standard components and controls.
-
Connect Google Forms to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Forms using the CData Python MCP Server.
-
Connect to Kintone Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Square Replication to Databricks
Use CData Sync for automated, continuous, customizable Square replication to Databricks.
-
Access Live Oracle Financials Cloud Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Financials Cloud data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create SSAS Tabular Models from Datadog Data
How to build a SQL Server Analysis Service Tabular Model from Datadog using CData drivers.
-
Build Deel-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Deel.
-
Connect Planio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Planio using the CData Python MCP Server.
-
Integrate Dynamics 365 Business Central with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dynamics 365 Business Central with External Services.
-
Create Dynamic HubDB Grids Using the Infragistics XamDataGrid
Learn how you can connect HubDB to Infragistics XamDataGrid to build dynamic grids.
-
Build a Singer.io Tap for Guru With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Guru data using
-
Automated Continuous IBM Informix Replication to Databricks
Use CData Sync for automated, continuous, customizable IBM Informix replication to Databricks.
-
Replicate Zoho Creator Data in Heroku for Use in Salesforce Connect
Replicate Zoho Creator to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Visualize Sybase Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Sybase in Python.
-
Query Planio Data in DataGrip
Create a Data Source for Planio in DataGrip and use SQL to query live Planio.
-
DataBind Controls to Pipeline CRM Data in Delphi
DataBind to Pipeline CRM in Delphi with standard data access components and controls.
-
Connect to Sage 300 Data in RazorSQL
Connect to Sage 300 from wizards and query Sage 300 from the GUI in the RazorSQL database management tool.
-
Access Live Sage Cloud Accounting Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Business Cloud Accounting from your Google Sheets.
-
DataBind Square Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Square with the DevExpress Windows Forms and Web controls to provide Square to a chart.