CData Software - Knowledge Base
Recent Articles
-
Connect to SAP HANA Data in RapidMiner
Integrate SAP HANA data with standard components and data source configuration wizards in RapidMiner Studio.
-
Choosing the Best Method to Connect TaxJar to SQL Server: 5 Options Explained
Discover multiple ways to connect and use TaxJar data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for Greenplum in MicroStrategy Desktop
Connect to Greenplum data in MicroStrategy Desktop using the CData Software ODBC Driver for Greenplum.
-
Import and Visualize Rebilly Data in Power View
Create data visualizations based on Rebilly data in Excel.
-
Connect to AfterShip Data from PowerBuilder via ADO.NET
This article demonstrates how to access AfterShip data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Extract, Transform, and Load ChargeOver Data in Informatica PowerCenter
Create a simple Workflow for ChargeOver data in Informatica PowerCenter.
-
Connect to Microsoft OneDrive in SpagoBI
Create reports featuring live Microsoft OneDrive data in SpagoBI Studio. Host Microsoft OneDrive reports on SpagoBI Server.
-
Import Real-Time Workday Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Workday data in ColdFusion.
-
Integrate Live Dropbox Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dropbox from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Dropbox data.
-
Integrate Live Zuora Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Zuora data from within the IDE.
-
Access Live Todoist Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Todoist data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Clockify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Clockify to connect to Clockify data from Web applications running on WebLogic.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Spanner
Provide connectivity to Google Spanner data through an SAP BusinessObjects universe.
-
Visualize FreshBooks Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FreshBooks data.
-
Access Live Stripe Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Stripe data from your Excel spreadsheets.
-
Excel Spreadsheet Automation on EnterpriseDB Data with the QUERY Formula
Pull data from EnterpriseDB, automate spreadsheets, and more with the QUERY formula.
-
How to connect to AfterShip Data from Spring Boot
Connect to AfterShip in a Spring Boot Application using the CData API Driver for JDBC
-
Automate Gong Data Replication to Couchbase
Use CData Sync to Customize and automate Gong data replication to Couchbase.
-
Connecting Pipedream with Yelp Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Yelp data in real time.
-
Automate Coda Data Replication to Azure Synapse
Use CData Sync to customize and automate Coda data replication to Azure Synapse.
-
Import Real-Time Google Calendar Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Calendar data in ColdFusion.
-
Using the CData Software ODBC Driver for Tanda in PyCharm
Connect to Tanda as an ODBC data source in PyCharm using the CData Software ODBC Driver for Tanda.
-
Replicate Microsoft Teams Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Teams data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Browserless Replication to MongoDB
Use CData Sync for automated, continuous, customizable Browserless replication to MongoDB.
-
ETL TaxJar in Oracle Data Integrator
This article shows how to transfer TaxJar data into a data warehouse using Oracle Data Integrator.
-
Build a Singer.io Tap for OpenWeatherMap With the CData Python Connector
Learn how to easily build a Singer.io Tap for live OpenWeatherMap data using the CData Python Connector.
-
How to Visualize MailerLite Data in Python with pandas
Use pandas and other modules to analyze and visualize live MailerLite data in Python.
-
Connect Moosend Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Moosend data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Migrating data from SparkPost to Google BigQuery using CData SSIS Components.
Easily push SparkPost data to Google BigQuery using the CData SSIS Tasks for SparkPost and Google BigQuery.
-
How to Connect the Power BI Service to Webex: Complete Guide
Connect to the CData Software Power BI Connector for Webex from PowerBI.com to provide real-time Webex data across the organization.
-
How to create an RPA flow for Oracle Sales Data in UiPath Studio
Use the Oracle Sales ODBC Driver to create workflows that access real-time Oracle Sales data without any coding.
-
Create Sage 300 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sage 300 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate Multiple Workday Accounts
Replicate multiple Workday accounts to one or many databases.
-
Connect to VWO Data in HULFT Integrate
Connect to VWO as a JDBC data source in HULFT Integrate
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Time Data
Use CData Power BI Connectors to visualize QuickBooks Time data in Power BI.
-
Integrate with QuickBooks Online Data in SnapLogic
Use CData Connect AI to connect to and integrate with live QuickBooks Online data in SnapLogic.
-
Integrate Devin with Live Zendesk Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Zendesk data.
-
Connect to Basecamp Data in Claris FileMaker Pro
Use the CData ODBC Driver for Basecamp in FileMaker Pro to connect to Basecamp and work with Basecamp data in your FileMaker applications.
-
Integrating OpenCode with Neo4J 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.
-
How to work with ChargeOver Data in Apache Spark using SQL
Access and process ChargeOver Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live ZohoInvoice Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZohoInvoice data into the statistical analysis tools available in SAS JMP. This article shows how to use ZohoInvoice data in the Graph Builder and Query Builder.
-
Connect Coda to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Coda with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Controls to SAP Concur Data in C++Builder
DataBind to SAP Concur data in C++Builder with standard components and controls.
-
Rapidly Develop ADP-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 ADP.
-
Visualize Live Google Tasks Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Tasks data.
-
Build CSV-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live CSV data and build CSV-connected web apps with Axios.
-
Automated Continuous Chargebee Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Chargebee replication to Azure SQL Database.
-
Import and Visualize HCL Domino Data in Power View
Create data visualizations based on HCL Domino data in Excel.
-
Process & Analyze Google Directory Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Directory Data.
-
Connect to Presto 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 Presto data.
-
Connecting Mastra with Impala 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 Impala data, no replication required.
-
Import Real-Time Instantly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Instantly data in ColdFusion.
-
Explore Geographical Relationships in AfterShip Data with Power Map
Create data visualizations with AfterShip data in Power Map.
-
Access Planio Data from MySQL in PHP
Connect to Planio through the standard MySQL libraries in PHP.
-
Add Databricks Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Databricks with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query SQL Analysis Services Data in ColdFusion
Write standard ColdFusion data access code to connect to SQL Analysis Services data.
-
Use the CData Software JDBC Driver for SAP BusinessObjects BI in MicroStrategy Web
Connect to SAP BusinessObjects BI data in MicroStrategy Web using the CData Software JDBC Driver for SAP BusinessObjects BI.
-
Visualize Live BigCommerce Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live BigCommerce data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Live ZohoDesk Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live ZohoDesk data through a conversational interface.
-
Integrate Theia IDE with Live GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live GetResponse data from within the development environment.
-
Connect to SQL Server Data in ACL Analytics
Connect to SQL Server data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SQL Server data.
-
Create Demio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Demio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Dataiku with Apify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apify data.
-
How to Visualize Salesforce Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce data in Python.
-
Use Databricks Agent Bricks to Talk to Your Wave Financial Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Wave Financial data for you.
-
Automated Continuous SendPulse Replication to MongoDB
Use CData Sync for automated, continuous, customizable SendPulse replication to MongoDB.
-
Automated Continuous Scrapfly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Scrapfly replication to Google BigQuery.
-
Build a Singer.io Tap for MailChimp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MailChimp data using the CData Python Connector.
-
Access Live FHIR Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live FHIR data from your Excel spreadsheets.
-
Integrating Dataiku with SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SQL Analysis Services data.
-
Publish Crystal Reports on Amplitude Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amplitude data.
-
Connect to Todoist Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Todoist to connect to Todoist data and execute queries in PowerBuilder.
-
Use JayDeBeApi to access Retently Data in Python
Use standard Python scripting and the development environment of your choice to access live Retently data.
-
Use the CData ODBC Driver for Tally in Microsoft Power Query
You can use the CData Tally ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Tally data into Microsoft Power Query.
-
Build Smartsheet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Smartsheet data.
-
View Reports on Real-Time SAP Ariba Procurement Data in Power BI Report Server
Use the CData ODBC Driver for SAP Ariba Procurement to visualize SAP Ariba Procurement data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to & Open Freshteam Data in Microsoft Excel
This article uses the CData ODBC driver for Freshteam to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Freshservice Data in the Pentaho Report Designer
Publish reports based on Freshservice data in the Pentaho BI tool.
-
Build Apps with Live Twitter Ads Data Using the Low-Code Development Platform of Mendix
Connect Twitter Ads data with Mendix to build apps using the CData JDBC Driver for Twitter Ads.
-
Connect to Live Adobe Experience Manager Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Adobe Experience Manager in CData Connect AI and connect to your Adobe Experience Manager data from PostgreSQL.
-
Integrating Antigravity CLI with Basecamp data via CData CLI
Connect Basecamp data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Sage Intacct Data from a Connection Pool in JBoss
Integrate Sage Intacct data into Java servlets: Use the Management Console in JBoss to install the Sage Intacct JDBC Driver.
-
Integrate with Perplexity Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Perplexity data in SnapLogic.
-
Use the CData Software JDBC Driver for Microsoft Ads in MicroStrategy
Connect to Microsoft Ads data in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Ads.
-
Replicate Multiple Clockify Accounts via the CData Sync CLI
Replicate multiple Clockify accounts to one or many databases.
-
Rapidly Develop BigCommerce-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 BigCommerce.
-
Creating Spark-Connected Applications in Unqork
You can use CData Connect AI to feed Spark data to Unqork and build custom business apps.
-
Integrate Cursor with Live Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Supabase data from within the editor.
-
Connect to LaunchDarkly Data in RapidMiner
Integrate LaunchDarkly data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Gumloop with Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon Athena data within automated workflows.
-
How to Connect to Live Oracle Financials Cloud Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Oracle Financials Cloud data for you.
-
Create Dynamic Kafka Grids Using the Infragistics XamDataGrid
Learn how you can connect Kafka to Infragistics XamDataGrid to build dynamic grids.
-
Automate Close Data Replication to SAP HANA
Use CData Sync to customize and automate Close data replication to SAP HANA.
-
How to use SQLAlchemy ORM to access Reply.io Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Reply.io data.
-
Creating Amazon Athena-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon Athena data to Unqork and build custom business apps.
-
Integrating Claude Code CLI with Copper 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.
-
Query Facebook Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Facebook Ads data from Node.js.
-
Analyze GraphQL Data in Looker
Use CData Connect AI to connect to GraphQL Data from Looker and build custom apps using live GraphQL data.
-
Use CData Connect AI to Access BenchmarkEmail Data in Microsoft Power Pivot
Use CData Connect AI to connect to live BenchmarkEmail data in the Power Pivot business intelligence tool.
-
How to Access Live Google Calendar Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Calendar enables you to integrate Google Calendar data into workflows built using Microsoft Power Automate Desktop.