CData Software - Knowledge Base
Recent Articles
-
Trigger Basecamp IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Basecamp with standard wizards in Logic Apps.
-
Create WooCommerce-Connected Applications in Appsmith
Connect to WooCommerce Data via CData Connect AI in Appsmith and create custom business applications with real-time access to WooCommerce.
-
Integrate LibreChat with Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Lakebase from within the chat interface.
-
Use the CData Software ODBC Driver for Excel in MicroStrategy Desktop
Connect to Microsoft Excel in MicroStrategy Desktop using the CData Software ODBC Driver for Excel.
-
Rapidly Develop Act CRM-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 Act CRM.
-
Feed Exa Data into FineReport
How to set Exa as a JDBC data source in FineReport.
-
Create SingleStore-Connected Nintex Workflows
Use CData Connect AI to connect to SingleStore Data from Nintex Workflow Cloud and build custom workflows using live SingleStore.
-
Connect to Avro from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache Avro, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Choosing the Best Method to Connect PayPal to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PayPal from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData SSIS Components for Lakebase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Lakebase.
-
Access Live Spark Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Apache Spark SQL from your Excel spreadsheets.
-
Rapidly Develop Google Spanner-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 Google Spanner.
-
How to Connect Flowise AI Agents to Live Act-On Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Act-On without replication.
-
Integrate GitHub Data in Pentaho Data Integration
Build ETL pipelines based on GitHub in the Pentaho Data Integration tool.
-
Integrating Cursor CLI with Deel 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 ODBC Driver for Apify in Microsoft Power Query
You can use the CData Apify ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apify into Microsoft Power Query.
-
Work with Jira Data in FoxPro
Load Atlassian Jira into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Spotify Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Spotify data access from reports, embedded analytics, and more.
-
Use Manus AI to Talk to Your Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Certinia.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Greenhouse to Power BI dashboards. Simply drag and drop Greenhouse into data visuals on the Power BI canvas.
-
How to Easily Query Oracle HCM Cloud Data in OpenOffice Base
Connect to Oracle HCM Cloud data in OpenOffice Base using the CData ODBC Driver for Oracle HCM Cloud and generate reports with live data insights.
-
How to connect PolyBase to Salesforce CRM Analytics
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce CRM Analytics.
-
Analyze SAP Ariba Source Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Ariba Source and visualize SAP Ariba Source in SAP Analytics Cloud.
-
Explore Geographical Relationships in Kintone Data with Power Map
Create data visualizations with Kintone in Power Map.
-
Access Live Sugar CRM Data in TIBCO Data Virtualization
Use the Sugar CRM Tibco DV Adapter to create a Sugar CRM data source in TIBCO Data Virtualization Studio and gain access to live Sugar CRM from your TDV Server.
-
Getting Started with the CData Tableau Connector for NASA
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Creating Jira-Connected Applications in Unqork
You can use CData Connect AI to feed Atlassian Jira to Unqork and build custom business apps.
-
Connect VWO to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live VWO using the CData Python MCP Server.
-
Use Dash to Build Web Apps on Gong Data via CData Connect AI
Build interactive Dash web apps on live Gong using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Apify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Apify replication to PostgreSQL.
-
Model, Search, and Visualize Live MarkLogic Data in ThoughtSpot
Use CData Connect AI to connect to live MarkLogic for modeling, searching, and visualizing.
-
Replicate Procore Data to Multiple Databases
Replicate Procore to disparate databases with a point-and-click configuration.
-
Access Live SendPulse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SendPulse in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating GitHub Copilot CLI with Google Translate 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.
-
Getting Started with the CData JDBC Driver for GraphQL
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for GraphQL.
-
Build Voice Agents in ElevenLabs with access to Live Basecamp Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Basecamp.
-
How to Work with Spark Data in ETL Validator JDBC
Connect to Spark from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for Hacker News
Learn to install and license the CData Python Connector
-
Build SAP Ariba Source-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Ariba Source.
-
Connect and Visualize Live Google Contacts Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Contacts into the Databricks platform and create visualization dashboards with real-time Google Contacts.
-
Integrating Antigravity CLI with Apache Spark SQL via CData CLI
Connect Apache Spark SQL to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Google Search Results from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Search from HeidiSQL.
-
ETL Cloudflare in Oracle Data Integrator
This article shows how to transfer Cloudflare into a data warehouse using Oracle Data Integrator.
-
DataBind Charts to Hive Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Hive 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.
-
ETL Facebook in Oracle Data Integrator
This article shows how to transfer Facebook into a data warehouse using Oracle Data Integrator.
-
How to publish and share Autopilot Data dashboards with Tableau Server
The CData ODBC driver for Autopilot enables you integrate Autopilot into Tableau dashboards.
-
Migrating data from WordPress to Snowflake using CData SSIS Components.
Easily push WordPress to Snowflake using the CData SSIS Tasks for WordPress and Snowflake.
-
Automated Continuous Basecamp Replication to Oracle
Use CData Sync for automated, continuous, customizable Basecamp replication to Oracle.
-
Create Reports with Spark Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Spark SQL.
-
Publish Crystal Reports on PivotalTracker Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PivotalTracker.
-
Connecting Moonlit Workflow with Amazon S3 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Amazon S3 in real time.
-
Getting Started with the CData SSIS Components for Active Directory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Active Directory.
-
Connect to Clockify Data in Aqua Data Studio
Access Clockify from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Query Live Bannerbear Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bannerbear data in natural language using Python.
-
How to Access Flowlu Data Using Entity Framework
This article shows how to access Flowlu using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Real-Time Databricks Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Databricks and Dataflow to import and use Databricks in Power Apps.
-
Build Dashboards with ClickUp Data in DBxtra
Create dynamic dashboards and perform analytics based on ClickUp in DBxtra.
-
Explore Geographical Relationships in Outreach.io Data with Power Map
Create data visualizations with Outreach.io in Power Map.
-
Build Klaviyo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Klaviyo and build web apps with connectivity to live Klaviyo.
-
Back Up Slack to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Slack. In this article, we will employ an SSIS workflow to populate a database with Slack data.
-
DataBind Controls to Mixpanel Data in Delphi
DataBind to Mixpanel in Delphi with standard data access components and controls.
-
Operational Reporting on Salesforce Pardot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce Pardot.
-
How to publish and share Instantly Data dashboards with Tableau Server
The CData ODBC driver for Instantly enables you integrate Instantly into Tableau dashboards.
-
Add Contentful Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Contentful with the Informatica Enterprise Data Catalog to classify and organize data.
-
Operational Reporting on CapsuleCRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CapsuleCRM.
-
Use the CData API Server to Access Parquet Data in Microsoft PowerPivot
Use the CData API Server to connect to live Apache Parquet in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Microsoft Planner in MicroStrategy
Connect to Microsoft Planner in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Planner.
-
Moving Data from GitHub to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live GitHub data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
DataBind Controls to Microsoft Entra ID Data in C++Builder
DataBind to Microsoft Entra ID in C++Builder with standard components and controls.
-
Enable the Microsoft Teams JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Teams.
-
ETL Nethunt in Oracle Data Integrator
This article shows how to transfer Nethunt into a data warehouse using Oracle Data Integrator.
-
Access Live Avalara AvaTax Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Avalara AvaTax through MCP integration.
-
Connect to Mouseflow Data in Aqua Data Studio
Access Mouseflow from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Claude Code with Cvent Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Cvent within assisted coding and automated development workflows.
-
How to create an RPA flow for Spark Data in UiPath Studio
Use the Spark ODBC Driver to create workflows that access real-time Apache Spark SQL without any coding.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Clari
Provide connectivity to Clari through an SAP BusinessObjects universe.
-
How to Access Live SQL Server Data in Visual Studio Code via Cline
Run CData MCP Server for SQL Server on Windows Subsytem for Linux (WSL) and connect to live Microsoft SQL Server from the Cline extension in Visual Studio Code.
-
Natively Connect to SingleStore Data in PHP
The CData ODBC driver for SingleStore enables you to create PHP applications with connectivity to SingleStore. Leverage the native support for ODBC in PHP.
-
Create Dynamic Asana Grids Using the Infragistics XamDataGrid
Learn how you can connect Asana to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Claude Code CLI with Access 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.
-
Integrate Live Procore Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Procore to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automate NASA Integration Tasks from PowerShell
Are you in search of a quick and easy way to access NASA from PowerShell? This article demonstrates how to utilize the NASA Cmdlets for tasks like connecting to NASA, automating operations, downloading data, and more.
-
Establish a Live Connection with SparkPost Data using Tableau Bridge
The CData ODBC Driver for SparkPost enables you to integrate live SparkPost into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Highrise with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Highrise with External Services.
-
Consume Google Spanner OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Spanner feeds that reflect any changes in SAP Lumira.
-
Gorgias Reporting in OBIEE with the Gorgias JDBC Driver
Deploy the Gorgias JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Zuora Data from a Connection Pool in Jetty
The Zuora JDBC Driver supports connection pooling: This article shows how to connect faster to Zuora from Web apps in Jetty.
-
Use the CData Software JDBC Driver for FHIR in MicroStrategy
Connect to FHIR in MicroStrategy Developer using the CData Software JDBC Driver for FHIR.
-
Access Live Vercel Data in Coginiti Pro
Connect to and query live Vercel from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access ChargeOver Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ChargeOver from HeidiSQL.
-
Integrate Dynamics 365 Business Central with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dynamics 365 Business Central with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dynamics 365 Business Central.
-
Integrate Open WebUI with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle Eloqua from within the chat interface.
-
Create Odoo-Connected Business Apps in AppSheet
Connect to Odoo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Odoo ERP.
-
Connecting Mastra with Epicor Kinetic Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Epicor Kinetic, no replication required.
-
Hubstaff Reporting in OBIEE with the Hubstaff JDBC Driver
Deploy the Hubstaff JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Workday Data in ACL Analytics
Connect to Workday via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Workday.
-
Getting Started with the CData Power BI Connector for ADP
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for ADP.
-
Connect to and Visualize Live Wave Financial Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Wave Financial.
-
Analyze Shippo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Shippo in Microsoft R Open.
-
Access SAS Data Sets 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 SAS Data Sets.