CData Software - Knowledge Base
Recent Articles
-
Replicate Multiple CampaignMonitor Accounts via the CData Sync CLI
Replicate multiple CampaignMonitor accounts to one or many databases.
-
Integrate Drip Data in Pentaho Data Integration
Build ETL pipelines based on Drip in the Pentaho Data Integration tool.
-
Connect to HelloSign in SpagoBI
Create reports featuring live HelloSign in SpagoBI Studio. Host HelloSign reports on SpagoBI Server.
-
Connect to JDBC-ODBC Bridge Data in JRuby
Create a simple JRuby app with access to live JDBC-ODBC Bridge.
-
Analyze Salesloft Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Salesloft and visualize live Salesloft in Infragistics Reveal.
-
Publish Reports with Notion Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Notion.
-
Integrate with SAP SuccessFactors Data in JReport Designer
Create charts and reports based on SAP SuccessFactors in JReport Designer.
-
Build Instagram-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Instagram to explore live Instagram Data in Gemini Code Assist to assist with building Instagram-powered applications.
-
Connect to API Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with API Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Pipeline CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pipeline CRM from your Oracle system.
-
Visualize Live LDAP Objects in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LDAP.
-
Automated Continuous Square Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Square replication to OneLake in Microsoft Fabric.
-
Import and Visualize HubDB Data in Power View
Create data visualizations based on HubDB in Excel.
-
Create Blackbaud FE NXT-Connected Applications in Appsmith
Connect to Blackbaud FE NXT Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Blackbaud FE NXT.
-
Connect to Zoho Projects Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Projects in the Denodo Virtual DataPort Administrator.
-
Add BenchmarkEmail Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for BenchmarkEmail with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to & Open Delighted Data in Microsoft Excel
This article uses the CData ODBC driver for Delighted to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Excel Add-In for MariaDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MariaDB.
-
Replicate Multiple Paylocity Accounts
Replicate multiple Paylocity accounts to one or many databases.
-
Use the CData SSIS Components to Insert New or Update Existing Salesforce Marketing Records from SQL Server
Easily push SQL Server data to Salesforce Marketing using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce Marketing or update existing records with data from a SQL Server database.
-
Automate Google Tasks Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Tasks from PowerShell? This article demonstrates how to utilize the Google Tasks Cmdlets for tasks like connecting to Google Tasks, automating operations, downloading data, and more.
-
Provide OData Services of Oracle Eloqua Reporting Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Eloqua Reporting by developing a WCF Service Application.
-
How to connect SharePoint with Google Ad Manager Data through external lists
Provide Google Ad Manager to SharePoint users as an external list.
-
Process & Analyze Redis Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Redis Data.
-
Integrating SAP Hybris C4C Data in Talend Cloud Data Management Platform
Connect SAP Hybris C4C Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Hybris C4C.
-
Build a PostgreSQL Interface for Snapchat Ads Data using the CData JDBC Driver
Use the Remoting features of the Snapchat Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Cloudflare Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Cloudflare from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect YouTube Analytics 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 YouTube Analytics data in real time using natural language.
-
Access Retently Data from MySQL in PHP
Connect to Retently through the standard MySQL libraries in PHP.
-
Create Excel Online Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Excel Online data access from reports, embedded analytics, and more.
-
Integrate Live QuickBooks Online Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live QuickBooks Online to Blue Prism using the CData ODBC Driver for QuickBooks Online to create automated workflows for repetitive business tasks.
-
Connect to MariaDB from a Connection Pool in WebLogic
Use the CData JDBC Driver for MariaDB to connect to MariaDB from Web applications running on WebLogic.
-
How to connect PolyBase to OneNote
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft OneNote.
-
Replicate PostgreSQL Data to Multiple Databases via the CData Sync CLI
Replicate PostgreSQL to disparate databases with a single configuration.
-
Import Real-Time REST Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use REST in ColdFusion.
-
Connect to Google Contacts Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Contacts as an External Source in Dremio.
-
Connect to Oracle SCM from Asprova with CData Software ODBC Driver for Oracle SCM
This article shows how to connect faster to Oracle SCM data from Asprova.
-
Load Demio Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Demio to a database.
-
Connect to WooCommerce Data in DBArtisan
Use wizards in DBArtisan to configure WooCommerce as a data source.
-
How to Visualize Parquet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache Parquet in Python.
-
Migrating data from Google Drive to Databricks using CData SSIS Components.
Easily push Google Drive to Databricks using the CData SSIS Tasks for Google Drive and Databricks.
-
Host the API Server on Azure
Host the CData API Server in Microsoft Windows Azure to create always-on OData entrypoints for your data.
-
Manage ZohoSubscriptions Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZohoSubscriptions.
-
How to work with Bitbucket Data in Apache Spark using SQL
Access and process Bitbucket Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to and Query MessageBird Data in QlikView over ODBC
Create data visualizations with MessageBird in QlikView.
-
Build an OLAP Cube in SSAS from SharePoint Excel Services Data
Establish a connection to SharePoint Excel Services data from SQL Server Analysis Services, and use the SharePoint Excel Services Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Facebook Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Facebook from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate ConvertAPI Data in the Pentaho Report Designer
Publish reports based on ConvertAPI in the Pentaho BI tool.
-
Connect to Zoho Inventory Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zoho Inventory from Appeon PowerBuilder using the CData ADO.NET Provider for Zoho Inventory.
-
Automate Square Data Replication to SAP HANA
Use CData Sync to customize and automate Square replication to SAP HANA.
-
Connect to Intercom Data in CloverDX (formerly CloverETL)
Transfer Intercom using the visual workflow in the CloverDX data integration tool.
-
Connect to ZendeskSell in SpagoBI
Create reports featuring live ZendeskSell in SpagoBI Studio. Host ZendeskSell reports on SpagoBI Server.
-
Use the CData Software ODBC Driver for ClickUp in MicroStrategy Web
Connect to ClickUp in MicroStrategy Web using the CData Software ODBC Driver for ClickUp.
-
Bidirectional Access to Gumroad Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Gumroad in Filemaker Pro for Mac or Windows.
-
Bidirectional Access to Cassandra Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache Cassandra in Filemaker Pro for Mac or Windows.
-
How to Connect to Live Dynamics 365 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 Microsoft Dynamics 365 for you.
-
Configure the CData JDBC Driver for Bitbucket in a Connection Pool in Tomcat
Connect to Bitbucket from a connection pool in Tomcat.
-
Publish Reports with Chargebee Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Chargebee.
-
Connect to Figshare Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Analyze SAS Data Sets Data in Looker
Use CData Connect AI to connect to SAS Data Sets Data from Looker and build custom apps using live SAS Data Sets.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft Entra ID
Create Microsoft Entra ID data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Kintone from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Kintone, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Cloudflare Data in Ruby
Connect to Cloudflare in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Crystal Reports on Perplexity Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Perplexity.
-
Back Up SAS XPORT to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAS xpt. In this article, we will employ an SSIS workflow to populate a database with SAS XPORT data.
-
Connect to Certinia Data in Jaspersoft Studio
Execute SQL to remote Certinia in Jaspersoft Studio.
-
Automated Continuous Lakebase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Lakebase replication to delimited files (CSV/TSV).
-
How to Connect to Live Freshservice 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 Freshservice for you.
-
Automate Omnisend Data Replication to Azure Synapse
Use CData Sync to customize and automate Omnisend replication to Azure Synapse.
-
Integrate Live HBase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apache HBase and integrate live Apache HBase into apps built in Microsoft Power Apps.
-
Natively Connect to Clio Data in PHP
The CData ODBC driver for Clio enables you to create PHP applications with connectivity to Clio. Leverage the native support for ODBC in PHP.
-
Connect to PostgreSQL Data in NetBeans
Connect to PostgreSQL in NetBeans with the data source configuration wizard.
-
Integrating Claude Code CLI with RSS Feeds 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.
-
Integrating Claude Code with Monday.com Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Monday.com within assisted coding and automated development workflows.
-
Bidirectional Access to LaunchDarkly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LaunchDarkly in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData ODBC Driver for SharePoint
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SharePoint.
-
Connect to SharePoint Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Bidirectional Access to MailerLite Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MailerLite in Filemaker Pro for Mac or Windows.
-
Analyze Teradata Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Teradata in Microsoft R Open.
-
Access Live Google Campaign Manager 360 Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Google Campaign Manager 360 through MCP integration.
-
Replicate ConvertKit Data from PowerShell
Write a quick PowerShell script to query ConvertKit. Use connectivity to the live data to replicate ConvertKit to SQL Server.
-
Integrating Boomi Agentstudio with Confluence Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Atlassian Confluence, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build an OLAP Cube in SSAS from ZohoSubscriptions Data
Establish a connection to ZohoSubscriptions data from SQL Server Analysis Services, and use the ZohoSubscriptions Data Provider to build OLAP cubes for use in analytics and reporting.
-
Enable the Neo4J JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Neo4J.
-
Integrate Oracle Financials Cloud Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle Financials Cloud and integrate live Oracle Financials Cloud into your Power Automate tasks.
-
DataBind Charts to Sugar CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sugar CRM 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.
-
Access Live Microsoft Entra ID Data in AWS Lambda
Connect to live Microsoft Entra ID in AWS Lambda using the CData JDBC Driver.
-
Moving Data from CampaignMonitor to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CampaignMonitor data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize PhantomBuster Data in TIBCO Spotfire through ADO.NET
Integrate PhantomBuster into dashboards in TIBCO Spotfire.
-
Publish Reports with CouchDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache CouchDB.
-
Connect to Power BI XMLA Data in DBeaver
Use the CData ODBC Driver to connect to Power BI XMLA in DBeaver.
-
Access Active Directory 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 Active Directory.
-
How to Query Raisers Edge NXT Data in MySQL Workbench
Execute MySQL queries against live Raisers Edge NXT from MySQL Workbench.
-
Use the CData Software ODBC Driver for Slack in MicroStrategy
Connect to Slack in MicroStrategy Developer using the CData Software ODBC Driver for Slack.
-
Connect to Gong from a Connection Pool in WebLogic
Use the CData JDBC Driver for Gong to connect to Gong from Web applications running on WebLogic.
-
DataBind Amazon S3 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Amazon S3 with the DevExpress Windows Forms and Web controls to provide Amazon S3 to a chart.
-
How to load HDFS data into Elasticsearch via Logstash
Introducing a simple method to load HDFS data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Query Live Pipedrive Data in Perplexity MacOS Desktop
Connect to and query live Pipedrive Data in Perplexity Desktop using CData MCP Server.
-
DataBind Controls to Salesforce CRM Analytics Data in C++Builder
DataBind to Salesforce CRM Analytics in C++Builder with standard components and controls.
-
Integrating Kiro CLI with Autopilot 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.