CData Software - Knowledge Base
Recent Articles
-
Access Live YouTube Analytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live YouTube Analytics from your Excel spreadsheets.
-
Connect to Pipeline CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pipeline CRM in the Denodo Virtual DataPort Administrator.
-
Design BIRT Reports on Quaderno Data
Provide current Quaderno to your embedded analytics.
-
How to connect to Okta Data from IntelliJ
Integrate connectivity to Okta with wizards in IntelliJ.
-
Excel Spreadsheet Automation on Microsoft Ads Data with the QUERY Formula
Pull data from Microsoft Ads, automate spreadsheets, and more with the QUERY formula.
-
Integrating Kiro CLI with LDAP Objects 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.
-
Seamlessly Bring Procore Data into Retool Using CData Connect AI
Integrate Procore data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Rapidly Develop SharePoint-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SharePoint.
-
Connecting Mastra with Odoo 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 Odoo ERP, no replication required.
-
Build an OLAP Cube in SSAS from ConstantContact Data
Establish a connection to ConstantContact data from SQL Server Analysis Services, and use the ConstantContact Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Query Live Cvent Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Cvent data in natural language using Python.
-
Integrating Claude Code CLI with JotForm 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.
-
Publish Crystal Reports on Avalara AvaTax Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Avalara AvaTax.
-
Automated Continuous Bitbucket Replication to Oracle
Use CData Sync for automated, continuous, customizable Bitbucket replication to Oracle.
-
Analyze Elasticsearch Data in Cognos Analytics
Use CData Connect AI to connect to Elasticsearch Data from Cognos Analytics and analyze live Elasticsearch.
-
Excel Spreadsheet Automation on Certinia Data with the QUERY Formula
Pull data from Certinia, automate spreadsheets, and more with the QUERY formula.
-
Create Reports with Jodoo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jodoo.
-
Consume SAP ByDesign OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Business ByDesign as OData feeds from PowerBuilder using the API Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Active Directory
Provide connectivity to Active Directory through an SAP BusinessObjects universe.
-
Use Biml to Build SSIS Tasks to Replicate ScrapingBee Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ScrapingBee to SQL Server.
-
Visualize Live Office 365 Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Office 365 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze NetSuite Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of NetSuite CRM & ERP and visualize live NetSuite CRM & ERP in Infragistics Reveal.
-
How to Connect to Live Oracle Eloqua Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Oracle Eloqua for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Sybase IQ
Create an ODBC connection to Sybase IQ in Informatica and browse and transfer Sybase IQ.
-
Connect to Stack Exchange Data in CloverDX (formerly CloverETL)
Transfer Stack Exchange using the visual workflow in the CloverDX data integration tool.
-
How to connect to Excel Online Data with Squirrel SQL client
Connect to Microsoft Excel Online and execute queries in the Squirrel SQL Client.
-
Build Google Search-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Search and build Google Search-connected web apps with Axios.
-
Configure the CData JDBC Driver for ShipStation in a Connection Pool in Tomcat
Connect to ShipStation from a connection pool in Tomcat.
-
Create Azure Synapse-Connected Nintex Workflows
Use CData Connect AI to connect to Azure Synapse Data from Nintex Workflow Cloud and build custom workflows using live Azure Synapse.
-
Visualize Databricks Data in Sisense
Create an ElastiCube in Sisense app with access to Databricks.
-
Integrating Dataiku with SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP SuccessFactors LMS.
-
Create Dashboards and Visualize Live Sage 200 Data in Geckoboard
Use CData Connect AI to connect to live Sage 200 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect RSS Feeds to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your RSS Feeds using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect TigerGraph to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect TigerGraph with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SAS xpt Data from AWS Glue
Use CData Connect AI to gain access to live SAS XPORT from your AWS Glue jobs.
-
Connect to Epicor Kinetic Data in Aqua Data Studio
Access Epicor Kinetic from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect PolyBase to Accelo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Accelo.
-
Publish Crystal Reports on Omnisend Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Omnisend.
-
How to work with CampaignMonitor Data in Apache Spark using SQL
Access and process CampaignMonitor Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Dataiku with Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Neo4J.
-
Create Dynamic Onfleet Grids Using the Infragistics XamDataGrid
Learn how you can connect Onfleet to Infragistics XamDataGrid to build dynamic grids.
-
Connect to DB2 Data in DBArtisan
Use wizards in DBArtisan to configure IBM DB2 as a data source.
-
Integrating Dataiku with MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MariaDB.
-
Use the CData API Server to Access Salesforce Data 360 Data in Microsoft PowerPivot
Use the CData API Server to connect to live Salesforce Data 360 in the Power Pivot business intelligence tool.
-
Integrating Cursor CLI with Missive 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 Adobe Target Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Adobe Target replication to AlloyDB.
-
Integrating Boomi Agentstudio with SharePoint Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft SharePoint, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Qualaroo Data in the Pentaho Report Designer
Publish reports based on Qualaroo in the Pentaho BI tool.
-
Connect to JSON Services from PowerBuilder via ADO.NET
This article demonstrates how to access JSON from Appeon PowerBuilder using the CData ADO.NET Provider for JSON.
-
Use Dash to Build to Web Apps on SAP Fieldglass Data
Create Python applications that use pandas and Dash to build SAP Fieldglass-connected web apps.
-
Connect to and Query MailChimp Data in QlikView over ODBC
Create data visualizations with MailChimp in QlikView.
-
Visualize Wrike Data in Sisense
Create an ElastiCube in Sisense app with access to Wrike.
-
Integrating LangGraph with EnterpriseDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on EnterpriseDB within automated workflows.
-
Automated Continuous Microsoft Entra ID Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Databricks.
-
Build NASA-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live NASA.
-
Automated Continuous PayPal Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PayPal replication to PostgreSQL.
-
Integrate Mailgun Data in the Pentaho Report Designer
Publish reports based on Mailgun in the Pentaho BI tool.
-
Connect to OneNote Data from a Connection Pool in Jetty
The OneNote JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft OneNote from Web apps in Jetty.
-
How to publish and share Intercom Data dashboards with Tableau Server
The CData ODBC driver for Intercom enables you integrate Intercom into Tableau dashboards.
-
Create Short.io Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Short.io from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to EnterpriseDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access EnterpriseDB from Appeon PowerBuilder using the CData ADO.NET Provider for EnterpriseDB.
-
Configure the CData JDBC Driver for Landbot in a Connection Pool in Tomcat
Connect to Landbot from a connection pool in Tomcat.
-
Use Grok to Talk to Your Paylocity 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 Paylocity for you.
-
Model, Search, and Visualize Live Microsoft Ads Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Ads for modeling, searching, and visualizing.
-
How to Query Clari Data in MySQL Workbench
Execute MySQL queries against live Clari from MySQL Workbench.
-
Build AI/ML Models with Live Planio Data using Dataiku
Connect Planio Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Hive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Hive from Informatica Cloud.
-
Access Live Sybase IQ Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sybase IQ from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query Outlook Data in ColdFusion
Write standard ColdFusion data access code to connect to Outlook.
-
Query, Visualize, and Share live Smartsheet Data in Redash
Use CData Connect AI to connect to live Smartsheet in Redash for querying, visualizing, and sharing.
-
Extend Google Sheets with MariaDB Data
Make calls to MariaDB from Google Apps Script via the API Server.
-
How to work with SAP HANA Data in Apache Spark using SQL
Access and process SAP HANA Data in Apache Spark using the CData Software JDBC Driver.
-
Add Gumroad Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Gumroad with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Visualize MariaDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live MariaDB in Python.
-
Seamlessly Bring Cvent Data into Retool Using CData Connect AI
Integrate Cvent data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
ETL GitLab in Oracle Data Integrator
This article shows how to transfer GitLab into a data warehouse using Oracle Data Integrator.
-
Visualize Pipeline CRM Data in Tableau
The CData ODBC driver for Pipeline CRM enables you integrate Pipeline CRM into Tableau dashboards.
-
Perform Batch Operations with SuiteCRM Data in Apache NiFi
Connect to SuiteCRM and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Freshdesk Data in TIBCO Spotfire through OData
Integrate Freshdesk into dashboards in TIBCO Spotfire.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Basecamp within intelligent workflows.
-
Integrate Live CloudConvert Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CloudConvert to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Publish Crystal Reports on ConstantContact Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ConstantContact.
-
Build Redis-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Redis to explore live Redis Data in Cursor to assist with building Redis-powered applications.
-
Automated Continuous MarkLogic Replication to Oracle
Use CData Sync for automated, continuous, customizable MarkLogic replication to Oracle.
-
Automated Continuous Amazon Athena Replication to MySQL
Use CData Sync for automated, continuous, customizable Amazon Athena replication to MySQL.
-
How to Work with Adobe Target Data in AWS Glue Jobs Using JDBC
Connect to Adobe Target from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for NASA in MicroStrategy Desktop
Connect to NASA in MicroStrategy Desktop using the CData Software ODBC Driver for NASA.
-
Use Manus AI to Talk to Your FreshBooks 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 FreshBooks.
-
Access Snowflake Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Snowflake from HeidiSQL.
-
Connect to Parquet Data in JRuby
Create a simple JRuby app with access to live Apache Parquet.
-
Extract, Transform, and Load Office 365 Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Office 365 in Informatica PowerCenter.
-
Connecting Pipedream with Xero Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Xero data in real time.
-
Visualize Live Azure Data Catalog Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Data Catalog.
-
Query ActiveCampaign Data in DataGrip
Create a Data Source for ActiveCampaign in DataGrip and use SQL to query live ActiveCampaign.
-
LINQ to SuiteCRM 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 SuiteCRM Data Provider.
-
How to publish and share Accelo Data dashboards with Tableau Server
The CData ODBC driver for Accelo enables you integrate Accelo into Tableau dashboards.
-
Replicate Multiple Oracle Financials Cloud Accounts
Replicate multiple Oracle Financials Cloud accounts to one or many databases.
-
Access Live Salesforce Marketing Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Marketing Cloud from your Google Sheets.
-
Create Dynamic Quaderno Grids Using the Infragistics XamDataGrid
Learn how you can connect Quaderno to Infragistics XamDataGrid to build dynamic grids.
-
Connect to SurveyMonkey Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SurveyMonkey Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.