CData Software - Knowledge Base
Recent Articles
-
Bridge Oracle SCM Connectivity with Apache NiFi
Access and process Oracle SCM in Apache NiFi using the CData JDBC Driver.
-
Build Amazon Athena-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Amazon Athena to explore live Amazon Athena Data in Cursor to assist with building Amazon Athena-powered applications.
-
How to connect to Google Forms Data from IntelliJ
Integrate connectivity to Google Forms with wizards in IntelliJ.
-
Publish Reports with Greenhouse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Greenhouse.
-
Connect Shippo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Shippo using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Sybase IQ Replication to MySQL
Use CData Sync for automated, continuous, customizable Sybase IQ replication to MySQL.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Smartsheet within intelligent workflows.
-
Back Up FormSite to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with FormSite data.
-
Work with ElevenLabs Data in FoxPro
Load ElevenLabs into a FoxPro database. This article includes full code and a walk-through of the process.
-
Provide OData Services of ConstantContact Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ConstantContact by developing a WCF Service Application.
-
Access Live Google Campaign Manager 360 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Campaign Manager 360 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Wrike Data in HULFT Integrate
Connect to Wrike as a JDBC data source in HULFT Integrate
-
Automated Continuous Stack Exchange Replication to SQL Server
Use CData Sync for automated, continuous, customizable Stack Exchange replication to SQL Server.
-
How to use SQLAlchemy ORM to access FHIR Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of FHIR.
-
Object-Relational Mapping (ORM) with Highrise 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 Highrise CRM into a Java-based ORM framework, Hibernate.
-
How to Build an ETL App for Amazon DynamoDB Data in Python with CData
Create ETL applications and real-time data pipelines for Amazon DynamoDB in Python with petl.
-
Manage Demio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Demio.
-
Use the CData Software ODBC Driver for Square in MicroStrategy Web
Connect to Square in MicroStrategy Web using the CData Software ODBC Driver for Square.
-
Create Dynamic Harvest Grids Using the Infragistics XamDataGrid
Learn how you can connect Harvest to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Tableau Connector for Samanage
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Live Bullhorn CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Bullhorn CRM into custom reports in Power BI.
-
Operational Reporting on SAP HANA XS Advanced Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP HANA XS Advanced.
-
Analyze Acumatica Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Acumatica ERP in Microsoft R Open.
-
Use Biml to Build SSIS Tasks to Replicate Google Analytics Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Analytics to SQL Server.
-
Connect to Raisers Edge NXT from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Raisers Edge NXT, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Trigger Instagram IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Instagram with standard wizards in Logic Apps.
-
Consume Authorize.Net OData Feeds in PowerBuilder
This article demonstrates how to consume Authorize.Net as OData feeds from PowerBuilder using the API Server.
-
Connecting GenSpark with Google Ad Manager Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Ad Manager without any replication or custom integration required.
-
How to Import Data from Azure DevOps into Google Sheets
Import Azure DevOps into a Google spreadsheet that is automatically refreshed.
-
Build Discourse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Discourse and build web apps with connectivity to live Discourse.
-
View Reports on Real-Time iContact Data in Power BI Report Server
Use the CData ODBC Driver for iContact to visualize iContact in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Visualizations of AdRoll Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of AdRoll in Birst.
-
Access CapsuleCRM Data from MySQL in Amazon QuickSight
Connect to CapsuleCRM and build visualizations of CapsuleCRM using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Xero Replication to SQLite
Use CData Sync for automated, continuous, customizable Xero replication to SQLite.
-
Getting Started with the CData JDBC Driver for Grafana
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Grafana.
-
Build a Singer.io Tap for Qualaroo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Qualaroo data using
-
Visualize SAP HANA XS Advanced Data in TIBCO Spotfire through OData
Integrate SAP HANA XS Advanced into dashboards in TIBCO Spotfire.
-
DataBind Controls to Square Data in Delphi
DataBind to Square in Delphi with standard data access components and controls.
-
Integrating Gumloop with Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Presto within automated workflows.
-
Automated Continuous Amplitude Replication to SingleStore
Use CData Sync for automated, continuous, customizable Amplitude replication to SingleStore.
-
Connecting Pipedream with Excel Online 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 Excel Online data in real time.
-
Access Live Google Analytics Data in TIBCO Data Virtualization
Use the Google Analytics Tibco DV Adapter to create a Google Analytics data source in TIBCO Data Virtualization Studio and gain access to live Google Analytics from your TDV Server.
-
Connect to Amplitude Data in HULFT Integrate
Connect to Amplitude as a JDBC data source in HULFT Integrate
-
Automated Continuous WordPress Replication to Amazon S3
Use CData Sync for automated, continuous, customizable WordPress replication to Amazon S3.
-
DataBind Controls to Tavily Data in C++Builder
DataBind to Tavily in C++Builder with standard components and controls.
-
Integrating Kiro CLI with Beeminder 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.
-
Validate Azure Table Data with QuerySurge
Access and validate Azure Table Storage in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Google Ad Manager 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 Google Ad Manager through natural language.
-
Access LaunchDarkly 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 LaunchDarkly.
-
How to Access Live Microsoft Teams Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Teams enables you to integrate Microsoft Teams into workflows built using Microsoft Power Automate Desktop.
-
Analyze Paylocity Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Paylocity and visualize Paylocity in SAP Analytics Cloud.
-
Consume Sage Intacct OData Feeds in PowerBuilder
This article demonstrates how to consume Sage Intacct as OData feeds from PowerBuilder using the API Server.
-
Analyze FHIR Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze FHIR with the CData JDBC Driver for FHIR.
-
Use CData Connect AI to Access Google Drive Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Drive in the Power Pivot business intelligence tool.
-
Connect Brex Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Brex using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Manage Optimizely Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Optimizely.
-
Connect to ZeroBounce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZeroBounce as an External Source in Dremio.
-
Integrate Goose with Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Quickbase from within the local AI agent.
-
Building Dynamic Web Pages with Monday.com Data Using AngularJS
Create single-page applications with live connectivity to Monday.com using the CData API Server.
-
Create Power BI Reports on Real-Time Aircall Data
Use the CData ODBC Driver for Aircall to visualize Aircall in Power BI Desktop.
-
Use the CData Software ODBC Driver for Excel Online in MicroStrategy Desktop
Connect to Microsoft Excel Online in MicroStrategy Desktop using the CData Software ODBC Driver for Excel Online.
-
Automated Continuous Excel Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Excel replication to Azure SQL Database.
-
Use Claude to Talk to Your SAP Netweaver Gateway 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 SAP Netweaver Gateway for you.
-
Automated Continuous Pinterest Replication to Oracle
Use CData Sync for automated, continuous, customizable Pinterest replication to Oracle.
-
Connect to Neo4J Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Neo4J as an External Source in Dremio.
-
Build Mailjet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mailjet.
-
Automated Continuous Bugsnag Replication to SQL Server
Use CData Sync for automated, continuous, customizable Bugsnag replication to SQL Server.
-
Seamlessly Bring Sage Intacct Data into Retool Using CData Connect AI
Integrate Sage Intacct data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live JDBC-ODBC Bridge Data in TIBCO Data Virtualization
Use the JDBC-ODBC Bridge Tibco DV Adapter to create a JDBC-ODBC Bridge data source in TIBCO Data Virtualization Studio and gain access to live JDBC-ODBC Bridge from your TDV Server.
-
New SharePoint Views: Sites, AllLists, AllFiles
This article reviews the newly added views to the CData SharePoint Drivers, Sites, AllLists, and AllFiles, and explores example queries using the new views.
-
Connect to Tavily Data from PowerBuilder via JDBC
This article demonstrates how to access Tavily from PowerBuilder using the Tavily JDBC Driver.
-
Rapidly Develop Kintone-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 Kintone.
-
How to integrate Basecamp with Apache Airflow
Access and process Basecamp in Apache Airflow using the CData JDBC Driver.
-
Analyze Instantly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Instantly with the CData JDBC Driver for Instantly.
-
Publish Reports with Zoho Projects Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Projects.
-
Automated Continuous Apify Replication to Databricks
Use CData Sync for automated, continuous, customizable Apify replication to Databricks.
-
Build Dashboards with Mistral AI Data in DBxtra
Create dynamic dashboards and perform analytics based on Mistral AI in DBxtra.
-
Connect to Microsoft Entra ID Data from a Connection Pool in JBoss
Integrate Microsoft Entra ID into Java servlets: Use the Management Console in JBoss to install the Microsoft Entra ID JDBC Driver.
-
Access Live Dynamics 365 Business Central Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Dynamics 365 Business Central through MCP integration.
-
Connect Oracle SCM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle SCM with IBM WebSphere for seamless data integration and connectivity.
-
Integrate LibreChat with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live IBM Cloudant from within the chat interface.
-
Build an OLAP Cube in SSAS from Sendwithus Data
Establish a connection to Sendwithus data from SQL Server Analysis Services, and use the Sendwithus Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Vimeo Data in Jaspersoft Studio
Execute SQL to remote Vimeo in Jaspersoft Studio.
-
Build Twilio-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Twilio to explore live Twilio Data in Claude Code to assist with building Twilio-powered applications.
-
Work with Factorial Data in FoxPro
Load Factorial into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Mixpanel Data in Jaspersoft Studio
Execute SQL to remote Mixpanel in Jaspersoft Studio.
-
How to Query SFTP Data in MySQL Workbench
Execute MySQL queries against live SFTP from MySQL Workbench.
-
How to Query Live Quickbase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Quickbase data in natural language using Python.
-
Connect to LightSpeedRetail Data in CloverDX (formerly CloverETL)
Transfer LightSpeedRetail using the visual workflow in the CloverDX data integration tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Unbounce
Create an ODBC connection to Unbounce in Informatica and browse and transfer Unbounce.
-
Replicate Multiple TaxJar Accounts
Replicate multiple TaxJar accounts to one or many databases.
-
Build Automated IBM Informix-Connected Workflows in Zapier
Use CData Connect AI to connect to live IBM Informix and build automated workflows in Zapier.
-
Build Agents in Relevance AI with Access to Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Apache Phoenix within intelligent agent workflows.
-
Connect to Figshare Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Figshare and work with Figshare in your FileMaker application.
-
How to Connect to Live Authorize.Net Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Authorize.Net for you.
-
Connect to Dynamics CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Dynamics CRM in the Denodo Virtual DataPort Administrator.
-
Use the CData ODBC Driver for Elorus from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Elorus to connect to Elorus from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Elorus in Excel.
-
Connect to Shortcut Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Shortcut as an External Source in Dremio.
-
DataBind Charts to Workable Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Workable 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.
-
Manage Figshare Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Figshare.