CData Software - Knowledge Base
Recent Articles
-
Create Box Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Box from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to ZohoExpense Data in ACL Analytics
Connect to ZohoExpense data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ZohoExpense data.
-
Add Aweber Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Aweber with the Informatica Enterprise Data Catalog to classify and organize data.
-
Using the CData Software ODBC Driver for Productboard in PyCharm
Connect to Productboard as an ODBC data source in PyCharm using the CData Software ODBC Driver for Productboard.
-
Create Datasets from Mistral AI in Domo Workbench and Build Visualizations of Mistral AI Data in Domo
Use the CData Software ODBC Driver for Mistral AI to create datasets from Mistral AI data in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from LinkedIn Ads to Snowflake using CData SSIS Components.
Easily push LinkedIn Ads data to Snowflake using the CData SSIS Tasks for LinkedIn Ads and Snowflake.
-
Connect to Real-Time Sage 200 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage 200 and Dataflow to import and use Sage 200 data in Power Apps.
-
Migrating data from Google Calendar to Databricks using CData SSIS Components.
Easily push Google Calendar data to Databricks using the CData SSIS Tasks for Google Calendar and Databricks.
-
Create Data Visualizations in Cognos BI with Retently Data
Access Retently data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Voice Agents in ElevenLabs with access to Live SendPulse Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SendPulse data.
-
Analyze Odoo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Odoo data and visualize live Odoo data in Infragistics Reveal.
-
Connect to Microsoft Entra ID Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Entra ID to connect to Microsoft Entra ID data and execute queries in PowerBuilder.
-
Operational Reporting on Salesforce Pardot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce Pardot data.
-
Build Apps with Live Jodoo Data Using the Low-Code Development Platform of Mendix
Connect Jodoo data with Mendix to build apps using the CData API Driver for JDBC.
-
Create SSAS Tabular Models from FHIR Data
How to build a SQL Server Analysis Service Tabular Model from FHIR data using CData drivers.
-
Build Cosmos DB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Cosmos DB data and build visualizations in Tableau.
-
How to Connect to & Open Figshare Data in Microsoft Excel
This article uses the CData ODBC driver for Figshare to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Claude Code with PolarTeamPro Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on PolarTeamPro data within assisted coding and automated development workflows.
-
Getting Started with the CData Excel Add-In for Demio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Demio.
-
Build Automated Sendwithus-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sendwithus data and build automated workflows in Zapier.
-
Connect to Adobe Experience Manager Data in Google Apps Script via Connect AI
Use CData Connect AI to access Adobe Experience Manager data in Google Apps Script.
-
Access Quickbase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Quickbase data from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Clari
Provide connectivity to Clari data through an SAP BusinessObjects universe.
-
Migrating data from Google Spanner to Databricks using CData SSIS Components.
Easily push Google Spanner data to Databricks using the CData SSIS Tasks for Google Spanner and Databricks.
-
Connect to MailerLite Data in ACL Analytics
Connect to MailerLite data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MailerLite data.
-
Natively Connect to SingleStore Data in PHP
The CData ODBC driver for SingleStore enables you to create PHP applications with connectivity to SingleStore data. Leverage the native support for ODBC in PHP.
-
How to connect to CircleCI Data in DBVisualizer
Integrate CircleCI data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Visualize QuickBooks Online 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 QuickBooks Online data in Python.
-
Create Dynamic Asana Grids Using the Infragistics XamDataGrid
Learn how you can connect Asana to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Campaigner Replication to SQLite
Use CData Sync for automated, continuous, customizable Campaigner replication to SQLite.
-
Use the CData Software ODBC Driver for Sybase in MicroStrategy
Connect to Sybase data in MicroStrategy Developer using the CData Software ODBC Driver for Sybase.
-
Integrating Claude Code CLI with Access 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.
-
Import Real-Time SparkPost Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SparkPost data in ColdFusion.
-
Establish a Live Connection with SparkPost Data using Tableau Bridge
The CData ODBC Driver for SparkPost enables you to integrate live SparkPost data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build ClickUp Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ClickUp data and build visualizations in Tableau.
-
Use the CData ODBC Driver for BigCommerce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for BigCommerce to connect to BigCommerce data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring BigCommerce data in Excel.
-
Use the CData Software JDBC Driver for FHIR in MicroStrategy
Connect to FHIR data in MicroStrategy Developer using the CData Software JDBC Driver for FHIR.
-
Connect to OneNote Data in DBArtisan
Use wizards in DBArtisan to configure OneNote data as a data source.
-
Connect to SAP Concur Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Concur data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Concur.
-
Automated Continuous ShipStation Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ShipStation replication to AlloyDB.
-
Build a Singer.io Tap for Eventbrite With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Eventbrite data using the CData Python Connector.
-
Visualize HBase Data in Sisense
Create an ElastiCube in Sisense app with access to HBase data.
-
Connect to Snapchat Ads Data in DBeaver
Use the CData ODBC Driver to connect to Snapchat Ads data in DBeaver.
-
Create Reports with iContact Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date iContact data.
-
Connect to Workday Data in ACL Analytics
Connect to Workday data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Workday data.
-
How to Connect to Live Greenhouse 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 Greenhouse data through natural language.
-
Connect ServiceNow to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ServiceNow with IBM WebSphere for seamless data integration and connectivity.
-
How to Build an ETL App for SAP HANA Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP HANA data in Python with petl and the CData Connect AI Python SDK.
-
Build Data Flows from Brex to SQL Server using SSIS
Easily back up Brex data to SQL Server using the SSIS components for Brex.
-
Connect to Templated Data in JRuby
Create a simple JRuby app with access to live Templated data.
-
Integrating Gumloop with Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Bitbucket data within automated workflows.
-
Use Biml to Build SSIS Tasks to Replicate Copper Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Copper data to SQL Server.
-
Build NetSuite SuiteAnalytics-Connected Apps in Choreo
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Choreo and build custom apps using live NetSuite SuiteAnalytics data.
-
Analyze Exa Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Exa data in Microsoft R Open.
-
Load Dynamics 365 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dynamics 365 data to a database.
-
Visualize Act CRM 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 Act CRM data into TIBCO Spotfire.
-
Connect to Wrike Data from a Connection Pool in JBoss
Integrate Wrike data into Java servlets: Use the Management Console in JBoss to install the Wrike JDBC Driver.
-
Automated Continuous WordPress Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable WordPress replication to Azure SQL Database.
-
Prepare, Blend, and Analyze CapsuleCRM Data in Alteryx Designer (Connect AI)
Build workflows to access live CapsuleCRM data for self-service data analytics.
-
Analyze Google Drive Data in Looker
Use CData Connect AI to connect to Google Drive Data from Looker and build custom apps using live Google Drive data.
-
Analyze Adobe Experience Manager Data in Cognos Analytics
Use CData Connect AI to connect to Adobe Experience Manager Data from Cognos Analytics and analyze live Adobe Experience Manager data.
-
Access GitLab Data from MySQL in Amazon QuickSight
Connect to GitLab and build visualizations of GitLab data using a MySQL Connection in Amazon QuickSight.
-
Integrate Reply.io Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Reply.io data from Informatica Cloud.
-
Choosing the Best Method to Connect Moosend to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Moosend data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate ZeroBounce Data Replication to Couchbase
Use CData Sync to Customize and automate ZeroBounce data replication to Couchbase.
-
How to create Google Tasks federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Tasks data in MySQL .
-
Build a Simple VCL Application for Email Data
How to build a simple VCL Application to view Email data in RAD Studio using the CData ODBC Driver for Email.
-
Build PostgreSQL-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for PostgreSQL Data and create custom apps in Mendix.
-
Connect to Shippo Data in RapidMiner
Integrate Shippo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize SAP Netweaver Gateway Data in Tableau
The CData ODBC driver for SAP Netweaver Gateway enables you integrate SAP Netweaver Gateway data into Tableau dashboards.
-
Create a Data Access Object for Qualaroo Data using JDBI
A brief overview of creating a SQL Object API for Qualaroo data in JDBI.
-
Visualize ADP Data in TIBCO Spotfire through ADO.NET
Integrate ADP data into dashboards in TIBCO Spotfire.
-
Query Jira Assets Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Jira Assets entities in PHP by modeling them as objects.
-
Connect to SparkPost Data from a Connection Pool in JBoss
Integrate SparkPost data into Java servlets: Use the Management Console in JBoss to install the SparkPost JDBC Driver.
-
Connect to Google Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Ads in FileMaker Pro to connect to Google Ads and work with Google Ads data in your FileMaker applications.
-
Automate Instagram Data Replication to Azure Synapse
Use CData Sync to customize and automate Instagram data replication to Azure Synapse.
-
API Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to API data through CData Connect AI using different applications and tools.
-
Prepare, Blend, and Analyze Optimizely Data in Alteryx Designer (Connect AI)
Build workflows to access live Optimizely data for self-service data analytics.
-
Access Live HBase Data in AWS Lambda
Connect to live HBase data in AWS Lambda using the CData JDBC Driver.
-
Integrate Trae with Live Vertica Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Vertica data from within the AI-powered IDE.
-
Use Agno to Talk to Your Redshift 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 Redshift data for you.
-
Access Klipfolio 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 Klipfolio data.
-
How to create CampaignMonitor federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CampaignMonitor data in MySQL .
-
Connecting GenSpark with AfterShip Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to AfterShip data without any replication or custom integration required.
-
Connect to Real-Time Salesforce Marketing Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce Marketing and Dataflow to import and use Salesforce Marketing data in Power Apps.
-
Query ClickTime Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ClickTime data from Node.js.
-
How to connect to Google Analytics Data in DBVisualizer
Integrate Google Analytics data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Jira Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Jira data and build visualizations in Tableau.
-
Publish Float-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Float data.
-
Query BigCommerce Data in DataGrip
Create a Data Source for BigCommerce in DataGrip and use SQL to query live BigCommerce data.
-
Create Informatica Mappings From/To a JDBC Data Source for JDBC-ODBC Bridge
Create JDBC-ODBC Bridge data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Attio Replication to Snowflake
Use CData Sync for automated, continuous, customizable Attio replication to Snowflake.
-
Automated Continuous Monday.com Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Monday.com replication to delimited files (CSV/TSV).
-
Bind Live Oracle Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create Dashboards and Visualize Live WooCommerce Data in Geckoboard
Use CData Connect AI to connect to live WooCommerce data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Phoenix Replication to SQLite
Use CData Sync for automated, continuous, customizable Phoenix replication to SQLite.
-
How to work with Raisers Edge NXT Data in Apache Spark using SQL
Access and process Raisers Edge NXT Data in Apache Spark using the CData Software JDBC Driver.
-
How to Query GetResponse Data in MySQL Workbench
Execute MySQL queries against live GetResponse data from MySQL Workbench.
-
Use Biml to Build SSIS Tasks to Replicate ZohoSubscriptions Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoSubscriptions data to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act-On
Provide connectivity to Act-On data through an SAP BusinessObjects universe.