CData Software - Knowledge Base
Recent Articles
-
Connecting GenSpark with FTP Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to FTP data without any replication or custom integration required.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Hybris C4C
Provide connectivity to SAP Hybris C4C data through an SAP BusinessObjects universe.
-
How to Build an ETL App for Sybase IQ Data in Python with CData Connect AI
Build ETL pipelines that read and write live Sybase IQ data in Python with petl and the CData Connect AI Python SDK.
-
Access VWO Data from MySQL in Amazon QuickSight
Connect to VWO and build visualizations of VWO data using a MySQL Connection in Amazon QuickSight.
-
Choosing the Best Method to Connect Omnisend to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Omnisend data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use CData Connect AI to Access ActiveCampaign Data in Microsoft Power Pivot
Use CData Connect AI to connect to live ActiveCampaign data in the Power Pivot business intelligence tool.
-
Connect and Visualize Live SAP SuccessFactors LMS Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors LMS data into the Databricks platform and create visualization dashboards with real-time SAP SuccessFactors LMS data.
-
Integrate Live Highrise Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Highrise data to Blue Prism using the CData ODBC Driver for Highrise to create automated workflows for repetitive business tasks.
-
Connecting Agentforce with Azure Data Catalog 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 Azure Data Catalog data for you.
-
Automated Continuous SendPulse Replication to SingleStore
Use CData Sync for automated, continuous, customizable SendPulse replication to SingleStore.
-
Automated Continuous SAS xpt Replication to MySQL
Use CData Sync for automated, continuous, customizable SAS xpt replication to MySQL.
-
Visualize LDAP Objects in Tableau
The CData ODBC driver for LDAP enables you integrate LDAP objects into Tableau dashboards.
-
Automated Continuous Moosend Replication to Vertica
Use CData Sync for automated, continuous, customizable Moosend replication to Vertica.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy
Connect to Zoho Projects data in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Projects.
-
Use CData Connect AI to Access Smartsheet Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Smartsheet data in the Power Pivot business intelligence tool.
-
Provide OData Services of Bullhorn CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Bullhorn CRM data by developing a WCF Service Application.
-
DataBind Charts to Cloudflare Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cloudflare 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.
-
Configure the CData JDBC Driver for QuickBooks Online in a Connection Pool in Tomcat
Connect to QuickBooks Online data from a connection pool in Tomcat.
-
Create Data Visualizations Based On Act-On Data in Mode
Use CData Connect AI to connect to Act-On Data from Mode and build visualizations using live Act-On data.
-
Connect to WordPress Data from a Connection Pool in JBoss
Integrate WordPress data into Java servlets: Use the Management Console in JBoss to install the WordPress JDBC Driver.
-
Create Shopify-Connected Nintex Workflows
Use CData Connect AI to connect to Shopify Data from Nintex Workflow Cloud and build custom workflows using live Shopify data.
-
Access Monday.com Data from MySQL in Amazon QuickSight
Connect to Monday.com and build visualizations of Monday.com data using a MySQL Connection in Amazon QuickSight.
-
Connect Hubstaff to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Hubstaff data using the CData Python MCP Server.
-
How to Connect to Live Freshservice Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Freshservice data without replication.
-
Query ChartMogul Data as a MySQL Database in Node.js
Execute MySQL queries against ChartMogul data from Node.js.
-
Automated NetSuite SuiteAnalytics Data Replication to Teradata
Use CData Sync to Customize and automate NetSuite SuiteAnalytics data replication to Teradata.
-
Visualize Zoho CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho CRM data.
-
Visualize Live PayPal Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PayPal data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Dash to Build Web Apps on BambooHR Data via CData Connect AI
Build interactive Dash web apps on live BambooHR data using pandas and the CData Connect AI Python SDK.
-
Integrate Devin with Live ConstantContact 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 ConstantContact data.
-
Connect to RabbitMQ Data in CloverDX (formerly CloverETL)
Transfer RabbitMQ data using the visual workflow in the CloverDX data integration tool.
-
Build Grafana-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Grafana data and build Grafana-connected web apps with Axios.
-
Connect to Jira Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Jira Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Data Flows from HCL Domino to SQL Server using SSIS
Easily back up HCL Domino data to SQL Server using the SSIS components for HCL Domino.
-
Use the CData Software JDBC Driver for Outreach.io in MicroStrategy Desktop
Connect to Outreach.io data in MicroStrategy Desktop using the CData Software JDBC Driver for Outreach.io.
-
Choosing the Best Method to Connect PingOne to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PingOne data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Data Flows from Shortcut to SQL Server using SSIS
Easily back up Shortcut data to SQL Server using the SSIS components for Shortcut.
-
Connect to Notion Data in RapidMiner
Integrate Notion data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Teradata Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Teradata as an External Source in Dremio.
-
Connect to Spotify Data from PowerBuilder via ADO.NET
This article demonstrates how to access Spotify data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to MarkLogic Data from a Connection Pool in Jetty
The MarkLogic JDBC Driver supports connection pooling: This article shows how to connect faster to MarkLogic data from Web apps in Jetty.
-
How to Access Live SharePoint Excel Services Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SharePoint Excel Services enables you to integrate SharePoint Excel Services data into workflows built using Microsoft Power Automate Desktop.
-
Build AdRoll-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live AdRoll data.
-
Build Oracle Financials Cloud Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Financials Cloud data and build visualizations in Tableau.
-
Integrating Claude Code CLI with Grafana 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 update SAP Concur from Excel
This article explains how to transfer data from Excel to SAP Concur using the Excel Add-In for SAP Concur.
-
Interact with Live SAP Ariba Procurement Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP Ariba Procurement data.
-
Integrating Claude Code with Dynamics NAV Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Dynamics NAV data within assisted coding and automated development workflows.
-
Write a Simple Go Application to work with HubSpot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to HubSpot data.
-
Create Airtable Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Airtable data access from reports, embedded analytics, and more.
-
Build Visualizations of Teamwork Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Teamwork data in Birst.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy Web
Connect to SAS xpt data in MicroStrategy Web using the CData Software ODBC Driver for SAS xpt.
-
Working with Amazon S3 Data in LINQPad
Execute LINQ queries to Amazon S3 data in LINQPad.
-
Connect and Query Live Office 365 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Office 365 data into Databricks and enable direct, live querying and analysis without replication.
-
Model, Search, and Visualize Live Excel Online Data in ThoughtSpot
Use CData Connect AI to connect to live Excel Online data for modeling, searching, and visualizing.
-
Connect to Elorus Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Elorus and the SQL Gateway to access Elorus data from Google Apps Script.
-
How to Work with Instantly Data in AWS Glue Jobs Using JDBC
Connect to Instantly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Migrating data from Instagram to Snowflake using CData SSIS Components.
Easily push Instagram data to Snowflake using the CData SSIS Tasks for Instagram and Snowflake.
-
Integrate Live HDFS 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 HDFS data from within the IDE.
-
Use the CData Software ODBC Driver for Salesforce Marketing in MicroStrategy Web
Connect to Salesforce Marketing data in MicroStrategy Web using the CData Software ODBC Driver for Salesforce Marketing.
-
Explore Geographical Relationships in Confluence Data with Power Map
Create data visualizations with Confluence data in Power Map.
-
Use Biml to Build SSIS Tasks to Replicate Moosend Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Moosend data to SQL Server.
-
Connect to Certinia Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Certinia and the Script function in FileMaker Pro to connect to Certinia and work with Certinia data in your FileMaker application.
-
Access Mailgun Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mailgun data from your Oracle system.
-
Link Datadog with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Datadog data in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time Zoho Recruit Data in Power BI Report Server
Use the CData ODBC Driver for Zoho Recruit to visualize Zoho Recruit data in Power BI Desktop and then publish them to Power BI Report Server.
-
Feed Jira Assets Data into FineReport
How to set Jira Assets data as a JDBC data source in FineReport.
-
Connect to Sybase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sybase data using standard SQL.
-
Analyze Basecamp Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Basecamp data and visualize Basecamp data in SAP Analytics Cloud.
-
Connect to GitLab Data in RapidMiner
Integrate GitLab data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Tableau Connector for Salesforce Pardot
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesforce Pardot.
-
Query Zoho Inventory Data in DataGrip
Create a Data Source for Zoho Inventory in DataGrip and use SQL to query live Zoho Inventory data.
-
Analyze Live ZohoExpense Data in SAS Viya
Use CData Connect AI to connect to ZohoExpense data from SAS Viya and deploy self-service analytics using live ZohoExpense data.
-
Process & Analyze Access Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Access Data.
-
Use the CData Software ODBC Driver for QuickBooks in MicroStrategy
Connect to QuickBooks data in MicroStrategy Developer using the CData Software ODBC Driver for QuickBooks.
-
Create PabblySubscriptions Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PabblySubscriptions data access from reports, embedded analytics, and more.
-
Create Informatica Mappings From/To an ODBC Data Source for Webex
Create an ODBC connection to Webex in Informatica and browse and transfer Webex data.
-
Build Data Flows from Webex to SQL Server using SSIS
Easily back up Webex data to SQL Server using the SSIS components for Webex.
-
Connect to QuickBooks Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for QuickBooks data in Airbyte.
-
Creating Zendesk-Connected Applications in Unqork
You can use CData Connect AI to feed Zendesk data to Unqork and build custom business apps.
-
Connect to Testmonitor Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Testmonitor data from Filemaker Pro on Mac.
-
Connect to Azure Analysis Services Data in HULFT Integrate
Connect to Azure Analysis Services as a JDBC data source in HULFT Integrate
-
How to connect to Certinia Data from Spring Boot
Connect to Certinia in a Spring Boot Application using the CData JDBC Driver for Certinia
-
Connect to Azure Synapse Data from a Connection Pool in JBoss
Integrate Azure Synapse data into Java servlets: Use the Management Console in JBoss to install the Azure Synapse JDBC Driver.
-
How to connect to Zuora Data in DBVisualizer
Integrate Zuora data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Guru in SpagoBI
Create reports featuring live Guru data in SpagoBI Studio. Host Guru reports on SpagoBI Server.
-
Use Manus AI to Talk to Your Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Calendar data.
-
How to Connect to LDAP Objects in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LDAP objects. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for Sage 200 in MicroStrategy
Connect to Sage 200 data in MicroStrategy Developer using the CData Software ODBC Driver for Sage 200.
-
Replicate Parquet Data to Multiple Databases
Replicate Parquet data to disparate databases with a point-and-click configuration.
-
Easily Integrate Anaplan Data in Lazarus Pascal IDE
Learn how to easily integrate live Anaplan data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Power BI Connector for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Service Cloud.
-
How to Build an ETL App for Bright Data Data in Python with CData
Create ETL applications and real-time data pipelines for Bright Data data in Python with petl.
-
Work with HelloSign Data in FoxPro
Load HelloSign data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate PayPal Data in the Pentaho Report Designer
Publish reports based on PayPal data in the Pentaho BI tool.
-
A PostgreSQL Interface for Helpscout Data (MySQL Remoting via JDBC)
Use the Remoting features of the Helpscout JDBC Driver to create a PostgreSQL entry-point for data access.
-
Creating XML-Connected Applications in Unqork
You can use CData Connect AI to feed XML data to Unqork and build custom business apps.
-
Connect to Mailgun Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Mailgun Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use CData Connect AI to Access Freshteam Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Freshteam data in the Power Pivot business intelligence tool.
-
Access Live Oracle Eloqua Data in TIBCO Data Virtualization
Use the Oracle Eloqua Tibco DV Adapter to create a Oracle Eloqua data data source in TIBCO Data Virtualization Studio and gain access to live Oracle Eloqua data from your TDV Server.