CData Software - Knowledge Base
Recent Articles
-
How to Design TaxJar Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to TaxJar from mobile and tablet Power Apps.
-
Use the CData Software JDBC Driver for Hugging Face in MicroStrategy Web
Connect to Hugging Face in MicroStrategy Web using the CData Software JDBC Driver for Hugging Face.
-
Integrate with Amazon S3 Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Amazon S3 in SnapLogic.
-
Build a Singer.io Tap for Adobe Target With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Adobe Target data using
-
Visualize Live Google Drive Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Drive using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from SQL Server to Xero through SSIS
Easily push SQL Server data to Xero using the CData SSIS Tasks for Xero.
-
Connect to Raisers Edge NXT Data in Google Apps Script via Connect AI
Use CData Connect AI to access Raisers Edge NXT in Google Apps Script.
-
Getting Started with the CData Excel Add-In for Recurly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Recurly.
-
Use Dash to Build Web Apps on Greenplum Data via CData Connect AI
Build interactive Dash web apps on live Pivotal GreenPlum using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Freshsales Replication to MongoDB
Use CData Sync for automated, continuous, customizable Freshsales replication to MongoDB.
-
Access Live Act-On Data in AWS Lambda
Connect to live Act-On in AWS Lambda using the CData JDBC Driver.
-
How to Visualize Missive Data in Python with pandas
Use pandas and other modules to analyze and visualize live Missive in Python.
-
Stream SAP BusinessObjects BI Data into Apache Kafka Topics
Access and stream SAP BusinessObjects BI in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Query Live CSV Data in Perplexity MacOS Desktop
Connect to and query live CSV Data in Perplexity Desktop using CData MCP Server.
-
Migrating data from Toggl to Databricks using CData SSIS Components.
Easily push Toggl to Databricks using the CData SSIS Tasks for Toggl and Databricks.
-
Visualize Exact Online Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Exact Online.
-
Integrating OpenCode Terminal with Tavily 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.
-
Access Live Hive Data in Excel 365 Online (Excel for the web)
Connect to Apache Hive from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Object-Relational Mapping (ORM) with Clari 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 Clari into a Java-based ORM framework, Hibernate.
-
Analyze Live Exact Online Data in SAS Viya
Use CData Connect AI to connect to Exact Online from SAS Viya and deploy self-service analytics using live Exact Online.
-
Import and Visualize Elasticsearch Data in Power View
Create data visualizations based on Elasticsearch in Excel.
-
Integrate Bitly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bitly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bitly.
-
Connect to and Query Pinterest Data in QlikView over ODBC
Create data visualizations with Pinterest in QlikView.
-
Bidirectional Access to DB2 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate IBM DB2 in Filemaker Pro for Mac or Windows.
-
Access Live BigCommerce Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live BigCommerce from your Excel spreadsheets.
-
Query Google Analytics Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Analytics.
-
Connect to Email Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Email in Airbyte.
-
Connect to Dynamics CRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Dynamics CRM Data and connect to Microsoft Dynamics CRM in Akorbi Digital RunMyProcess.
-
Use Dash to Build to Web Apps on Splunk Data
Create Python applications that use pandas and Dash to build Splunk-connected web apps.
-
Explore Geographical Relationships in Zoho Books Data with Power Map
Create data visualizations with Zoho Books in Power Map.
-
How to Access Avaza Data Using Entity Framework
This article shows how to access Avaza using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import Real-Time SageHR Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SageHR in ColdFusion.
-
How to Connect to Live Gmail 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 Gmail for you.
-
Connect to Act CRM Data in Jaspersoft Studio
Execute SQL to remote Act CRM in Jaspersoft Studio.
-
How to Connect to Live Blackbaud FE NXT Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Blackbaud FE NXT through natural language.
-
Getting Started with the CData JDBC Driver for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LaunchDarkly.
-
Connect and Query Live Zoho Inventory Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoho Inventory into Databricks
-
Integrate Grafana Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Grafana from Informatica Cloud.
-
Import Real-Time Klipfolio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Klipfolio in ColdFusion.
-
Connect to Todoist Data from PowerBuilder via ADO.NET
This article demonstrates how to access Todoist from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Salesforce Pardot Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesforce Pardot and build visualizations in Tableau.
-
Import and Visualize Gong Data in Power View
Create data visualizations based on Gong in Excel.
-
Create Datasets from Salesforce Pardot in Domo Workbench and Build Visualizations of Salesforce Pardot Data in Domo
Use the CData Software ODBC Driver for Salesforce Pardot to create datasets from Salesforce Pardot in Domo Workbench and then build visualizations in the Domo service.
-
Create Data Visualizations in Cognos BI with Tavily Data
Access Tavily as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect PolyBase to IBM Cloud Object Storage
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Cloud Object Storage.
-
Integrating Antigravity CLI with Apache Parquet via CData CLI
Connect Apache Parquet to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Act-On Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Act-On facts in real time.
-
Build Charts with OpenWeatherMap Data in Clear Analytics
Create dynamic charts and perform analytics based on OpenWeatherMap in Clear Analytics.
-
Enable the Google Drive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Drive.
-
Edit and Search External Microsoft Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Ads to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Ads Data objects that you can access from apps and the dashboard.
-
Bridge Amazon Marketplace Connectivity with Apache NiFi
Access and process Amazon Marketplace in Apache NiFi using the CData JDBC Driver.
-
How to Easily Query HelloSign Data in OpenOffice Base
Connect to HelloSign data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate with ClickTime Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ClickTime to a JSON file on disk.
-
Query GetResponse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GetResponse from Node.js.
-
Access Google Spanner Data from MySQL in Amazon QuickSight
Connect to Google Spanner and build visualizations of Google Spanner using a MySQL Connection in Amazon QuickSight.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Blackbaud FE NXT actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Rapidly Develop SAS Data Sets-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 SAS Data Sets.
-
Visualize Live Highrise Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Highrise CRM into custom reports in Power BI.
-
How to Access Live Pinecone Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pinecone enables you to integrate Pinecone into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to YouTube Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to YouTube Analytics. Leverage the native support for ODBC in PHP.
-
Design BIRT Reports on Omnisend Data
Provide current Omnisend to your embedded analytics.
-
Connect to Bullhorn CRM Data in CloverDX (formerly CloverETL)
Transfer Bullhorn CRM using the visual workflow in the CloverDX data integration tool.
-
Easily Integrate Oracle SCM Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle SCM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Tableau Connector for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connecting Mastra with Zoho CRM 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 Zoho CRM, no replication required.
-
Integrate Live Google Search Results into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Search from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Search.
-
How to create Visio diagrams from Zoho Inventory Data
Automatically update Zoho Inventory with the changes you make to Visio master shapes.
-
Automated Continuous SageHR Replication to MySQL
Use CData Sync for automated, continuous, customizable SageHR replication to MySQL.
-
Build a PostgreSQL Interface for Webflow Data using the CData JDBC Driver
Use the Remoting features of the Webflow JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live LinkedIn Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your LinkedIn for you.
-
Analyze MYOB AccountRight Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MYOB AccountRight with the CData JDBC Driver for MYOB AccountRight.
-
Integrate CouchDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache CouchDB from Informatica Cloud.
-
Build Visualizations of HDFS Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache HDFS in Birst.
-
Analyze Gmail Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gmail in Microsoft R Open.
-
Connect to Codat Data in Jaspersoft Studio
Execute SQL to remote Codat in Jaspersoft Studio.
-
Analyze Elasticsearch Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Elasticsearch and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Query Landbot Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Landbot from Node.js.
-
How to Use a Microsoft Access Database to Update Xero Data in Real Time
Update Xero data by creating a linked table in Microsoft Access with the CData Xero ODBC Driver.
-
Integrating Dataiku with MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MarkLogic.
-
Stream HCL Domino Data into Apache Kafka Topics
Access and stream HCL Domino in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Migrating data from Optimizely to Google BigQuery using CData SSIS Components.
Easily push Optimizely to Google BigQuery using the CData SSIS Tasks for Optimizely and Google BigQuery.
-
DataBind Charts to SAS xpt Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAS XPORT 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.
-
LINQ to Suadeo 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 Suadeo Data Provider.
-
Connect to WooCommerce from Asprova with CData Software ODBC Driver for WooCommerce
This article shows how to connect faster to WooCommerce data from Asprova.
-
Query Clio Data in ColdFusion
Write standard ColdFusion data access code to connect to Clio.
-
Integrate Cursor with Live SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Fieldglass from within the editor.
-
Connect to Raisers Edge NXT Data in Jaspersoft Studio
Execute SQL to remote Raisers Edge NXT in Jaspersoft Studio.
-
Automated Continuous SAP Ariba Source Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to OneLake in Microsoft Fabric.
-
How to Connect to Live AlloyDB 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 Google AlloyDB for you.
-
Use Grok to Talk to Your Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Salesforce CRM Analytics for you.
-
Use the CData API Server to Access IBM Informix Data in Microsoft PowerPivot
Use the CData API Server to connect to live IBM Informix in the Power Pivot business intelligence tool.
-
Automated Continuous SAP Netweaver Gateway Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to SQLite.
-
Work with SQL Server Data in FoxPro
Load Microsoft SQL Server into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a PostgreSQL Interface for LeadDesk Data using the CData JDBC Driver
Use the Remoting features of the LeadDesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamics NAV Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics NAV from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze SendGrid Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SendGrid and visualize SendGrid in SAP Analytics Cloud.
-
Integrate Open WebUI with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Freshservice from within the chat interface.
-
Create Data Visualizations Based On Freshdesk Data in Mode
Use CData Connect AI to connect to Freshdesk Data from Mode and build visualizations using live
-
Build Data Flows from Mailgun to SQL Server using SSIS
Easily back up Mailgun to SQL Server using the SSIS components for Mailgun.
-
Integrating Claude Code with Oracle Eloqua Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Eloqua within assisted coding and automated development workflows.