CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SuiteCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Databricks.
-
Automated Continuous BambooHR Replication to Vertica
Use CData Sync for automated, continuous, customizable BambooHR replication to Vertica.
-
Connect to Copper Data in HULFT Integrate
Connect to Copper as a JDBC data source in HULFT Integrate
-
Import Real-Time Okta Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Okta data in ColdFusion.
-
How to Work with ServiceDesk Plus Data in AWS Glue Jobs Using JDBC
Connect to ServiceDesk Plus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to PabblySubscriptions Data in RapidMiner
Integrate PabblySubscriptions data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Manus AI to Talk to Your Epicor Kinetic 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 Epicor Kinetic data.
-
Access Live Reckon Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Reckon data from your Excel spreadsheets.
-
Seamlessly Bring Xero Data into Retool Using CData Connect AI
Integrate Xero data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Zoom-Connected Applications in Appsmith
Connect to Zoom Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zoom data.
-
How to Connect to Live Klaviyo 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 Klaviyo data without replication.
-
Use ChatGPT to Talk to Your MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MarkLogic data for you.
-
Access Live Xero Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Xero data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Tavily Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Tavily data from HeidiSQL.
-
Integrate Live Azure Data Lake Storage Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Data Lake Storage from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Data Lake Storage data.
-
Integrate Microsoft Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Ads with External Services.
-
Use Manus AI to Talk to Your Lakebase 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 Lakebase data.
-
View Reports on Real-Time Act CRM Data in Power BI Report Server
Use the CData ODBC Driver for Act CRM to visualize Act CRM data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to import JotForm Data into Apache Solr
Use the CData Software JDBC Driver for JotForm in Data Import Handler and create an automated import of JotForm data to Apache Solr Enterprise Search platform.
-
How to Connect Flowise AI Agents to Live Azure DevOps 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 Azure DevOps data without replication.
-
Create Jumpseller-Connected Applications in Appsmith
Connect to Jumpseller Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Jumpseller data.
-
Extract, Transform, and Load Google Calendar Data in Informatica PowerCenter
Create a simple Workflow for Google Calendar data in Informatica PowerCenter.
-
Automate Hugging Face Data Replication to SAP HANA
Use CData Sync to customize and automate Hugging Face data replication to SAP HANA.
-
ClickTime Reporting in OBIEE with the ClickTime JDBC Driver
Deploy the ClickTime JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Adobe Target-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Adobe Target Data and create custom apps in Bubble.
-
Access Factorial Data from MySQL in PHP
Connect to Factorial through the standard MySQL libraries in PHP.
-
Analyze LDAP Objects in R via JDBC
Use standard R functions and the development environment of your choice to analyze LDAP objects with the CData JDBC Driver for LDAP.
-
Build Automated Workflows with Live Klipfolio Data in Workato
Use CData Connect AI to connect to live Klipfolio data and build automated workflows in Workato.
-
How to create an RPA flow for SparkPost Data in UiPath Studio
Use the SparkPost ODBC Driver to create workflows that access real-time SparkPost data without any coding.
-
How to Connect to Live Google Forms Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Forms data for you.
-
Visualize Google Tasks Data in Tableau
The CData ODBC driver for Google Tasks enables you integrate Google Tasks data into Tableau dashboards.
-
Operational Reporting on Helpscout Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Helpscout data.
-
Connect to Access Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Access to connect to Access data and execute queries in PowerBuilder.
-
Create SpaceX Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SpaceX data access from reports, embedded analytics, and more.
-
Connect to Oracle HCM Cloud Data in Aqua Data Studio
Access Oracle HCM Cloud data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to SingleStore Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SingleStore data.
-
How to connect to JotForm Data in DBVisualizer
Integrate JotForm data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Google Contacts Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Contacts data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for Azure Synapse in MicroStrategy Web
Connect to Azure Synapse data in MicroStrategy Web using the CData Software ODBC Driver for Azure Synapse.
-
Connect to Greenhouse Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Greenhouse data in Airbyte.
-
Connect to Real-Time Billsby Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Billsby data in Power Apps.
-
Getting Started with the CData Tableau Connector for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Campaign Manager 360.
-
Access Live OData Services 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 OData services through MCP integration.
-
LINQ to Email Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Email Data Provider.
-
Access Live Dynamics NAV 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 Dynamics NAV data through MCP integration.
-
Work with Live Authorize.Net Data in Power Query
Use CData Connect AI to connect to Authorize.Net data and work with live Authorize.Net data in Microsoft Power Query.
-
Automated Continuous Gumroad Replication to MongoDB
Use CData Sync for automated, continuous, customizable Gumroad replication to MongoDB.
-
Validate Float Data with QuerySurge
Access and validate Float data in QuerySurge using the CData JDBC Driver.
-
How to Seamlessly Import IBM Informix Data into IBM SPSS Modeler
Integrate IBM Informix data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Establish a Live Connection with Tanda Data using Tableau Bridge
The CData ODBC Driver for Tanda enables you to integrate live Tanda data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Boomi Agentstudio with Power BI XMLA Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Power BI XMLA data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Todoist Replication to Vertica
Use CData Sync for automated, continuous, customizable Todoist replication to Vertica.
-
Search External Mailgun Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Mailgun data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Mailgun Data objects that you can access from apps and the dashboard.
-
Create SSAS Tabular Models from Unbounce Data
How to build a SQL Server Analysis Service Tabular Model from Unbounce data using CData drivers.
-
How to Connect DBeaver to Oracle SCM via a JDBC Driver
Manage Oracle SCM data with visual tools in DBeaver like the query browser.
-
How to connect and process Unbounce data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Unbounce data.
-
Build Apps with Live Accelo Data Using the Low-Code Development Platform of Mendix
Connect Accelo data with Mendix to build apps using the CData API Driver for JDBC.
-
Work with Google Translate Data in FoxPro
Load Google Translate data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect the Power BI Service to SAP BusinessObjects BI: Complete Guide
Connect to the CData Software Power BI Connector for SAP BusinessObjects BI from PowerBI.com to provide real-time SAP BusinessObjects BI data across the organization.
-
Create Datasets from Demio in Domo Workbench and Build Visualizations of Demio Data in Domo
Use the CData Software ODBC Driver for Demio to create datasets from Demio data in Domo Workbench and then build visualizations in the Domo service.
-
Publish Microsoft Exchange-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Exchange data.
-
Import and Visualize Amazon Athena Data in Power View
Create data visualizations based on Amazon Athena data in Excel.
-
Model, Search, and Visualize Live PolarTeamPro Data in ThoughtSpot
Use CData Connect AI to connect to live PolarTeamPro data for modeling, searching, and visualizing.
-
Connect to PDFMonkey Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to PDFMonkey and work with PDFMonkey data in your FileMaker application.
-
Write a Simple Go Application to work with FreeAgent Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to FreeAgent data.
-
How to load Google Ad Manager data into Elasticsearch via Logstash
Introducing a simple method to load Google Ad Manager data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Guru-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Guru data.
-
Migrating data from SAP SuccessFactors LMS to Google BigQuery using CData SSIS Components.
Easily push SAP SuccessFactors LMS data to Google BigQuery using the CData SSIS Tasks for SAP SuccessFactors LMS and Google BigQuery.
-
How to Connect Zoho CRM 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 Zoho CRM data in real time using natural language.
-
Automated Continuous IBM Cloud Object Storage Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Apache Cassandra.
-
Build AI Agents with Adobe Experience Manager Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Adobe Experience Manager data through CData Connect AI.
-
Build JotForm-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to JotForm data and build web apps with connectivity to live JotForm data.
-
eBay Reporting in OBIEE with the eBay JDBC Driver
Deploy the eBay JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Boomi Agentstudio with PayPal Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to PayPal data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Dashboards with Gorgias Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gorgias data in Dundas BI.
-
Integrate Lakebase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Lakebase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Lakebase data.
-
Create Reports with Oracle SCM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle SCM data.
-
How to Connect Salesforce Marketing 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 Salesforce Marketing data in real time using natural language.
-
How to connect to PingOne Data with Squirrel SQL client
Connect to PingOne data and execute queries in the Squirrel SQL Client.
-
Create Okta-Connected Dashboards in Grafana
Connect to Okta Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Okta data.
-
Import Sage Intacct Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sage Intacct Data and provide access to live Sage Intacct data for custom reports in the Power BI Service.
-
How to Seamlessly Import SAP Fieldglass Data into IBM SPSS Modeler
Integrate SAP Fieldglass data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Charts with Bullhorn CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Bullhorn CRM data in Clear Analytics.
-
Connect to CircleCI Data in DBeaver
Use the CData ODBC Driver to connect to CircleCI data in DBeaver.
-
Integrate Live Marketo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Marketo data to Blue Prism using the CData ODBC Driver for Marketo to create automated workflows for repetitive business tasks.
-
Connect to JobNimbus from a Connection Pool in WebLogic
Use the CData JDBC Driver for JobNimbus to connect to JobNimbus data from Web applications running on WebLogic.
-
Connect to Live Yelp Data in MicroStrategy through CData Connect AI
Create a live connection to Yelp Data in CData Connect AI and connect to your Yelp data from MicroStrategy.
-
Connect to Avro Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Avro data in Airbyte.
-
Create a Data Access Object for Flowlu Data using JDBI
A brief overview of creating a SQL Object API for Flowlu data in JDBI.
-
Create Informatica Mappings From/To an ODBC Data Source for Coda
Create an ODBC connection to Coda in Informatica and browse and transfer Coda data.
-
Build Pipedrive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Pipedrive data and build Pipedrive-connected web apps with Axios.
-
Connect to Google Sheets Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Sheets Data and connect to Google Sheets data in Akorbi Digital RunMyProcess.
-
Access Live Azure Table Data in Excel 365 Online (Excel for the web)
Connect to Azure Table data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Informatica Mappings From/To an ODBC Data Source for Redshift
Create an ODBC connection to Redshift in Informatica and browse and transfer Redshift data.
-
Query Beeminder Data in DataGrip
Create a Data Source for Beeminder in DataGrip and use SQL to query live Beeminder data.
-
Integrate TaxJar Data into Power Automate Desktop using CData Connect
CData Connect for TaxJar Data enables you to integrate TaxJar data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Cassandra Data in Claris FileMaker Pro
Use the CData ODBC Driver for Cassandra in FileMaker Pro to connect to Cassandra and work with Cassandra data in your FileMaker applications.
-
Integrating Helpscout Data in Talend Cloud Data Management Platform
Connect Helpscout Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to create Visio diagrams from SuiteCRM Data
Automatically update SuiteCRM data with the changes you make to Visio master shapes.
-
Visualize Live AfterShip Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live AfterShip data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.