CData Software - Knowledge Base
Recent Articles
-
How to Create Derived Views, Saved Queries, and Custom Reports in CData Connect AI
Explore the Derived Views, Saved Queries, and Custom Reports features in CDataConnect AI
-
How to Create Power BI Visual Reports with Real-Time Acumatica Data
Use CData Power BI Connectors to visualize Acumatica data in Power BI.
-
How to Connect Flowise AI Agents to Live Mailgun Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Mailgun data without replication.
-
Automated Continuous Microsoft Planner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Apache Cassandra.
-
Build Automated Workflows with Live BenchmarkEmail Data in Workato
Use CData Connect AI to connect to live BenchmarkEmail data and build automated workflows in Workato.
-
Replicate Aweber Data to Multiple Databases via the CData Sync CLI
Replicate Aweber data to disparate databases with a single configuration.
-
Connect to Mode Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mode and work with Mode data in your FileMaker applications.
-
Integrating Codex with Azure Data Lake Storage 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.
-
Query Box Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Box data from Node.js.
-
Connect to Live eBay Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to eBay Analytics Data in CData Connect AI and connect to your eBay Analytics data from MicroStrategy.
-
Connect to AlloyDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live AlloyDB data.
-
Query Raisers Edge NXT Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Raisers Edge NXT data from Node.js.
-
How to Visualize Coda Data in Python with pandas
Use pandas and other modules to analyze and visualize live Coda data in Python.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ServiceDesk Plus
Provide connectivity to ServiceDesk Plus data through an SAP BusinessObjects universe.
-
How to Visualize Wave Financial Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Wave Financial data in Python.
-
LINQ to Marketo 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 Marketo Data Provider.
-
Write a Simple Go Application to work with Paddle Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Paddle data.
-
Automated Continuous PayPal Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PayPal replication to Amazon S3.
-
Feed Shopify Data into FineReport
How to set Shopify data as a JDBC data source in FineReport.
-
Automate Productboard Data Replication to SAP HANA
Use CData Sync to customize and automate Productboard data replication to SAP HANA.
-
Work with Salesloft Data in FoxPro
Load Salesloft data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Migrating data from OData to Snowflake using CData SSIS Components.
Easily push OData services to Snowflake using the CData SSIS Tasks for OData and Snowflake.
-
Natively Connect to MariaDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MariaDB data. Leverage the native support for ODBC in PHP.
-
Operational Reporting on Clari Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Clari data.
-
Integrate Trae with Live Google Cloud Storage Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Google Cloud Storage data from within the AI-powered IDE.
-
Publish Reports with Miro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Miro data.
-
Access SFTP Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SFTP data from your Oracle system.
-
How to Create Power BI Visual Reports with Real-Time Workday Data
Use CData Power BI Connectors to visualize Workday data in Power BI.
-
Integrating Claude Code with WordPress Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on WordPress data within assisted coding and automated development workflows.
-
How to Query Wave Financial Data in MySQL Workbench
Execute MySQL queries against live Wave Financial data from MySQL Workbench.
-
Working with Cvent Data in LINQPad
Execute LINQ queries to Cvent data in LINQPad.
-
Enable the Outlook JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Outlook data.
-
Use the CData Software ODBC Driver for Odoo in MicroStrategy Web
Connect to Odoo data in MicroStrategy Web using the CData Software ODBC Driver for Odoo.
-
Integrate LibreChat with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Drive data from within the chat interface.
-
Build a PostgreSQL Interface for Act CRM Data using the CData JDBC Driver
Use the Remoting features of the Act CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Landbot Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Landbot data from PowerShell? This article demonstrates how to utilize the Landbot Cmdlets for tasks like connecting to Landbot data, automating operations, downloading data, and more.
-
Integrate Devin with Live Azure Analysis Services 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 Azure Analysis Services data.
-
Access Live Reckon Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Reckon data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for SAP HANA in Microsoft Power Query
You can use the CData SAP HANA ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP HANA data into Microsoft Power Query.
-
Migrating data from MailerLite to Google BigQuery using CData SSIS Components.
Easily push MailerLite data to Google BigQuery using the CData SSIS Tasks for MailerLite and Google BigQuery.
-
Load Sage Intacct Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sage Intacct data to a database.
-
Analyze MongoDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MongoDB data and visualize MongoDB data in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for ChartMogul in SAS for Real-Time Reporting and Analytics
Connect to real-time ChartMogul data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ChartMogul.
-
Use the CData Software JDBC Driver for CockroachDB in MicroStrategy Desktop
Connect to CockroachDB data in MicroStrategy Desktop using the CData Software JDBC Driver for CockroachDB.
-
Use Databricks Agent Bricks to Talk to Your Vault CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Vault CRM data for you.
-
Automated Continuous Sage Cloud Accounting Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Apache Cassandra.
-
Create Office 365-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Office 365 Data from OutSystems and build custom enterprise apps using live Office 365 data.
-
Integrating Cursor with Gorgias 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.
-
Replicate SQL Server Data to Multiple Databases
Replicate SQL Server data to disparate databases with a point-and-click configuration.
-
Visualize Live Rebilly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Rebilly data.
-
Create SAP Business One-Connected Business Apps in AppSheet
Connect to SAP Business One Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Business One data.
-
Integrating Dataiku with Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Basecamp data.
-
Access Amazon Marketplace 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 Amazon Marketplace data.
-
Build Snowflake-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Snowflake Data from Zoho Analytics and import live Snowflake data.
-
Integrate with Live Impala Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Impala from the MuleSoft Anypoint Platform to integrate live Impala data into custom reports and dashboards.
-
Automated Continuous Mistral AI Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mistral AI replication to Snowflake.
-
Migrating data from Adobe Commerce to Databricks using CData SSIS Components.
Easily push Adobe Commerce data to Databricks using the CData SSIS Tasks for Adobe Commerce and Databricks.
-
Teamwork Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Teamwork facts in real time.
-
Connect to and Query Adobe Experience Manager Data in QlikView over ODBC
Create data visualizations with Adobe Experience Manager data in QlikView.
-
Use the CData ODBC Driver for Epicor Kinetic from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Epicor Kinetic to connect to Epicor Kinetic data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Epicor Kinetic data in Excel.
-
Feed Mailgun Data into FineReport
How to set Mailgun data as a JDBC data source in FineReport.
-
Connect to Intercom Data from PowerBuilder via JDBC
This article demonstrates how to access Intercom data from PowerBuilder using the Intercom JDBC Driver.
-
Access Live Chargebee Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Chargebee data into the statistical analysis tools available in SAS JMP. This article shows how to use Chargebee data in the Graph Builder and Query Builder.
-
Build AgileCRM-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live AgileCRM data without replication.
-
Automated Continuous HelloSign Replication to Databricks
Use CData Sync for automated, continuous, customizable HelloSign replication to Databricks.
-
Prepare, Blend, and Analyze Hacker News Data in Alteryx Designer (ODBC)
Build workflows to access live Hacker News data for self-service data analytics.
-
Connect to SAP Business Warehouse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Business Warehouse to connect to SAP Business Warehouse data and execute queries in PowerBuilder.
-
How to Connect to Live SAS xpt Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAS xpt data without replication.
-
Connect to Cloudflare Data from a Connection Pool in Jetty
The Cloudflare JDBC Driver supports connection pooling: This article shows how to connect faster to Cloudflare data from Web apps in Jetty.
-
Connect to Hugging Face from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hugging Face to connect to Hugging Face data from Web applications running on WebLogic.
-
Automated Continuous OData Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable OData replication to Azure SQL Database.
-
Create Invoiced Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Invoiced from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Live Simplesat Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Simplesat data.
-
How to Connect to Live MySQL 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 MySQL data for you.
-
Natively Connect to SAP Fieldglass Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Fieldglass data. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with SAP Ariba Source Data
Access SAP Ariba Source data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Manage ADP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ADP.
-
How to Connect to & Open Testmonitor Data in Microsoft Excel
This article uses the CData ODBC driver for Testmonitor to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Charts with Google Directory Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Directory data in Clear Analytics.
-
Connecting Mastra with Avalara AvaTax 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 Avalara AvaTax data, no replication required.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy Web
Connect to TigerGraph data in MicroStrategy Web using the CData Software ODBC Driver for TigerGraph.
-
Build Charts with Databricks Data in Clear Analytics
Create dynamic charts and perform analytics based on Databricks data in Clear Analytics.
-
How to Create Power BI Visual Reports with Real-Time ScrapingBee Data
Use CData Power BI Connectors to visualize ScrapingBee data in Power BI.
-
Connecting Agentforce with SuiteCRM 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 SuiteCRM data for you.
-
Create Dashboards and Visualize Live Amazon Marketplace Data in Geckoboard
Use CData Connect AI to connect to live Amazon Marketplace data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Printify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Printify with External Services.
-
Create iContact-Connected Nintex Workflows
Use CData Connect AI to connect to iContact Data from Nintex Workflow Cloud and build custom workflows using live iContact data.
-
Integrating LlamaIndex with Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Instagram data in real time.
-
Use the CData Software ODBC Driver for Coda in SAS for Real-Time Reporting and Analytics
Connect to real-time Coda data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Coda.
-
Add Telegram Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Telegram with the Informatica Enterprise Data Catalog to classify and organize data.
-
Choosing the Best Method to Connect Oracle Eloqua to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Eloqua data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Stripe Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Stripe data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Import Real-Time Pingdom Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pingdom data in ColdFusion.
-
Configure the CData JDBC Driver for Aha! in a Connection Pool in Tomcat
Connect to Aha! data from a connection pool in Tomcat.
-
How to connect to Typeform Data with Squirrel SQL client
Connect to Typeform data and execute queries in the Squirrel SQL Client.
-
Connect to Vault CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Vault CRM to connect to Vault CRM data from Web applications running on WebLogic.
-
Analyze Twitter Ads Data in Looker
Use CData Connect AI to connect to Twitter Ads Data from Looker and build custom apps using live Twitter Ads data.
-
Create Hive-Connected Nintex Workflows
Use CData Connect AI to connect to Hive Data from Nintex Workflow Cloud and build custom workflows using live Hive data.
-
Migrating data from Salesforce Pardot to Snowflake using CData SSIS Components.
Easily push Salesforce Pardot data to Snowflake using the CData SSIS Tasks for Salesforce Pardot and Snowflake.
-
Moving Data from ZohoInvoice to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoInvoice data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.