CData Software - Knowledge Base
Recent Articles
-
Analyze HDFS Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache HDFS in Microsoft R Open.
-
How to integrate Oracle SCM with Apache Airflow
Access and process Oracle SCM in Apache Airflow using the CData JDBC Driver.
-
DataBind Controls to Campaigner Data in Delphi
DataBind to Campaigner in Delphi with standard data access components and controls.
-
How to integrate Azure Analysis Services with Apache Airflow
Access and process Azure Analysis Services in Apache Airflow using the CData JDBC Driver.
-
How to Build an ETL App for Splunk Data in Python with CData
Create ETL applications and real-time data pipelines for Splunk in Python with petl.
-
Integrating Cursor CLI with QuickBooks 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 Bitly-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Bitly Data in GitHub Copilot to assist with building Bitly-powered applications.
-
Publish Guru-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Guru.
-
Integrating Kiro CLI with Coinbase 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.
-
Connect to Google Calendar Data in NetBeans
Connect to Google Calendar in NetBeans with the data source configuration wizard.
-
Automated Continuous MYOB AccountRight Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Google BigQuery.
-
Model Zoom Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoom, enabling the direct import of real-time Zoom.
-
Visualize Live Dynamics 365 Business Central Data in the Power BI Service
Use CData Connect AI to connect to live Dynamics 365 Business Central and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with Live Twilio Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Twilio from the MuleSoft Anypoint Platform to integrate live Twilio into custom reports and dashboards.
-
Use JayDeBeApi to access Superchat Data in Python
Use standard Python scripting and the development environment of your choice to access live Superchat.
-
Connect to SAP Business One Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Business One in Google Apps Script.
-
Connect Rootly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Rootly using the CData Python MCP Server.
-
Create Informatica Mappings From/To an ODBC Data Source for ZarMoney
Create an ODBC connection to ZarMoney in Informatica and browse and transfer ZarMoney.
-
Automate Marketo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Marketo replication to Azure Data Lake.
-
Feed Paymo Data into FineReport
How to set Paymo as a JDBC data source in FineReport.
-
Natively Connect to Google Directory Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Directory. Leverage the native support for ODBC in PHP.
-
Visualize xBase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to xBase.
-
Connect and Query Live Azure Data Lake Storage Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage into Databricks
-
Connect to Google Directory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Directory, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Samanage Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Samanage using standard SQL.
-
Build Dashboards with Codat Data in Dundas BI
Create dynamic dashboards and perform analytics based on Codat in Dundas BI.
-
Use Dash to Build to Web Apps on Teamwork Data
Create Python applications that use pandas and Dash to build Teamwork-connected web apps.
-
Natively Connect to Foursquare Data in PHP
The CData ODBC driver for Foursquare enables you to create PHP applications with connectivity to Foursquare. Leverage the native support for ODBC in PHP.
-
Provide OData Services of ConvertAPI Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ConvertAPI by developing a WCF Service Application.
-
How to Connect DBeaver to Adobe Commerce via a JDBC Driver
Manage Adobe Commerce with visual tools in DBeaver like the query browser.
-
How to Visualize ConvertKit Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConvertKit in Python.
-
Connect to Slack Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Slack in the Denodo Virtual DataPort Administrator.
-
Connect to Perigon Data in Jaspersoft Studio
Execute SQL to remote Perigon in Jaspersoft Studio.
-
Automated Continuous Delighted Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Delighted replication to Amazon S3.
-
Getting Started with the CData Python Connector for Deel
Learn to install and license the CData Python Connector
-
How to Connect to Live NetSuite 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 NetSuite CRM & ERP for you.
-
Connect to Live Sage Intacct Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage Intacct in CData Connect AI and connect to your Sage Intacct from PostgreSQL.
-
Automated Continuous SAP ByDesign Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Oracle.
-
Analyze Greenhouse Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Greenhouse and visualize live Greenhouse in Infragistics Reveal.
-
How to Create Power BI Visual Reports with Real-Time SAP HANA XS Advanced Data
Use CData Power BI Connectors to visualize SAP HANA XS Advanced in Power BI.
-
Analyze Customer.io Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Customer.io and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Eventbrite Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Eventbrite from your Oracle system.
-
Automate Redis Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Redis from PowerShell? This article demonstrates how to utilize the Redis Cmdlets for tasks like connecting to Redis, automating operations, downloading data, and more.
-
Import Real-Time OpenWeatherMap Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use OpenWeatherMap in ColdFusion.
-
Automated Continuous CapsuleCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Databricks.
-
Connect to Outlook Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Outlook in the Denodo Virtual DataPort Administrator.
-
Analyze eBay Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for eBay Analytics from Power Pivot. You will use the Table Import Wizard to load eBay Analytics. You can visually build the import query or use any SQL supported by the driver.
-
Build Apps with Live Twilio in Adalo using CData Connect AI
Use CData Connect AI to integrate live Twilio into the Adalo platform and build custom mobile and web applications with real-time Twilio.
-
Visualize Vault CRM Data in TIBCO Spotfire through OData
Integrate Veeva Vault & Vault CRM into dashboards in TIBCO Spotfire.
-
Consume Optimizely OData Feeds in PowerBuilder
This article demonstrates how to consume Optimizely as OData feeds from PowerBuilder using the API Server.
-
How to Access Keap Data Using Entity Framework
This article shows how to access Keap using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Boomi Agentstudio with Procore Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Procore, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData ADO.NET Provider for Bitbucket
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Bitbucket.
-
Build MailChimp Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MailChimp and build visualizations in Tableau.
-
DataBind Hugging Face Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Hugging Face to a chart.
-
Connect to Amazon Marketplace Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon Marketplace in FileMaker Pro to connect to Amazon Marketplace and work with Amazon Marketplace in your FileMaker applications.
-
How to connect to Apify Data from IntelliJ
Integrate connectivity to Apify with wizards in IntelliJ.
-
Build SAP Business One Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Business One and build visualizations in Tableau Cloud.
-
How to Work with FHIR Data in ETL Validator JDBC
Connect to FHIR from ETL Validator jobs using the CData Software JDBC Driver.
-
How to load TigerGraph data into Elasticsearch via Logstash
Introducing a simple method to load TigerGraph data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query WooCommerce Data from Node.js
Use the OData endpoint of the CData API Server to connect to your WooCommerce and perform CRUD operations on WooCommerce from Node.js.
-
Connect to Zuora Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Zuora.
-
Perform Batch Operations with ADP Data in Apache NiFi
Connect to ADP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to load Outreach.io data into Elasticsearch via Logstash
Introducing a simple method to load Outreach.io data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pushbullet
Provide connectivity to Pushbullet through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for IBM Informix in MicroStrategy
Connect to IBM Informix in MicroStrategy Developer using the CData Software ODBC Driver for IBM Informix.
-
How to work with Act-On Data in Apache Spark using SQL
Access and process Act-On Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Live Exa Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Exa to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
ETL Odoo in Oracle Data Integrator
This article shows how to transfer Odoo ERP into a data warehouse using Oracle Data Integrator.
-
Operational Reporting on Egnyte Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Egnyte.
-
Automated Continuous PabblySubscriptions Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Google BigQuery.
-
Connect to Sage Intacct from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sage Intacct, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Publish Reports with Brex Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Brex.
-
Access Live Dropbox Data in TIBCO Data Virtualization
Use the Dropbox Tibco DV Adapter to create a Dropbox data source in TIBCO Data Virtualization Studio and gain access to live Dropbox from your TDV Server.
-
Add Wistia Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Wistia with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous SAP Fieldglass Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Google BigQuery.
-
How to create ADP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ADP in MySQL .
-
How to Create Power BI Visual Reports with Real-Time Sage 200 Data
Use CData Power BI Connectors to visualize Sage 200 in Power BI.
-
Choosing the Best Method to Connect ZohoPeople to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoPeople from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to update Google Contacts from Excel
This article explains how to transfer data from Excel to Google Contacts using the Excel Add-In for Google Contacts.
-
Import Parallel Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Parallel. In this article, you will use the OData format to import Parallel into Microsoft Power Query.
-
Use the CData Software ODBC Driver for SAP Ariba Procurement in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Ariba Procurement in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Build Dashboards with Teradata Data in Dundas BI
Create dynamic dashboards and perform analytics based on Teradata in Dundas BI.
-
Build AI/ML Models with Live ZohoDesk Data using Dataiku
Connect ZohoDesk Data with Dataiku using the CData API Driver for JDBC.
-
Elasticsearch Reporting in OBIEE with the Elasticsearch JDBC Driver
Deploy the Elasticsearch JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Vercel
Provide connectivity to Vercel through an SAP BusinessObjects universe.
-
How to connect to Billsby Data in DBVisualizer
Integrate Billsby with visual data analysis tools and data connection wizards in DBVisualizer
-
Explore Geographical Relationships in Zendesk Data with Power Map
Create data visualizations with Zendesk in Power Map.
-
Process & Analyze Amazon S3 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Amazon S3 Data.
-
Building Dynamic Web Pages with Auth0 Data Using AngularJS
Create single-page applications with live connectivity to Auth0 using the CData API Server.
-
Automated Continuous Adobe Commerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to AlloyDB.
-
Access Live Accelo Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Accelo data source in TIBCO Data Virtualization Studio and gain access to live Accelo from your TDV Server.
-
LINQ to Dynamics CRM 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 Dynamics CRM Data Provider.
-
Replicate GetResponse Data in Heroku for Use in Salesforce Connect
Replicate GetResponse to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Create Power BI Visual Reports with Real-Time Elorus Data
Use CData Power BI Connectors to visualize Elorus in Power BI.
-
Integrating Cursor CLI with Exa 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.
-
Connect to GraphQL in SpagoBI
Create reports featuring live GraphQL in SpagoBI Studio. Host GraphQL reports on SpagoBI Server.
-
Visualize Azure Synapse 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 Azure Synapse into TIBCO Spotfire.
-
Integrate FormSite Data in the Pentaho Report Designer
Publish reports based on FormSite in the Pentaho BI tool.
-
Use the CData ODBC Driver for Copper from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Copper to connect to Copper from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Copper in Excel.