CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ODBC Driver for Odoo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Odoo.
-
Access Live LDAP Objects in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live LDAP objects from your Excel spreadsheets.
-
Integrating Boomi Agentstudio with Dynamics 365 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Dynamics 365 data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Agents in Relevance AI with Access to Live Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Wistia data within intelligent agent workflows.
-
Automated Sybase IQ Data Replication to Teradata
Use CData Sync to Customize and automate Sybase IQ data replication to Teradata.
-
Connect to IBM Cloud Object Storage Data in Jaspersoft Studio
Execute SQL to remote IBM Cloud Object Storage data in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Notion in MicroStrategy Desktop
Connect to Notion data in MicroStrategy Desktop using the CData Software ODBC Driver for Notion.
-
Access Live Vertica 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 Vertica data through MCP integration.
-
Automated Continuous Shippo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Shippo replication to Amazon S3.
-
Connect to Snapchat Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live Snapchat Ads data from HeidiSQL.
-
How to connect and process Microsoft OneDrive data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft OneDrive data.
-
Use the CData Software JDBC Driver for Facebook Ads in MicroStrategy Desktop
Connect to Facebook Ads data in MicroStrategy Desktop using the CData Software JDBC Driver for Facebook Ads.
-
Connect to Apify Data from a Connection Pool in Jetty
The Apify JDBC Driver supports connection pooling: This article shows how to connect faster to Apify data from Web apps in Jetty.
-
Publish Telegram-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Telegram data.
-
Integrating Boomi Agentstudio with Neo4J Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Neo4J data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automate Marketo Data Replication to SAP HANA
Use CData Sync to customize and automate Marketo data replication to SAP HANA.
-
Replicate Xero Data to Multiple Databases via the CData Sync CLI
Replicate Xero data to disparate databases with a single configuration.
-
Automated Continuous Spotify Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Spotify replication to Amazon S3.
-
Use the CData Software JDBC Driver for ClickTime in MicroStrategy Desktop
Connect to ClickTime data in MicroStrategy Desktop using the CData Software JDBC Driver for ClickTime.
-
How to connect to Drip Data with Squirrel SQL client
Connect to Drip data and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce data through natural language.
-
Connect to ConvertAPI in SpagoBI
Create reports featuring live ConvertAPI data in SpagoBI Studio. Host ConvertAPI reports on SpagoBI Server.
-
Automated Continuous Short.io Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Short.io data replication to OneLake in Microsoft Fabric.
-
Create Data Visualizations Based On Paymo Data in Mode
Use CData Connect AI to connect to Paymo Data from Mode and build visualizations using live Paymo data.
-
Automated Continuous SAP Hybris C4C Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Snowflake.
-
Excel Spreadsheet Automation on Access Data with the QUERY Formula
Pull data from Access, automate spreadsheets, and more with the QUERY formula.
-
Integrate Harvest Data in the Pentaho Report Designer
Publish reports based on Harvest data in the Pentaho BI tool.
-
Query Amplitude Data in DataGrip
Create a Data Source for Amplitude in DataGrip and use SQL to query live Amplitude data.
-
Create Apps from CSV Data in Qlik Sense Cloud
Use CData Connect AI to connect to CSV Data and build apps from live CSV data in Qlik Sense Cloud.
-
Build Voice Agents in ElevenLabs with access to Live Google Campaign Manager 360 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Campaign Manager 360 data.
-
Access Live Oracle Service Cloud Data in Excel 365 Online (Excel for the web)
Connect to Oracle Service Cloud data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Datasets from Nuclia in Domo Workbench and Build Visualizations of Nuclia Data in Domo
Use the CData Software ODBC Driver for Nuclia to create datasets from Nuclia data in Domo Workbench and then build visualizations in the Domo service.
-
Choosing the Best Method to Connect Google Tasks to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Tasks data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Claude to Talk to Your Gmail 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 Gmail data for you.
-
Automated Continuous Mode Replication to SQL Server
Use CData Sync for automated, continuous, customizable Mode replication to SQL Server.
-
How to Query Live Xero Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Xero data data in natural language using Python.
-
How to Create Power BI Visual Reports with Real-Time Quickbase Data
Use CData Power BI Connectors to visualize Quickbase data in Power BI.
-
Access Live PostgreSQL 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 PostgreSQL data through MCP integration.
-
Getting Started with the CData JDBC Driver for Stripe
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Stripe.
-
How to create Foursquare federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Foursquare data in MySQL .
-
Bridge Mailjet Connectivity with Apache NiFi
Access and process Mailjet data in Apache NiFi using the CData JDBC Driver.
-
Visualize Mixpanel Data in TIBCO Spotfire through ADO.NET
Integrate Mixpanel data into dashboards in TIBCO Spotfire.
-
Moving Data from Dynamics NAV to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dynamics NAV data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SAP SuccessFactors Data from AWS Glue
Use CData Connect AI to gain access to live SAP SuccessFactors data from your AWS Glue jobs.
-
Working with SparkPost Data in LINQPad
Execute LINQ queries to SparkPost data in LINQPad.
-
Interact with Live Jumpseller Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Jumpseller data.
-
Create Datasets from Reckon in Domo Workbench and Build Visualizations of Reckon Data in Domo
Use the CData Software ODBC Driver for Reckon to create datasets from Reckon data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Salesforce Pardot Data in NetBeans
Connect to Salesforce Pardot data in NetBeans with the data source configuration wizard.
-
Consume HCL Domino OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HCL Domino feeds that reflect any changes in SAP Lumira.
-
ETL MailerSend in Oracle Data Integrator
This article shows how to transfer MailerSend data into a data warehouse using Oracle Data Integrator.
-
Visualize Oracle Sales Data in TIBCO Spotfire through OData
Integrate Oracle Sales data into dashboards in TIBCO Spotfire.
-
Connect to FTP from Asprova with CData Software ODBC Driver for FTP
This article shows how to connect faster to FTP data from Asprova.
-
Connect to Vimeo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Vimeo and work with Vimeo data in your FileMaker applications.
-
Integrate Simplesat Data in Pentaho Data Integration
Build ETL pipelines based on Simplesat data in the Pentaho Data Integration tool.
-
Query Paylocity Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Paylocity entities in PHP by modeling them as objects.
-
Prepare, Blend, and Analyze Sybase Data in Alteryx Designer (Connect AI)
Build workflows to access live Sybase data for self-service data analytics.
-
Connect to Gorgias Data in RapidMiner
Integrate Gorgias data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create an RPA flow for JobNimbus Data in UiPath Studio
Use the JobNimbus ODBC Driver to create workflows that access real-time JobNimbus data without any coding.
-
How to Easily Query Sage 300 Data in OpenOffice Base
Connect to Sage 300 data in OpenOffice Base using the CData ODBC Driver for Sage 300 and generate reports with live data insights.
-
Build SAS Data Sets-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAS Data Sets data.
-
How to create SpaceX federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SpaceX data in MySQL .
-
Integrate Google's Vertex AI Agent with Live Suadeo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Suadeo data within intelligent workflows.
-
Use the CData Software ODBC Driver for ConvertKit in MicroStrategy Desktop
Connect to ConvertKit data in MicroStrategy Desktop using the CData Software ODBC Driver for ConvertKit.
-
Getting Started with the CData SSIS Components for Humanity
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Humanity.
-
Use the CData Software ODBC Driver for Sugar CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Sugar CRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sugar CRM.
-
Integrating Claude Code with Databricks Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Databricks data within assisted coding and automated development workflows.
-
Integrating Antigravity CLI with DB2 data via CData CLI
Connect DB2 data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate MongoDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MongoDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MongoDB data.
-
Connect to Zoho Books Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Zoho Books.
-
Connect to Acumatica Data in ACL Analytics
Connect to Acumatica data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Acumatica data.
-
Connect and Visualize Live Pinterest Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Pinterest data into the Databricks platform and create visualization dashboards with real-time Pinterest data.
-
Connect to SingleStore Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SingleStore and the SQL Gateway to access SingleStore data from Google Apps Script.
-
Import Real-Time Samanage Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Samanage data in ColdFusion.
-
Visualize Live QuickBooks Time Data in the Power BI Service
Use CData Connect AI to connect to live QuickBooks Time data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with Bullhorn CRM Data in ETL Validator JDBC
Connect to Bullhorn CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Billsby in MicroStrategy Desktop
Connect to Billsby data in MicroStrategy Desktop using the CData Software ODBC Driver for Billsby.
-
Automated Continuous ConvertAPI Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ConvertAPI data replication to OneLake in Microsoft Fabric.
-
Connect to Sendwithus Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sendwithus Data and connect to Sendwithus data in Akorbi Digital RunMyProcess.
-
How to create GetResponse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for GetResponse data in MySQL .
-
Extract, Transform, and Load PabblySubscriptions Data in Informatica PowerCenter
Create a simple Workflow for PabblySubscriptions data in Informatica PowerCenter.
-
Use Agno to Talk to Your Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Epicor Kinetic data for you.
-
Bridge Google Calendar Connectivity with Apache NiFi
Access and process Google Calendar data in Apache NiFi using the CData JDBC Driver.
-
How to Work with Postmark Data in ETL Validator JDBC
Connect to Postmark from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect SharePoint with Amazon S3 Data through external lists
Provide Amazon S3 data to SharePoint users as an external list.
-
Connect to PayPal Data in JRuby
Create a simple JRuby app with access to live PayPal data.
-
Integrate Google's Antigravity Agent with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Greenplum data using the Model Context Protocol.
-
Integrate Live Google Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Analytics data to Blue Prism using the CData ODBC Driver for Google Analytics to create automated workflows for repetitive business tasks.
-
How to Connect DBeaver to Templated via a JDBC Driver
Manage Templated data with visual tools in DBeaver like the query browser.
-
Query Bitly Data as a MySQL Database in Node.js
Execute MySQL queries against Bitly data from Node.js.
-
Integrate Real-Time Access to Google Drive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Drive data in real time.
-
Connect to Xero Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Xero and the Script function in FileMaker Pro to connect to Xero and work with Xero data in your FileMaker application.
-
How to Connect Flowise AI Agents to Live Zoho CRM 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 Zoho CRM data without replication.
-
Visualize Google Campaign Manager 360 Data in Sisense
Create an ElastiCube in Sisense app with access to Google Campaign Manager 360 data.
-
Connect to MySQL Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MySQL data.
-
Integrate Real-Time Access to Elasticsearch in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Elasticsearch data in real time.
-
Import Okta Data Using Azure Data Factory
Use CData Connect AI to connect to Okta Data from Azure Data Factory and import live Okta data.
-
Use the CData Software ODBC Driver for LinkedIn Ads in MicroStrategy Web
Connect to LinkedIn Ads data in MicroStrategy Web using the CData Software ODBC Driver for LinkedIn Ads.
-
Automated Continuous HBase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HBase replication to Amazon Redshift.
-
Operational Reporting on SAP Business One Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business One data.
-
Back Up Salesforce data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce. In this article, we will employ an SSIS workflow to populate a database with Salesforce data data.