CData Software - Knowledge Base
Recent Articles
-
Process & Analyze PayPal Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PayPal Data.
-
Analyze JSON Services in Cognos Analytics
Use CData Connect AI to connect to JSON Services from Cognos Analytics and analyze live JSON.
-
How to Work with Omnisend Data in AWS Glue Jobs Using JDBC
Connect to Omnisend from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Google Sheets Data from a Connection Pool in Jetty
The Google Sheets JDBC Driver supports connection pooling: This article shows how to connect faster to Google Sheets from Web apps in Jetty.
-
How to Connect to Live Salesforce Pardot 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 Salesforce Pardot for you.
-
Create SSAS Tabular Models from Gorgias Data
How to build a SQL Server Analysis Service Tabular Model from Gorgias using CData drivers.
-
Automated Continuous Avalara AvaTax Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to PostgreSQL.
-
How to Connect to Live Bullhorn CRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Bullhorn CRM securely in real time.
-
Build a PostgreSQL Interface for Jumpseller Data using the CData JDBC Driver
Use the Remoting features of the Jumpseller JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build an OLAP Cube in SSAS from Microsoft Ads Data
Establish a connection to Microsoft Ads data from SQL Server Analysis Services, and use the Microsoft Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live Samanage Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Samanage using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Data Visualizations Based On Salesforce CRM Analytics Data in Mode
Use CData Connect AI to connect to Salesforce CRM Analytics Data from Mode and build visualizations using live
-
Analyze PolarTeamPro Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PolarTeamPro in Microsoft R Open.
-
Connect to Sage 200 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sage 200 to connect to Sage 200 from Web applications running on WebLogic.
-
Connect to SAP Netweaver Gateway from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Netweaver Gateway, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import and Visualize Authorize.Net Data in Power View
Create data visualizations based on Authorize.Net in Excel.
-
Create Dynamic Anaplan Grids Using the Infragistics XamDataGrid
Learn how you can connect Anaplan to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Cosmos DB Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cosmos DB replication to SQL Server.
-
Create Raisers Edge NXT-Connected Nintex Workflows
Use CData Connect AI to connect to Raisers Edge NXT Data from Nintex Workflow Cloud and build custom workflows using live Raisers Edge NXT.
-
Connect to SAP ByDesign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Business ByDesign, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Publish Reports with Exa Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Exa.
-
Bind Live Facebook Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Facebook data
-
Connect to Freshteam Data in DBArtisan
Use wizards in DBArtisan to configure Freshteam as a data source.
-
Configure the CData JDBC Driver for Twitter Ads in a Connection Pool in Tomcat
Connect to Twitter Ads from a connection pool in Tomcat.
-
Integrating Claude Code CLI with XML 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.
-
View Reports on Real-Time Rootly Data in Power BI Report Server
Use the CData ODBC Driver for Rootly to visualize Rootly in Power BI Desktop and then publish them to Power BI Report Server.
-
Use JayDeBeApi to access Insightly Data in Python
Use standard Python scripting and the development environment of your choice to access live Insightly.
-
Automate Tasks in Power Automate Using the CData API Server
Automate MailChimp actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
DataBind Sybase IQ Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Sybase IQ with the DevExpress Windows Forms and Web controls to provide Sybase IQ to a chart.
-
Manage Tanda Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Tanda.
-
Access Live Google Search Results in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Search from your Google Sheets.
-
Create Impala-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Impala Data from Klipfolio and build custom visualizations using live Apache Impala.
-
Build Amazon Marketplace-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Amazon Marketplace to explore live Amazon Marketplace Data in GitHub Copilot to assist with building Amazon Marketplace-powered applications.
-
Connect to Cloudflare Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Cloudflare using standard SQL.
-
How to publish and share Billsby Data dashboards with Tableau Server
The CData ODBC driver for Billsby enables you integrate Billsby into Tableau dashboards.
-
Integrating Codex CLI with Google Search 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 Automated Workflows with Live Amazon Marketplace Data in Workato
Use CData Connect AI to connect to live Amazon Marketplace and build automated workflows in Workato.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Adobe Analytics using the Model Context Protocol.
-
Connect to Accelo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Accelo and the SQL Gateway to access Accelo from Google Apps Script.
-
Establish a Live Connection with Printify Data using Tableau Bridge
The CData ODBC Driver for Printify enables you to integrate live Printify into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Bullhorn CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Bullhorn CRM data access from reports, embedded analytics, and more.
-
Connect to Oracle SCM Data in DBArtisan
Use wizards in DBArtisan to configure Oracle SCM as a data source.
-
Connect to Testmonitor from Asprova with CData Software ODBC Driver for Testmonitor
This article shows how to connect faster to Testmonitor data from Asprova.
-
Integrate Spotify with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Spotify with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Spotify.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zendesk within intelligent workflows.
-
Create Power BI Reports on Real-Time Oracle Service Cloud Data
Use the CData ODBC Driver for Oracle Service Cloud to visualize Oracle Service Cloud in Power BI Desktop.
-
How to Connect DBeaver to SuiteCRM via a JDBC Driver
Manage SuiteCRM with visual tools in DBeaver like the query browser.
-
SAP Business One Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Business One facts in real time.
-
How to create Visio diagrams from BigQuery Data
Automatically update Google BigQuery with the changes you make to Visio master shapes.
-
Use Manus AI to Talk to Your DocuSign 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 DocuSign.
-
Natively Connect to Anaplan Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Anaplan. Leverage the native support for ODBC in PHP.
-
How to Connect to Live DB2 Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live IBM DB2 without replication.
-
Connect to Instagram Data from PowerBuilder via JDBC
This article demonstrates how to access Instagram from PowerBuilder using the Instagram JDBC Driver.
-
Connect to Deel Data in DBeaver
Use the CData ODBC Driver to connect to Deel in DBeaver.
-
Connect ChargeOver Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ChargeOver using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Operational Reporting on Optimizely Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Optimizely.
-
How to Seamlessly Import Presto Data into IBM SPSS Modeler
Integrate Presto data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
View Reports on Real-Time Dotmailer Data in Power BI Report Server
Use the CData ODBC Driver for Dotmailer to visualize Dotmailer in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Datasets from Rebilly in Domo Workbench and Build Visualizations of Rebilly Data in Domo
Use the CData Software ODBC Driver for Rebilly to create datasets from Rebilly in Domo Workbench and then build visualizations in the Domo service.
-
Query Stripe Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Stripe and perform CRUD operations on Stripe from Node.js.
-
Connect to SharePoint Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft SharePoint as a data source.
-
Use the CData Software ODBC Driver for MailerLite in SAS for Real-Time Reporting and Analytics
Connect to real-time MailerLite in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MailerLite.
-
Access Live Google Directory Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Directory from your Google Sheets.
-
Use the CData API Server to Access Oracle SCM Data in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle SCM in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Guru in MicroStrategy Web
Connect to Guru in MicroStrategy Web using the CData Software ODBC Driver for Guru.
-
Dropbox Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dropbox facts in real time.
-
Back Up Apache Phoenix to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Phoenix. In this article, we will employ an SSIS workflow to populate a database with Apache Phoenix data.
-
Connect to Anaplan Data in RapidMiner
Integrate Anaplan with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Live Phoenix 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 Apache Phoenix for you.
-
Automated Continuous Flowlu Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Flowlu replication to Azure SQL Database.
-
Use Dash to Build to Web Apps on CampaignMonitor Data
Create Python applications that use pandas and Dash to build CampaignMonitor-connected web apps.
-
Access Live LinkedIn Ads Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live LinkedIn Ads data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to connect to Phoenix Data in DBVisualizer
Integrate Apache Phoenix with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Dynamic Google Tasks Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Tasks to Infragistics XamDataGrid to build dynamic grids.
-
Provide OData Services of Insightly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Insightly by developing a WCF Service Application.
-
Automated Continuous Autopilot Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Autopilot replication to delimited files (CSV/TSV).
-
Provide OData Services of Blackbaud FE NXT Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Blackbaud FE NXT by developing a WCF Service Application.
-
Working with Retently Data in LINQPad
Execute LINQ queries to Retently in LINQPad.
-
Getting Started with the CData Power BI Connector for ShipStation
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for ShipStation.
-
Integrate Live Apollo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Apollo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apollo.
-
Create Data Visualizations in Cognos BI with PingOne Data
Access PingOne as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect and process REST from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live REST.
-
How to use SQLAlchemy ORM to access Salesforce Pardot Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce Pardot.
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Data Lake Storage in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Use the CData API Server to Access RSS Feeds in Microsoft PowerPivot
Use the CData API Server to connect to live RSS Feeds in the Power Pivot business intelligence tool.
-
Automate Rebilly Data Replication to Azure Data Lake
Use CData Sync to customize and automate Rebilly replication to Azure Data Lake.
-
Connect to Impala Data from AWS Glue
Use CData Connect AI to gain access to live Apache Impala from your AWS Glue jobs.
-
Natively Connect to AlloyDB Data in PHP
The CData ODBC driver for AlloyDB enables you to create PHP applications with connectivity to Google AlloyDB. Leverage the native support for ODBC in PHP.
-
Build an OLAP Cube in SSAS from Brex Data
Establish a connection to Brex data from SQL Server Analysis Services, and use the Brex Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import Real-Time Twitter Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Twitter Ads in ColdFusion.
-
How to Access Live Reply.io Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Reply.io enables you to integrate Reply.io into workflows built using Microsoft Power Automate Desktop.
-
How to Work with Testmonitor Data in AWS Glue Jobs Using JDBC
Connect to Testmonitor from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate XML Data Replication to SAP HANA
Use CData Sync to customize and automate XML Files replication to SAP HANA.
-
Use the CData Software ODBC Driver for JSON in MicroStrategy Desktop
Connect to JSON in MicroStrategy Desktop using the CData Software ODBC Driver for JSON.
-
DataBind Controls to Aweber Data in C++Builder
DataBind to Aweber in C++Builder with standard components and controls.
-
Getting Started with the CData Connect AI Python SDK for Google Directory
Install the CData Connect AI Python SDK to read and write live Google Directory with standard DB-API 2.0 Python code.
-
Build Azure Table-Connected Apps in Choreo
Use CData Connect AI to connect to Azure Table Data from Choreo and build custom apps using live Azure Table Storage.
-
How to use SQLAlchemy ORM to access LeadDesk Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LeadDesk.
-
Publish Google Cloud Storage-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Cloud Storage.
-
How to create Visio diagrams from WordPress Data
Automatically update WordPress with the changes you make to Visio master shapes.