CData Software - Knowledge Base
Recent Articles
-
Connect to QuickBooks from a Connection Pool in WebLogic
Use the CData JDBC Driver for QuickBooks to connect to QuickBooks Desktop from Web applications running on WebLogic.
-
Integrating Gumloop with Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Creator within automated workflows.
-
Getting Started with the CData SSIS Components for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoPeople.
-
Excel Spreadsheet Automation on Suadeo Data with the QUERY Formula
Pull data from Suadeo, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Salesforce Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesforce & Force.com replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Tableau Connector for SAP Concur
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Concur.
-
Access ActiveCampaign 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 ActiveCampaign.
-
How to Connect to & Open SuiteCRM Data in Microsoft Excel
This article uses the CData ODBC driver for SuiteCRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Dataiku with Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon Redshift.
-
Use the CData Software ODBC Driver for Todoist in SAS for Real-Time Reporting and Analytics
Connect to real-time Todoist in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Todoist.
-
Connect to Live Square Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Square in CData Connect AI and connect to your Square from PostgreSQL.
-
Connect to Google Spanner Data from AWS Glue
Use CData Connect AI to gain access to live Google Spanner from your AWS Glue jobs.
-
Access Odoo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Odoo ERP from your Oracle system.
-
Access Live Freshservice Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Freshservice into the statistical analysis tools available in SAS JMP. This article shows how to use Freshservice in the Graph Builder and Query Builder.
-
Connect Shortcut to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Shortcut using the CData Python MCP Server.
-
How to load Splunk data into Elasticsearch via Logstash
Introducing a simple method to load Splunk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Automated Act-On-Connected Workflows in Zapier
Use CData Connect AI to connect to live Act-On and build automated workflows in Zapier.
-
Back Up CockroachDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CockroachDB. In this article, we will employ an SSIS workflow to populate a database with CockroachDB data.
-
Back Up QuickBooks Desktop to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for QuickBooks. In this article, we will employ an SSIS workflow to populate a database with QuickBooks Desktop data.
-
Import Real-Time Oracle Service Cloud Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Service Cloud in ColdFusion.
-
Integrate Adobe Experience Manager Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Adobe Experience Manager from Informatica Cloud.
-
Build Semantic Layer Views for Cosmos DB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Cosmos DB.
-
Validate SAP SuccessFactors LMS Data with QuerySurge
Access and validate SAP SuccessFactors LMS in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Greenplum Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Pivotal GreenPlum for you.
-
Automate Smartsheet Data Replication to Azure Synapse
Use CData Sync to customize and automate Smartsheet replication to Azure Synapse.
-
Use Claude to Talk to Your Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Apache Avro for you.
-
CData AWS Glue Connector for Salesforce Deployment Guide
A detailed deployment and usage guide for the CData AWS Glue Connector for Salesforce
-
Automated Continuous Todoist Replication to SQL Server
Use CData Sync for automated, continuous, customizable Todoist replication to SQL Server.
-
Build AI/ML Models with Live Customer.io Data using Dataiku
Connect Customer.io Data with Dataiku using the CData API Driver for JDBC.
-
A PostgreSQL Interface for Coda Data (MySQL Remoting via JDBC)
Use the Remoting features of the Coda JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Quaderno Data with Squirrel SQL client
Connect to Quaderno and execute queries in the Squirrel SQL Client.
-
Prepare, Blend, and Analyze Oracle HCM Cloud Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle HCM Cloud for self-service data analytics.
-
Integrating LangGraph with FTP Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on FTP Servers within automated workflows.
-
Automated Continuous HubSpot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable HubSpot replication to Apache Cassandra.
-
Build Act-On-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Act-On and build Act-On-connected web apps with Axios.
-
Build Charts with Avalara AvaTax Data in Clear Analytics
Create dynamic charts and perform analytics based on Avalara AvaTax in Clear Analytics.
-
Use JayDeBeApi to access QuickBooks Data in Python
Use standard Python scripting and the development environment of your choice to access live QuickBooks Desktop.
-
DataBind Wrike Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Wrike to a chart.
-
Visualize Live Printful Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Printful.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Excel
Provide connectivity to Microsoft Excel through an SAP BusinessObjects universe.
-
Connect to Mailgun Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mailgun in the Denodo Virtual DataPort Administrator.
-
Automated Continuous BigCommerce Replication to Vertica
Use CData Sync for automated, continuous, customizable BigCommerce replication to Vertica.
-
Build Visualizations of Bitly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bitly in Birst.
-
Connect to Attio Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Attio using standard SQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Ad Manager
Create Google Ad Manager data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure Analysis Services to Power BI dashboards. Simply drag and drop Azure Analysis Services into data visuals on the Power BI canvas.
-
Access Live AlloyDB Data in AWS Lambda
Connect to live Google AlloyDB in AWS Lambda using the CData JDBC Driver.
-
Build IBM Cloud Object Storage-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for IBM Cloud Object Storage to explore live IBM Cloud Object Storage Data in GitHub Copilot to assist with building IBM Cloud Object Storage-powered applications.
-
Replicate Multiple Basecamp Accounts via the CData Sync CLI
Replicate multiple Basecamp accounts to one or many databases.
-
Build MVC Applications with Connectivity to Close Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Close from an ASP.NET MVC application.
-
Connect to Amazon S3 Data in Google Apps Script via Connect AI
Use CData Connect AI to access Amazon S3 in Google Apps Script.
-
Replicate Shortcut Data in Heroku for Use in Salesforce Connect
Replicate Shortcut to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zoho Books to Power BI dashboards. Simply drag and drop Zoho Books into data visuals on the Power BI canvas.
-
Connect CloudConvert to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CloudConvert with IBM WebSphere for seamless data integration and connectivity.
-
Create Splunk-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Splunk Data from Klipfolio and build custom visualizations using live Splunk.
-
Bridge Klipfolio Connectivity with Apache NiFi
Access and process Klipfolio in Apache NiFi using the CData JDBC Driver.
-
Connect to Excel Online Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Excel Online.
-
Create SSAS Tabular Models from Office 365 Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Office 365 using CData drivers.
-
Integrate with Salesforce CRM Analytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce CRM Analytics in SnapLogic.
-
Getting Started with the CData ODBC Driver for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Amazon DynamoDB.
-
Build Data Flows from SQL Server to Microsoft Entra ID through SSIS
Easily push SQL Server data to Microsoft Entra ID using the CData SSIS Tasks for Microsoft Entra ID.
-
Connect to Calendly Data in DBeaver
Use the CData ODBC Driver to connect to Calendly in DBeaver.
-
Getting Started with the CData Tableau Connector for Qualaroo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Working with SAP HANA XS Advanced Data in LINQPad
Execute LINQ queries to SAP HANA XS Advanced in LINQPad.
-
Automate Confluence Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Atlassian Confluence from PowerShell? This article demonstrates how to utilize the Confluence Cmdlets for tasks like connecting to Atlassian Confluence, automating operations, downloading data, and more.
-
Automate Calendly Data Replication to SAP HANA
Use CData Sync to customize and automate Calendly replication to SAP HANA.
-
Connect to Microsoft Teams Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Teams to connect to Microsoft Teams and execute queries in PowerBuilder.
-
Visualize Live Gong Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Gong into custom reports in Power BI.
-
Consume Azure DevOps OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure DevOps feeds that reflect any changes in SAP Lumira.
-
Visualize MariaDB Data in Tableau
The CData ODBC driver for MariaDB enables you integrate MariaDB into Tableau dashboards.
-
How to Build an ETL App for Azure Data Lake Storage Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Data Lake Storage in Python with petl.
-
Bridge Sentry Connectivity with Apache NiFi
Access and process Sentry in Apache NiFi using the CData JDBC Driver.
-
Connect to Basecamp from Asprova with CData Software ODBC Driver for Basecamp
This article shows how to connect faster to Basecamp data from Asprova.
-
Access Live Oracle Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Database from your Excel spreadsheets.
-
Visualize EmailOctopus Data in TIBCO Spotfire through ADO.NET
Integrate EmailOctopus into dashboards in TIBCO Spotfire.
-
How to Connect DBeaver to Notion via a JDBC Driver
Manage Notion with visual tools in DBeaver like the query browser.
-
How to create Adobe Target federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Adobe Target in MySQL .
-
Automated Basecamp Data Replication to Teradata
Use CData Sync to Customize and automate Basecamp replication to Teradata.
-
Connect to AlloyDB Data in RapidMiner
Integrate Google AlloyDB with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Instantly
Create Instantly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Highrise Data in ColdFusion
Write standard ColdFusion data access code to connect to Highrise CRM.
-
Prepare, Blend, and Analyze Bright Data Data in Alteryx Designer (ODBC)
Build workflows to access live Bright Data for self-service data analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Smartsheet
Provide connectivity to Smartsheet through an SAP BusinessObjects universe.
-
How to load CSV data into Elasticsearch via Logstash
Introducing a simple method to load CSV data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Microsoft OneLake Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Apache Kafka.
-
How to Connect to Live BigCommerce Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your BigCommerce through natural language.
-
Integrate Live Pipedrive Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pipedrive to Blue Prism using the CData ODBC Driver for Pipedrive to create automated workflows for repetitive business tasks.
-
Connect to SAP Business One from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Business One, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Claude Code CLI with ConvertKit 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.
-
Model Dynamics CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics CRM, enabling the direct import of real-time Microsoft Dynamics CRM.
-
Create Quickbase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Quickbase data access from reports, embedded analytics, and more.
-
Access Live Figshare Data in AWS Lambda
Connect to live Figshare in AWS Lambda using the CData JDBC Driver.
-
Integrate with Live Zoho Books Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoho Books from the MuleSoft Anypoint Platform to integrate live Zoho Books into custom reports and dashboards.
-
Integrate with live Asana Data in Jitterbit
Use CData Connect AI to connect to and integrate live Asana in Jitterbit.
-
Integrating LangChain with Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apache Avro within automated workflows.
-
Connect to Azure Analysis Services Data in ACL Analytics
Connect to Azure Analysis Services via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure Analysis Services.
-
Use the CData Software ODBC Driver for Google Translate in MicroStrategy Web
Connect to Google Translate in MicroStrategy Web using the CData Software ODBC Driver for Google Translate.
-
Visualize SuiteCRM Data in TIBCO Spotfire through ADO.NET
Integrate SuiteCRM into dashboards in TIBCO Spotfire.
-
Design BIRT Reports on Zoho CRM Data
Provide current Zoho CRM to your embedded analytics.
-
Visualize Live Dynamics 365 Business Central Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Dynamics 365 Business Central using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.