CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Zoho Projects Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Google BigQuery.
-
Access Live Zoom Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoom from your Excel spreadsheets.
-
Migrating data from Testmonitor to Snowflake using CData SSIS Components.
Easily push Testmonitor to Snowflake using the CData SSIS Tasks for Testmonitor and Snowflake.
-
Load Microsoft Exchange Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Exchange to a database.
-
Analyze Zendesk Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zendesk and visualize Zendesk in SAP Analytics Cloud.
-
Build an OLAP Cube in SSAS from HBase Data
Establish a connection to Apache HBase data from SQL Server Analysis Services, and use the HBase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Dash to Build to Web Apps on Parallel Data
Create Python applications that use pandas and Dash to build Parallel-connected web apps.
-
Work with SharePoint Excel Services Data in FoxPro
Load SharePoint Excel Services into a FoxPro database. This article includes full code and a walk-through of the process.
-
Process & Analyze Shortcut Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Shortcut Data.
-
Integrate with Live Databricks Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Databricks from the MuleSoft Anypoint Platform to integrate live Databricks into custom reports and dashboards.
-
View Reports on Real-Time Microsoft Exchange Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Exchange to visualize Microsoft Exchange in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Gumloop with Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Workday within automated workflows.
-
Connect to Rootly Data from PowerBuilder via JDBC
This article demonstrates how to access Rootly from PowerBuilder using the Rootly JDBC Driver.
-
Build Quickbase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Quickbase and build visualizations in Tableau.
-
How to Create Power BI Visual Reports with Real-Time Figshare Data
Use CData Power BI Connectors to visualize Figshare in Power BI.
-
How to Access Live Sybase IQ Data in Visual Studio Code via Cline
Run CData MCP Server for Sybase IQ on Windows Subsytem for Linux (WSL) and connect to live Sybase IQ from the Cline extension in Visual Studio Code.
-
How to Seamlessly Import Reply.io Data into IBM SPSS Modeler
Integrate Reply.io data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live IBM Informix Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live IBM Informix to Blue Prism using the CData ODBC Driver for IBM Informix to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Samanage in MicroStrategy Web
Connect to Samanage in MicroStrategy Web using the CData Software ODBC Driver for Samanage.
-
Add SAP Hybris C4C Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Hybris C4C with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query AfterShip Data in MySQL Workbench
Execute MySQL queries against live AfterShip from MySQL Workbench.
-
Create Greenhouse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Greenhouse data access from reports, embedded analytics, and more.
-
Process & Analyze xBase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live xBase Data.
-
Build OneNote Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft OneNote and build visualizations in Tableau.
-
Integrating Gumloop with Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce Pardot within automated workflows.
-
Connect Oracle to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Database using the CData Python MCP Server.
-
Integrate with BigQuery Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google BigQuery to a JSON file on disk.
-
Connect to Salesforce Data from PowerBuilder via JDBC
This article demonstrates how to access Salesforce & Force.com from PowerBuilder using the Salesforce JDBC Driver.
-
Visualize Live MessageBird Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MessageBird using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Power BI XMLA Data as a SQL Server Database in Node.js
Execute SQL Server queries against Power BI XMLA from Node.js.
-
Automated Continuous SAP Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP ERP/NetWeaver replication to OneLake in Microsoft Fabric.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live MariaDB within intelligent workflows.
-
Use the CData Software ODBC Driver for Rootly in MicroStrategy Desktop
Connect to Rootly in MicroStrategy Desktop using the CData Software ODBC Driver for Rootly.
-
Create Dynamic PagerDuty Grids Using the Infragistics XamDataGrid
Learn how you can connect PagerDuty to Infragistics XamDataGrid to build dynamic grids.
-
Write a Simple Go Application to work with CSV Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to CSV/TSV Files.
-
Build a PostgreSQL Interface for CloudConvert Data using the CData JDBC Driver
Use the Remoting features of the CloudConvert JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect the Power BI Service to Google Spanner: Complete Guide
Connect to the CData Software Power BI Connector for Google Spanner from PowerBI.com to provide real-time Google Spanner across the organization.
-
Build Apps with Live Basecamp Data Using the Low-Code Development Platform of Mendix
Connect Basecamp with Mendix to build apps using the CData JDBC Driver for Basecamp.
-
Integrating OpenCode Terminal with Amazon DynamoDB 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 Semantic Layer Views for Parquet Data in APOS Live Data Gateway
Use the CData Connector for Parquet in APOS Live Data Gateway to build Semantic Layer Views for Apache Parquet.
-
Query, Visualize, and Share live Oracle Sales Data in Redash
Use CData Connect AI to connect to live Oracle Sales in Redash for querying, visualizing, and sharing.
-
How to connect to Datadog Data from IntelliJ
Integrate connectivity to Datadog with wizards in IntelliJ.
-
Use the CData SSIS Components to Insert New or Update Existing YouTube Analytics Records from SQL Server
Easily push SQL Server data to YouTube Analytics using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into YouTube Analytics or update existing records with data from a SQL Server database.
-
Access Live Mixpanel Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Mixpanel into the statistical analysis tools available in SAS JMP. This article shows how to use Mixpanel in the Graph Builder and Query Builder.
-
Explore Geographical Relationships in CircleCI Data with Power Map
Create data visualizations with CircleCI in Power Map.
-
Access Hugging Face Data from MySQL in PHP
Connect to Hugging Face through the standard MySQL libraries in PHP.
-
Integrating Antigravity CLI with Google Drive via CData CLI
Connect Google Drive to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Facebook Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Facebook with the CData JDBC Driver for Facebook.
-
Stream Google Tasks Data into Apache Kafka Topics
Access and stream Google Tasks in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize Omnisend Data in Python with pandas
Use pandas and other modules to analyze and visualize live Omnisend in Python.
-
How to create Visio diagrams from SAP SuccessFactors Data
Automatically update SAP SuccessFactors with the changes you make to Visio master shapes.
-
Integrate Mailgun with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mailgun with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mailgun.
-
How to Query Live Mailjet Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mailjet data in natural language using Python.
-
Access Live Adobe Commerce Data in AWS Lambda
Connect to live Adobe Commerce in AWS Lambda using the CData JDBC Driver.
-
Create Freshdesk-Connected Dashboards in Grafana
Connect to Freshdesk Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Freshdesk.
-
Build MVC Applications with Connectivity to Harvest Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Harvest from an ASP.NET MVC application.
-
Connect to Tickspot Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Tickspot in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData SSIS Components for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle Service Cloud.
-
Connect to ShipEngine Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ShipEngine to connect to ShipEngine and execute queries in PowerBuilder.
-
Publish Crystal Reports on Confluence Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Atlassian Confluence.
-
Visualize TaxJar Data in TIBCO Spotfire through ADO.NET
Integrate TaxJar into dashboards in TIBCO Spotfire.
-
Connect to Google Translate Data from a Connection Pool in Jetty
The Google Translate JDBC Driver supports connection pooling: This article shows how to connect faster to Google Translate from Web apps in Jetty.
-
Automated Continuous OneNote Replication to MySQL
Use CData Sync for automated, continuous, customizable OneNote replication to MySQL.
-
Connect to Recurly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Recurly to connect to Recurly and execute queries in PowerBuilder.
-
Automated Continuous Nethunt Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Nethunt replication to OneLake in Microsoft Fabric.
-
How to connect to LinkedIn Data from IntelliJ
Integrate connectivity to LinkedIn with wizards in IntelliJ.
-
Use Grok to Talk to Your Jira 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 Atlassian Jira for you.
-
How to use SQLAlchemy ORM to access Certinia Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Certinia.
-
Integrating LlamaIndex with Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Service Cloud in real time.
-
Automated Continuous MessageBird Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MessageBird replication to IBM DB2.
-
Replicate Multiple Microsoft Teams Accounts
Replicate multiple Microsoft Teams accounts to one or many databases.
-
Automated Continuous Omnisend Replication to SQL Server
Use CData Sync for automated, continuous, customizable Omnisend replication to SQL Server.
-
Access Live HubSpot Data in Excel 365 Online (Excel for the web)
Connect to HubSpot from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData ODBC Driver for PostgreSQL in Microsoft Power Query
You can use the CData PostgreSQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PostgreSQL into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Bannerbear in SAS for Real-Time Reporting and Analytics
Connect to real-time Bannerbear in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Bannerbear.
-
Automated Continuous ServiceNow Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ServiceNow replication to Google BigQuery.
-
Getting Started with the CData Tableau Connector for Shippo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Consume Oracle Financials Cloud OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Financials Cloud as OData feeds from PowerBuilder using the API Server.
-
Access Adobe Commerce 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 Adobe Commerce.
-
Integrate Confluence with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Confluence with External Services.
-
Analyze Live Zoho Inventory Data in SAS Viya
Use CData Connect AI to connect to Zoho Inventory from SAS Viya and deploy self-service analytics using live Zoho Inventory.
-
Integrating Codex CLI with Zoho Inventory 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.
-
Create IBM Cloud Object Storage Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time IBM Cloud Object Storage data access from reports, embedded analytics, and more.
-
Visualize ChartMogul Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ChartMogul.
-
Viewing ZendeskSell Data in RAD Studio Data Explorer
How to view ZendeskSell in RAD Studio Data Explorer using the CData ODBC Driver for ZendeskSell.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LeadDesk
Provide connectivity to LeadDesk through an SAP BusinessObjects universe.
-
Import Real-Time JotForm Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use JotForm in ColdFusion.
-
Prepare, Blend, and Analyze Aircall Data in Alteryx Designer (ODBC)
Build workflows to access live Aircall for self-service data analytics.
-
Build Google Campaign Manager 360-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Campaign Manager 360 Data and create custom apps in Mendix.
-
Use ChatGPT to Talk to Your YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your YouTube Analytics for you.
-
Use the CData ODBC Driver for Apify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Apify to connect to Apify from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apify in Excel.
-
Automated Continuous Airtable Replication to Vertica
Use CData Sync for automated, continuous, customizable Airtable replication to Vertica.
-
Use the CData Software ODBC Driver for LinkedIn in SAS for Real-Time Reporting and Analytics
Connect to real-time LinkedIn in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for LinkedIn.
-
Automated Continuous HCL Domino Replication to Databricks
Use CData Sync for automated, continuous, customizable HCL Domino replication to Databricks.
-
Use the CData ODBC Driver for ElevenLabs in Microsoft Power Query
You can use the CData ElevenLabs ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ElevenLabs into Microsoft Power Query.
-
Access xBase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live xBase from HeidiSQL.
-
How to import SQL Server Data into Apache Solr
Use the CData Software JDBC Driver for SQL Server in Data Import Handler and create an automated import of Microsoft SQL Server to Apache Solr Enterprise Search platform.
-
Integrating Boomi Agentstudio with Active Directory Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Active Directory, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
LINQ to Freshteam 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 Freshteam Data Provider.
-
How to Seamlessly Import Paymo Data into IBM SPSS Modeler
Integrate Paymo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.