CData Software - Knowledge Base
Recent Articles
-
Integrating Dataiku with Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Entra ID data.
-
How to connect and process QuickBooks Online data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks Online data.
-
Build Google Drive-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Drive Data and create custom apps in Mendix.
-
Connect to SAP Concur Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP Concur.
-
How to create an RPA flow for CouchDB Data in UiPath Studio
Use the CouchDB ODBC Driver to create workflows that access real-time CouchDB data without any coding.
-
Replicate SAP Netweaver Gateway Data from PowerShell
Write a quick PowerShell script to query SAP Netweaver Gateway data. Use connectivity to the live data to replicate SAP Netweaver Gateway data to SQL Server.
-
Build a PostgreSQL Interface for Onfleet Data using the CData JDBC Driver
Use the Remoting features of the Onfleet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Phoenix Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Phoenix to connect to Phoenix data and execute queries in PowerBuilder.
-
Analyze ServiceDesk Plus Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ServiceDesk Plus from Power Pivot. You will use the Table Import Wizard to load ServiceDesk Plus data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Dynamics CRM in SpagoBI
Create reports featuring live Dynamics CRM data in SpagoBI Studio. Host Dynamics CRM reports on SpagoBI Server.
-
How to Seamlessly Import Wave Financial Data into IBM SPSS Modeler
Integrate Wave Financial data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Codex with Jumpseller 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 create an RPA flow for Reply.io Data in UiPath Studio
Use the Reply.io ODBC Driver to create workflows that access real-time Reply.io data without any coding.
-
Connect to Live RSS Feeds in MicroStrategy through CData Connect AI
Create a live connection to RSS Feeds in CData Connect AI and connect to your RSS feeds from MicroStrategy.
-
Build Data Flows from Discord to SQL Server using SSIS
Easily back up Discord data to SQL Server using the SSIS components for Discord.
-
Connect to JDBC-ODBC Bridge Data in RazorSQL
Connect to JDBC-ODBC Bridge from wizards and query JDBC-ODBC Bridge data from the GUI in the RazorSQL database management tool.
-
How to Create Power BI Visual Reports with Real-Time Testmonitor Data
Use CData Power BI Connectors to visualize Testmonitor data in Power BI.
-
Integrating Cursor with Azure DevOps 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.
-
Build Apps with Live Google Sheets data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Sheets data into the Adalo platform and build custom mobile and web applications with real-time Google Sheets data.
-
Add Calendly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Calendly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Establish a Live Connection with Foursquare Data using Tableau Bridge
The CData ODBC Driver for Foursquare enables you to integrate live Foursquare data into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate TaxJar Data to Multiple Databases
Replicate TaxJar data to disparate databases with a point-and-click configuration.
-
Object-Relational Mapping (ORM) with Teamwork Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Teamwork data into a Java-based ORM framework, Hibernate.
-
Replicate SingleStore Data to Multiple Databases
Replicate SingleStore data to disparate databases with a point-and-click configuration.
-
Query Bannerbear Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bannerbear data from Node.js.
-
Build Notion-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Notion data.
-
Link Pingdom with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pingdom data in Filemaker Pro for Mac or Windows.
-
TaxJar Reporting in OBIEE with the TaxJar JDBC Driver
Deploy the TaxJar JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Link Teamgate with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Teamgate data in Filemaker Pro for Mac or Windows.
-
Access Live Microsoft Teams Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Teams data from your Excel spreadsheets.
-
Query SharePoint Excel Services Data in DataGrip
Create a Data Source for SharePoint Excel Services in DataGrip and use SQL to query live SharePoint Excel Services data.
-
Build AI/ML Models with Live Reckon Data using Dataiku
Connect Reckon Data with Dataiku using the CData JDBC Driver for Reckon.
-
How to Connect Flowise AI Agents to Live Amazon Athena 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 Amazon Athena data without replication.
-
Automate Dynamics CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Dynamics CRM data replication to Couchbase.
-
How to create an RPA flow for Rootly Data in UiPath Studio
Use the Rootly ODBC Driver to create workflows that access real-time Rootly data without any coding.
-
Easily Integrate xBase Data in Lazarus Pascal IDE
Learn how to easily integrate live xBase data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous ConvertAPI Replication to MySQL
Use CData Sync for automated, continuous, customizable ConvertAPI replication to MySQL.
-
Excel Spreadsheet Automation on SAP Data with the QUERY Formula
Pull data from SAP, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to & Open Sage 300 Data in Microsoft Excel
This article uses the CData ODBC driver for Sage 300 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Prepare, Blend, and Analyze Spark Data in Alteryx Designer (Connect AI)
Build workflows to access live Spark data for self-service data analytics.
-
How to Build an ETL App for Avalara AvaTax Data in Python with CData Connect AI
Build ETL pipelines that read and write live Avalara AvaTax data in Python with petl and the CData Connect AI Python SDK.
-
Analyze IBM Cloud Object Storage Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of IBM Cloud Object Storage data and visualize live IBM Cloud Object Storage data in Infragistics Reveal.
-
Automated Continuous HelloSign Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HelloSign replication to Google Cloud SQL.
-
Analyze Google Tasks Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Tasks data with the CData JDBC Driver for Google Tasks.
-
Use the CData Software ODBC Driver for SingleStore in MicroStrategy Web
Connect to SingleStore data in MicroStrategy Web using the CData Software ODBC Driver for SingleStore.
-
Build Front-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Front data.
-
Automated Continuous SAP Hybris C4C Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Google Cloud SQL.
-
Bind Live SAP ByDesign Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP ByDesign data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build Agents in Relevance AI with Access to Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sendwithus data within intelligent agent workflows.
-
Build Couchbase-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Couchbase Data from Zoho Analytics and import live Couchbase data.
-
Build Data Flows from Intercom to SQL Server using SSIS
Easily back up Intercom data to SQL Server using the SSIS components for Intercom.
-
Connect to LDAP Objects from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live LDAP objects from Filemaker Pro on Mac.
-
How to Connect to Live SAS Data Sets 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 Data Sets data without replication.
-
Create Dynamic Raisers Edge NXT Grids Using the Infragistics XamDataGrid
Learn how you can connect Raisers Edge NXT to Infragistics XamDataGrid to build dynamic grids.
-
Connect Datadog to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Datadog with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Zoho Recruit Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho Recruit data with the CData JDBC Driver for Zoho Recruit.
-
Visualize Live Todoist Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Todoist data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Aircall Data in Coginiti Pro
Connect to and query live Aircall data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Dropbox in SAS for Real-Time Reporting and Analytics
Connect to real-time Dropbox data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dropbox.
-
Visualize Google Tasks Data in TIBCO Spotfire through ADO.NET
Integrate Google Tasks data into dashboards in TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Perigon
Provide connectivity to Perigon data through an SAP BusinessObjects universe.
-
Connect to ChargeOver Data in Aqua Data Studio
Access ChargeOver data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Google Spanner Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Spanner data in Google Apps Script.
-
Use Databricks Agent Bricks to Talk to Your Dynamics 365 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dynamics 365 data for you.
-
How to Query Pipeliner CRM Data in MySQL Workbench
Execute MySQL queries against live Pipeliner CRM data from MySQL Workbench.
-
Connect to SAP Business Warehouse Data from AWS Glue
Use CData Connect AI to gain access to live SAP Business Warehouse data from your AWS Glue jobs.
-
Build Visualizations of SendPulse Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SendPulse data in Birst.
-
Analyze Bright Data Data in Cognos Analytics
Use CData Connect AI to connect to Bright Data Data from Cognos Analytics and analyze live Bright Data data.
-
Connecting GenSpark with Shopify Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Shopify data without any replication or custom integration required.
-
How to connect PolyBase to ElevenLabs
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ElevenLabs data.
-
Create Reports with Instagram Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Instagram data.
-
Migrating data from Intercom to Google BigQuery using CData SSIS Components.
Easily push Intercom data to Google BigQuery using the CData SSIS Tasks for Intercom and Google BigQuery.
-
Integrating Cursor with AgileCRM 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.
-
DataBind Controls to Freshsales Data in C++Builder
DataBind to Freshsales data in C++Builder with standard components and controls.
-
Query Epicor Kinetic Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Epicor Kinetic data from Node.js.
-
Integrating SendPulse Data in Talend Cloud Data Management Platform
Connect SendPulse Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate SAP Concur Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Concur data and integrate live SAP Concur data into your Power Automate tasks.
-
Provide OData Services of Oracle Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle data by developing a WCF Service Application.
-
Automated Continuous Wistia Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Wistia replication to Apache Cassandra.
-
Integrate Live Omnisend Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Omnisend from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Omnisend data.
-
Automated Continuous PolarTeamPro Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Azure SQL Database.
-
Automated Continuous ScrapingBee Replication to SQLite
Use CData Sync for automated, continuous, customizable ScrapingBee replication to SQLite.
-
Build a Singer.io Tap for Factorial With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Factorial data using the CData Python Connector.
-
Integrate Cursor with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Planner data from within the editor.
-
ETL Reckon Accounts Hosted in Oracle Data Integrator
This article shows how to transfer Reckon Accounts Hosted data into a data warehouse using Oracle Data Integrator.
-
Connect to and Query Onfleet Data in QlikView over ODBC
Create data visualizations with Onfleet data in QlikView.
-
Use the CData Software JDBC Driver for Marketo in MicroStrategy
Connect to Marketo data in MicroStrategy Developer using the CData Software JDBC Driver for Marketo.
-
Import and Visualize Hugging Face Data in Power View
Create data visualizations based on Hugging Face data in Excel.
-
Connect and Visualize Live Mailjet Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Mailjet data into the Databricks platform and create visualization dashboards with real-time Mailjet data.
-
Use CData Connect AI to Access Amazon S3 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Amazon S3 data in the Power Pivot business intelligence tool.
-
Migrating data from Adobe Target to Google BigQuery using CData SSIS Components.
Easily push Adobe Target data to Google BigQuery using the CData SSIS Tasks for Adobe Target and Google BigQuery.
-
Integrating Cursor with SendGrid 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.
-
Feed Cloudant Data into FineReport
How to set Cloudant data as a JDBC data source in FineReport.
-
How to Connect to Live Snapchat Ads 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 Snapchat Ads data through natural language.
-
Automate Quickbase Data Replication to SAP HANA
Use CData Sync to customize and automate Quickbase data replication to SAP HANA.
-
How to connect and process Mixpanel data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mixpanel data.
-
Connect to Jumpseller Data in Aqua Data Studio
Access Jumpseller data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Ontraport Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Ontraport to connect to Ontraport data and execute queries in PowerBuilder.
-
Automated Twilio Data Replication to Teradata
Use CData Sync to Customize and automate Twilio data replication to Teradata.
-
Connect to Oracle Service Cloud Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle Service Cloud data from Crystal Reports.