CData Software - Knowledge Base
Recent Articles
-
How to connect SharePoint with JSON Services through external lists
Provide JSON services to SharePoint users as an external list.
-
Build a PostgreSQL Interface for Salesforce Marketing Data using the CData JDBC Driver
Use the Remoting features of the Salesforce Marketing JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Auth0 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Auth0 replication to Apache Kafka.
-
DataBind Controls to Browserless Data in C++Builder
DataBind to Browserless data in C++Builder with standard components and controls.
-
How to Connect to Live Yelp 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 Yelp data through natural language.
-
Build an OLAP Cube in SSAS from Zoho CRM Data
Establish a connection to Zoho CRM data data from SQL Server Analysis Services, and use the Zoho CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Sage 300 Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage 300 replication to SQLite.
-
Connect to Sage 200 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sage 200 data from Filemaker Pro on Mac.
-
Visualize Live Google Spanner Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Spanner data.
-
Connect to Paymo Data from PowerBuilder via JDBC
This article demonstrates how to access Paymo data from PowerBuilder using the Paymo JDBC Driver.
-
SAP HANA XS Advanced Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP HANA XS Advanced data through CData Connect AI using different applications and tools.
-
Build Azure Data Catalog-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Azure Data Catalog Data and create custom apps in Bubble.
-
Object-Relational Mapping (ORM) with Google Sheets 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 Sheets data into a Java-based ORM framework, Hibernate.
-
Working with Zoho Books Data in LINQPad
Execute LINQ queries to Zoho Books data in LINQPad.
-
Build Pipelines with Live Authorize.Net Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Authorize.Net from Google Cloud Data Fusion, enabling the integration of live Authorize.Net data into the building and management of effective data pipelines.
-
Build Voice Agents in ElevenLabs with access to Live BenchmarkEmail Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live BenchmarkEmail data.
-
Access Typeform Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Typeform data from HeidiSQL.
-
Access Mocean Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mocean data from HeidiSQL.
-
Connect to Sage Cloud Accounting Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sage Cloud Accounting and the Script function in FileMaker Pro to connect to Sage Cloud Accounting and work with Sage Cloud Accounting data in your FileMaker application.
-
Configure the CData JDBC Driver for Presto in a Connection Pool in Tomcat
Connect to Presto data from a connection pool in Tomcat.
-
Publish ConvertKit-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ConvertKit data.
-
Viewing Power BI XMLA Data in RAD Studio Data Explorer
How to view Power BI XMLA data in RAD Studio Data Explorer using the CData ODBC Driver for Power BI XMLA.
-
Migrating data from Zoom to Google BigQuery using CData SSIS Components.
Easily push Zoom data to Google BigQuery using the CData SSIS Tasks for Zoom and Google BigQuery.
-
Visualize Rebilly Data in Sisense
Create an ElastiCube in Sisense app with access to Rebilly data.
-
Connect to Pipedrive Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pipedrive to connect to Pipedrive data and execute queries in PowerBuilder.
-
Connect to Greenhouse from Asprova with CData Software ODBC Driver for Greenhouse
This article shows how to connect faster to Greenhouse data from Asprova.
-
Automated Continuous Omnisend Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Omnisend replication to delimited files (CSV/TSV).
-
Create Salesforce Pardot-Connected Nintex Workflows
Use CData Connect AI to connect to Salesforce Pardot Data from Nintex Workflow Cloud and build custom workflows using live Salesforce Pardot data.
-
Automated Continuous Slack Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Slack replication to Google Cloud SQL.
-
Replicate Multiple Pinterest Accounts
Replicate multiple Pinterest accounts to one or many databases.
-
Replicate Act CRM Data to Multiple Databases
Replicate Act CRM data to disparate databases with a point-and-click configuration.
-
Build Azure Analysis Services Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Analysis Services data and build visualizations in Tableau Cloud.
-
Automated Continuous Confluence Replication to MySQL
Use CData Sync for automated, continuous, customizable Confluence replication to MySQL.
-
Access Live Zoho Books Data in TIBCO Data Virtualization
Use the Zoho Books Tibco DV Adapter to create a Zoho Books data data source in TIBCO Data Virtualization Studio and gain access to live Zoho Books data from your TDV Server.
-
ETL Procore in Oracle Data Integrator
This article shows how to transfer Procore data into a data warehouse using Oracle Data Integrator.
-
Create Datasets from Bright Data in Domo Workbench and Build Visualizations of Bright Data Data in Domo
Use the CData Software ODBC Driver for Bright Data to create datasets from Bright Data data in Domo Workbench and then build visualizations in the Domo service.
-
Access MailerLite Data from MySQL in Amazon QuickSight
Connect to MailerLite and build visualizations of MailerLite data using a MySQL Connection in Amazon QuickSight.
-
How to Access Live Apollo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Apollo enables you to integrate Apollo data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Devin with Live XML 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 XML data.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft OneDrive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft OneDrive data to SQL Server.
-
Build a Singer.io Tap for Auth0 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Auth0 data using the CData Python Connector.
-
How to Connect to Oracle Eloqua Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Eloqua data. Leverage the pyodbc module for ODBC in Python.
-
How to update Facebook from Excel
This article explains how to transfer data from Excel to Facebook using the Excel Add-In for Facebook.
-
How to Seamlessly Import Splunk Data into IBM SPSS Modeler
Integrate Splunk data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData ODBC Driver for SFTP in Microsoft Power Query
You can use the CData SFTP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SFTP data into Microsoft Power Query.
-
Publish Crystal Reports on Okta Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Okta data.
-
Establish a Live Connection with Bitly Data using Tableau Bridge
The CData ODBC Driver for Bitly enables you to integrate live Bitly data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Acumatica-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Acumatica data.
-
Use Manus AI to Talk to Your Aweber 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 Aweber data.
-
Getting Started with the CData Tableau Connector for SparkPost
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Stream Opsgenie Data into Apache Kafka Topics
Access and stream Opsgenie data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Build an ETL App for Zoho Inventory Data in Python with CData Connect AI
Build ETL pipelines that read and write live Zoho Inventory data in Python with petl and the CData Connect AI Python SDK.
-
Replicate Avro Data to Multiple Databases
Replicate Avro data to disparate databases with a point-and-click configuration.
-
Validate Snapchat Ads Data with QuerySurge
Access and validate Snapchat Ads data in QuerySurge using the CData JDBC Driver.
-
Connect eBay to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live eBay data using the CData Python MCP Server.
-
How to Query Workable Data in MySQL Workbench
Execute MySQL queries against live Workable data from MySQL Workbench.
-
Work with Live HDFS Data in Power Query
Use CData Connect AI to connect to HDFS data and work with live HDFS data in Microsoft Power Query.
-
Connect to Sage Intacct Data in Aqua Data Studio
Access Sage Intacct data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Vimeo Data in NetBeans
Connect to Vimeo data in NetBeans with the data source configuration wizard.
-
Build Automated Workflows with Live AgileCRM Data in Workato
Use CData Connect AI to connect to live AgileCRM data and build automated workflows in Workato.
-
Build Semantic Layer Views for ZohoDesk Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ZohoDesk data.
-
Connect SAP Hybris C4C to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Hybris C4C data using the CData Python MCP Server.
-
Connect to Quaderno Data in HULFT Integrate
Connect to Quaderno as a JDBC data source in HULFT Integrate
-
Create Informatica Mappings From/To a JDBC Data Source for Postmark
Create Postmark data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous MailerSend Replication to Snowflake
Use CData Sync for automated, continuous, customizable MailerSend replication to Snowflake.
-
How to load Active Directory data into Elasticsearch via Logstash
Introducing a simple method to load Active Directory data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Live Gong Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Gong data directly from the development environment.
-
How to integrate Quickbase with Apache Airflow
Access and process Quickbase data in Apache Airflow using the CData JDBC Driver.
-
Integrate Trae with Live Bullhorn CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Bullhorn CRM data from within the AI-powered IDE.
-
Visualize Cohere Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Cohere data.
-
Build Agents in Relevance AI with Access to Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Hybris C4C data within intelligent agent workflows.
-
Automated Continuous CampaignMonitor Replication to SQL Server
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to SQL Server.
-
Connect to Deel Data in JRuby
Create a simple JRuby app with access to live Deel data.
-
DataBind Controls to Quaderno Data in Delphi
DataBind to Quaderno data in Delphi with standard data access components and controls.
-
Build Pipelines with Live Grafana Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Grafana from Google Cloud Data Fusion, enabling the integration of live Grafana data into the building and management of effective data pipelines.
-
Connect to Foursquare Data in CloverDX (formerly CloverETL)
Transfer Foursquare data using the visual workflow in the CloverDX data integration tool.
-
Integrating Codex with Attio 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.
-
Create Datasets from iContact in Domo Workbench and Build Visualizations of iContact Data in Domo
Use the CData Software ODBC Driver for iContact to create datasets from iContact data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Query Brex Data in QlikView over ODBC
Create data visualizations with Brex data in QlikView.
-
Query Okta Data as a MySQL Database in Node.js
Execute MySQL queries against Okta data from Node.js.
-
Visualize Live Azure DevOps Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Azure DevOps data into custom reports in Power BI.
-
Integrate Google's Vertex AI Agent with Live Sage Intacct 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 Sage Intacct data within intelligent workflows.
-
Analyze MessageBird Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MessageBird from Power Pivot. You will use the Table Import Wizard to load MessageBird data. You can visually build the import query or use any SQL supported by the driver.
-
Connect DocuSign to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect DocuSign with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to LeadDesk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LeadDesk data. Leverage the pyodbc module for ODBC in Python.
-
Viewing Dynamics CRM Data in RAD Studio Data Explorer
How to view Dynamics CRM data in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics CRM.
-
Getting Started with the CData ADO.NET Provider for Dotmailer
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
A PostgreSQL Interface for Oracle SCM Data using the CData ODBC Driver
Use the SQL Gateway and Oracle SCM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Cloudant Data in Alteryx Designer (ODBC)
Build workflows to access live Cloudant data for self-service data analytics.
-
Building Dynamic Web Pages with Dynamics 365 Business Central Data Using AngularJS
Create single-page applications with live connectivity to Dynamics 365 Business Central using the CData API Server.
-
Connect to MailerSend Data in Ruby
Connect to MailerSend data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Trae with Live Sybase IQ Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Sybase IQ data from within the AI-powered IDE.
-
Write a Simple Go Application to work with Marketo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Marketo data.
-
ClickTime Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ClickTime facts in real time.
-
Load Sentry Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sentry data to a database.
-
Integrating Codex with JDBC-ODBC Bridge 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.
-
Build MailChimp-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MailChimp data and build MailChimp-connected web apps with Axios.
-
Excel Spreadsheet Automation on MailerSend Data with the QUERY Formula
Pull data from MailerSend, automate spreadsheets, and more with the QUERY formula.
-
Integrating Cursor with Quaderno 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.
-
Extract, Transform, and Load CSV Data in Informatica PowerCenter
Create a simple Workflow for CSV data in Informatica PowerCenter.