CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for LightSpeedRetail in MicroStrategy Web
Connect to LightSpeedRetail in MicroStrategy Web using the CData Software JDBC Driver for LightSpeedRetail.
-
Provide OData Services of Aircall Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Aircall by developing a WCF Service Application.
-
Rapidly Develop Pingdom-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 Pingdom.
-
Publish Crystal Reports on Vault CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Veeva Vault & Vault CRM.
-
Connect to Microsoft Entra ID Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Entra ID as an External Source in Dremio.
-
Build Oracle Service Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Service Cloud and build web apps with connectivity to live Oracle Service Cloud.
-
Migrating data from ZohoInvoice to Databricks using CData SSIS Components.
Easily push ZohoInvoice to Databricks using the CData SSIS Tasks for ZohoInvoice and Databricks.
-
Integrating SAP SuccessFactors LMS Data in Talend Cloud Data Management Platform
Connect SAP SuccessFactors LMS Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP SuccessFactors LMS.
-
Create Reports with Sage 300 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage 300.
-
Build Dashboards with Oracle Eloqua Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Eloqua in Dundas BI.
-
Replicate Workday Data to Multiple Databases
Replicate Workday to disparate databases with a point-and-click configuration.
-
Connect to Gorgias Data in Ruby
Connect to Gorgias in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to SAP Fieldglass Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Fieldglass using standard SQL.
-
Create Dynamic IBM Cloud Object Storage Grids Using the Infragistics XamDataGrid
Learn how you can connect IBM Cloud Object Storage to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Zuora Data in RazorSQL
Connect to Zuora from wizards and query Zuora from the GUI in the RazorSQL database management tool.
-
Replicate SAP SuccessFactors Data to Multiple Databases via the CData Sync CLI
Replicate SAP SuccessFactors to disparate databases with a single configuration.
-
Access Live Microsoft Planner Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Planner from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live Shortcut Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Shortcut in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Excel Spreadsheet Automation on Phoenix Data with the QUERY Formula
Pull data from Phoenix, automate spreadsheets, and more with the QUERY formula.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Translate
Create an ODBC connection to Google Translate in Informatica and browse and transfer Google Translate.
-
Automated Continuous Access Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Access replication to Amazon S3.
-
Build a PostgreSQL Interface for Recurly Data using the CData JDBC Driver
Use the Remoting features of the Recurly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Humanity Data in Jaspersoft Studio
Execute SQL to remote Humanity in Jaspersoft Studio.
-
Access Live SAP Data in AWS Lambda
Connect to live SAP ERP/NetWeaver in AWS Lambda using the CData JDBC Driver.
-
Work with CockroachDB Data in FoxPro
Load CockroachDB into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to SAP HANA Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP HANA from Filemaker Pro on Mac.
-
Create Neo4J-Connected Applications in Appsmith
Connect to Neo4J Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Neo4J.
-
Connect to PayPal Data from a Connection Pool in Jetty
The PayPal JDBC Driver supports connection pooling: This article shows how to connect faster to PayPal from Web apps in Jetty.
-
Connect to Facebook Ads Data in ACL Analytics
Connect to Facebook Ads via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Facebook Ads.
-
Integrate with Google Contacts Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Contacts in SnapLogic.
-
Automate BambooHR Integration Tasks from PowerShell
Are you in search of a quick and easy way to access BambooHR from PowerShell? This article demonstrates how to utilize the BambooHR Cmdlets for tasks like connecting to BambooHR, automating operations, downloading data, and more.
-
Use Dash to Build to Web Apps on Pipeliner CRM Data
Create Python applications that use pandas and Dash to build Pipeliner CRM-connected web apps.
-
How to connect and process Placid from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Placid.
-
How to connect to Zoom Data from Spring Boot
Connect to Zoom in a Spring Boot Application using the CData API Driver for JDBC
-
A PostgreSQL Interface for eBay Analytics Data using the CData ODBC Driver
Use the SQL Gateway and eBay Analytics ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous PivotalTracker Replication to MongoDB
Use CData Sync for automated, continuous, customizable PivotalTracker replication to MongoDB.
-
Integrating Gumloop with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Power BI XMLA within automated workflows.
-
Access OData Services 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 OData.
-
Integrate Open WebUI with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MYOB AccountRight from within the chat interface.
-
Automated Continuous Freshsales Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Freshsales replication to IBM DB2.
-
How to Access Live Bitly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bitly enables you to integrate Bitly into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Tableau Connector for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Ad Manager.
-
Access ZohoExpense Data from MySQL in PHP
Connect to ZohoExpense through the standard MySQL libraries in PHP.
-
Publish YouTube Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live YouTube Analytics.
-
How to Design Excel Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Excel from mobile and tablet Power Apps.
-
Automated Continuous MongoDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MongoDB replication to IBM DB2.
-
Query BigCommerce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against BigCommerce from Node.js.
-
Integrate Amazon Marketplace Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon Marketplace from Informatica Cloud.
-
Integrating GitHub Copilot CLI with Front 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.
-
Publish Airtable-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Airtable.
-
Automated Continuous Tally Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Tally replication to AlloyDB.
-
Visualize Authorize.Net Data in TIBCO Spotfire through OData
Integrate Authorize.Net into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Python Connector for Zoho CRM
Learn to install and license the CData Python Connector
-
How to Connect to & Open Zoho Inventory Data in Microsoft Excel
This article uses the CData ODBC driver for Zoho Inventory to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software JDBC Driver for Pinterest in MicroStrategy Web
Connect to Pinterest in MicroStrategy Web using the CData Software JDBC Driver for Pinterest.
-
Access Live MYOB AccountRight Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MYOB AccountRight from your Excel spreadsheets.
-
Excel Spreadsheet Automation on Mailjet Data with the QUERY Formula
Pull data from Mailjet, automate spreadsheets, and more with the QUERY formula.
-
Build a Simple VCL Application for Gumroad Data
How to build a simple VCL Application to view Gumroad in RAD Studio using the CData ODBC Driver for Gumroad.
-
Load Dynamics 365 Business Central Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dynamics 365 Business Central to a database.
-
Connect to Freshdesk Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Freshdesk.
-
How to import Google Tasks Data into Apache Solr
Use the CData Software JDBC Driver for Google Tasks in Data Import Handler and create an automated import of Google Tasks to Apache Solr Enterprise Search platform.
-
Integrating Codex CLI with Discord 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.
-
Build Apps with Live Google Spanner Data Using the Low-Code Development Platform of Mendix
Connect Google Spanner with Mendix to build apps using the CData JDBC Driver for Google Spanner.
-
Moving Data from HDFS to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live HDFS data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Azure AI Foundry to Talk to Your Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Zoho Inventory for you.
-
Connect to SendPulse Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SendPulse as an External Source in Dremio.
-
How to Easily Query Pipedrive Data in OpenOffice Base
Connect to Pipedrive data in OpenOffice Base using the CData ODBC Driver for Pipedrive and generate reports with live data insights.
-
Integrating GitHub Copilot CLI with Opsgenie 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.
-
Replicate Front Data to Multiple Databases via the CData Sync CLI
Replicate Front to disparate databases with a single configuration.
-
How to Query Live Jira Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Atlassian Jira data in natural language using Python.
-
Consume Excel Online OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Excel Online feeds that reflect any changes in SAP Lumira.
-
Connect to Mailjet Data in CloverDX (formerly CloverETL)
Transfer Mailjet using the visual workflow in the CloverDX data integration tool.
-
Connect to FreshBooks Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live FreshBooks from Filemaker Pro on Mac.
-
Building Dynamic Web Pages with xBase Data Using AngularJS
Create single-page applications with live connectivity to xBase using the CData API Server.
-
Build AI/ML Models with Live Zoho Creator Data using Dataiku
Connect Zoho Creator Data with Dataiku using the CData JDBC Driver for Zoho Creator.
-
Validate Anaplan Data with QuerySurge
Access and validate Anaplan in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Pipeline CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to AlloyDB.
-
Publish Hugging Face-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Hugging Face.
-
How to Connect the Power BI Service to Workable: Complete Guide
Connect to the CData Software Power BI Connector for Workable from PowerBI.com to provide real-time Workable across the organization.
-
Automated Continuous Toggl Replication to Oracle
Use CData Sync for automated, continuous, customizable Toggl replication to Oracle.
-
Getting Started with the CData JDBC Driver for Excel Online
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Excel Online.
-
Getting Started with the CData Python Connector for EnterpriseDB
Learn to install and license the CData Python Connector
-
How to Access Live Klaviyo Data in Visual Studio Code via Cline
Run CData MCP Server for Klaviyo on Windows Subsytem for Linux (WSL) and connect to live Klaviyo from the Cline extension in Visual Studio Code.
-
Automated Continuous SageHR Replication to SQLite
Use CData Sync for automated, continuous, customizable SageHR replication to SQLite.
-
DataBind Charts to Placid Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Placid 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.
-
Create Mixpanel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mixpanel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access ZohoMarketingHub Data from MySQL in PHP
Connect to ZohoMarketingHub through the standard MySQL libraries in PHP.
-
Query Microsoft Entra ID Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Entra ID from Node.js.
-
ETL Anaplan in Oracle Data Integrator
This article shows how to transfer Anaplan into a data warehouse using Oracle Data Integrator.
-
How to create Freshdesk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Freshdesk in MySQL .
-
Integrating Claude Code with Vertica Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Vertica within assisted coding and automated development workflows.
-
Integrate Live Shortcut Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Shortcut to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Dashboards with Bitly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Bitly in Dundas BI.
-
Import Real-Time MailerLite Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MailerLite in ColdFusion.
-
View Reports on Real-Time HubDB Data in Power BI Report Server
Use the CData ODBC Driver for HubDB to visualize HubDB in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Build an ETL App for WordPress Data in Python with CData Connect AI
Build ETL pipelines that read and write live WordPress in Python with petl and the CData Connect AI Python SDK.
-
Create Informatica Mappings From/To an ODBC Data Source for Stack Exchange
Create an ODBC connection to Stack Exchange in Informatica and browse and transfer Stack Exchange.
-
Migrating data from PayPal to Databricks using CData SSIS Components.
Easily push PayPal to Databricks using the CData SSIS Tasks for PayPal and Databricks.
-
Use Dash to Build to Web Apps on Oracle SCM Data
Create Python applications that use pandas and Dash to build Oracle SCM-connected web apps.
-
Access Tickspot 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 Tickspot.