CData Software - Knowledge Base
Recent Articles
-
Process & Analyze YouTube Analytics Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live YouTube Analytics Data.
-
Work with Live FreshBooks Data in Power Query
Use CData Connect AI to connect to FreshBooks data and work with live FreshBooks data in Microsoft Power Query.
-
Use Dash to Build Web Apps on SuiteCRM Data via CData Connect AI
Build interactive Dash web apps on live SuiteCRM data using pandas and the CData Connect AI Python SDK.
-
A PostgreSQL Interface for Hive Data using the CData ODBC Driver
Use the SQL Gateway and Hive ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Exact Online Data in DBVisualizer
Integrate Exact Online data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Power BI XMLA Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Power BI XMLA data from Filemaker Pro on Mac.
-
Connect to Google Tasks Data from a Connection Pool in Jetty
The Google Tasks JDBC Driver supports connection pooling: This article shows how to connect faster to Google Tasks data from Web apps in Jetty.
-
Integrate Access Data in Pentaho Data Integration
Build ETL pipelines based on Access data in the Pentaho Data Integration tool.
-
Build Agents in Relevance AI with Access to Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Slack data within intelligent agent workflows.
-
Replicate Shopify Data to Multiple Databases via the CData Sync CLI
Replicate Shopify data to disparate databases with a single configuration.
-
Create Dashboards and Visualize Live Sybase IQ Data in Geckoboard
Use CData Connect AI to connect to live Sybase IQ data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to connect PolyBase to Vimeo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Vimeo data.
-
Use Biml to Build SSIS Tasks to Replicate SAP Hybris C4C Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Hybris C4C data to SQL Server.
-
Connect and Query Live Google Analytics Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Analytics data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect to Helpscout Data from IntelliJ
Integrate connectivity to Helpscout data with wizards in IntelliJ.
-
Integrate OpenCode with Live Avalara AvaTax Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Avalara AvaTax data from within your AI coding agent.
-
Create Reports with Avalara AvaTax Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Avalara AvaTax data.
-
Visualize Gorgias Data in Tableau
The CData ODBC driver for Gorgias enables you integrate Gorgias data into Tableau dashboards.
-
How to Visualize SurveyMonkey Data in Python with pandas
Use pandas and other modules to analyze and visualize live SurveyMonkey data in Python.
-
Connect to Cohere Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Cohere and work with Cohere data in your FileMaker application.
-
Integrating Gumloop with Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft OneDrive data within automated workflows.
-
Connecting Mastra with Wave Financial 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 Wave Financial data, no replication required.
-
How to Connect to Live Google Forms 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 Google Forms data for you.
-
Access Bullhorn CRM 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 Bullhorn CRM data.
-
How to Work with Azure Synapse Data in AWS Glue Jobs Using JDBC
Connect to Azure Synapse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live MariaDB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to MariaDB data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous LinkedIn Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Google Cloud SQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Helpscout
Create Helpscout data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Configure the CData JDBC Driver for Google Translate in a Connection Pool in Tomcat
Connect to Google Translate data from a connection pool in Tomcat.
-
Automated Continuous Copper Replication to Vertica
Use CData Sync for automated, continuous, customizable Copper replication to Vertica.
-
Replicate Multiple PolarTeamPro Accounts
Replicate multiple PolarTeamPro accounts to one or many databases.
-
Integrating Boomi Agentstudio with XML Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to XML data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous SAS xpt Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAS xpt replication to Apache Kafka.
-
Integrate LinkedIn Ads Data in the Pentaho Report Designer
Publish reports based on LinkedIn Ads data in the Pentaho BI tool.
-
Integrating Boomi Agentstudio with Amazon DynamoDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Amazon DynamoDB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Migrating data from Sage Intacct to Google BigQuery using CData SSIS Components.
Easily push Sage Intacct data to Google BigQuery using the CData SSIS Tasks for Sage Intacct and Google BigQuery.
-
Automated Continuous Shippo Replication to SQLite
Use CData Sync for automated, continuous, customizable Shippo replication to SQLite.
-
Integrating GitHub Copilot with Wrike 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 Connect to Live Avalara AvaTax 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 Avalara AvaTax data for you.
-
Integrate Live Figshare Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Figshare from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Figshare data.
-
Create ActiveCampaign Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ActiveCampaign from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create HubSpot-Connected Applications in Appsmith
Connect to HubSpot Data via CData Connect AI in Appsmith and create custom business applications with real-time access to HubSpot data.
-
Back Up Freshdesk data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Freshdesk. In this article, we will employ an SSIS workflow to populate a database with Freshdesk data data.
-
Getting Started with the CData Excel Add-In for CloudConvert
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CloudConvert.
-
Use the CData Software ODBC Driver for Hive in MicroStrategy Web
Connect to Hive data in MicroStrategy Web using the CData Software ODBC Driver for Hive.
-
Publish Instagram-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Instagram data.
-
Create Dashboards and Visualize Live Airtable Data in Geckoboard
Use CData Connect AI to connect to live Airtable data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze Recurly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Recurly from Power Pivot. You will use the Table Import Wizard to load Recurly data. You can visually build the import query or use any SQL supported by the driver.
-
Building Dynamic Web Pages with Paylocity Data Using AngularJS
Create single-page applications with live connectivity to Paylocity using the CData API Server.
-
Build Dashboards with MySQL Data in DBxtra
Create dynamic dashboards and perform analytics based on MySQL data in DBxtra.
-
Link SAP Fieldglass with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Fieldglass data in Filemaker Pro for Mac or Windows.
-
Build Google Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Analytics data and build web apps with connectivity to live Google Analytics data.
-
How to Seamlessly Import Eventbrite Data into IBM SPSS Modeler
Integrate Eventbrite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Google Directory Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Directory data.
-
Design BIRT Reports on Oracle Eloqua Reporting Data
Provide current Oracle Eloqua Reporting data to your embedded analytics.
-
Integrate Pipeline CRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pipeline CRM data from Informatica Cloud.
-
Create Informatica Mappings From/To a JDBC Data Source for SageHR
Create SageHR data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Automated SAP BusinessObjects BI-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP BusinessObjects BI data and build automated workflows in Zapier.
-
Analyze Microsoft Planner Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Planner data in Microsoft R Open.
-
Query Salesforce Marketing Data as a MySQL Database in Node.js
Execute MySQL queries against Salesforce Marketing data from Node.js.
-
Connect to Xero Data in JRuby
Create a simple JRuby app with access to live Xero data.
-
Connect to AfterShip Data in DBeaver
Use the CData ODBC Driver to connect to AfterShip data in DBeaver.
-
Connect to Stripe Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Stripe to connect to Stripe data and execute queries in PowerBuilder.
-
Visualize Live Google Search Results in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Search results.
-
Integrating LangGraph with Active Directory Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Active Directory data within automated workflows.
-
Visualize Oracle Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle data.
-
Visualize Live Azure Data Lake Storage Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Data Lake Storage data.
-
Operational Reporting on ShipEngine Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ShipEngine data.
-
Integrate LibreChat with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Active Directory data from within the chat interface.
-
Build ShipStation-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ShipStation data.
-
Connect to SAP SuccessFactors Data in JRuby
Create a simple JRuby app with access to live SAP SuccessFactors data.
-
Access Databricks 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 Databricks data.
-
Automated Unbounce Data Replication to Teradata
Use CData Sync to Customize and automate Unbounce data replication to Teradata.
-
Analyze Pipeliner CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pipeliner CRM data in Microsoft R Open.
-
Connect to Zoho Creator Data in Jaspersoft Studio
Execute SQL to remote Zoho Creator data in Jaspersoft Studio.
-
Work with Live Microsoft OneDrive Data in Power Query
Use CData Connect AI to connect to Microsoft OneDrive data and work with live Microsoft OneDrive data in Microsoft Power Query.
-
Perform Batch Operations with Zoho Inventory Data in Apache NiFi
Connect to Zoho Inventory data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Egnyte Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Egnyte Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Mailgun Data in Pentaho Data Integration
Build ETL pipelines based on Mailgun data in the Pentaho Data Integration tool.
-
Analyze SingleStore Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SingleStore from Power Pivot. You will use the Table Import Wizard to load SingleStore data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect DBeaver to Freshdesk via a JDBC Driver
Manage Freshdesk data with visual tools in DBeaver like the query browser.
-
Publish Reports with Box Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Box data.
-
How to Query Live Microsoft Exchange Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Exchange data data in natural language using Python.
-
Bridge Campaigner Connectivity with Apache NiFi
Access and process Campaigner data in Apache NiFi using the CData JDBC Driver.
-
How to connect Amazon QuickSight to BigCommerce Data
Create a connection to BigCommerce data in CData Connect AI and insert BigCommerce data into Amazon QuickSight SPICE to build interactive dashboards.
-
Analyze Clockify Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Clockify data with the CData JDBC Driver for Clockify.
-
Connect to and Query Microsoft Planner Data in QlikView over ODBC
Create data visualizations with Microsoft Planner data in QlikView.
-
Deploy the ADO.NET Provider for Campaigner on an SSRS Report Server
Connect to Campaigner data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData Software JDBC Driver for Microsoft Planner in MicroStrategy
Connect to Microsoft Planner data in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Planner.
-
Visualize Live WordPress Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live WordPress data into custom reports in Power BI.
-
Create PingOne-Connected Business Apps in AppSheet
Connect to PingOne Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to PingOne data.
-
How to Visualize Moosend 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 Moosend data in Python.
-
Access Live Figshare Data in Coginiti Pro
Connect to and query live Figshare data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Build an ETL App for Kintone Data in Python with CData Connect AI
Build ETL pipelines that read and write live Kintone data in Python with petl and the CData Connect AI Python SDK.
-
Integrating LlamaIndex with Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Snapchat Ads data in real time.
-
Connect to OnePageCrm Data in DBeaver
Use the CData ODBC Driver to connect to OnePageCrm data in DBeaver.
-
Connect Microsoft Dataverse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Dataverse data using the CData Python MCP Server.
-
Create Dynamic Zoho Inventory Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho Inventory to Infragistics XamDataGrid to build dynamic grids.
-
Create Amazon Athena-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon Athena Data from OutSystems and build custom enterprise apps using live Amazon Athena data.
-
Connect to MailerLite Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MailerLite Data and connect to MailerLite data in Akorbi Digital RunMyProcess.