CData Software - Knowledge Base
Recent Articles
-
Access Live PayPal Data in Excel 365 Online (Excel for the web)
Connect to PayPal data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use Azure AI Foundry to Talk to Your MailerLite 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 MailerLite data for you.
-
Connect to Databricks Data in Claris FileMaker Pro
Use the CData ODBC Driver for Databricks in FileMaker Pro to connect to Databricks and work with Databricks data in your FileMaker applications.
-
Build Semantic Layer Views for Shortcut Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Shortcut data.
-
How to Access Eventbrite Data Using Entity Framework
This article shows how to access Eventbrite data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to and Query Reckon Data in QlikView over ODBC
Create data visualizations with Reckon data in QlikView.
-
How to Connect to Live Cassandra 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 Cassandra data for you.
-
ETL Sage Intacct in Oracle Data Integrator
This article shows how to transfer Sage Intacct data into a data warehouse using Oracle Data Integrator.
-
Integrate Asana Data into Power Automate Desktop using CData Connect
CData Connect for Asana Data enables you to integrate Asana data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Copper Data in Tableau
The CData ODBC driver for Copper enables you integrate Copper data into Tableau dashboards.
-
Validate Azure Analysis Services Data with QuerySurge
Access and validate Azure Analysis Services data in QuerySurge using the CData JDBC Driver.
-
Access Live Asana Data in Coginiti Pro
Connect to and query live Asana data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software JDBC Driver for Snapchat Ads in MicroStrategy Web
Connect to Snapchat Ads data in MicroStrategy Web using the CData Software JDBC Driver for Snapchat Ads.
-
Use the CData SSIS Components to Insert New or Update Existing Acumatica Records from SQL Server
Easily push SQL Server data to Acumatica using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Acumatica or update existing records with data from a SQL Server database.
-
Bridge Asana Connectivity with Apache NiFi
Access and process Asana data in Apache NiFi using the CData JDBC Driver.
-
Easily Integrate Confluence Data in Lazarus Pascal IDE
Learn how to easily integrate live Confluence data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create ZohoSubscriptions Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoSubscriptions from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to eBay Data in ACL Analytics
Connect to eBay data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to eBay data.
-
How to Connect to Live QuickBooks Online 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 QuickBooks Online data through natural language.
-
Viewing MailChimp Data in RAD Studio Data Explorer
How to view MailChimp data in RAD Studio Data Explorer using the CData ODBC Driver for MailChimp.
-
Connect to and Query GraphQL Data in QlikView over ODBC
Create data visualizations with GraphQL data in QlikView.
-
Connect to Zuora from Asprova with CData Software ODBC Driver for Zuora
This article shows how to connect faster to Zuora data from Asprova.
-
Back Up Aircall data 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 Aircall data data.
-
Automated Continuous Grafana Replication to Snowflake
Use CData Sync for automated, continuous, customizable Grafana replication to Snowflake.
-
Add Google Contacts Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Contacts with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Claude Code CLI with NetSuite 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.
-
Connect to ScrapingBee Data from a Connection Pool in Jetty
The ScrapingBee JDBC Driver supports connection pooling: This article shows how to connect faster to ScrapingBee data from Web apps in Jetty.
-
Publish Crystal Reports on iContact Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date iContact data.
-
Connect ZendeskSell to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZendeskSell with IBM WebSphere for seamless data integration and connectivity.
-
Access Redshift Data from MySQL in Amazon QuickSight
Connect to Redshift and build visualizations of Redshift data using a MySQL Connection in Amazon QuickSight.
-
Integrate SendGrid with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SendGrid with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SendGrid data.
-
Automated Continuous ConstantContact Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ConstantContact replication to Amazon Redshift.
-
Access Live PingOne Data in Coginiti Pro
Connect to and query live PingOne data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Reports from CockroachDB Data in Looker Studio
Use CData Connect AI to gain access to live CockroachDB data and create custom reports in Looker Studio.
-
Analyze PabblySubscriptions Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PabblySubscriptions data with the CData JDBC Driver for PabblySubscriptions.
-
Connecting GenSpark with WordPress Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to WordPress data without any replication or custom integration required.
-
How to Connect to Live PolarTeamPro Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your PolarTeamPro data for you.
-
How to connect SharePoint with Excel Data through external lists
Provide Excel data to SharePoint users as an external list.
-
Integrate Wave Financial with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Wave Financial with External Services.
-
Query Microsoft Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Ads data from Node.js.
-
Connect to Recurly Data in Jaspersoft Studio
Execute SQL to remote Recurly data in Jaspersoft Studio.
-
Use Dash to Build Web Apps on HubSpot Data via CData Connect AI
Build interactive Dash web apps on live HubSpot data using pandas and the CData Connect AI Python SDK.
-
Connect to Odoo Data in Jaspersoft Studio
Execute SQL to remote Odoo data in Jaspersoft Studio.
-
A PostgreSQL Interface for Typeform Data using the CData ODBC Driver
Use the SQL Gateway and Typeform ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Cursor with Live Testmonitor Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Testmonitor data from within the editor.
-
Import Supabase Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Supabase Data and provide access to live Supabase data for custom reports in the Power BI Service.
-
Connect to Bright Data Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Bright Data data.
-
Build a PostgreSQL Interface for SAP Data using the CData JDBC Driver
Use the Remoting features of the SAP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with OnePageCrm Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OnePageCrm data.
-
Automated Continuous ZohoDesk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Amazon Redshift.
-
Integrate Certinia with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Certinia with External Services.
-
Connect to Okta Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Okta data.
-
Integrate Live PabblySubscriptions Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PabblySubscriptions data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate with Typeform Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Typeform data to a JSON file on disk.
-
Using the CData Software ODBC Driver for Hubstaff in PyCharm
Connect to Hubstaff as an ODBC data source in PyCharm using the CData Software ODBC Driver for Hubstaff.
-
How to Access PolarTeamPro Data Using Entity Framework
This article shows how to access PolarTeamPro data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Flowlu Data in DBeaver
Use the CData ODBC Driver to connect to Flowlu data in DBeaver.
-
How to create an RPA flow for Productboard Data in UiPath Studio
Use the Productboard ODBC Driver to create workflows that access real-time Productboard data without any coding.
-
Back Up Blackbaud FE NXT data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Blackbaud FE NXT. In this article, we will employ an SSIS workflow to populate a database with Blackbaud FE NXT data data.
-
Getting Started with the CData Excel Add-In for GetResponse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GetResponse.
-
Connect to Live Epicor Kinetic Data in MicroStrategy through CData Connect AI
Create a live connection to Epicor Kinetic Data in CData Connect AI and connect to your Epicor Kinetic data from MicroStrategy.
-
Replicate Helpscout Data in Heroku for Use in Salesforce Connect
Replicate Helpscout data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Redis Replication to Oracle
Use CData Sync for automated, continuous, customizable Redis replication to Oracle.
-
Query Monday.com Data as a SQL Server Database in Node.js
Execute SQL Server queries against Monday.com data from Node.js.
-
Build iContact-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for iContact Data and create custom apps in Bubble.
-
Migrating data from Google Drive to Snowflake using CData SSIS Components.
Easily push Google Drive data to Snowflake using the CData SSIS Tasks for Google Drive and Snowflake.
-
Import Google Calendar Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Calendar Data and provide access to live Google Calendar data for custom reports in the Power BI Service.
-
Automated Continuous SAP Business One Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Business One replication to SQLite.
-
How to Connect to & Open HelloSign Data in Microsoft Excel
This article uses the CData ODBC driver for HelloSign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build a Simple VCL Application for Sendwithus Data
How to build a simple VCL Application to view Sendwithus data in RAD Studio using the CData ODBC Driver for Sendwithus.
-
Build Dashboards with Impala Data in Dundas BI
Create dynamic dashboards and perform analytics based on Impala data in Dundas BI.
-
Connect to CampaignMonitor Data in DBArtisan
Use wizards in DBArtisan to configure CampaignMonitor data as a data source.
-
Analyze Live Discord Data in SAS Viya
Use CData Connect AI to connect to Discord data from SAS Viya and deploy self-service analytics using live Discord data.
-
Create Zoho Projects-Connected Business Apps in AppSheet
Connect to Zoho Projects Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho Projects data.
-
Automated Continuous Jira Assets Replication to SingleStore
Use CData Sync for automated, continuous, customizable Jira Assets replication to SingleStore.
-
Visualize PayPal Data in Sisense
Create an ElastiCube in Sisense app with access to PayPal data.
-
Integrate Cline with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Greenplum data from within your IDE.
-
Perform Batch Operations with HubDB Data in Apache NiFi
Connect to HubDB data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Pipeline CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pipeline CRM data.
-
Use Grok to Talk to Your Google Drive 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 Google Drive data for you.
-
Visualize Live SAP ByDesign Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP ByDesign data into custom reports in Power BI.
-
Use Dash to Build Web Apps on Acumatica Data via CData Connect AI
Build interactive Dash web apps on live Acumatica data using pandas and the CData Connect AI Python SDK.
-
How to connect Amazon QuickSight to PolarTeamPro Data
Create a connection to PolarTeamPro data in CData Connect AI and insert PolarTeamPro data into Amazon QuickSight SPICE to build interactive dashboards.
-
Manage Asana Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Asana.
-
Create Data Visualizations in Cognos BI with Paylocity Data
Access Paylocity data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to import Hubstaff Data into Apache Solr
Use the CData Software JDBC Driver for Hubstaff in Data Import Handler and create an automated import of Hubstaff data to Apache Solr Enterprise Search platform.
-
Connect to Discourse in SpagoBI
Create reports featuring live Discourse data in SpagoBI Studio. Host Discourse reports on SpagoBI Server.
-
Build MVC Applications with Connectivity to Customer.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Customer.io from an ASP.NET MVC application.
-
Integrating GitHub Copilot with Perplexity 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.
-
Viewing Adobe Experience Manager Data in RAD Studio Data Explorer
How to view Adobe Experience Manager data in RAD Studio Data Explorer using the CData ODBC Driver for Adobe Experience Manager.
-
Query Sendwithus Data in DataGrip
Create a Data Source for Sendwithus in DataGrip and use SQL to query live Sendwithus data.
-
Interact with Live SAP SuccessFactors Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP SuccessFactors data.
-
Connect and Visualize Live SAP Fieldglass Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Fieldglass data into the Databricks platform and create visualization dashboards with real-time SAP Fieldglass data.
-
Query Close Data in DataGrip
Create a Data Source for Close in DataGrip and use SQL to query live Close data.
-
Use the CData Software ODBC Driver for PDFMonkey in MicroStrategy
Connect to PDFMonkey data in MicroStrategy Developer using the CData Software ODBC Driver for PDFMonkey.
-
Query Live QuickBooks Time 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 QuickBooks Time data through a conversational interface.
-
Integrate Google's Antigravity Agent with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live FTP data using the Model Context Protocol.
-
Create Reports from Acumatica Data in Looker Studio
Use CData Connect AI to gain access to live Acumatica data and create custom reports in Looker Studio.
-
Natively Connect to ShipStation Data in PHP
The CData ODBC driver for ShipStation enables you to create PHP applications with connectivity to ShipStation data. Leverage the native support for ODBC in PHP.
-
Visualize Okta Data in Tableau
The CData ODBC driver for Okta enables you integrate Okta data into Tableau dashboards.