CData Software - Knowledge Base
Recent Articles
-
How to Query Live LinkedIn Ads Data in Perplexity MacOS Desktop
Connect to and query live LinkedIn Ads Data in Perplexity Desktop using CData MCP Server.
-
Publish Suadeo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Suadeo.
-
How to Seamlessly Import SurveyMonkey Data into IBM SPSS Modeler
Integrate SurveyMonkey data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Cline with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Ads from within your IDE.
-
Build Semantic Layer Views for Jira Data in APOS Live Data Gateway
Use the CData Connector for Jira in APOS Live Data Gateway to build Semantic Layer Views for Atlassian Jira.
-
Integrating Claude Code with Presto Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Presto within assisted coding and automated development workflows.
-
Integrate Theia IDE with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Publish Crystal Reports on Zoho Creator Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Creator.
-
How to Build an ETL App for Drip Data in Python with CData
Create ETL applications and real-time data pipelines for Drip in Python with petl.
-
Connect to and Query Shippo Data in QlikView over ODBC
Create data visualizations with Shippo in QlikView.
-
Trigger Access IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Access with standard wizards in Logic Apps.
-
Validate Hive Data with QuerySurge
Access and validate Apache Hive in QuerySurge using the CData JDBC Driver.
-
How to Query Live Zoho Inventory Data in Perplexity MacOS Desktop
Connect to and query live Zoho Inventory Data in Perplexity Desktop using CData MCP Server.
-
Work with Auth0 Data in FoxPro
Load Auth0 into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize CSV Data in Sisense
Create an ElastiCube in Sisense app with access to CSV/TSV Files.
-
Build SageHR-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SageHR.
-
Build an OLAP Cube in SSAS from MarkLogic Data
Establish a connection to MarkLogic data from SQL Server Analysis Services, and use the MarkLogic Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous SharePoint Excel Services Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Amazon Redshift.
-
Connect to Adobe Commerce Data in Google Apps Script via Connect AI
Use CData Connect AI to access Adobe Commerce in Google Apps Script.
-
Access Landbot 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 Landbot.
-
Create Informatica Mappings From/To an ODBC Data Source for CSV
Create an ODBC connection to CSV in Informatica and browse and transfer CSV/TSV Files.
-
Connect to Discord Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Discord using standard SQL.
-
Manage Teradata Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Teradata.
-
How to Connect the Power BI Service to ChargeOver: Complete Guide
Connect to the CData Software Power BI Connector for ChargeOver from PowerBI.com to provide real-time ChargeOver across the organization.
-
Connect to Superchat Data from PowerBuilder via ADO.NET
This article demonstrates how to access Superchat from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect ShipEngine to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ShipEngine using the CData Python MCP Server.
-
Use the CData Software JDBC Driver for FTP in MicroStrategy
Connect to FTP Servers in MicroStrategy Developer using the CData Software JDBC Driver for FTP.
-
Automated Continuous FreshBooks Replication to Amazon S3
Use CData Sync for automated, continuous, customizable FreshBooks replication to Amazon S3.
-
Connecting Mastra with Oracle Sales 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 Oracle Sales, no replication required.
-
Use JayDeBeApi to access Salesforce CRM Analytics Data in Python
Use standard Python scripting and the development environment of your choice to access live Salesforce CRM Analytics.
-
Getting Started with the CData JDBC Driver for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for OnePageCrm.
-
Build NetSuite-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to NetSuite Data from Zoho Analytics and import live NetSuite CRM & ERP.
-
Viewing GitLab Data in RAD Studio Data Explorer
How to view GitLab in RAD Studio Data Explorer using the CData ODBC Driver for GitLab.
-
Getting Started with the CData ODBC Driver for FreeAgent
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FreeAgent.
-
How to Use a Microsoft Access Database to Update Kintone Data in Real Time
Update Kintone data by creating a linked table in Microsoft Access with the CData Kintone ODBC Driver.
-
Getting Started with the CData SSIS Components for Testmonitor
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Testmonitor.
-
Build MVC Applications with Connectivity to Testmonitor Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Testmonitor from an ASP.NET MVC application.
-
Getting Started with the CData Excel Add-In for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft OneDrive.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live LinkedIn Ads within intelligent workflows.
-
Connect to MailerLite Data in CloverDX (formerly CloverETL)
Transfer MailerLite using the visual workflow in the CloverDX data integration tool.
-
Integrate with MongoDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MongoDB to a JSON file on disk.
-
Analyze Google Campaign Manager 360 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Campaign Manager 360 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Replicate Data from Multiple Local Files Using CData Sync
Use CData Sync to replicate multiple local files to a data warehouse
-
Visualize Todoist Data in Sisense
Create an ElastiCube in Sisense app with access to Todoist.
-
Connect to Real-Time Amazon Marketplace Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Amazon Marketplace and Dataflow to import and use Amazon Marketplace in Power Apps.
-
Build Impala-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Impala.
-
Use Dash to Build to Web Apps on Spotify Data
Create Python applications that use pandas and Dash to build Spotify-connected web apps.
-
Integrating LlamaIndex with Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Apache Phoenix in real time.
-
Establish a Live Connection with Workable Data using Tableau Bridge
The CData ODBC Driver for Workable enables you to integrate live Workable into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated YouTube Analytics Data Replication to Teradata
Use CData Sync to Customize and automate YouTube Analytics replication to Teradata.
-
Connect to Outlook in SpagoBI
Create reports featuring live Outlook in SpagoBI Studio. Host Outlook reports on SpagoBI Server.
-
Build MVC Applications with Connectivity to Certinia Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Certinia from an ASP.NET MVC application.
-
Build Data Flows from PingOne to SQL Server using SSIS
Easily back up PingOne to SQL Server using the SSIS components for PingOne.
-
Moving Data from Tanda to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Tanda data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to integrate Klipfolio with Apache Airflow
Access and process Klipfolio in Apache Airflow using the CData JDBC Driver.
-
Migrating data from ClickUp to Google BigQuery using CData SSIS Components.
Easily push ClickUp to Google BigQuery using the CData SSIS Tasks for ClickUp and Google BigQuery.
-
Enable the Office 365 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Office 365.
-
Back Up Delighted to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Delighted data.
-
Connect to JSON Services in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect to Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS for you.
-
Build a Singer.io Tap for Campaigner With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Campaigner data using
-
Create SSAS Tabular Models from Mailjet Data
How to build a SQL Server Analysis Service Tabular Model from Mailjet using CData drivers.
-
Build Visualizations of Amazon Marketplace Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon Marketplace in Birst.
-
Automated Continuous Keap Replication to Vertica
Use CData Sync for automated, continuous, customizable Keap replication to Vertica.
-
Use Biml to Build SSIS Tasks to Replicate Sybase IQ Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sybase IQ to SQL Server.
-
How to Use a Microsoft Access Database to Update Dynamics 365 Data in Real Time
Update Dynamics 365 data by creating a linked table in Microsoft Access with the CData Dynamics 365 ODBC Driver.
-
Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy
Connect to eBay Analytics in MicroStrategy Developer using the CData Software ODBC Driver for eBay Analytics.
-
Integrate Microsoft OneDrive Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft OneDrive Data enables you to integrate Microsoft OneDrive into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live Xero Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Connect to Live API Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your API for you.
-
Build Dashboards with AfterShip Data in DBxtra
Create dynamic dashboards and perform analytics based on AfterShip in DBxtra.
-
Create Reports from HCL Domino Data in Looker Studio
Use CData Connect AI to gain access to live HCL Domino and create custom reports in Looker Studio.
-
Connect to Salesforce Marketing from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesforce Marketing to connect to Salesforce Marketing Cloud from Web applications running on WebLogic.
-
Access Live FHIR Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live FHIR data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Codex CLI with Instantly 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 Strava Data in JRuby
Create a simple JRuby app with access to live Strava.
-
How to integrate Zuora with Apache Airflow
Access and process Zuora in Apache Airflow using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for xBase
Provide connectivity to xBase through an SAP BusinessObjects universe.
-
Building Dynamic Web Pages with Cassandra Data Using AngularJS
Create single-page applications with live connectivity to Cassandra using the CData API Server.
-
Feed Paddle Data into FineReport
How to set Paddle as a JDBC data source in FineReport.
-
Import and Visualize RabbitMQ Data in Power View
Create data visualizations based on RabbitMQ in Excel.
-
Getting Started with the CData ODBC Driver for MailerSend
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MailerSend.
-
Build Visualizations of Close Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Close in Birst.
-
Connect to Live ServiceNow Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ServiceNow in CData Connect AI and connect to your ServiceNow from PostgreSQL.
-
Getting Started with the CData Connect AI Python SDK for Azure DevOps
Install the CData Connect AI Python SDK to read and write live Azure DevOps with standard DB-API 2.0 Python code.
-
Write a Simple Go Application to work with Databricks Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Databricks.
-
Connect to YouTube Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live WooCommerce Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live WooCommerce from your Google Sheets.
-
Replicate QuickBooks Time Data from PowerShell
Write a quick PowerShell script to query QuickBooks Time. Use connectivity to the live data to replicate QuickBooks Time to SQL Server.
-
A PostgreSQL Interface for Sage Cloud Accounting Data using the CData ODBC Driver
Use the SQL Gateway and Sage Cloud Accounting ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Vault CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Veeva Vault & Vault CRM replication to Azure Synapse.
-
Connect to Pingdom Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pingdom to connect to Pingdom and execute queries in PowerBuilder.
-
Automated Continuous CockroachDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to Google Cloud SQL.
-
Visualize Live Cvent Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Cvent using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Charts with Instagram Data in Clear Analytics
Create dynamic charts and perform analytics based on Instagram in Clear Analytics.
-
View Reports on Real-Time ChartMogul Data in Power BI Report Server
Use the CData ODBC Driver for ChartMogul to visualize ChartMogul in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Act CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Act CRM replication to Databricks.
-
View Reports on Real-Time VWO Data in Power BI Report Server
Use the CData ODBC Driver for VWO to visualize VWO in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect MailChimp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MailChimp using the CData Python MCP Server.
-
Access Live Bugsnag Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bugsnag in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.