CData Software - Knowledge Base
Recent Articles
-
How to publish and share Act-On Data dashboards with Tableau Server
The CData ODBC driver for Act-On enables you integrate Act-On data into Tableau dashboards.
-
Integrate Devin with Live Jumpseller 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 Jumpseller data.
-
Integrate with Live Anaplan Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Anaplan from the MuleSoft Anypoint Platform to integrate live Anaplan data into custom reports and dashboards.
-
Bridge Slack Connectivity with Apache NiFi
Access and process Slack data in Apache NiFi using the CData JDBC Driver.
-
Connect to Helpscout Data from a Connection Pool in JBoss
Integrate Helpscout data into Java servlets: Use the Management Console in JBoss to install the Helpscout JDBC Driver.
-
Integrate LibreChat with Live Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Klipfolio data from within the chat interface.
-
Viewing Dropbox Data in RAD Studio Data Explorer
How to view Dropbox data in RAD Studio Data Explorer using the CData ODBC Driver for Dropbox.
-
Replicate Multiple Rebilly Accounts
Replicate multiple Rebilly accounts to one or many databases.
-
Use the CData Software ODBC Driver for ZohoInvoice in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoInvoice data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoInvoice.
-
Integrate Live Salesforce Data 360 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce Data 360 data to Blue Prism using the CData ODBC Driver for Salesforce Data 360 to create automated workflows for repetitive business tasks.
-
Object-Relational Mapping (ORM) with Google Tasks Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Tasks data into a Java-based ORM framework, Hibernate.
-
Build Automated Workflows with Live Google Ads Data in Workato
Use CData Connect AI to connect to live Google Ads data and build automated workflows in Workato.
-
Feed JSON Services into FineReport
How to set JSON services as a JDBC data source in FineReport.
-
Query Live Google Spanner 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 Google Spanner data through a conversational interface.
-
Access Live SAP HANA XS Advanced 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 SAP HANA XS Advanced data through MCP integration.
-
Build a Singer.io Tap for Microsoft Entra ID With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Entra ID data using the CData Python Connector.
-
Connect to SAP Hybris C4C Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Hybris C4C in FileMaker Pro to connect to SAP Hybris C4C and work with SAP Hybris C4C data in your FileMaker applications.
-
How to Connect Flowise AI Agents to Live Xero Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Xero data without replication.
-
Access Live LightSpeedRetail Data in AWS Lambda (with IntelliJ IDEA)
Connect to live LightSpeedRetail data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate HubSpot Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to HubSpot data and integrate live HubSpot data into your Power Automate tasks.
-
Connecting Pipedream with Asana 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 Asana data in real time.
-
Automate WordPress Data Replication to Azure Data Lake
Use CData Sync to customize and automate WordPress data replication to Azure Data Lake.
-
How to import Google Forms Data into Apache Solr
Use the CData Software JDBC Driver for Google Forms in Data Import Handler and create an automated import of Google Forms data to Apache Solr Enterprise Search platform.
-
Integrate Salesforce Pardot Data in the Pentaho Report Designer
Publish reports based on Salesforce Pardot data in the Pentaho BI tool.
-
Stream Splunk Data into Apache Kafka Topics
Access and stream Splunk data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Guru-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Guru Data from Zoho Analytics and import live Guru data.
-
Connect to CouchDB Data in Jaspersoft Studio
Execute SQL to remote CouchDB data in Jaspersoft Studio.
-
Automate Hugging Face Data Replication to Azure Synapse
Use CData Sync to customize and automate Hugging Face data replication to Azure Synapse.
-
How to connect to Impala Data from Spring Boot
Connect to Impala in a Spring Boot Application using the CData JDBC Driver for Impala
-
Use Databricks Agent Bricks to Talk to Your Dynamics CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dynamics CRM data for you.
-
Integrate Live Sugar CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sugar CRM data to Blue Prism using the CData ODBC Driver for Sugar CRM to create automated workflows for repetitive business tasks.
-
Build SAP SuccessFactors LMS-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP SuccessFactors LMS Data and create custom apps in Mendix.
-
Model, Search, and Visualize Live Workday Data in ThoughtSpot
Use CData Connect AI to connect to live Workday data for modeling, searching, and visualizing.
-
Analyze ChartMogul Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ChartMogul from Power Pivot. You will use the Table Import Wizard to load ChartMogul data. You can visually build the import query or use any SQL supported by the driver.
-
Query Halo Service Desk Data in DataGrip
Create a Data Source for Halo Service Desk in DataGrip and use SQL to query live Halo Service Desk data.
-
Extract, Transform, and Load Oracle Service Cloud Data in Informatica PowerCenter
Create a simple Workflow for Oracle Service Cloud data in Informatica PowerCenter.
-
Import Real-Time Bitbucket Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bitbucket data in ColdFusion.
-
Replicate Omnisend Data to Multiple Databases
Replicate Omnisend data to disparate databases with a point-and-click configuration.
-
Automated Continuous Hive Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Hive replication to IBM DB2.
-
How to Access CircleCI Data Using Entity Framework
This article shows how to access CircleCI data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build EnterpriseDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live EnterpriseDB data and build visualizations in Tableau Cloud.
-
Visualize Aweber Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Aweber data.
-
Excel Spreadsheet Automation on Jodoo Data with the QUERY Formula
Pull data from Jodoo, automate spreadsheets, and more with the QUERY formula.
-
Create a Data Access Object for Wrike Data using JDBI
A brief overview of creating a SQL Object API for Wrike data in JDBI.
-
Getting Started with the CData ADO.NET Provider for Scrapfly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Live Quaderno Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Quaderno data.
-
Getting Started with the CData ADO.NET Provider for Vault CRM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Vault CRM.
-
How to Connect to Figshare Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Figshare data. Leverage the pyodbc module for ODBC in Python.
-
Stream Airtable Data into Apache Kafka Topics
Access and stream Airtable data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Perform Batch Operations with Couchbase Data in Apache NiFi
Connect to Couchbase data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to AgileCRM Data in DBArtisan
Use wizards in DBArtisan to configure AgileCRM data as a data source.
-
Access Live DocuSign 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 DocuSign data through MCP integration.
-
Getting Started with the CData ADO.NET Provider for Sage 200
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sage 200.
-
Connect to Apify Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apify data in Airbyte.
-
How to connect SharePoint with Airtable Data through external lists
Provide Airtable data to SharePoint users as an external list.
-
View Reports on Real-Time Teamgate Data in Power BI Report Server
Use the CData ODBC Driver for Teamgate to visualize Teamgate data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build an OLAP Cube in SSAS from Scrapfly Data
Establish a connection to Scrapfly data data from SQL Server Analysis Services, and use the Scrapfly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Kiro with Chargebee 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.
-
Integrate OpenCode with Live Zoho Books Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zoho Books data from within your AI coding agent.
-
Connect to HBase Data from AWS Glue
Use CData Connect AI to gain access to live HBase data from your AWS Glue jobs.
-
Query Live Microsoft Planner 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 Microsoft Planner data through a conversational interface.
-
Automated Shippo Data Replication to Teradata
Use CData Sync to Customize and automate Shippo data replication to Teradata.
-
Replicate Multiple ClickTime Accounts via the CData Sync CLI
Replicate multiple ClickTime accounts to one or many databases.
-
Integrating LangGraph with Act CRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Act CRM data within automated workflows.
-
ETL Factorial in Oracle Data Integrator
This article shows how to transfer Factorial data into a data warehouse using Oracle Data Integrator.
-
Excel Spreadsheet Automation on Sage Intacct Data with the QUERY Formula
Pull data from Sage Intacct, automate spreadsheets, and more with the QUERY formula.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Ad Manager
Create an ODBC connection to Google Ad Manager in Informatica and browse and transfer Google Ad Manager data.
-
Automated Continuous Amazon DynamoDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Snowflake.
-
Integrating Antigravity CLI with Hacker News data via CData CLI
Connect Hacker News data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build MVC Applications with Connectivity to CockroachDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CockroachDB from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for Google Drive in MicroStrategy Web
Connect to Google Drive data in MicroStrategy Web using the CData Software ODBC Driver for Google Drive.
-
Build Semantic Layer Views for Reckon Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Reckon data.
-
Connect and Visualize Live MailChimp Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MailChimp data into the Databricks platform and create visualization dashboards with real-time MailChimp data.
-
Analyze Amazon S3 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Amazon S3 from Power Pivot. You will use the Table Import Wizard to load Amazon S3 data. You can visually build the import query or use any SQL supported by the driver.
-
Replicate Freshteam Data to Multiple Databases
Replicate Freshteam data to disparate databases with a point-and-click configuration.
-
Query RabbitMQ Data in DataGrip
Create a Data Source for RabbitMQ in DataGrip and use SQL to query live RabbitMQ data.
-
Build Microsoft Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Ads data and build web apps with connectivity to live Microsoft Ads data.
-
Build Google Spanner-Connected Apps in Choreo
Use CData Connect AI to connect to Google Spanner Data from Choreo and build custom apps using live Google Spanner data.
-
Create Informatica Mappings From/To a JDBC Data Source for Greenplum
Create Greenplum data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous TaxJar Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable TaxJar replication to Google BigQuery.
-
Use Azure AI Foundry to Talk to Your Zoho Creator 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 Zoho Creator data for you.
-
Create Reports from ZohoDesk Data in Looker Studio
Use CData Connect AI to gain access to live ZohoDesk data and create custom reports in Looker Studio.
-
How to Easily Query Oracle Data in OpenOffice Base
Connect to Oracle data in OpenOffice Base using the CData ODBC Driver for Oracle and generate reports with live data insights.
-
Integrate Google Forms Data in the Pentaho Report Designer
Publish reports based on Google Forms data in the Pentaho BI tool.
-
Access Live IBM Cloud Object Storage Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to IBM Cloud Object Storage data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Rapidly Develop Instantly-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Instantly.
-
Interact with Live Twitter Ads Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Twitter Ads data.
-
Query Jodoo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Jodoo data from Node.js.
-
How to Visualize Zoho Creator 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 Zoho Creator data in Python.
-
Connect and Query Live SAP Business One Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Business One data into Databricks and enable direct, live querying and analysis without replication.
-
Choosing the Best Method to Connect Landbot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Landbot data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous ElevenLabs Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ElevenLabs replication to AlloyDB.
-
Use the CData Software ODBC Driver for Templated in MicroStrategy
Connect to Templated data in MicroStrategy Developer using the CData Software ODBC Driver for Templated.
-
Connect to Hive Data in JRuby
Create a simple JRuby app with access to live Hive data.
-
Connect to WordPress Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to WordPress.
-
Back Up ActiveCampaign data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ActiveCampaign. In this article, we will employ an SSIS workflow to populate a database with ActiveCampaign data data.
-
Integrating Gumloop with Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sage Cloud Accounting data within automated workflows.
-
How to Query Zoho Recruit Data in MySQL Workbench
Execute MySQL queries against live Zoho Recruit data from MySQL Workbench.
-
Access Live Sugar CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sugar CRM data into the statistical analysis tools available in SAS JMP. This article shows how to use Sugar CRM data in the Graph Builder and Query Builder.
-
Integrating Kiro with Instantly 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.