CData Software - Knowledge Base
Recent Articles
-
Integrating Codex CLI with Okta 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.
-
Create Power BI Reports on Real-Time Beeminder Data
Use the CData ODBC Driver for Beeminder to visualize Beeminder in Power BI Desktop.
-
Use Dash to Build to Web Apps on Demio Data
Create Python applications that use pandas and Dash to build Demio-connected web apps.
-
Query Apify Data as a MySQL Database in Node.js
Execute MySQL queries against Apify from Node.js.
-
Automated Continuous Oracle Eloqua Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Apache Kafka.
-
Work with Gong Data in FoxPro
Load Gong into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Adobe Experience Manager Data in Coginiti Pro
Connect to and query live Adobe Experience Manager from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live CloudConvert Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate CloudConvert into the statistical analysis tools available in SAS JMP. This article shows how to use CloudConvert in the Graph Builder and Query Builder.
-
Write a Simple Go Application to work with MongoDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MongoDB.
-
Integrate with live YouTube Analytics Data in Jitterbit
Use CData Connect AI to connect to and integrate live YouTube Analytics in Jitterbit.
-
Integrating GitHub Copilot CLI with GitLab 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 Wave Financial Data in HULFT Integrate
Connect to Wave Financial as a JDBC data source in HULFT Integrate
-
A PostgreSQL Interface for Miro Data using the CData ODBC Driver
Use the SQL Gateway and Miro ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Office 365 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Office 365 and the Script function in FileMaker Pro to connect to Office 365 and work with Microsoft Office 365 in your FileMaker application.
-
Build a Simple VCL Application for ZohoInvoice Data
How to build a simple VCL Application to view ZohoInvoice in RAD Studio using the CData ODBC Driver for ZohoInvoice.
-
How to Import Data from MarkLogic into Google Sheets
Import MarkLogic into a Google spreadsheet that is automatically refreshed.
-
Use Dash to Build Web Apps on Salesforce CRM Analytics Data via CData Connect AI
Build interactive Dash web apps on live Salesforce CRM Analytics using pandas and the CData Connect AI Python SDK.
-
Access Live Hive Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Hive from your Excel spreadsheets.
-
CSV Reporting in OBIEE with the CSV JDBC Driver
Deploy the CSV JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData API Server to Access Exact Online Data in Microsoft PowerPivot
Use the CData API Server to connect to live Exact Online in the Power Pivot business intelligence tool.
-
Access Live Greenhouse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Greenhouse into the statistical analysis tools available in SAS JMP. This article shows how to use Greenhouse in the Graph Builder and Query Builder.
-
Automate SAP SuccessFactors Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP SuccessFactors from PowerShell? This article demonstrates how to utilize the SAP SuccessFactors Cmdlets for tasks like connecting to SAP SuccessFactors, automating operations, downloading data, and more.
-
Build an OLAP Cube in SSAS from Odoo Data
Establish a connection to Odoo ERP data from SQL Server Analysis Services, and use the Odoo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Opsgenie Data as a MySQL Database in Node.js
Execute MySQL queries against Opsgenie from Node.js.
-
Working with SendPulse Data in LINQPad
Execute LINQ queries to SendPulse in LINQPad.
-
Model, Search, and Visualize Live Acumatica Data in ThoughtSpot
Use CData Connect AI to connect to live Acumatica ERP for modeling, searching, and visualizing.
-
Build Blackbaud FE NXT-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Blackbaud FE NXT and build Blackbaud FE NXT-connected web apps with Axios.
-
A PostgreSQL Interface for Snapchat Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Snapchat Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with BambooHR Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on BambooHR within assisted coding and automated development workflows.
-
How to connect and process IBM Cloudant from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live IBM Cloudant.
-
Publish Crystal Reports on Onfleet Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Onfleet.
-
Connect to and Visualize Live Harvest Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Harvest.
-
Connect to Flowlu Data in HULFT Integrate
Connect to Flowlu as a JDBC data source in HULFT Integrate
-
Connect to Teamgate Data in Jaspersoft Studio
Execute SQL to remote Teamgate in Jaspersoft Studio.
-
How to Query Live Freshteam Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshteam data in natural language using Python.
-
Build Epicor Kinetic-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Epicor Kinetic Data and create custom apps in Mendix.
-
Create Power BI Reports on Real-Time SAP Business Warehouse Data
Use the CData ODBC Driver for SAP Business Warehouse to visualize SAP Business Warehouse in Power BI Desktop.
-
How to Use a Microsoft Access Database to Update IBM Informix Data in Real Time
Update IBM Informix data by creating a linked table in Microsoft Access with the CData IBM Informix ODBC Driver.
-
Work with Outreach.io Data in FoxPro
Load Outreach.io into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Phoenix Data in Ruby
Connect to Apache Phoenix in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to NASA Data in Jaspersoft Studio
Execute SQL to remote NASA in Jaspersoft Studio.
-
Import Real-Time Twilio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Twilio in ColdFusion.
-
Automated Continuous Samanage Replication to Oracle
Use CData Sync for automated, continuous, customizable Samanage replication to Oracle.
-
Connecting Pipedream with Google Directory 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 Google Directory data in real time.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZohoExpense
Provide connectivity to ZohoExpense through an SAP BusinessObjects universe.
-
Connect to Real-Time ZohoInvoice Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoInvoice in Power Apps.
-
Analyze Flowlu Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Flowlu from Power Pivot. You will use the Table Import Wizard to load Flowlu. You can visually build the import query or use any SQL supported by the driver.
-
Query Live WordPress Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live WordPress directly from the development environment.
-
Connect to Azure Table Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
LINQ to LightSpeedRetail 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 LightSpeedRetail Data Provider.
-
Moving Data from WordPress to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live WordPress data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect MessageBird Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MessageBird using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate Cloudflare Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Cloudflare from PowerShell? This article demonstrates how to utilize the Cloudflare Cmdlets for tasks like connecting to Cloudflare, automating operations, downloading data, and more.
-
Query Monday.com Data in ColdFusion
Write standard ColdFusion data access code to connect to Monday.com.
-
How to Connect to Live Freshdesk Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Freshdesk for you.
-
Use the CData Software JDBC Driver for Stack Exchange in MicroStrategy Desktop
Connect to Stack Exchange in MicroStrategy Desktop using the CData Software JDBC Driver for Stack Exchange.
-
Use Claude to Talk to Your Xero 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 Xero Accounting for you.
-
LINQ to Demio 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 Demio Data Provider.
-
Build CouchDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for CouchDB Data and create custom apps in Bubble.
-
Access Reckon Accounts Hosted Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Reckon Accounts Hosted from your Oracle system.
-
How to Build an ETL App for Oracle Service Cloud Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Service Cloud in Python with petl.
-
How to Connect the Power BI Service to Webflow: Complete Guide
Connect to the CData Software Power BI Connector for Webflow from PowerBI.com to provide real-time Webflow across the organization.
-
How to connect and process Billsby from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Billsby.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Stripe within intelligent workflows.
-
Connect to ConvertAPI Data in RazorSQL
Connect to ConvertAPI from wizards and query ConvertAPI from the GUI in the RazorSQL database management tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Ads
Create Google Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Teradata Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Teradata replication to Google BigQuery.
-
Integrate SAS Data Sets Data in the Pentaho Report Designer
Publish reports based on SAS Data Sets in the Pentaho BI tool.
-
Access Live Epicor Kinetic Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Epicor Kinetic in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Spark Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Spark SQL and visualize live Apache Spark SQL in Infragistics Reveal.
-
Connect to HBase Data in Jaspersoft Studio
Execute SQL to remote Apache HBase in Jaspersoft Studio.
-
Visualize QuickBooks Online Data in TIBCO Spotfire through OData
Integrate QuickBooks Online into dashboards in TIBCO Spotfire.
-
How to Access Live Acumatica Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Acumatica enables you to integrate Acumatica ERP into workflows built using Microsoft Power Automate Desktop.
-
Query SAS Data Sets Data in ColdFusion
Write standard ColdFusion data access code to connect to SAS Data Sets.
-
Query Sugar CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Sugar CRM.
-
Integrating OpenCode Terminal with TigerGraph 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.
-
Use the CData Software JDBC Driver for NetSuite in MicroStrategy Desktop
Connect to NetSuite CRM & ERP in MicroStrategy Desktop using the CData Software JDBC Driver for NetSuite.
-
How to Connect to Live Zendesk Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Zendesk for you.
-
Rapidly Develop Salesloft-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 Salesloft.
-
Use the CData Software JDBC Driver for MailerLite in MicroStrategy
Connect to MailerLite in MicroStrategy Developer using the CData Software JDBC Driver for MailerLite.
-
Connect to Azure Analysis Services Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Analysis Services in Airbyte.
-
Connect to Paylocity Data in Jaspersoft Studio
Execute SQL to remote Paylocity in Jaspersoft Studio.
-
Create Amazon S3-Connected Applications in Appsmith
Connect to Amazon S3 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon S3.
-
Replicate Multiple ConstantContact Accounts via the CData Sync CLI
Replicate multiple ConstantContact accounts to one or many databases.
-
Build Dashboards with Gumroad Data in DBxtra
Create dynamic dashboards and perform analytics based on Gumroad in DBxtra.
-
Getting Started with the CData ODBC Driver for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MYOB AccountRight.
-
Load Cosmos DB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Cosmos DB to a database.
-
Replicate Active Directory Data to Multiple Databases
Replicate Active Directory to disparate databases with a point-and-click configuration.
-
Migrating data from Eventbrite to Google BigQuery using CData SSIS Components.
Easily push Eventbrite to Google BigQuery using the CData SSIS Tasks for Eventbrite and Google BigQuery.
-
Build Bitbucket-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Bitbucket.
-
Consume GitHub OData Feeds in SAP Lumira
Use the API Server to create data visualizations on GitHub feeds that reflect any changes in SAP Lumira.
-
Analyze MySQL Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MySQL and visualize MySQL in SAP Analytics Cloud.
-
Create Dynamic Guru Grids Using the Infragistics XamDataGrid
Learn how you can connect Guru to Infragistics XamDataGrid to build dynamic grids.
-
Build a Simple VCL Application for LaunchDarkly Data
How to build a simple VCL Application to view LaunchDarkly in RAD Studio using the CData ODBC Driver for LaunchDarkly.
-
Build Apps with Live BigCommerce in Adalo using CData Connect AI
Use CData Connect AI to integrate live BigCommerce into the Adalo platform and build custom mobile and web applications with real-time BigCommerce.
-
Natively Connect to Google Sheets Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the native support for ODBC in PHP.
-
How to Work with Telegram Data in ETL Validator JDBC
Connect to Telegram from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Easily Query SAP Business Warehouse Data in OpenOffice Base
Connect to SAP Business Warehouse data in OpenOffice Base using the CData ODBC Driver for SAP Business Warehouse and generate reports with live data insights.
-
Automate Teradata Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Teradata from PowerShell? This article demonstrates how to utilize the Teradata Cmdlets for tasks like connecting to Teradata, automating operations, downloading data, and more.
-
How to use SQLAlchemy ORM to access Impala Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Impala.