CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with Dotmailer Data in Dundas BI
Create dynamic dashboards and perform analytics based on Dotmailer data in Dundas BI.
-
Use the CData Software JDBC Driver for Microsoft Teams in MicroStrategy Desktop
Connect to Microsoft Teams data in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Teams.
-
Automated Continuous Azure DevOps Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Apache Cassandra.
-
Replicate Multiple Freshteam Accounts via the CData Sync CLI
Replicate multiple Freshteam accounts to one or many databases.
-
Establish a Live Connection with SAP HANA Data using Tableau Bridge
The CData ODBC Driver for SAP HANA enables you to integrate live SAP HANA data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Informatica Mappings From/To an ODBC Data Source for Mouseflow
Create an ODBC connection to Mouseflow in Informatica and browse and transfer Mouseflow data.
-
Connect to PingOne Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PingOne and the SQL Gateway to access PingOne data from Google Apps Script.
-
Connect to Timely Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Timely Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Wistia Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Wistia replication to Azure SQL Database.
-
Integrating Claude Code with Supabase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Supabase data within assisted coding and automated development workflows.
-
How to Connect to Azure Synapse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Azure Synapse data. Leverage the pyodbc module for ODBC in Python.
-
Import Sage 200 Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sage 200 Data and provide access to live Sage 200 data for custom reports in the Power BI Service.
-
Analyze Oracle SCM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle SCM data in Microsoft R Open.
-
Use Microsoft Copilot Studio to talk to your Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Bannerbear data for you.
-
Bridge Kintone Connectivity with Apache NiFi
Access and process Kintone data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous MariaDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MariaDB replication to Google BigQuery.
-
How to publish and share Bullhorn CRM Data dashboards with Tableau Server
The CData ODBC driver for Bullhorn CRM enables you integrate Bullhorn CRM data into Tableau dashboards.
-
Access Live Google Search Results in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Search results in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Facebook Ads Data Replication to Teradata
Use CData Sync to Customize and automate Facebook Ads data replication to Teradata.
-
How to Work with Google Forms Data in ETL Validator JDBC
Connect to Google Forms from ETL Validator jobs using the CData Software JDBC Driver.
-
Natively Connect to Amplitude Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amplitude data. Leverage the native support for ODBC in PHP.
-
Choosing the Best Method to Connect ClickTime to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ClickTime data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Datasets from ConvertAPI in Domo Workbench and Build Visualizations of ConvertAPI Data in Domo
Use the CData Software ODBC Driver for ConvertAPI to create datasets from ConvertAPI data in Domo Workbench and then build visualizations in the Domo service.
-
A PostgreSQL Interface for Customer.io Data using the CData ODBC Driver
Use the SQL Gateway and Customer.io ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Vault CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Vault CRM data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Devin with Live Salesforce CRM Analytics 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 Salesforce CRM Analytics data.
-
Build Dashboards with QuickBooks Time Data in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks Time data in DBxtra.
-
Integrate Amazon S3 Data into Power Automate Desktop using CData Connect
CData Connect for Amazon S3 Data enables you to integrate Amazon S3 data into workflows built using Microsoft Power Automate Desktop.
-
Load Paymo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Paymo data to a database.
-
Connect to Printify Data in RapidMiner
Integrate Printify data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating LlamaIndex with Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Omnisend data in real time.
-
Create Apps from Odoo Data in Qlik Sense Cloud
Use CData Connect AI to connect to Odoo Data and build apps from live Odoo data in Qlik Sense Cloud.
-
Use the CData ODBC Driver for Zoho Books from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Books to connect to Zoho Books data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Books data in Excel.
-
Integrate OpenCode with Live Adobe Target Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Adobe Target data from within your AI coding agent.
-
Create Phoenix-Connected Dashboards in Grafana
Connect to Phoenix Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Phoenix data.
-
Build Voice Agents in ElevenLabs with access to Live Mailgun Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Mailgun data.
-
Connect and Visualize Live Jira Assets Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Jira Assets data into the Databricks platform and create visualization dashboards with real-time Jira Assets data.
-
Getting Started with the CData ADO.NET Provider for SpaceX
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Dashboards and Visualize Live Okta Data in Geckoboard
Use CData Connect AI to connect to live Okta data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Cvent Data from MySQL in Amazon QuickSight
Connect to Cvent and build visualizations of Cvent data using a MySQL Connection in Amazon QuickSight.
-
Use Dash to Build to Web Apps on Shortcut Data
Create Python applications that use pandas and Dash to build Shortcut-connected web apps.
-
How to Connect Freshdesk 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 Freshdesk data in real time using natural language.
-
Use the CData Software ODBC Driver for Bullhorn CRM in MicroStrategy Desktop
Connect to Bullhorn CRM data in MicroStrategy Desktop using the CData Software ODBC Driver for Bullhorn CRM.
-
Build Monday.com-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Monday.com Data and create custom apps in Mendix.
-
Connecting Moonlit Workflow with Tavily Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Tavily data in real time.
-
Integrate Devin with Live Shopify 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 Shopify data.
-
Automated Continuous ZarMoney Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZarMoney replication to Amazon S3.
-
Integrate Live Lakebase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Lakebase data to Blue Prism using the CData ODBC Driver for Lakebase to create automated workflows for repetitive business tasks.
-
Connect to Paddle Data in HULFT Integrate
Connect to Paddle as a JDBC data source in HULFT Integrate
-
How to connect PolyBase to Paylocity
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Paylocity data.
-
Publish Crystal Reports on FreshBooks Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FreshBooks data.
-
Query SAP Ariba Source Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Ariba Source data from Node.js.
-
Query Humanity Data as a MySQL Database in Node.js
Execute MySQL queries against Humanity data from Node.js.
-
Integrate LibreChat with Live LDAP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live LDAP objects from within the chat interface.
-
Create Autopilot Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Autopilot from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Perplexity Data in Tableau
The CData ODBC driver for Perplexity enables you integrate Perplexity data into Tableau dashboards.
-
Build Tavily Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Tavily data and build visualizations in Tableau Cloud.
-
DataBind Google Campaign Manager 360 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Campaign Manager 360 with the DevExpress Windows Forms and Web controls to provide Google Campaign Manager 360 data to a chart.
-
Manage Zoho Creator Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Creator.
-
Analyze Google Ads Data in Cognos Analytics
Use CData Connect AI to connect to Google Ads Data from Cognos Analytics and analyze live Google Ads data.
-
How to create Visio diagrams from Zoho Creator Data
Automatically update Zoho Creator data with the changes you make to Visio master shapes.
-
Seamlessly Bring Notion Data into Retool Using CData Connect AI
Integrate Notion data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Epicor Kinetic-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Epicor Kinetic Data from OutSystems and build custom enterprise apps using live Epicor Kinetic data.
-
Connect to Suadeo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Suadeo as an External Source in Dremio.
-
How to Seamlessly Import Salesforce Pardot Data into IBM SPSS Modeler
Integrate Salesforce Pardot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Load SAP SuccessFactors Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP SuccessFactors data to a database.
-
Connect to LightSpeedRetail Data in Aqua Data Studio
Access LightSpeedRetail data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software JDBC Driver for PagerDuty in MicroStrategy Desktop
Connect to PagerDuty data in MicroStrategy Desktop using the CData Software JDBC Driver for PagerDuty.
-
Use the CData Software JDBC Driver for EnterpriseDB in MicroStrategy Desktop
Connect to EnterpriseDB data in MicroStrategy Desktop using the CData Software JDBC Driver for EnterpriseDB.
-
Getting Started with the CData JDBC Driver for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ActiveCampaign.
-
Access Live Auth0 Data in AWS Lambda
Connect to live Auth0 data in AWS Lambda using the CData JDBC Driver.
-
Avalara AvaTax Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Avalara AvaTax facts in real time.
-
Integrating Codex with PabblySubscriptions 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.
-
Perform Batch Operations with WordPress Data in Apache NiFi
Connect to WordPress data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Workable Replication to SingleStore
Use CData Sync for automated, continuous, customizable Workable replication to SingleStore.
-
Build Data Flows from SQL Server to Presto through SSIS
Easily push SQL Server data to Presto using the CData SSIS Tasks for Presto.
-
Create Oracle Financials Cloud-Connected Dashboards in Grafana
Connect to Oracle Financials Cloud Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Financials Cloud data.
-
Create SSAS Tabular Models from Basecamp Data
How to build a SQL Server Analysis Service Tabular Model from Basecamp data using CData drivers.
-
Integrate with WordPress Data in JReport Designer
Create charts and reports based on WordPress data in JReport Designer.
-
Import Real-Time Miro Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Miro data in ColdFusion.
-
Enable the Teamwork JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Teamwork data.
-
Connect to Workday Data in Claris FileMaker Pro
Use the CData ODBC Driver for Workday in FileMaker Pro to connect to Workday and work with Workday data in your FileMaker applications.
-
Create Informatica Mappings From/To an ODBC Data Source for Trello
Create an ODBC connection to Trello in Informatica and browse and transfer Trello data.
-
Connect to Azure Data Catalog Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Azure Data Catalog Data and connect to Azure Data Catalog data in Akorbi Digital RunMyProcess.
-
Build Data Flows from SQL Server to Teradata through SSIS
Easily push SQL Server data to Teradata using the CData SSIS Tasks for Teradata.
-
Connect to HBase Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with HBase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live Certinia Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Certinia data from your Google Sheets.
-
Build Facebook Ads-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Facebook Ads data without replication.
-
How to Connect Flowise AI Agents to Live MailChimp 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 MailChimp data without replication.
-
ETL Sage 300 in Oracle Data Integrator
This article shows how to transfer Sage 300 data into a data warehouse using Oracle Data Integrator.
-
Build an OLAP Cube in SSAS from Confluence Data
Establish a connection to Confluence data data from SQL Server Analysis Services, and use the Confluence Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Dashboards with Apollo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apollo data in Dundas BI.
-
Easily Integrate Everhour Data in Lazarus Pascal IDE
Learn how to easily integrate live Everhour data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to SQL Analysis Services Data in CloverDX (formerly CloverETL)
Transfer SQL Analysis Services data using the visual workflow in the CloverDX data integration tool.
-
Build a Simple VCL Application for Trello Data
How to build a simple VCL Application to view Trello data in RAD Studio using the CData ODBC Driver for Trello.
-
How to Build an ETL App for IBM Informix Data in Python with CData
Create ETL applications and real-time data pipelines for IBM Informix data in Python with petl.
-
How to Use a Microsoft Access Database to Update Oracle Service Cloud Data in Real Time
Update Oracle Service Cloud data by creating a linked table in Microsoft Access with the CData Oracle Service Cloud ODBC Driver.
-
How to load Scrapfly data into Elasticsearch via Logstash
Introducing a simple method to load Scrapfly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Claude Code CLI with Jumpseller 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.
-
Integrating OpenCode with Amazon Marketplace 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.