CData Software - Knowledge Base
Recent Articles
-
Viewing JotForm Data in RAD Studio Data Explorer
How to view JotForm data in RAD Studio Data Explorer using the CData ODBC Driver for JotForm.
-
How to Connect to Live Blackbaud FE NXT 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 Blackbaud FE NXT data for you.
-
Choosing the Best Method to Connect Shippo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Shippo data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Claude Code CLI with Pingdom 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.
-
DataBind Charts to Google Cloud Storage Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Cloud Storage data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automate Mode Data Replication to Couchbase
Use CData Sync to Customize and automate Mode data replication to Couchbase.
-
Explore Geographical Relationships in HubDB Data with Power Map
Create data visualizations with HubDB data in Power Map.
-
Connecting Pipedream with PingOne 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 PingOne data in real time.
-
Excel Spreadsheet Automation on Oracle Financials Cloud Data with the QUERY Formula
Pull data from Oracle Financials Cloud, automate spreadsheets, and more with the QUERY formula.
-
How to connect and process Rebilly data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Rebilly data.
-
Use JayDeBeApi to access LaunchDarkly Data in Python
Use standard Python scripting and the development environment of your choice to access live LaunchDarkly data.
-
Publish Crystal Reports on Exa Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exa data.
-
Getting Started with the CData Power BI Connector for RSS
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for RSS.
-
Model Impala Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Impala, enabling the direct import of real-time Impala data.
-
Connect to Close Data from PowerBuilder via JDBC
This article demonstrates how to access Close data from PowerBuilder using the Close JDBC Driver.
-
Replicate Parallel Data from PowerShell
Write a quick PowerShell script to query Parallel data. Use connectivity to the live data to replicate Parallel data to SQL Server.
-
Automated EnterpriseDB Data Replication to Teradata
Use CData Sync to Customize and automate EnterpriseDB data replication to Teradata.
-
Build Exa-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Exa Data and create custom apps in Bubble.
-
Create Reports from Sage Intacct Data in Looker Studio
Use CData Connect AI to gain access to live Sage Intacct data and create custom reports in Looker Studio.
-
A PostgreSQL Interface for eBay Analytics Data (MySQL Remoting via JDBC)
Use the Remoting features of the eBay Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Salesforce Data 360 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce Data 360 data.
-
Create Informatica Mappings From/To an ODBC Data Source for Strava
Create an ODBC connection to Strava in Informatica and browse and transfer Strava data.
-
Create Vault CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Vault CRM data access from reports, embedded analytics, and more.
-
Consume Azure DevOps OData Feeds in PowerBuilder
This article demonstrates how to consume Azure DevOps data as OData feeds from PowerBuilder using the API Server.
-
Visualize Zoom Data in Tableau
The CData ODBC driver for Zoom enables you integrate Zoom data into Tableau dashboards.
-
Automated Continuous Oracle Sales Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Databricks.
-
Visualize Live MySQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MySQL data into custom reports in Power BI.
-
Integrate Live Keap Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Keap data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate with ZohoDesk Data in JReport Designer
Create charts and reports based on ZohoDesk data in JReport Designer.
-
Back Up Microsoft Dataverse data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Dataverse. In this article, we will employ an SSIS workflow to populate a database with Microsoft Dataverse data data.
-
Work with Bitly Data in FoxPro
Load Bitly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Oracle Financials Cloud Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Vertica.
-
Getting Started with the CData SSIS Components for ADP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ADP.
-
Model Dynamics 365 Business Central Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365 Business Central, enabling the direct import of real-time Dynamics 365 Business Central data.
-
Use CData Connect AI to Access Dynamics 365 Business Central Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Dynamics 365 Business Central data in the Power Pivot business intelligence tool.
-
Create Cloudflare Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cloudflare data access from reports, embedded analytics, and more.
-
DataBind FreshBooks Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide FreshBooks data to a chart.
-
Analyze QuickBooks Time Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze QuickBooks Time data in Microsoft R Open.
-
Query Live Zuora 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 Zuora data through a conversational interface.
-
Create Informatica Mappings From/To a JDBC Data Source for RSS
Create RSS data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connecting Agentforce with Hive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Hive data for you.
-
Connect to Act CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Act CRM and the Script function in FileMaker Pro to connect to Act CRM and work with Act CRM data in your FileMaker application.
-
Analyze ElevenLabs Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ElevenLabs data with the CData JDBC Driver for ElevenLabs.
-
Access Typeform Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Typeform data from your Oracle system.
-
Create Facebook Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Facebook Ads data access from reports, embedded analytics, and more.
-
Integrating GitHub Copilot with Pipeliner CRM 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.
-
Access Salesforce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesforce data from HeidiSQL.
-
Connect to Live Freshservice Data in MicroStrategy through CData Connect AI
Create a live connection to Freshservice Data in CData Connect AI and connect to your Freshservice data from MicroStrategy.
-
Integrate with Sybase IQ Data in JReport Designer
Create charts and reports based on Sybase IQ data in JReport Designer.
-
Link Mailgun with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mailgun data in Filemaker Pro for Mac or Windows.
-
Integrate Live BambooHR 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 BambooHR data from within the IDE.
-
Connecting Moonlit Workflow with SAP ByDesign 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 SAP ByDesign data in real time.
-
How to Connect XML Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live XML data in real time using natural language.
-
How to Visualize Zoho Creator Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Creator data in Python.
-
Create SSAS Tabular Models from OnePageCrm Data
How to build a SQL Server Analysis Service Tabular Model from OnePageCrm data using CData drivers.
-
Integrating LangGraph with MySQL Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MySQL data within automated workflows.
-
Integrate Mocean Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mocean data from Informatica Cloud.
-
Migrating data from Cosmos DB to Snowflake using CData SSIS Components.
Easily push Cosmos DB data to Snowflake using the CData SSIS Tasks for Cosmos DB and Snowflake.
-
How to connect PolyBase to Vercel
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Vercel data.
-
Stream LinkedIn Data into Apache Kafka Topics
Access and stream LinkedIn data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize Salesloft 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 Salesloft data in Python.
-
Publish Reports with Redis Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redis data.
-
Build Visualizations of SAP HANA XS Advanced Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA XS Advanced data in Birst.
-
Create Power BI Reports on Real-Time PostgreSQL Data
Use the CData ODBC Driver for PostgreSQL to visualize PostgreSQL data in Power BI Desktop.
-
Connect to RSS Feeds in HULFT Integrate
Connect to RSS as a JDBC data source in HULFT Integrate
-
Create Reports with Bitbucket Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bitbucket data.
-
Build a Singer.io Tap for Aha! With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Aha! data using the CData Python Connector.
-
Build Charts with Zoho Recruit Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoho Recruit data in Clear Analytics.
-
DataBind Charts to ActiveCampaign Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ActiveCampaign data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Migrating data from Suadeo to Databricks using CData SSIS Components.
Easily push Suadeo data to Databricks using the CData SSIS Tasks for Suadeo and Databricks.
-
How to work with Paylocity Data in Apache Spark using SQL
Access and process Paylocity Data in Apache Spark using the CData Software JDBC Driver.
-
Build Sybase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sybase Data and create custom apps in Mendix.
-
Integrate Cloudant Data into Power Automate Desktop using CData Connect
CData Connect for Cloudant Data enables you to integrate Cloudant data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Elorus Data in Aqua Data Studio
Access Elorus data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Perplexity Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Perplexity facts in real time.
-
Use the CData ODBC Driver for Mistral AI in Microsoft Power Query
You can use the CData Mistral AI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mistral AI data into Microsoft Power Query.
-
Automated Continuous ActiveCampaign Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Azure SQL Database.
-
Manage Oracle Eloqua Reporting Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle Eloqua Reporting.
-
Query Live Campaigner 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 Campaigner data through a conversational interface.
-
Process & Analyze Parallel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Parallel Data.
-
Integrate Redshift Data in Pentaho Data Integration
Build ETL pipelines based on Redshift data in the Pentaho Data Integration tool.
-
How to create Visio diagrams from Microsoft Teams Data
Automatically update Microsoft Teams data with the changes you make to Visio master shapes.
-
Integrate Google's Antigravity Agent with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Dropbox data using the Model Context Protocol.
-
Easily Integrate Scrapfly Data in Lazarus Pascal IDE
Learn how to easily integrate live Scrapfly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Operational Reporting on Teradata Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Teradata data.
-
Import Real-Time Telegram Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Telegram data in ColdFusion.
-
Visualize Shopify Data in TIBCO Spotfire through ADO.NET
Integrate Shopify data into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Active Directory in MicroStrategy
Connect to Active Directory data in MicroStrategy Developer using the CData Software ODBC Driver for Active Directory.
-
Access Live Printify Data in AWS Lambda
Connect to live Printify data in AWS Lambda using the CData JDBC Driver.
-
Build AI Agents with SQL Analysis Services Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SQL Analysis Services data through CData Connect AI.
-
Build Smartsheet-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Smartsheet data and build Smartsheet-connected web apps with Axios.
-
Getting Started with the CData Tableau Connector for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho CRM.
-
Visualize Live Adobe Target Data in the Power BI Service
Use CData Connect AI to connect to live Adobe Target data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Power BI Reports on Real-Time Suadeo Data
Use the CData ODBC Driver for Suadeo to visualize Suadeo data in Power BI Desktop.
-
How to connect to SAP HANA XS Advanced Data in DBVisualizer
Integrate SAP HANA XS Advanced data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build CouchDB-Connected Apps in Choreo
Use CData Connect AI to connect to CouchDB Data from Choreo and build custom apps using live CouchDB data.
-
Create Data Visualizations Based On AgileCRM Data in Mode
Use CData Connect AI to connect to AgileCRM Data from Mode and build visualizations using live AgileCRM data.
-
Connect to Reply.io Data in NetBeans
Connect to Reply.io data in NetBeans with the data source configuration wizard.
-
Viewing xBase Data in RAD Studio Data Explorer
How to view xBase data in RAD Studio Data Explorer using the CData ODBC Driver for xBase.
-
Connect to SAP Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP and the Script function in FileMaker Pro to connect to SAP and work with SAP data in your FileMaker application.