CData Software - Knowledge Base
Recent Articles
-
Integrating Cursor with Front 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 Easily Query PingOne Data in OpenOffice Base
Connect to PingOne data in OpenOffice Base using the CData ODBC Driver for PingOne and generate reports with live data insights.
-
How to Access Live Xero Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Xero enables you to integrate Xero data into workflows built using Microsoft Power Automate Desktop.
-
Model, Search, and Visualize Live Dynamics CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Dynamics CRM data for modeling, searching, and visualizing.
-
Connect to Moosend 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 Moosend and work with Moosend data in your FileMaker application.
-
Use the CData Software ODBC Driver for DocuSign in MicroStrategy Web
Connect to DocuSign data in MicroStrategy Web using the CData Software ODBC Driver for DocuSign.
-
Model, Search, and Visualize Live SAP SuccessFactors LMS Data in ThoughtSpot
Use CData Connect AI to connect to live SAP SuccessFactors LMS data for modeling, searching, and visualizing.
-
Connect to and Query CSV Data in QlikView over ODBC
Create data visualizations with CSV data in QlikView.
-
Connect to and Visualize Live ZeroBounce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZeroBounce data.
-
Build Dashboards with Brex Data in Dundas BI
Create dynamic dashboards and perform analytics based on Brex data in Dundas BI.
-
Build an OLAP Cube in SSAS from Act-On Data
Establish a connection to Act-On data data from SQL Server Analysis Services, and use the Act-On Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to SAP ByDesign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP ByDesign data in the Denodo Virtual DataPort Administrator.
-
How to import MariaDB Data into Apache Solr
Use the CData Software JDBC Driver for MariaDB in Data Import Handler and create an automated import of MariaDB data to Apache Solr Enterprise Search platform.
-
Integrate Goose with Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sendwithus data from within the local AI agent.
-
Integrating Kiro with Gong 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 AgileCRM Replication to Oracle
Use CData Sync for automated, continuous, customizable AgileCRM replication to Oracle.
-
How to Build an ETL App for TaxJar Data in Python with CData
Create ETL applications and real-time data pipelines for TaxJar data in Python with petl.
-
Working with SAP SuccessFactors Data in LINQPad
Execute LINQ queries to SAP SuccessFactors data in LINQPad.
-
Integrate with ServiceDesk Plus Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ServiceDesk Plus data in SnapLogic.
-
How to Connect to Live Avalara AvaTax 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 Avalara AvaTax data for you.
-
Build an OLAP Cube in SSAS from Wistia Data
Establish a connection to Wistia data data from SQL Server Analysis Services, and use the Wistia Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish EnterpriseDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live EnterpriseDB data.
-
How to Connect to Live BigQuery Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live BigQuery data securely in real time.
-
Create Microsoft Entra ID Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Entra ID data access from reports, embedded analytics, and more.
-
Integrate with Excel Online Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Excel Online data in SnapLogic.
-
Create Data Visualizations in Cognos BI with Ontraport Data
Access Ontraport data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData ADO.NET Provider for Unbounce
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData Software ODBC Driver for Cvent in SAS for Real-Time Reporting and Analytics
Connect to real-time Cvent data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cvent.
-
Automate Front Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Front data from PowerShell? This article demonstrates how to utilize the Front Cmdlets for tasks like connecting to Front data, automating operations, downloading data, and more.
-
Integrate Office 365 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Office 365 with External Services.
-
Access Live PayPal Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PayPal data from your Excel spreadsheets.
-
Create Power BI Reports on Real-Time Paddle Data
Use the CData ODBC Driver for Paddle to visualize Paddle data in Power BI Desktop.
-
How to connect to Klipfolio Data with Squirrel SQL client
Connect to Klipfolio data and execute queries in the Squirrel SQL Client.
-
Interact with Live Pinterest Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Pinterest data.
-
How to connect to Elasticsearch Data with Squirrel SQL client
Connect to Elasticsearch data and execute queries in the Squirrel SQL Client.
-
Query Accelo Data in DataGrip
Create a Data Source for Accelo in DataGrip and use SQL to query live Accelo data.
-
Connect to Sybase IQ Data in RapidMiner
Integrate Sybase IQ data with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Multiple LightSpeedRetail Accounts via the CData Sync CLI
Replicate multiple LightSpeedRetail accounts to one or many databases.
-
Build SparkPost-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 SparkPost data without replication.
-
Build MVC Applications with Connectivity to Reckon Accounts Hosted Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Reckon Accounts Hosted from an ASP.NET MVC application.
-
Create SSAS Tabular Models from ADP Data
How to build a SQL Server Analysis Service Tabular Model from ADP data using CData drivers.
-
Connect to Amazon S3 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon S3 data from Crystal Reports.
-
Integrate LibreChat with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Adobe Analytics data from within the chat interface.
-
Create Data Visualizations Based On Amazon Marketplace Data in Mode
Use CData Connect AI to connect to Amazon Marketplace Data from Mode and build visualizations using live Amazon Marketplace data.
-
Connect and Query Live ZohoSubscriptions Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ZohoSubscriptions data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect to Microsoft OneDrive Data from Spring Boot
Connect to Microsoft OneDrive in a Spring Boot Application using the CData JDBC Driver for Microsoft OneDrive
-
Work with Live Facebook Ads Data in Power Query
Use CData Connect AI to connect to Facebook Ads data and work with live Facebook Ads data in Microsoft Power Query.
-
Operational Reporting on Adobe Target Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Adobe Target data.
-
Connect Neo4J Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Neo4J data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Eloqua Reporting data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Eloqua Reporting.
-
Automate Exact Online Data Replication to Azure Synapse
Use CData Sync to customize and automate Exact Online data replication to Azure Synapse.
-
Query Live Sybase 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 Sybase data through a conversational interface.
-
Integrate Theia IDE with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Google Calendar data from within the development environment.
-
How to create an RPA flow for Freshdesk Data in UiPath Studio
Use the Freshdesk ODBC Driver to create workflows that access real-time Freshdesk data without any coding.
-
Build a PostgreSQL Interface for ADP Data using the CData JDBC Driver
Use the Remoting features of the ADP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports with Google Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ads data.
-
Integrate Goose with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP ByDesign data from within the local AI agent.
-
Build a PostgreSQL Interface for RSS Feeds using the CData JDBC Driver
Use the Remoting features of the RSS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Real-Time Microsoft Entra ID Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Entra ID and Dataflow to import and use Microsoft Entra ID data in Power Apps.
-
Analyze Data in MicroStrategy Using the CData ODBC Driver for Dynamics CRM
In this article we show the use of CData ODBC Drivers with the MicroStrategy BI platform.
-
How to connect to GitHub Data with Squirrel SQL client
Connect to GitHub data and execute queries in the Squirrel SQL Client.
-
Integrate Live SAS Data Sets Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAS Data Sets data and integrate live SAS Data Sets data into apps built in Microsoft Power Apps.
-
Automated Continuous Blackbaud FE NXT Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to IBM DB2.
-
Integrating ZarMoney Data in Talend Cloud Data Management Platform
Connect ZarMoney Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Trae with Live Oracle Sales Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Oracle Sales data from within the AI-powered IDE.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Templated
Provide connectivity to Templated data through an SAP BusinessObjects universe.
-
Deploy the ADO.NET Provider for DocuSign on an SSRS Report Server
Connect to DocuSign 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.
-
Automate Zoom Data Replication to SAP HANA
Use CData Sync to customize and automate Zoom data replication to SAP HANA.
-
Query Hubstaff Data in DataGrip
Create a Data Source for Hubstaff in DataGrip and use SQL to query live Hubstaff data.
-
How to Connect to Live Figshare Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Figshare data for you.
-
Build Pipelines with Live SparkPost Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SparkPost from Google Cloud Data Fusion, enabling the integration of live SparkPost data into the building and management of effective data pipelines.
-
Using the CData Software ODBC Driver for QuickBooks in PyCharm
Connect to QuickBooks as an ODBC data source in PyCharm using the CData Software ODBC Driver for QuickBooks.
-
Build ADP-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ADP data and build ADP-connected web apps with Axios.
-
Using the CData Software ODBC Driver for Retently in PyCharm
Connect to Retently as an ODBC data source in PyCharm using the CData Software ODBC Driver for Retently.
-
Connecting Agentforce with Epicor Kinetic 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 Epicor Kinetic data for you.
-
Replicate Azure Analysis Services Data from PowerShell
Write a quick PowerShell script to query Azure Analysis Services data. Use connectivity to the live data to replicate Azure Analysis Services data to SQL Server.
-
Publish Azure Analysis Services-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Analysis Services data.
-
How to create Impala federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Impala data in MySQL .
-
Getting Started with the CData Tableau Connector for ChartMogul
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Wave Financial-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 Wave Financial data without replication.
-
How to connect to Procore Data from Spring Boot
Connect to Procore in a Spring Boot Application using the CData API Driver for JDBC
-
Create Informatica Mappings From/To a JDBC Data Source for CockroachDB
Create CockroachDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build SAP Ariba Procurement-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Ariba Procurement Data and create custom apps in Bubble.
-
Connect to QuickBooks Time Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks Time and the Script function in FileMaker Pro to connect to QuickBooks Time and work with QuickBooks Time data in your FileMaker application.
-
Access Bugsnag Data from MySQL in Amazon QuickSight
Connect to Bugsnag and build visualizations of Bugsnag data using a MySQL Connection in Amazon QuickSight.
-
Automate Redis Data Replication to Azure Synapse
Use CData Sync to customize and automate Redis data replication to Azure Synapse.
-
Integrating LangChain with ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ZohoInvoice data within automated workflows.
-
Access Live Microsoft Ads Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Ads data into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Ads data in the Graph Builder and Query Builder.
-
Build Agents in Relevance AI with Access to Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Apollo data within intelligent agent workflows.
-
Replicate IBM Cloud Object Storage Data in Heroku for Use in Salesforce Connect
Replicate IBM Cloud Object Storage data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Anaplan Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Anaplan data access from reports, embedded analytics, and more.
-
Access BigCommerce Data from MySQL in Amazon QuickSight
Connect to BigCommerce and build visualizations of BigCommerce data using a MySQL Connection in Amazon QuickSight.
-
Create Bitbucket-Connected Dashboards in Grafana
Connect to Bitbucket Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Bitbucket data.
-
How to Connect to MailerLite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MailerLite data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Factorial Replication to MySQL
Use CData Sync for automated, continuous, customizable Factorial replication to MySQL.
-
Use Manus AI to Talk to Your SuiteCRM 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 SuiteCRM data.
-
Consume Salesforce Data 360 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce Data 360 feeds that reflect any changes in SAP Lumira.
-
Use the CData ODBC Driver for Zoho CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho CRM to connect to Zoho CRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho CRM data in Excel.
-
Using the CData Software ODBC Driver for Cloudflare in PyCharm
Connect to Cloudflare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cloudflare.
-
Connect to Short.io Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Short.io data in the Denodo Virtual DataPort Administrator.