CData Software - Knowledge Base
Recent Articles
-
Analyze Acumatica Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Acumatica data and visualize Acumatica data in SAP Analytics Cloud.
-
Build Data Flows from SQL Server to Reckon Accounts Hosted through SSIS
Easily push SQL Server data to Reckon Accounts Hosted using the CData SSIS Tasks for Reckon Accounts Hosted.
-
Trigger Azure Table IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Azure Table with standard wizards in Logic Apps.
-
Publish Certinia-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Certinia data.
-
Integrating Google Forms Data in Talend Cloud Data Management Platform
Connect Google Forms Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automate PabblySubscriptions Data Replication to Azure Data Lake
Use CData Sync to customize and automate PabblySubscriptions data replication to Azure Data Lake.
-
Connect to Cloudant Data in RapidMiner
Integrate Cloudant data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting GenSpark with Adobe Target Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Adobe Target data without any replication or custom integration required.
-
Replicate SuiteCRM Data to Multiple Databases via the CData Sync CLI
Replicate SuiteCRM data to disparate databases with a single configuration.
-
Visualize Unbounce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Unbounce data.
-
Automated Continuous Discourse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Discourse data replication to OneLake in Microsoft Fabric.
-
Access Impala Data from MySQL in PHP
Connect to Impala through the standard MySQL libraries in PHP.
-
Model ADP Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ADP, enabling the direct import of real-time ADP data.
-
Use the CData ODBC Driver for ConvertAPI in Microsoft Power Query
You can use the CData ConvertAPI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ConvertAPI data into Microsoft Power Query.
-
Integrate Google's Vertex AI Agent with Live Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Samanage data within intelligent workflows.
-
Integrate Live Salesforce Marketing Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce Marketing data to Blue Prism using the CData ODBC Driver for Salesforce Marketing to create automated workflows for repetitive business tasks.
-
Access Live Neo4J Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Neo4J data through MCP integration.
-
Getting Started with the CData ODBC Driver for Hubstaff
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Hubstaff.
-
Automated Continuous Azure Data Catalog Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Data Catalog data replication to OneLake in Microsoft Fabric.
-
Configure the CData JDBC Driver for MessageBird in a Connection Pool in Tomcat
Connect to MessageBird data from a connection pool in Tomcat.
-
How to connect to SQL Server Data from Spring Boot
Connect to SQL Server in a Spring Boot Application using the CData JDBC Driver for SQL Server
-
Build a PostgreSQL Interface for Square Data using the CData JDBC Driver
Use the Remoting features of the Square JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Power BI Connector for Clari
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Semantic Layer Views for eBay Analytics Data in APOS Live Data Gateway
Use the CData Connector for eBay Analytics in APOS Live Data Gateway to build Semantic Layer Views for eBay Analytics data.
-
Access Ontraport Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Ontraport data from HeidiSQL.
-
Build Dropbox-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Dropbox data and build web apps with connectivity to live Dropbox data.
-
Getting Started with the CData SSIS Components for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Pipeliner CRM.
-
Access Salesforce Marketing Data from MySQL in PHP
Connect to Salesforce Marketing through the standard MySQL libraries in PHP.
-
How to Connect the Power BI Service to Klipfolio: Complete Guide
Connect to the CData Software Power BI Connector for Klipfolio from PowerBI.com to provide real-time Klipfolio data across the organization.
-
Connect to Amplitude Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amplitude and the SQL Gateway to access Amplitude data from Google Apps Script.
-
Create Power BI Reports on Real-Time ServiceDesk Plus Data
Use the CData ODBC Driver for ServiceDesk Plus to visualize ServiceDesk Plus data in Power BI Desktop.
-
Connect to and Query Telegram Data in QlikView over ODBC
Create data visualizations with Telegram data in QlikView.
-
Getting Started with the CData Power BI Connector for Gorgias
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Model, Search, and Visualize Live Raisers Edge NXT Data in ThoughtSpot
Use CData Connect AI to connect to live Raisers Edge NXT data for modeling, searching, and visualizing.
-
Analyze SAP BusinessObjects BI Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP BusinessObjects BI data and visualize SAP BusinessObjects BI data in SAP Analytics Cloud.
-
How to Connect Zoom 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 Zoom data in real time using natural language.
-
Automate Front Data Replication to Azure Synapse
Use CData Sync to customize and automate Front data replication to Azure Synapse.
-
Integrating Boomi Agentstudio with Oracle Sales Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle Sales data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to publish and share SAS Data Sets Data dashboards with Tableau Server
The CData ODBC driver for SAS Data Sets enables you integrate SAS Data Sets data into Tableau dashboards.
-
Integrate Dify with Live Wistia Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Wistia data.
-
Connect to MailChimp Data from PowerBuilder via ADO.NET
This article demonstrates how to access MailChimp data from Appeon PowerBuilder using the CData ADO.NET Provider for MailChimp.
-
DataBind Testmonitor Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Testmonitor data to a chart.
-
Use Databricks Agent Bricks to Talk to Your SAP HANA XS Advanced Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP HANA XS Advanced data for you.
-
Automated Continuous Workable Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Workable replication to AlloyDB.
-
How to Connect DBeaver to Sage 300 via a JDBC Driver
Manage Sage 300 data with visual tools in DBeaver like the query browser.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for OpenWeatherMap
Provide connectivity to OpenWeatherMap data through an SAP BusinessObjects universe.
-
How to publish and share PagerDuty Data dashboards with Tableau Server
The CData ODBC driver for PagerDuty enables you integrate PagerDuty data into Tableau dashboards.
-
DataBind Controls to Aircall Data in Delphi
DataBind to Aircall data in Delphi with standard data access components and controls.
-
Analyze Live Bannerbear Data in SAS Viya
Use CData Connect AI to connect to Bannerbear data from SAS Viya and deploy self-service analytics using live Bannerbear data.
-
Connect to Figshare Data from a Connection Pool in Jetty
The Figshare JDBC Driver supports connection pooling: This article shows how to connect faster to Figshare data from Web apps in Jetty.
-
ETL LeadDesk in Oracle Data Integrator
This article shows how to transfer LeadDesk data into a data warehouse using Oracle Data Integrator.
-
Access Live Amazon DynamoDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon DynamoDB data from your Google Sheets.
-
Integrate with SurveyMonkey Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SurveyMonkey data in SnapLogic.
-
Build Facebook-Connected Apps in Choreo
Use CData Connect AI to connect to Facebook Data from Choreo and build custom apps using live Facebook data.
-
How to connect to Strava Data from IntelliJ
Integrate connectivity to Strava data with wizards in IntelliJ.
-
Connect Couchbase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Couchbase with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Amazon S3 Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Amazon S3 data for you.
-
Automated Continuous Keap Replication to SQL Server
Use CData Sync for automated, continuous, customizable Keap replication to SQL Server.
-
Access Live Power BI XMLA Data in TIBCO Data Virtualization
Use the Power BI XMLA Tibco DV Adapter to create a Power BI XMLA data data source in TIBCO Data Virtualization Studio and gain access to live Power BI XMLA data from your TDV Server.
-
A PostgreSQL Interface for Microsoft OneDrive Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft OneDrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Placid Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Placid data from Informatica Cloud.
-
Getting Started with the CData Tableau Connector for FTP
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for FTP.
-
Getting Started with the CData Power BI Connector for XML
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for XML.
-
Integrate Google's Vertex AI Agent with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Business One data within intelligent workflows.
-
Working with Teamgate Data in LINQPad
Execute LINQ queries to Teamgate data in LINQPad.
-
How to Work with Zoho Inventory Data in ETL Validator JDBC
Connect to Zoho Inventory from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Dataiku with Attio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Attio data.
-
Getting Started with the CData JDBC Driver for Nuclia
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Nuclia.
-
Integrating Boomi Agentstudio with SFTP Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SFTP data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live DB2 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live DB2 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create ZohoExpense-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ZohoExpense Data from Klipfolio and build custom visualizations using live ZohoExpense data.
-
Getting Started with the CData ADO.NET Provider for Bright Data
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build LDAP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LDAP objects.
-
Connect to Pipedrive Data from PowerBuilder via JDBC
This article demonstrates how to access Pipedrive data from PowerBuilder using the Pipedrive JDBC Driver.
-
Automated Continuous LDAP Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LDAP replication to Apache Kafka.
-
How to create Visio diagrams from Reckon Data
Automatically update Reckon data with the changes you make to Visio master shapes.
-
Enable the Dynamics NAV JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Dynamics NAV data.
-
Integrate OpenCode with Live MailerLite Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live MailerLite data from within your AI coding agent.
-
Write a Simple Go Application to work with SAS Data Sets Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAS Data Sets data.
-
Add ConstantContact Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ConstantContact with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to MailerLite Data from AWS Glue
Use CData Connect AI to gain access to live MailerLite data from your AWS Glue jobs.
-
Getting Started with the CData ODBC Driver for Salesforce Pardot
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Salesforce Pardot.
-
Build QuickBooks Time-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks Time data.
-
How to update Microsoft Exchange from Excel
This article explains how to transfer data from Excel to Microsoft Exchange using the Excel Add-In for Microsoft Exchange.
-
Create Data Visualizations in Cognos BI with Freshsales Data
Access Freshsales data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Azure AI Foundry to Talk to Your Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Airtable data for you.
-
Connect to and Query Procore Data in QlikView over ODBC
Create data visualizations with Procore data in QlikView.
-
Access Live Acumatica Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Acumatica data from your Excel spreadsheets.
-
Automated Continuous SAS xpt Replication to Databricks
Use CData Sync for automated, continuous, customizable SAS xpt replication to Databricks.
-
Extract, Transform, and Load ActiveCampaign Data in Informatica PowerCenter
Create a simple Workflow for ActiveCampaign data in Informatica PowerCenter.
-
Analyze Zoho CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho CRM data with the CData JDBC Driver for Zoho CRM.
-
Use Biml to Build SSIS Tasks to Replicate Office 365 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Office 365 data to SQL Server.
-
Back Up Dynamics 365 Business Central data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics 365 Business Central. In this article, we will employ an SSIS workflow to populate a database with Dynamics 365 Business Central data data.
-
Getting Started with the CData Excel Add-In for Drip
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Drip.
-
Import Real-Time Access Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Access data in ColdFusion.
-
Integrating Claude Code CLI with ClickTime 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.
-
Replicate Blackbaud FE NXT Data to Multiple Databases via the CData Sync CLI
Replicate Blackbaud FE NXT data to disparate databases with a single configuration.
-
Faster Reporting using the QuickBooks Provider
The CData ADO.NET Provider for QuickBooks features advanced caching capabilities. The Auto Cache feature of the Data Provider can be used to execute expensive queries against a local, automatically updated cache.
-
Migrating data from Salesforce Data 360 to Databricks using CData SSIS Components.
Easily push Salesforce Data 360 data to Databricks using the CData SSIS Tasks for Salesforce Data 360 and Databricks.
-
Consume Neo4J OData Feeds in PowerBuilder
This article demonstrates how to consume Neo4J data as OData feeds from PowerBuilder using the API Server.