CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Telegram in Domo Workbench and Build Visualizations of Telegram Data in Domo
Use the CData Software ODBC Driver for Telegram to create datasets from Telegram in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Python Connector for Customer.io
Learn to install and license the CData Python Connector
-
A PostgreSQL Interface for Jumpseller Data (MySQL Remoting via JDBC)
Use the Remoting features of the Jumpseller JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ScrapingBee Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Publish GitLab-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live GitLab.
-
Getting Started with the CData Tableau Connector for Wave Financial
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Wave Financial.
-
Create Datasets from REST in Domo Workbench and Build Visualizations of REST Data in Domo
Use the CData Software ODBC Driver for REST to create datasets from REST in Domo Workbench and then build visualizations in the Domo service.
-
Access Live eBay Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live eBay from your Excel spreadsheets.
-
How to publish and share Google Forms Data dashboards with Tableau Server
The CData ODBC driver for Google Forms enables you integrate Google Forms into Tableau dashboards.
-
Object-Relational Mapping (ORM) with Humanity 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 Humanity into a Java-based ORM framework, Hibernate.
-
Replicate Oracle Data to Multiple Databases
Replicate Oracle Database to disparate databases with a point-and-click configuration.
-
How to Design SAP Hybris C4C Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SAP Hybris C4C from mobile and tablet Power Apps.
-
Configure the CData JDBC Driver for Greenhouse in a Connection Pool in Tomcat
Connect to Greenhouse from a connection pool in Tomcat.
-
Connect to Salesforce CRM Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce CRM Analytics as an External Source in Dremio.
-
PayPal Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to PayPal through CData Connect AI using different applications and tools.
-
How to connect to Twilio Data in DBVisualizer
Integrate Twilio with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Avalara AvaTax Data from MySQL in PHP
Connect to Avalara AvaTax through the standard MySQL libraries in PHP.
-
Integrate Cursor with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Search from within the editor.
-
Integrate Cursor with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce Marketing Cloud from within the editor.
-
Perform Batch Operations with BigQuery Data in Apache NiFi
Connect to Google BigQuery and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Add SingleStore Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SingleStore with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Supabase Data in Ruby
Connect to Supabase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Guru Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Copper Data in Jaspersoft Studio
Execute SQL to remote Copper in Jaspersoft Studio.
-
Visualize Campaigner Data in TIBCO Spotfire through ADO.NET
Integrate Campaigner into dashboards in TIBCO Spotfire.
-
Build AI Agents with Shopify 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 Shopify through CData Connect AI.
-
Write a Simple Go Application to work with Webflow Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Webflow.
-
Use the CData ODBC Driver for Anaplan in Microsoft Power Query
You can use the CData Anaplan ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Anaplan into Microsoft Power Query.
-
Connect to MYOB AccountRight Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MYOB AccountRight Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build an OLAP Cube in SSAS from SparkPost Data
Establish a connection to SparkPost data from SQL Server Analysis Services, and use the SparkPost Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Pingdom Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pingdom replication to SingleStore.
-
Viewing Jodoo Data in RAD Studio Data Explorer
How to view Jodoo in RAD Studio Data Explorer using the CData ODBC Driver for Jodoo.
-
Analyze Elasticsearch Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Elasticsearch and visualize live Elasticsearch in Infragistics Reveal.
-
How to Query Live Anaplan Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Anaplan data in natural language using Python.
-
Integrating Cursor CLI with eBay 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.
-
Getting Started with the CData Power BI Connector for Amplitude
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live FreshBooks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FreshBooks into the statistical analysis tools available in SAS JMP. This article shows how to use FreshBooks in the Graph Builder and Query Builder.
-
How to connect to Qualaroo Data with Squirrel SQL client
Connect to Qualaroo and execute queries in the Squirrel SQL Client.
-
Integrate Epicor Kinetic Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Epicor Kinetic and integrate live Epicor Kinetic into your Power Automate tasks.
-
How to Connect to HubSpot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to HubSpot. Leverage the pyodbc module for ODBC in Python.
-
How to Import Data from Google Search into Google Sheets
Import Google Search into a Google spreadsheet that is automatically refreshed.
-
Validate Humanity Data with QuerySurge
Access and validate Humanity in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Excel Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Excel replication to Amazon S3.
-
Build MVC Applications with Connectivity to Moosend Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Moosend from an ASP.NET MVC application.
-
Object-Relational Mapping (ORM) with Basecamp 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 Basecamp into a Java-based ORM framework, Hibernate.
-
Rapidly Develop Missive-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Missive.
-
DataBind Controls to OnePageCrm Data in Delphi
DataBind to OnePageCrm in Delphi with standard data access components and controls.
-
Create Power BI Reports on Real-Time Zuora Data
Use the CData ODBC Driver for Zuora to visualize Zuora in Power BI Desktop.
-
Building Dynamic Web Pages with YouTube Analytics Data Using AngularJS
Create single-page applications with live connectivity to YouTube Analytics using the CData API Server.
-
How to work with Procore Data in Apache Spark using SQL
Access and process Procore Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Pinterest Data from PowerShell
Write a quick PowerShell script to query Pinterest. Use connectivity to the live data to replicate Pinterest to SQL Server.
-
Replicate WooCommerce Data from PowerShell
Write a quick PowerShell script to query WooCommerce. Use connectivity to the live data to replicate WooCommerce to SQL Server.
-
How to Visualize Azure Data Catalog Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Data Catalog in Python.
-
Create SSAS Tabular Models from Ontraport Data
How to build a SQL Server Analysis Service Tabular Model from Ontraport using CData drivers.
-
How to create Visio diagrams from Amazon DynamoDB Data
Automatically update Amazon DynamoDB with the changes you make to Visio master shapes.
-
How to work with GraphQL Data in Apache Spark using SQL
Access and process GraphQL Data in Apache Spark using the CData Software JDBC Driver.
-
How to Build an ETL App for Cassandra Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Cassandra in Python with petl.
-
Build a Simple VCL Application for Discord Data
How to build a simple VCL Application to view Discord in RAD Studio using the CData ODBC Driver for Discord.
-
Connect to Gmail Data in RazorSQL
Connect to Gmail from wizards and query Gmail from the GUI in the RazorSQL database management tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live DocuSign within intelligent workflows.
-
Deploy the ADO.NET Provider for Printful on an SSRS Report Server
Connect to Printful from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Object-Relational Mapping (ORM) with ZohoSubscriptions 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 ZohoSubscriptions into a Java-based ORM framework, Hibernate.
-
Integrating Tanda Data in Talend Cloud Data Management Platform
Connect Tanda Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use CData Connect AI to Access SAP Netweaver Gateway Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Netweaver Gateway in the Power Pivot business intelligence tool.
-
Automate Omnisend Data Replication to Couchbase
Use CData Sync to Customize and automate Omnisend replication to Couchbase.
-
How to connect Amazon QuickSight to WordPress Data
Create a connection to WordPress in CData Connect AI and insert WordPress into Amazon QuickSight SPICE to build interactive dashboards.
-
Connecting GenSpark with MySQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MySQL without any replication or custom integration required.
-
Replicate Multiple SendPulse Accounts via the CData Sync CLI
Replicate multiple SendPulse accounts to one or many databases.
-
Enable the Tavily JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Tavily.
-
How to Work with iContact Data in ETL Validator JDBC
Connect to iContact from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Sage Intacct Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Intacct from your Excel spreadsheets.
-
A PostgreSQL Interface for Salesforce Marketing Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Marketing ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Everhour Data in Apache Spark using SQL
Access and process Everhour Data in Apache Spark using the CData Software JDBC Driver.
-
Build Office 365-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Office 365 to explore live Office 365 Data in Claude Code to assist with building Office 365-powered applications.
-
Replicate Redshift Data from PowerShell
Write a quick PowerShell script to query Amazon Redshift. Use connectivity to the live data to replicate Amazon Redshift to SQL Server.
-
Build Semantic Layer Views for Monday.com Data in APOS Live Data Gateway
Use the CData Connector for Monday.com in APOS Live Data Gateway to build Semantic Layer Views for Monday.com.
-
Integrate Live Microsoft Dataverse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Dataverse (CDS) and integrate live Microsoft Dataverse (CDS) into apps built in Microsoft Power Apps.
-
Visualize Live Shippo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Shippo.
-
Object-Relational Mapping (ORM) with Campaigner 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 Campaigner into a Java-based ORM framework, Hibernate.
-
Reckon Accounts Hosted Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Reckon Accounts Hosted facts in real time.
-
Write a Simple Go Application to work with Salesforce Pardot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce Pardot.
-
Establish a Live Connection with Planio Data using Tableau Bridge
The CData ODBC Driver for Planio enables you to integrate live Planio into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Kintone-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Kintone Data and create custom apps in Mendix.
-
How to Query Live eBay Data in Claude Desktop
Connect to and query live eBay Data in Claude Desktop using CData MCP Server.
-
Model, Search, and Visualize Live Google Contacts Data in ThoughtSpot
Use CData Connect AI to connect to live Google Contacts for modeling, searching, and visualizing.
-
Moving Data from MySQL to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MySQL data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Automated Workflows with Live Azure Data Lake Storage Data in Workato
Use CData Connect AI to connect to live Azure Data Lake Storage and build automated workflows in Workato.
-
Access Live Zoho Projects Data in Excel 365 Online (Excel for the web)
Connect to Zoho Projects from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query Amazon S3 Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Amazon S3 and perform CRUD operations on Amazon S3 from Node.js.
-
Query Drip Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Drip from Node.js.
-
Use CData Connect AI to Access MailChimp Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MailChimp in the Power Pivot business intelligence tool.
-
Extract, Transform, and Load Greenhouse Data in Informatica PowerCenter
Create a simple Workflow for Greenhouse in Informatica PowerCenter.
-
Automated Continuous Zoho CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho CRM replication to PostgreSQL.
-
How to Seamlessly Import Elorus Data into IBM SPSS Modeler
Integrate Elorus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Act CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Act CRM from Filemaker Pro on Mac.
-
Connect to AlloyDB Data in DBArtisan
Use wizards in DBArtisan to configure Google AlloyDB as a data source.
-
Natively Connect to Google Campaign Manager 360 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Campaign Manager 360. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze JSON Services in Alteryx Designer (ODBC)
Build workflows to access live JSON for self-service data analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SparkPost
Provide connectivity to SparkPost through an SAP BusinessObjects universe.
-
Create Redshift-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Redshift Data from OutSystems and build custom enterprise apps using live Amazon Redshift.