CData Software - Knowledge Base
Recent Articles
-
Integrating Codex with Anaplan 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.
-
Automated Continuous Insightly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Insightly replication to IBM DB2.
-
Integrate Dify with Live Shippo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Shippo data.
-
How to create Mailgun federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mailgun data in MySQL .
-
Access Live Sage Intacct Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Intacct data from your Excel spreadsheets.
-
DataBind Charts to Bitly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bitly 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.
-
LINQ to Azure Data Lake Storage 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 Azure Data Lake Storage Data Provider.
-
Work with Live DB2 Data in Power Query
Use CData Connect AI to connect to DB2 data and work with live DB2 data in Microsoft Power Query.
-
How to work with Everhour Data in Apache Spark using SQL
Access and process Everhour Data in Apache Spark using the CData Software JDBC Driver.
-
Build Automated HDFS-Connected Workflows in Zapier
Use CData Connect AI to connect to live HDFS data and build automated workflows in Zapier.
-
Create Power BI Reports on Real-Time Pinterest Data
Use the CData ODBC Driver for Pinterest to visualize Pinterest data in Power BI Desktop.
-
Query Live Supabase Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Supabase data through a conversational interface.
-
Connect to Neo4J from a Connection Pool in WebLogic
Use the CData JDBC Driver for Neo4J to connect to Neo4J data from Web applications running on WebLogic.
-
Automated Continuous Pipeline CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to MongoDB.
-
Integrate Gmail Data in Pentaho Data Integration
Build ETL pipelines based on Gmail data in the Pentaho Data Integration tool.
-
Integrate SpaceX Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SpaceX data from Informatica Cloud.
-
Natively Connect to Neo4J Data in PHP
The CData ODBC driver for Neo4J enables you to create PHP applications with connectivity to Neo4J data. Leverage the native support for ODBC in PHP.
-
Automate Strava Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Strava data from PowerShell? This article demonstrates how to utilize the Strava Cmdlets for tasks like connecting to Strava data, automating operations, downloading data, and more.
-
Integrate Live Amazon DynamoDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Amazon DynamoDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon DynamoDB data.
-
Getting Started with the CData Power BI Connector for Gumroad
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Live Vimeo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Vimeo enables you to integrate Vimeo data into workflows built using Microsoft Power Automate Desktop.
-
Build Agents in Relevance AI with Access to Live Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Search results within intelligent agent workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for Databricks
Create Databricks data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate OpenCode with Live Guru Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Guru data from within your AI coding agent.
-
Connect to Cloudant Data in Google Apps Script via Connect AI
Use CData Connect AI to access Cloudant data in Google Apps Script.
-
Access ClickUp Data from MySQL in PHP
Connect to ClickUp through the standard MySQL libraries in PHP.
-
How to connect and process Google Directory data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Directory data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SparkPost
Provide connectivity to SparkPost data through an SAP BusinessObjects universe.
-
Build AI Agents with Azure Table 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 Azure Table data through CData Connect AI.
-
Create Reports with CampaignMonitor Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CampaignMonitor data.
-
Build Dashboards with ShipEngine Data in DBxtra
Create dynamic dashboards and perform analytics based on ShipEngine data in DBxtra.
-
Create SSAS Tabular Models from Oracle Financials Cloud Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Financials Cloud data using CData drivers.
-
Getting Started with the CData ODBC Driver for Scrapfly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Scrapfly.
-
Query Live Smartsheet Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Smartsheet data through a conversational interface.
-
Consume SAP Business Warehouse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Business Warehouse feeds that reflect any changes in SAP Lumira.
-
Replicate Multiple ChargeOver Accounts via the CData Sync CLI
Replicate multiple ChargeOver accounts to one or many databases.
-
Visualize Amazon S3 Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Amazon S3 data into TIBCO Spotfire.
-
Connect to PingOne Data in ACL Analytics
Connect to PingOne data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to PingOne data.
-
Integrate with Jira Data in JReport Designer
Create charts and reports based on Jira data in JReport Designer.
-
Integrate Live SingleStore 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 SingleStore data from within the IDE.
-
Create Couchbase-Connected Nintex Workflows
Use CData Connect AI to connect to Couchbase Data from Nintex Workflow Cloud and build custom workflows using live Couchbase data.
-
Analyze CouchDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of CouchDB data and visualize CouchDB data in SAP Analytics Cloud.
-
Connect to Wistia 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 Wistia and work with Wistia data in your FileMaker application.
-
Deploy the ADO.NET Provider for PagerDuty on an SSRS Report Server
Connect to PagerDuty data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build AI/ML Models with Live TigerGraph Data using Dataiku
Connect TigerGraph Data with Dataiku using the CData JDBC Driver for TigerGraph.
-
Visualize Calendly Data in TIBCO Spotfire through ADO.NET
Integrate Calendly data into dashboards in TIBCO Spotfire.
-
Integrate Open WebUI with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zuora data from within the chat interface.
-
Work with AlloyDB Data in FoxPro
Load AlloyDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Elasticsearch Data to Multiple Databases via the CData Sync CLI
Replicate Elasticsearch data to disparate databases with a single configuration.
-
How to Connect to Live XML 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 XML data for you.
-
Integrate Devin with Live Workday Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Workday data.
-
Automated Continuous ServiceDesk Plus Replication to SingleStore
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to SingleStore.
-
Establish a Live Connection with SurveyMonkey Data using Tableau Bridge
The CData ODBC Driver for SurveyMonkey enables you to integrate live SurveyMonkey data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Dify with Live Dynamics NAV Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Dynamics NAV data.
-
Use Dash to Build Web Apps on Egnyte Data via CData Connect AI
Build interactive Dash web apps on live Egnyte data using pandas and the CData Connect AI Python SDK.
-
Migrating data from Google Directory to Snowflake using CData SSIS Components.
Easily push Google Directory data to Snowflake using the CData SSIS Tasks for Google Directory and Snowflake.
-
Automate SFTP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SFTP data from PowerShell? This article demonstrates how to utilize the SFTP Cmdlets for tasks like connecting to SFTP data, automating operations, downloading data, and more.
-
Publish ChartMogul-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ChartMogul data.
-
Work with Live Exact Online Data in Power Query
Use CData Connect AI to connect to Exact Online data and work with live Exact Online data in Microsoft Power Query.
-
Create Power BI Reports on Real-Time Trello Data
Use the CData ODBC Driver for Trello to visualize Trello data in Power BI Desktop.
-
Connect to Zoho Books Data in Aqua Data Studio
Access Zoho Books data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Power BI XMLA-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Power BI XMLA data and build web apps with connectivity to live Power BI XMLA data.
-
Use the CData Software JDBC Driver for Dropbox in MicroStrategy Desktop
Connect to Dropbox data in MicroStrategy Desktop using the CData Software JDBC Driver for Dropbox.
-
Create Reports from Google Cloud Storage Data in Looker Studio
Use CData Connect AI to gain access to live Google Cloud Storage data and create custom reports in Looker Studio.
-
Getting Started with the CData ADO.NET Provider for SendGrid
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SendGrid.
-
Connect to Instagram Data in Aqua Data Studio
Access Instagram data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate with Live Oracle Service Cloud Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Service Cloud from the MuleSoft Anypoint Platform to integrate live Oracle Service Cloud data into custom reports and dashboards.
-
Automated Continuous Aircall Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Aircall replication to Google BigQuery.
-
Use the CData Software ODBC Driver for Google Sheets in MicroStrategy Desktop
Connect to Google Sheets data in MicroStrategy Desktop using the CData Software ODBC Driver for Google Sheets.
-
Automated Continuous IBM Informix Replication to MySQL
Use CData Sync for automated, continuous, customizable IBM Informix replication to MySQL.
-
How to connect to MYOB AccountRight Data in DBVisualizer
Integrate MYOB AccountRight data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Pipelines with Live Asana Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Asana from Google Cloud Data Fusion, enabling the integration of live Asana data into the building and management of effective data pipelines.
-
Connect to Real-Time LDAP Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for LDAP and Dataflow to import and use LDAP objects in Power Apps.
-
Connect to Wistia Data in Jaspersoft Studio
Execute SQL to remote Wistia data in Jaspersoft Studio.
-
How to Connect the Power BI Service to CouchDB: Complete Guide
Connect to the CData Software Power BI Connector for CouchDB from PowerBI.com to provide real-time CouchDB data across the organization.
-
Analyze Oracle SCM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle SCM data and visualize Oracle SCM data in SAP Analytics Cloud.
-
Build Charts with DB2 Data in Clear Analytics
Create dynamic charts and perform analytics based on DB2 data in Clear Analytics.
-
Build Data Flows from SQL Server to Oracle through SSIS
Easily push SQL Server data to Oracle using the CData SSIS Tasks for Oracle.
-
DataBind Controls to Coinbase Data in Delphi
DataBind to Coinbase data in Delphi with standard data access components and controls.
-
A PostgreSQL Interface for ZendeskSell Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZendeskSell JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Azure DevOps to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure DevOps with IBM WebSphere for seamless data integration and connectivity.
-
Work with Typeform Data in FoxPro
Load Typeform data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import and Visualize Sage Cloud Accounting Data in Power View
Create data visualizations based on Sage Cloud Accounting data in Excel.
-
Connect to Reckon Data in ACL Analytics
Connect to Reckon data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Reckon data.
-
Connect to Pingdom Data in RapidMiner
Integrate Pingdom data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Easily Query JobNimbus Data in OpenOffice Base
Connect to JobNimbus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Deel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Deel data using standard SQL.
-
Integrating Kiro with Cvent 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.
-
Integrating Claude Code CLI with Recurly 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 Presto Data from MySQL in Amazon QuickSight
Connect to Presto and build visualizations of Presto data using a MySQL Connection in Amazon QuickSight.
-
Connect to SAP Netweaver Gateway Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Netweaver Gateway data in the Denodo Virtual DataPort Administrator.
-
Use Manus AI to Talk to Your SparkPost 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 SparkPost data.
-
Access Beeminder Data from MySQL in Amazon QuickSight
Connect to Beeminder and build visualizations of Beeminder data using a MySQL Connection in Amazon QuickSight.
-
Analyze Live ZohoSubscriptions Data in SAS Viya
Use CData Connect AI to connect to ZohoSubscriptions data from SAS Viya and deploy self-service analytics using live ZohoSubscriptions data.
-
Build Voice Agents in ElevenLabs with access to Live SAP Business Warehouse Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Business Warehouse data.
-
Stream Dynamics NAV Data into Apache Kafka Topics
Access and stream Dynamics NAV data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Mode Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Mode Data and connect to Mode data in Akorbi Digital RunMyProcess.
-
Automated Continuous Blackbaud FE NXT Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Apache Kafka.
-
Create Informatica Mappings From/To a JDBC Data Source for Asana
Create Asana data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to import Float Data into Apache Solr
Use the CData Software JDBC Driver for Float in Data Import Handler and create an automated import of Float data to Apache Solr Enterprise Search platform.