CData Software - Knowledge Base
Recent Articles
-
Manage Nethunt Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Nethunt.
-
Work with Live Cloudant Data in Power Query
Use CData Connect AI to connect to IBM Cloudant and work with live IBM Cloudant in Microsoft Power Query.
-
Establish a Live Connection with ZohoInvoice Data using Tableau Bridge
The CData ODBC Driver for ZohoInvoice enables you to integrate live ZohoInvoice into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Stack Exchange Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Azure SQL Database.
-
How to connect Amazon QuickSight to Reckon Accounts Hosted Data
Create a connection to Reckon Accounts Hosted in CData Connect AI and insert Reckon Accounts Hosted into Amazon QuickSight SPICE to build interactive dashboards.
-
Use ChatGPT to Talk to Your Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Dynamics 365 for you.
-
Integrate Real-Time Access to Vimeo in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Vimeo in real time.
-
Automate SAP Hybris C4C Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Hybris C4C replication to Azure Data Lake.
-
Connect to PayPal Data in CloverDX (formerly CloverETL)
Transfer PayPal using the visual workflow in the CloverDX data integration tool.
-
How to work with Sage Intacct Data in Apache Spark using SQL
Access and process Sage Intacct Data in Apache Spark using the CData Software JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for ConvertAPI
Create an ODBC connection to ConvertAPI in Informatica and browse and transfer ConvertAPI.
-
Analyze RSS Feeds in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze RSS Feeds in Microsoft R Open.
-
Automated Continuous Optimizely Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Optimizely replication to Apache Cassandra.
-
How to Work with ZohoMarketingHub Data in AWS Glue Jobs Using JDBC
Connect to ZohoMarketingHub from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create ZohoMarketingHub Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoMarketingHub data access from reports, embedded analytics, and more.
-
Replicate Multiple CData Connect AI Accounts
Replicate multiple CData Connect AI accounts to one or many databases.
-
Integrate ClickTime with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ClickTime with External Services.
-
Connect and Visualize Live Procore Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Procore into the Databricks platform and create visualization dashboards with real-time Procore.
-
Access Live Microsoft Entra ID Data in Coginiti Pro
Connect to and query live Microsoft Entra ID from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Adobe Analytics 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 Adobe Analytics through MCP integration.
-
Connect to QuickBooks Online Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time QuickBooks Online using standard SQL.
-
Automate Drift Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Drift and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
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.
-
Migrating data from DB2 to Google BigQuery using CData SSIS Components.
Easily push IBM DB2 to Google BigQuery using the CData SSIS Tasks for DB2 and Google BigQuery.
-
Publish Reports with Greenhouse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Greenhouse.
-
Rapidly Develop Mode-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 Mode.
-
Integrating Notion Data in Talend Cloud Data Management Platform
Connect Notion Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
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.
-
Connect to HCL Domino Data in Claris FileMaker Pro
Use the CData ODBC Driver for HCL Domino in FileMaker Pro to connect to HCL Domino and work with HCL Domino in your FileMaker applications.
-
Work with Live Adobe Analytics Data in Power Query
Use CData Connect AI to connect to Adobe Analytics and work with live Adobe Analytics in Microsoft Power Query.
-
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.
-
Query Instagram Data as a MySQL Database in Node.js
Execute MySQL queries against Instagram from Node.js.
-
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.
-
Getting Started with the CData JDBC Driver for Recurly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Recurly.
-
Access Live Workday Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Workday into the statistical analysis tools available in SAS JMP. This article shows how to use Workday in the Graph Builder and Query Builder.
-
Connect to Bitly Data in DBArtisan
Use wizards in DBArtisan to configure Bitly as a data source.
-
Automated Continuous Stack Exchange Replication to SQL Server
Use CData Sync for automated, continuous, customizable Stack Exchange replication to SQL Server.
-
Build Pipeliner CRM-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Pipeliner CRM Data in Gemini Code Assist to assist with building Pipeliner CRM-powered applications.
-
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.
-
How to Access Live SAP Netweaver Gateway Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Netweaver Gateway enables you to integrate SAP Netweaver Gateway into workflows built using Microsoft Power Automate Desktop.
-
Integrate Wave Financial Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Wave Financial from Informatica Cloud.
-
Manage Demio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Demio.
-
Access SendPulse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SendPulse from HeidiSQL.
-
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.
-
Analyze Salesforce Data in Looker
Use CData Connect AI to connect to Salesforce Data from Looker and build custom apps using live Salesforce & Force.com.
-
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.
-
Connect to ZohoMarketingHub Data in Jaspersoft Studio
Execute SQL to remote ZohoMarketingHub in Jaspersoft Studio.
-
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.
-
Automated Continuous Autopilot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Autopilot replication to Apache Cassandra.
-
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.
-
How to Build an ETL App for Attio Data in Python with CData
Create ETL applications and real-time data pipelines for Attio in Python with petl.
-
Build Automated Workflows with Live Acumatica Data in Workato
Use CData Connect AI to connect to live Acumatica ERP and build automated workflows in Workato.
-
Use Databricks Agent Bricks to Talk to Your Exact Online Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Exact Online for you.
-
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.
-
Query Sage Intacct Data in ColdFusion
Write standard ColdFusion data access code to connect to Sage Intacct.
-
Build Visualizations of AdRoll Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of AdRoll in Birst.
-
Automate Shippo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Shippo replication to Azure Data Lake.
-
Automated Continuous Facebook Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Facebook replication to Amazon Redshift.
-
Access Live Gumroad Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Gumroad into the statistical analysis tools available in SAS JMP. This article shows how to use Gumroad in the Graph Builder and Query Builder.
-
Analyze Discord Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Discord and visualize live Discord in Infragistics Reveal.
-
Automated Continuous Xero Replication to SQLite
Use CData Sync for automated, continuous, customizable Xero replication to SQLite.
-
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.
-
How to Visualize Mouseflow Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mouseflow in Python.
-
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.
-
Enable the Attio JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Attio.
-
Automated Continuous Amplitude Replication to SingleStore
Use CData Sync for automated, continuous, customizable Amplitude replication to SingleStore.
-
Connect to Amplitude Data in HULFT Integrate
Connect to Amplitude as a JDBC data source in HULFT Integrate
-
DataBind Controls to Tavily Data in C++Builder
DataBind to Tavily in C++Builder with standard components and controls.
-
How to Easily Query DB2 Data in OpenOffice Base
Connect to DB2 data in OpenOffice Base using the CData ODBC Driver for IBM DB2 and generate reports with live data insights.
-
Build Workable-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Workable Data in GitHub Copilot to assist with building Workable-powered applications.
-
How to Connect DBeaver to Apollo via a JDBC Driver
Manage Apollo with visual tools in DBeaver like the query browser.
-
View Reports on Real-Time Shopify Data in Power BI Report Server
Use the CData ODBC Driver for Shopify to visualize Shopify in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Data Flows from Perplexity to SQL Server using SSIS
Easily back up Perplexity to SQL Server using the SSIS components for Perplexity.
-
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.
-
Consume Sage Intacct OData Feeds in PowerBuilder
This article demonstrates how to consume Sage Intacct as OData feeds from PowerBuilder using the API Server.
-
Build Dashboards with Dynamics 365 Business Central Data in Dundas BI
Create dynamic dashboards and perform analytics based on Dynamics 365 Business Central in Dundas BI.
-
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.
-
Consume Bright Data OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Bright Data feeds that reflect any changes in SAP Lumira.
-
Create Power BI Reports on Real-Time Aircall Data
Use the CData ODBC Driver for Aircall to visualize Aircall in Power BI Desktop.
-
Create Authorize.Net Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Authorize.Net from PowerBI.com to create Power BI Dataflows with real-time data.
-
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.
-
Connect to MYOB AccountRight Data in RazorSQL
Connect to MYOB AccountRight from wizards and query MYOB AccountRight from the GUI in the RazorSQL database management tool.
-
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.
-
Automated Continuous Bugsnag Replication to SQL Server
Use CData Sync for automated, continuous, customizable Bugsnag replication to SQL 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.
-
Natively Connect to OData Services in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to OData. Leverage the native support for ODBC in PHP.
-
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.
-
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.
-
ETL LDAP in Oracle Data Integrator
This article shows how to transfer LDAP into a data warehouse using Oracle Data Integrator.
-
Build Dashboards with Mistral AI Data in DBxtra
Create dynamic dashboards and perform analytics based on Mistral AI in DBxtra.
-
Build Visualizations of Drip Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Drip in Birst.