CData Software - Knowledge Base
Recent Articles
-
Integrate Cursor with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ADP data from within the editor.
-
Connect to Jumpseller Data in Jaspersoft Studio
Execute SQL to remote Jumpseller data in Jaspersoft Studio.
-
How to Connect to Live Shopify Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Shopify data for you.
-
Connect and Query Live Databricks Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Databricks data into Databricks and enable direct, live querying and analysis without replication.
-
Visualize Live Zoho Books Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoho Books data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Amazon Athena Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Amazon Athena data using standard SQL.
-
Integrate Devin with Live LinkedIn 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 LinkedIn data.
-
How to use SQLAlchemy ORM to access Elorus Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Elorus data.
-
Use Manus AI to Talk to Your XML 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 XML data.
-
How to Work with Productboard Data in AWS Glue Jobs Using JDBC
Connect to Productboard from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Seamlessly Import Placid Data into IBM SPSS Modeler
Integrate Placid data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import and Visualize FHIR Data in Power View
Create data visualizations based on FHIR data in Excel.
-
How to Connect the Power BI Service to Pinterest: Complete Guide
Connect to the CData Software Power BI Connector for Pinterest from PowerBI.com to provide real-time Pinterest data across the organization.
-
Build Dashboards with Cloudant Data in DBxtra
Create dynamic dashboards and perform analytics based on Cloudant data in DBxtra.
-
How to connect to Postmark Data from IntelliJ
Integrate connectivity to Postmark data with wizards in IntelliJ.
-
Build Apps with Live GitLab Data Using the Low-Code Development Platform of Mendix
Connect GitLab data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Connect to Live xBase 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 xBase data through natural language.
-
Connect and Visualize Live SQL Analysis Services Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SQL Analysis Services data into the Databricks platform and create visualization dashboards with real-time SQL Analysis Services data.
-
Create Informatica Mappings From/To a JDBC Data Source for Parallel
Create Parallel data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Dashboards with Accelo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Accelo data in Dundas BI.
-
How to Connect to & Open Reckon Accounts Hosted Data in Microsoft Excel
This article uses the CData ODBC driver for Reckon Accounts Hosted to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Zoho Projects Data from PowerShell
Write a quick PowerShell script to query Zoho Projects data. Use connectivity to the live data to replicate Zoho Projects data to SQL Server.
-
How to Connect DBeaver to Egnyte via a JDBC Driver
Manage Egnyte data with visual tools in DBeaver like the query browser.
-
Integrate Real-Time Access to FTP in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to FTP data in real time.
-
View Reports on Real-Time Superchat Data in Power BI Report Server
Use the CData ODBC Driver for Superchat to visualize Superchat data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating GitHub Copilot with Asana 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.
-
Getting Started with the CData JDBC Driver for Suadeo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Suadeo.
-
Build an OLAP Cube in SSAS from Instantly Data
Establish a connection to Instantly data data from SQL Server Analysis Services, and use the Instantly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect and Visualize Live Sybase IQ Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sybase IQ data into the Databricks platform and create visualization dashboards with real-time Sybase IQ data.
-
Getting Started with the CData ADO.NET Provider for CircleCI
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Easily Integrate Placid Data in Lazarus Pascal IDE
Learn how to easily integrate live Placid data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query Avro Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Avro entities in PHP by modeling them as objects.
-
Automated Continuous Redis Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Redis replication to IBM DB2.
-
Automated Continuous Odoo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Odoo replication to Amazon Redshift.
-
Integrate Live Oracle SCM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle SCM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle SCM data.
-
Integrating Claude Code CLI with PolarTeamPro 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.
-
Analyze SurveyMonkey Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SurveyMonkey data and visualize SurveyMonkey data in SAP Analytics Cloud.
-
Create Oracle HCM Cloud-Connected Business Apps in AppSheet
Connect to Oracle HCM Cloud Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle HCM Cloud data.
-
Use the CData Software ODBC Driver for Apollo in MicroStrategy Desktop
Connect to Apollo data in MicroStrategy Desktop using the CData Software ODBC Driver for Apollo.
-
Create SAP SuccessFactors-Connected Business Apps in AppSheet
Connect to SAP SuccessFactors Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP SuccessFactors data.
-
How to Visualize Vercel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Vercel data in Python.
-
Build AI/ML Models with Live Missive Data using Dataiku
Connect Missive Data with Dataiku using the CData API Driver for JDBC.
-
Visualize ZohoSubscriptions Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ZohoSubscriptions data into TIBCO Spotfire.
-
LINQ to REST 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 REST Data Provider.
-
Build Visualizations of Phoenix Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Phoenix data in Birst.
-
Add Accelo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Accelo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to SuiteCRM Data from PowerBuilder via JDBC
This article demonstrates how to access SuiteCRM data from PowerBuilder using the SuiteCRM JDBC Driver.
-
Create Cvent-Connected Business Apps in AppSheet
Connect to Cvent Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Cvent data.
-
Validate NASA Data with QuerySurge
Access and validate NASA data in QuerySurge using the CData JDBC Driver.
-
Excel Spreadsheet Automation on Authorize.Net Data with the QUERY Formula
Pull data from Authorize.Net, automate spreadsheets, and more with the QUERY formula.
-
Connect to Adobe Analytics Data in NetBeans
Connect to Adobe Analytics data in NetBeans with the data source configuration wizard.
-
Integrate Devin with Live MailerLite 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 MailerLite data.
-
Use the CData ODBC Driver for Elasticsearch from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Elasticsearch to connect to Elasticsearch data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Elasticsearch data in Excel.
-
Replicate Zoho Inventory Data to Multiple Databases
Replicate Zoho Inventory data to disparate databases with a point-and-click configuration.
-
Integrating Gumloop with Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Monday.com data within automated workflows.
-
Connect to Twilio Data in DBArtisan
Use wizards in DBArtisan to configure Twilio data as a data source.
-
Displaying Data from Related Tables Using Angular with the API Server
Use the API Server and Angular to build a Web App to dynamically display related tables.
-
Visualize Live Samanage Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Samanage data.
-
Use Biml to Build SSIS Tasks to Replicate IBM Informix Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM Informix data to SQL Server.
-
Use JayDeBeApi to access Bitly Data in Python
Use standard Python scripting and the development environment of your choice to access live Bitly data.
-
Access Live Amazon S3 Data in Coginiti Pro
Connect to and query live Amazon S3 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Figshare Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Figshare data from Filemaker Pro on Mac.
-
Getting Started with the CData Connect AI Python SDK for Anaplan
Install the CData Connect AI Python SDK to read live Anaplan data with standard DB-API 2.0 Python code.
-
Create Data Visualizations in Cognos BI with CSV Data
Access CSV data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Apify Reporting in OBIEE with the Apify JDBC Driver
Deploy the Apify JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Crystal Reports on Printify Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Printify data.
-
Work with Xero Data in FoxPro
Load Xero data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Biml to Build SSIS Tasks to Replicate Clari Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Clari data to SQL Server.
-
Connect to and Visualize Live FTP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live FTP data.
-
Paymo Reporting in OBIEE with the Paymo JDBC Driver
Deploy the Paymo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect Float to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Float data using the CData Python MCP Server.
-
Access Live Nethunt Data in Coginiti Pro
Connect to and query live Nethunt data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Freshservice-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Freshservice Data and create custom apps in Mendix.
-
Connect to Gong Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Gong and work with Gong data in your FileMaker applications.
-
Access QuickBooks Online Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live QuickBooks Online data from HeidiSQL.
-
Connecting GenSpark with EnterpriseDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to EnterpriseDB data without any replication or custom integration required.
-
Using the CData Software ODBC Driver for Email in PyCharm
Connect to Email as an ODBC data source in PyCharm using the CData Software ODBC Driver for Email.
-
How to publish and share QuickBooks Data dashboards with Tableau Server
The CData ODBC driver for QuickBooks enables you integrate QuickBooks data into Tableau dashboards.
-
How to connect and process Salesforce Pardot data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Pardot data.
-
Automated Continuous ConvertAPI Replication to Databricks
Use CData Sync for automated, continuous, customizable ConvertAPI replication to Databricks.
-
A PostgreSQL Interface for MongoDB Data using the CData ODBC Driver
Use the SQL Gateway and MongoDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Bitly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bitly data into the statistical analysis tools available in SAS JMP. This article shows how to use Bitly data in the Graph Builder and Query Builder.
-
Easily Integrate Zoho Projects Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Projects data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create SSAS Tabular Models from Instantly Data
How to build a SQL Server Analysis Service Tabular Model from Instantly data using CData drivers.
-
Integrate Live Contentful Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Contentful data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automate OnePageCrm Data Replication to Azure Data Lake
Use CData Sync to customize and automate OnePageCrm data replication to Azure Data Lake.
-
Visualize Contentful Data in Tableau
The CData ODBC driver for Contentful enables you integrate Contentful data into Tableau dashboards.
-
Connect to ClickTime Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ClickTime and work with ClickTime data in your FileMaker applications.
-
Salesforce Marketing Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce Marketing facts in real time.
-
Model API Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and API, enabling the direct import of real-time API data.
-
How to Visualize ElevenLabs Data in Python with pandas
Use pandas and other modules to analyze and visualize live ElevenLabs data in Python.
-
Use the CData ODBC Driver for Moosend in Microsoft Power Query
You can use the CData Moosend ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Moosend data into Microsoft Power Query.
-
Integrating OpenCode with ZeroBounce 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.
-
Access Okta 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 Okta data.
-
Publish Tickspot-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Tickspot data.
-
Bind Live Oracle Sales Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Sales data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrating Codex with Microsoft Entra ID 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.
-
Moving Data from YouTube Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live YouTube Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Parallel 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 Parallel data.
-
Connect and Query Live Salesforce Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesforce data into Databricks and enable direct, live querying and analysis without replication.