CData Software - Knowledge Base
Recent Articles
-
Connect to SQL Analysis Services Data in Google Apps Script via Connect AI
Use CData Connect AI to access SQL Analysis Services data in Google Apps Script.
-
Automated Microsoft Dataverse Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Dataverse data replication to Teradata.
-
Use Manus AI to Talk to Your HubDB 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 HubDB data.
-
Build Dashboards with Coinbase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Coinbase data in Dundas BI.
-
Work with MariaDB Data in FoxPro
Load MariaDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Migrating data from Coinbase to Databricks using CData SSIS Components.
Easily push Coinbase data to Databricks using the CData SSIS Tasks for Coinbase and Databricks.
-
Feed Testmonitor Data into FineReport
How to set Testmonitor data as a JDBC data source in FineReport.
-
Operational Reporting on Zendesk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zendesk data.
-
Getting Started with the CData Excel Add-In for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft OneDrive.
-
Connect to VWO Data in RapidMiner
Integrate VWO data with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize Zoho Creator Data in TIBCO Spotfire through ADO.NET
Integrate Zoho Creator data into dashboards in TIBCO Spotfire.
-
Connecting Mastra with Hive 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 Hive data, no replication required.
-
Analyze Google Campaign Manager 360 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Campaign Manager 360 data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with VWO Data in JReport Designer
Create charts and reports based on VWO data in JReport Designer.
-
Use Grok to Talk to Your Amazon DynamoDB 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 Amazon DynamoDB data for you.
-
Integrating OpenCode with OpenWeatherMap 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.
-
How to Access Live Ontraport Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Ontraport enables you to integrate Ontraport data into workflows built using Microsoft Power Automate Desktop.
-
Import Real-Time Splunk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Splunk data in ColdFusion.
-
Build Impala-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Impala data.
-
Use Dash to Build to Web Apps on Spotify Data
Create Python applications that use pandas and Dash to build Spotify-connected web apps.
-
Integrate Goose with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Freshservice data from within the local AI agent.
-
Automated YouTube Analytics Data Replication to Teradata
Use CData Sync to Customize and automate YouTube Analytics data replication to Teradata.
-
Build Data Flows from PingOne to SQL Server using SSIS
Easily back up PingOne data to SQL Server using the SSIS components for PingOne.
-
How to import Typeform Data into Apache Solr
Use the CData Software JDBC Driver for Typeform in Data Import Handler and create an automated import of Typeform data to Apache Solr Enterprise Search platform.
-
Build a PostgreSQL Interface for Bullhorn CRM Data using the CData JDBC Driver
Use the Remoting features of the Bullhorn CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Perplexity Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Perplexity from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to and Query Microsoft Exchange Data in QlikView over ODBC
Create data visualizations with Microsoft Exchange data in QlikView.
-
Automated Continuous Sage 200 Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage 200 replication to SQLite.
-
Automate MarkLogic Data Replication to Couchbase
Use CData Sync to Customize and automate MarkLogic data replication to Couchbase.
-
How to connect to Pipeline CRM Data from IntelliJ
Integrate connectivity to Pipeline CRM data with wizards in IntelliJ.
-
Integrate Live Google Analytics Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Google Analytics data from within the IDE.
-
Connecting Moonlit Workflow with Timely 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 Timely data in real time.
-
Replicate Zoho CRM Data in Heroku for Use in Salesforce Connect
Replicate Zoho CRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy Web
Connect to Redshift data in MicroStrategy Web using the CData Software JDBC Driver for Redshift.
-
DataBind Charts to Printful Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Printful data 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.
-
How to Access Excel Online Data Using Entity Framework
This article shows how to access Excel Online data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Snowflake Data in ACL Analytics
Connect to Snowflake data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Snowflake data.
-
How to Use a Microsoft Access Database to Update Dynamics 365 Data in Real Time
Update Dynamics 365 data by creating a linked table in Microsoft Access with the CData Dynamics 365 ODBC Driver.
-
Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy
Connect to eBay Analytics data in MicroStrategy Developer using the CData Software ODBC Driver for eBay Analytics.
-
Integrate Live SFTP Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SFTP from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SFTP data.
-
Build Apps with Live Google Cloud Storage Data Using the Low-Code Development Platform of Mendix
Connect Google Cloud Storage data with Mendix to build apps using the CData JDBC Driver for Google Cloud Storage.
-
Automated Continuous Impala Replication to SQLite
Use CData Sync for automated, continuous, customizable Impala replication to SQLite.
-
Configure the CData JDBC Driver for Acumatica in a Connection Pool in Tomcat
Connect to Acumatica data from a connection pool in Tomcat.
-
Migrating data from Freshdesk to Google BigQuery using CData SSIS Components.
Easily push Freshdesk data to Google BigQuery using the CData SSIS Tasks for Freshdesk and Google BigQuery.
-
How to Access Everhour Data Using Entity Framework
This article shows how to access Everhour data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Grok to Talk to Your Redshift 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 Redshift data for you.
-
Tally Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Tally facts in real time.
-
Integrate Real-Time Access to SAP Fieldglass in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Fieldglass data in real time.
-
How to Connect to Tavily Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Tavily data. Leverage the pyodbc module for ODBC in Python.
-
Connect to JobNimbus Data from PowerBuilder via ADO.NET
This article demonstrates how to access JobNimbus data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect Amazon QuickSight to DB2 Data
Create a connection to DB2 data in CData Connect AI and insert DB2 data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Work with SAP Ariba Procurement Data in AWS Glue Jobs Using JDBC
Connect to SAP Ariba Procurement from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Insightly Data in the Pentaho Report Designer
Publish reports based on Insightly data in the Pentaho BI tool.
-
Build Sybase IQ-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sybase IQ Data from Zoho Analytics and import live Sybase IQ data.
-
Integrate Parallel Data in Pentaho Data Integration
Build ETL pipelines based on Parallel data in the Pentaho Data Integration tool.
-
Building Dynamic Web Pages with Cassandra Data Using AngularJS
Create single-page applications with live connectivity to Cassandra using the CData API Server.
-
Connect to ConstantContact Data from PowerBuilder via JDBC
This article demonstrates how to access ConstantContact data from PowerBuilder using the ConstantContact JDBC Driver.
-
How to connect PolyBase to HelloSign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HelloSign data.
-
Build Box-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Box Data from Zoho Analytics and import live Box data.
-
How to Connect to Live OneNote 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 OneNote data through natural language.
-
Bind Live ActiveCampaign Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ActiveCampaign data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrating LlamaIndex with WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on WooCommerce data in real time.
-
A PostgreSQL Interface for Sage Cloud Accounting Data using the CData ODBC Driver
Use the SQL Gateway and Sage Cloud Accounting ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Nuclia
Provide connectivity to Nuclia data through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze Adobe Commerce Data in Alteryx Designer (Connect AI)
Build workflows to access live Adobe Commerce data for self-service data analytics.
-
Connect to Close Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Close and the SQL Gateway to access Close data from Google Apps Script.
-
Perform Batch Operations with DB2 Data in Apache NiFi
Connect to DB2 data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Live Cvent Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Cvent data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate HCL Domino Data in the Pentaho Report Designer
Publish reports based on HCL Domino data in the Pentaho BI tool.
-
Automate SurveyMonkey Data Replication to SAP HANA
Use CData Sync to customize and automate SurveyMonkey data replication to SAP HANA.
-
Creating Toggl-Connected Applications in Unqork
You can use CData Connect AI to feed Toggl data to Unqork and build custom business apps.
-
How to Connect the Power BI Service to Tally: Complete Guide
Connect to the CData Software Power BI Connector for Tally from PowerBI.com to provide real-time Tally data across the organization.
-
Prepare, Blend, and Analyze YouTube Analytics Data in Alteryx Designer (ODBC)
Build workflows to access live YouTube Analytics data for self-service data analytics.
-
Build Amazon DynamoDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Amazon DynamoDB data and build Amazon DynamoDB-connected web apps with Axios.
-
How to connect to Google Ads Data in DBVisualizer
Integrate Google Ads data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to LightSpeedRetail Data in HULFT Integrate
Connect to LightSpeedRetail as a JDBC data source in HULFT Integrate
-
Integrate Cursor with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Avalara AvaTax data from within the editor.
-
Integrate Stack Exchange Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Stack Exchange data from Informatica Cloud.
-
Bridge SingleStore Connectivity with Apache NiFi
Access and process SingleStore data in Apache NiFi using the CData JDBC Driver.
-
How to connect to MarkLogic Data from Spring Boot
Connect to MarkLogic in a Spring Boot Application using the CData JDBC Driver for MarkLogic
-
Connect MailerSend Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MailerSend data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Power BI Connector for Drip
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connecting Pipedream with Sage 300 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 Sage 300 data in real time.
-
Work with Instagram Data in FoxPro
Load Instagram data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connecting Agentforce with Anaplan Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Anaplan data for you.
-
Use the CData Software ODBC Driver for Adobe Commerce in MicroStrategy
Connect to Adobe Commerce data in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Commerce.
-
Creating AfterShip-Connected Applications in Unqork
You can use CData Connect AI to feed AfterShip data to Unqork and build custom business apps.
-
How to Access Live Flowlu Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Flowlu enables you to integrate Flowlu data into workflows built using Microsoft Power Automate Desktop.
-
Query Grafana Data as a MySQL Database in Node.js
Execute MySQL queries against Grafana data from Node.js.
-
Use Azure AI Foundry to Talk to Your Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Impala data for you.
-
How to Connect to Live Apify Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apify data securely in real time.
-
Replicate Multiple Nuclia Accounts
Replicate multiple Nuclia accounts to one or many databases.
-
Use the CData Software JDBC Driver for Blackbaud FE NXT in MicroStrategy Desktop
Connect to Blackbaud FE NXT data in MicroStrategy Desktop using the CData Software JDBC Driver for Blackbaud FE NXT.
-
Migrating data from Snowflake to Databricks using CData SSIS Components.
Easily push Snowflake data to Databricks using the CData SSIS Tasks for Snowflake and Databricks.
-
Build AI Agents with HDFS Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live HDFS data through CData Connect AI.
-
Analyze Suadeo Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Suadeo data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automate Superchat Data Replication to Couchbase
Use CData Sync to Customize and automate Superchat data replication to Couchbase.
-
Build Dashboards with GraphQL Data in DBxtra
Create dynamic dashboards and perform analytics based on GraphQL data in DBxtra.
-
Connect to Anaplan from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Anaplan data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Live CouchDB Data in MicroStrategy through CData Connect AI
Create a live connection to CouchDB Data in CData Connect AI and connect to your CouchDB data from MicroStrategy.