CData Software - Knowledge Base
Recent Articles
-
Integrate Google's Vertex AI Agent with Live Greenplum 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 Greenplum data within intelligent workflows.
-
How to Seamlessly Import Cvent Data into IBM SPSS Modeler
Integrate Cvent data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Microsoft Teams Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Teams data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Browserless Replication to MongoDB
Use CData Sync for automated, continuous, customizable Browserless replication to MongoDB.
-
Access Coinbase Data from MySQL in PHP
Connect to Coinbase through the standard MySQL libraries in PHP.
-
How to Connect Sugar 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 Sugar CRM data in real time using natural language.
-
How to create an RPA flow for Oracle Sales Data in UiPath Studio
Use the Oracle Sales ODBC Driver to create workflows that access real-time Oracle Sales data without any coding.
-
Access Live Google Drive Data in Excel 365 Online (Excel for the web)
Connect to Google Drive data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to update Avalara AvaTax from Excel
This article explains how to transfer data from Excel to Avalara AvaTax using the Excel Add-In for Avalara AvaTax.
-
Getting Started with the CData ADO.NET Provider for Mocean
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Box Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Box replication to AlloyDB.
-
Create Informatica Mappings From/To a JDBC Data Source for Yelp
Create Yelp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Mistral AI Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mistral AI data with the CData JDBC Driver for Mistral AI.
-
Integrating Instagram Data in Talend Cloud Data Management Platform
Connect Instagram Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Instagram.
-
Automated Continuous Pinterest Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Pinterest replication to Amazon S3.
-
ETL WooCommerce in Oracle Data Integrator
This article shows how to transfer WooCommerce data into a data warehouse using Oracle Data Integrator.
-
Query ConvertKit Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ConvertKit data from Node.js.
-
Publish Azure Data Lake Storage-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Data Lake Storage data.
-
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.
-
Create JSON-Connected Dashboards in Grafana
Connect to JSON Services via CData Connect AI in Grafana and create custom business dashboards with real-time access to JSON services.
-
Automated Continuous Act-On Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Act-On replication to AlloyDB.
-
Use the CData ODBC Driver for Cvent from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cvent to connect to Cvent data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Cvent data in Excel.
-
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.
-
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.
-
Getting Started with the CData ODBC Driver for Printful
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Printful.
-
Publish Microsoft Planner-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Planner data.
-
Natively Connect to Act CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Act CRM data. Leverage the native support for ODBC in PHP.
-
DataBind Clari Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Clari data to a chart.
-
Access RabbitMQ Data from MySQL in PHP
Connect to RabbitMQ through the standard MySQL libraries in PHP.
-
Extract, Transform, and Load Oracle Service Cloud Data in Informatica PowerCenter
Create a simple Workflow for Oracle Service Cloud data in Informatica PowerCenter.
-
Getting Started with the CData Excel Add-In for Opsgenie
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Opsgenie.
-
Explore Geographical Relationships in AfterShip Data with Power Map
Create data visualizations with AfterShip data in Power Map.
-
Access Planio Data from MySQL in PHP
Connect to Planio through the standard MySQL libraries in PHP.
-
Build JSON-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live JSON services.
-
Explore Geographical Relationships in Jira Assets Data with Power Map
Create data visualizations with Jira Assets data in Power Map.
-
How to connect and process Instagram data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Instagram data.
-
Query Basecamp Data as a MySQL Database in Node.js
Execute MySQL queries against Basecamp data from Node.js.
-
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.
-
Replicate Snapchat Ads Data to Multiple Databases
Replicate Snapchat Ads data to disparate databases with a point-and-click configuration.
-
Replicate Multiple SAP SuccessFactors Accounts
Replicate multiple SAP SuccessFactors accounts to one or many databases.
-
Integrating OpenCode with Excel Online 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.
-
Load Close Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Close data to a database.
-
Connect to AgileCRM Data in DBArtisan
Use wizards in DBArtisan to configure AgileCRM data as a data source.
-
Integrate VWO with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate VWO with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to VWO data.
-
Integrate LibreChat with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live HCL Domino data from within the chat interface.
-
Integrate with EmailOctopus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy EmailOctopus data to a JSON file on disk.
-
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 Smartsheet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Smartsheet.
-
Connect to HBase Data from AWS Glue
Use CData Connect AI to gain access to live HBase data from your AWS Glue jobs.
-
Automated Shippo Data Replication to Teradata
Use CData Sync to Customize and automate Shippo data replication to Teradata.
-
Create Datasets from Tally in Domo Workbench and Build Visualizations of Tally Data in Domo
Use the CData Software ODBC Driver for Tally to create datasets from Tally data in Domo Workbench and then build visualizations in the Domo service.
-
Replicate Google Contacts Data from PowerShell
Write a quick PowerShell script to query Google Contacts data. Use connectivity to the live data to replicate Google Contacts data to SQL Server.
-
Replicate Reckon Accounts Hosted Data to Multiple Databases via the CData Sync CLI
Replicate Reckon Accounts Hosted data to disparate databases with a single configuration.
-
Connecting Agentforce with VWO Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your VWO data for you.
-
Connect to Confluence Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Confluence data.
-
Automated Continuous Facebook Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Oracle.
-
Use JayDeBeApi to access Retently Data in Python
Use standard Python scripting and the development environment of your choice to access live Retently data.
-
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.
-
Access Live Google Ads 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 Ads data through MCP integration.
-
Automated Bullhorn CRM Data Replication to Teradata
Use CData Sync to Customize and automate Bullhorn CRM data replication to Teradata.
-
Integrate Microsoft Planner Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Planner Data enables you to integrate Microsoft Planner data into workflows built using Microsoft Power Automate Desktop.
-
Connect and Visualize Live Mailgun Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Mailgun data into the Databricks platform and create visualization dashboards with real-time Mailgun data.
-
Automated Continuous Supabase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Supabase replication to SQL Server.
-
Automated Continuous Sentry Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sentry replication to Amazon Redshift.
-
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.
-
How to integrate Anaplan with Apache Airflow
Access and process Anaplan data in Apache Airflow using the CData JDBC Driver.
-
Creating Spark-Connected Applications in Unqork
You can use CData Connect AI to feed Spark data to Unqork and build custom business apps.
-
Connect to Epicor Kinetic Data in DBArtisan
Use wizards in DBArtisan to configure Epicor Kinetic data as a data source.
-
How to connect to Notion Data from IntelliJ
Integrate connectivity to Notion data with wizards in IntelliJ.
-
Automate IBM Informix Data Replication to Azure Data Lake
Use CData Sync to customize and automate IBM Informix data replication to Azure Data Lake.
-
Connect to LaunchDarkly Data in RapidMiner
Integrate LaunchDarkly data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Demio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Demio as an External Source in Dremio.
-
Automated Continuous Testmonitor Replication to SQLite
Use CData Sync for automated, continuous, customizable Testmonitor replication to SQLite.
-
Use the CData Software JDBC Driver for Cvent in MicroStrategy
Connect to Cvent data in MicroStrategy Developer using the CData Software JDBC Driver for Cvent.
-
Analyze ZohoExpense Data in Looker
Use CData Connect AI to connect to ZohoExpense Data from Looker and build custom apps using live ZohoExpense data.
-
Analyze Egnyte Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Egnyte data and visualize Egnyte data in SAP Analytics Cloud.
-
DataBind ZohoPeople Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoPeople data to a chart.
-
A PostgreSQL Interface for Figshare Data (MySQL Remoting via JDBC)
Use the Remoting features of the Figshare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Notion Replication to SingleStore
Use CData Sync for automated, continuous, customizable Notion replication to SingleStore.
-
Create SSAS Tabular Models from Planio Data
How to build a SQL Server Analysis Service Tabular Model from Planio data using CData drivers.
-
Analyze GraphQL Data in Looker
Use CData Connect AI to connect to GraphQL Data from Looker and build custom apps using live GraphQL data.
-
Build Excel Online-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Excel Online Data and create custom apps in Mendix.
-
Automated Continuous PhantomBuster Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PhantomBuster replication to PostgreSQL.
-
Getting Started with the CData Power BI Connector for Google Spanner
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Spanner.
-
Creating SAP ByDesign-Connected Applications in Unqork
You can use CData Connect AI to feed SAP ByDesign data to Unqork and build custom business apps.
-
Integrating Dataiku with YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live YouTube Analytics data.
-
How to create Visio diagrams from Workday Data
Automatically update Workday data with the changes you make to Visio master shapes.
-
Integrating LlamaIndex with Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Toggl data in real time.
-
Integrating Gumloop with Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Databricks data within automated workflows.
-
Integrate EnterpriseDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to EnterpriseDB data and integrate live EnterpriseDB data into your Power Automate tasks.
-
How to Visualize CSV 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 CSV data in Python.
-
Prepare, Blend, and Analyze Dynamics NAV Data in Alteryx Designer (Connect AI)
Build workflows to access live Dynamics NAV data for self-service data analytics.
-
Integrate BigCommerce Data in the Pentaho Report Designer
Publish reports based on BigCommerce data in the Pentaho BI tool.
-
Build Voice Agents in ElevenLabs with access to Live Dynamics CRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Dynamics CRM data.
-
Use the CData ODBC Driver for Mode in Microsoft Power Query
You can use the CData Mode ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mode data into Microsoft Power Query.
-
Connect Gorgias Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Gorgias data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate ChartMogul Data Replication to Azure Synapse
Use CData Sync to customize and automate ChartMogul data replication to Azure Synapse.
-
Access BenchmarkEmail Data from MySQL in PHP
Connect to BenchmarkEmail through the standard MySQL libraries in PHP.
-
Connect to SFTP Data from a Connection Pool in Jetty
The SFTP JDBC Driver supports connection pooling: This article shows how to connect faster to SFTP data from Web apps in Jetty.
-
Use ChatGPT to Talk to Your Phoenix 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 Phoenix data for you.