CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics 365.
-
How to Easily Query Amazon DynamoDB Data in OpenOffice Base
Connect to Amazon DynamoDB data in OpenOffice Base using the CData ODBC Driver for Amazon DynamoDB and generate reports with live data insights.
-
Connecting Moonlit Workflow with Notion Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Notion data in real time.
-
Connect Microsoft Planner to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Planner data using the CData Python MCP Server.
-
Access Apify Data from MySQL in Amazon QuickSight
Connect to Apify and build visualizations of Apify data using a MySQL Connection in Amazon QuickSight.
-
Load Landbot Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Landbot data to a database.
-
Automated Continuous FHIR Replication to MongoDB
Use CData Sync for automated, continuous, customizable FHIR replication to MongoDB.
-
Extract, Transform, and Load Samanage Data in Informatica PowerCenter
Create a simple Workflow for Samanage data in Informatica PowerCenter.
-
How to Access Live Instagram Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Instagram enables you to integrate Instagram data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Certinia Accounts
Replicate multiple Certinia accounts to one or many databases.
-
Getting Started with the CData ODBC Driver for Figshare
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Figshare.
-
Access Live SAP Business One Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Business One data from your Excel spreadsheets.
-
Build a Singer.io Tap for IBM Cloud Object Storage With the CData Python Connector
Learn how to easily build a Singer.io Tap for live IBM Cloud Object Storage data using the CData Python Connector.
-
Use the CData ODBC Driver for Twitter Ads in Microsoft Power Query
You can use the CData Twitter Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Twitter Ads data into Microsoft Power Query.
-
How to Query Opsgenie Data in MySQL Workbench
Execute MySQL queries against live Opsgenie data from MySQL Workbench.
-
Connect to ShipEngine 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 ShipEngine data.
-
Consume Sybase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sybase feeds that reflect any changes in SAP Lumira.
-
Create Power BI Reports on Real-Time Google Calendar Data
Use the CData ODBC Driver for Google Calendar to visualize Google Calendar data in Power BI Desktop.
-
How to Access Live Act-On Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Act-On enables you to integrate Act-On data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live Supabase 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 Supabase data through natural language.
-
Excel Spreadsheet Automation on Workday Data with the QUERY Formula
Pull data from Workday, automate spreadsheets, and more with the QUERY formula.
-
Replicate Multiple Landbot Accounts
Replicate multiple Landbot accounts to one or many databases.
-
Visualize IBM Informix Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to IBM Informix data.
-
Use Agno to Talk to Your Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Splunk data for you.
-
Connect to Postmark Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Postmark data.
-
Create SSAS Tabular Models from Zoom Data
How to build a SQL Server Analysis Service Tabular Model from Zoom data using CData drivers.
-
Connect to SingleStore Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SingleStore Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Greenhouse-Connected Business Apps in AppSheet
Connect to Greenhouse Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Greenhouse data.
-
Automated Continuous Microsoft OneLake Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to MySQL.
-
Connect to Asana Data in DBeaver
Use the CData ODBC Driver to connect to Asana data in DBeaver.
-
Replicate Multiple Vault CRM Accounts
Replicate multiple Vault CRM accounts to one or many databases.
-
Import Microsoft Exchange Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Exchange Data from Azure Data Factory and import live Microsoft Exchange data.
-
How to create an RPA flow for eBay Data in UiPath Studio
Use the eBay ODBC Driver to create workflows that access real-time eBay data without any coding.
-
Enable the Amazon Athena JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amazon Athena data.
-
Use CData Connect AI to Access AfterShip Data in Microsoft Power Pivot
Use CData Connect AI to connect to live AfterShip data in the Power Pivot business intelligence tool.
-
Query Live Bitbucket Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Bitbucket data directly from the development environment.
-
How to connect PolyBase to SpaceX
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SpaceX data.
-
Build Dashboards with Front Data in Dundas BI
Create dynamic dashboards and perform analytics based on Front data in Dundas BI.
-
Connect to Active Directory Data from PowerBuilder via JDBC
This article demonstrates how to access Active Directory data from PowerBuilder using the Active Directory JDBC Driver.
-
Access Live SageHR Data in Coginiti Pro
Connect to and query live SageHR data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Coinbase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Coinbase facts in real time.
-
Integrate MYOB AccountRight Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MYOB AccountRight data and integrate live MYOB AccountRight data into your Power Automate tasks.
-
Integrating Claude Code CLI with Twitter Ads 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.
-
Automated Continuous Avalara AvaTax Replication to Oracle
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Oracle.
-
Integrate Cursor with Live SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SparkPost data from within the editor.
-
Connect to Real-Time Zoho Projects Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Projects and Dataflow to import and use Zoho Projects data in Power Apps.
-
Create Dashboards and Visualize Live Act-On Data in Geckoboard
Use CData Connect AI to connect to live Act-On data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect and Visualize Live Spark Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Spark data into the Databricks platform and create visualization dashboards with real-time Spark data.
-
Connect to Spotify Data in DBeaver
Use the CData ODBC Driver to connect to Spotify data in DBeaver.
-
Manage BenchmarkEmail Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BenchmarkEmail.
-
Visualize Live BambooHR Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live BambooHR data.
-
Rapidly Develop ChargeOver-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by ChargeOver.
-
Visualize Live Azure DevOps Data in the Power BI Service
Use CData Connect AI to connect to live Azure DevOps data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Marketo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Marketo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to CloudConvert Data from PowerBuilder via JDBC
This article demonstrates how to access CloudConvert data from PowerBuilder using the CloudConvert JDBC Driver.
-
How to Build an ETL App for Dropbox Data in Python with CData
Create ETL applications and real-time data pipelines for Dropbox data in Python with petl.
-
Explore Geographical Relationships in Oracle Eloqua Reporting Data with Power Map
Create data visualizations with Oracle Eloqua Reporting data in Power Map.
-
Process & Analyze Phoenix Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Phoenix Data.
-
How to integrate Humanity with Apache Airflow
Access and process Humanity data in Apache Airflow using the CData JDBC Driver.
-
How to Connect DBeaver to Google Contacts via a JDBC Driver
Manage Google Contacts data with visual tools in DBeaver like the query browser.
-
Use CData Connect AI to Access MySQL Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MySQL data in the Power Pivot business intelligence tool.
-
Connect to Helpscout Data in RapidMiner
Integrate Helpscout data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to ActiveCampaign Data in RapidMiner
Integrate ActiveCampaign data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to import Freshteam Data into Apache Solr
Use the CData Software JDBC Driver for Freshteam in Data Import Handler and create an automated import of Freshteam data to Apache Solr Enterprise Search platform.
-
Connect to Oracle HCM Cloud Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle HCM Cloud and the Script function in FileMaker Pro to connect to Oracle HCM Cloud and work with Oracle HCM Cloud data in your FileMaker application.
-
Integrating LangChain with Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Guru data within automated workflows.
-
Build Visualizations of Couchbase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Couchbase data in Birst.
-
Integrate WooCommerce Data in the Pentaho Report Designer
Publish reports based on WooCommerce data in the Pentaho BI tool.
-
Integrate LibreChat with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Planner data from within the chat interface.
-
Visualize Salesforce Data 360 Data in Tableau
The CData ODBC driver for Salesforce Data 360 enables you integrate Salesforce Data 360 data into Tableau dashboards.
-
Build Apps with Live Discord data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Discord data into the Adalo platform and build custom mobile and web applications with real-time Discord data.
-
Connect to Klaviyo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Klaviyo Data and connect to Klaviyo data in Akorbi Digital RunMyProcess.
-
How to connect to Shippo Data from Spring Boot
Connect to Shippo in a Spring Boot Application using the CData API Driver for JDBC
-
ETL Salesforce Marketing in Oracle Data Integrator
This article shows how to transfer Salesforce Marketing data into a data warehouse using Oracle Data Integrator.
-
Publish Reports with Twitter Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twitter Ads data.
-
Connect to and Visualize Live Bugsnag Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bugsnag data.
-
How to connect Amazon QuickSight to Apollo Data
Create a connection to Apollo data in CData Connect AI and insert Apollo data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Reports from Paylocity Data in Looker Studio
Use CData Connect AI to gain access to live Paylocity data and create custom reports in Looker Studio.
-
Access Slack Data from MySQL in PHP
Connect to Slack through the standard MySQL libraries in PHP.
-
How to Connect to & Open SAP Concur Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Concur to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bind Live PayPal Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live PayPal data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Using the CData Software ODBC Driver for Blackbaud FE NXT in PyCharm
Connect to Blackbaud FE NXT as an ODBC data source in PyCharm using the CData Software ODBC Driver for Blackbaud FE NXT.
-
Automated Continuous Microsoft Teams Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SQLite.
-
Visualize Postmark Data in Sisense
Create an ElastiCube in Sisense app with access to Postmark data.
-
Connect to Pingdom in SpagoBI
Create reports featuring live Pingdom data in SpagoBI Studio. Host Pingdom reports on SpagoBI Server.
-
Access Live AlloyDB Data in Coginiti Pro
Connect to and query live AlloyDB data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Migrating data from SharePoint Excel Services to Google BigQuery using CData SSIS Components.
Easily push SharePoint Excel Services data to Google BigQuery using the CData SSIS Tasks for SharePoint Excel Services and Google BigQuery.
-
Create Dashboards and Visualize Live SAP Business One Data in Geckoboard
Use CData Connect AI to connect to live SAP Business One data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Semantic Layer Views for Dynamics 365 Data in APOS Live Data Gateway
Use the CData Connector for Dynamics 365 in APOS Live Data Gateway to build Semantic Layer Views for Dynamics 365 data.
-
Use the CData Software JDBC Driver for Phoenix in MicroStrategy Web
Connect to Phoenix data in MicroStrategy Web using the CData Software JDBC Driver for Phoenix.
-
Create Datasets from Accelo in Domo Workbench and Build Visualizations of Accelo Data in Domo
Use the CData Software ODBC Driver for Accelo to create datasets from Accelo data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Humanity Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Humanity data in the Denodo Virtual DataPort Administrator.
-
Integrate Mode Data into Power Automate Desktop using CData Connect
CData Connect for Mode Data enables you to integrate Mode data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Google's Antigravity Agent with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live OData services using the Model Context Protocol.
-
ETL Browserless in Oracle Data Integrator
This article shows how to transfer Browserless data into a data warehouse using Oracle Data Integrator.
-
How to Visualize Splunk Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Splunk data in Python.
-
Automated Continuous OData Services Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable OData services replication to OneLake in Microsoft Fabric.
-
Integrating GitHub Copilot with Amazon Marketplace 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 Odoo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Odoo data and visualize Odoo data in SAP Analytics Cloud.
-
Feed DocuSign Data into FineReport
How to set DocuSign data as a JDBC data source in FineReport.