CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Paddle Data using the CData ODBC Driver
Use the SQL Gateway and Paddle ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Claude to Talk to Your ZohoDesk 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 ZohoDesk data for you.
-
Build a PostgreSQL Interface for Paylocity Data using the CData JDBC Driver
Use the Remoting features of the Paylocity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Real-Time Access to HBase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HBase data in real time.
-
How to Build an ETL App for Gorgias Data in Python with CData
Create ETL applications and real-time data pipelines for Gorgias data in Python with petl.
-
Connect and Visualize Live SAS xpt Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAS xpt data into the Databricks platform and create visualization dashboards with real-time SAS xpt data.
-
Connect to Twitter Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Twitter Ads data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Presto Data from a Connection Pool in JBoss
Integrate Presto data into Java servlets: Use the Management Console in JBoss to install the Presto JDBC Driver.
-
DataBind Controls to GraphQL Data in Delphi
DataBind to GraphQL data in Delphi with standard data access components and controls.
-
Build a PostgreSQL Interface for Google Campaign Manager 360 Data using the CData JDBC Driver
Use the Remoting features of the Google Campaign Manager 360 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Templated-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Templated data.
-
Analyze Airtable Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Airtable data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
View Reports on Real-Time Quickbase Data in Power BI Report Server
Use the CData ODBC Driver for Quickbase to visualize Quickbase data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Zoho CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoho CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Create Power BI Visual Reports with Real-Time eBay Analytics Data
Use CData Power BI Connectors to visualize eBay Analytics data in Power BI.
-
Trigger Avalara AvaTax IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Avalara AvaTax with standard wizards in Logic Apps.
-
Replicate ChargeOver Data to Multiple Databases
Replicate ChargeOver data to disparate databases with a point-and-click configuration.
-
Use the CData Software ODBC Driver for Shippo in SAS for Real-Time Reporting and Analytics
Connect to real-time Shippo data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Shippo.
-
Bridge Humanity Connectivity with Apache NiFi
Access and process Humanity data in Apache NiFi using the CData JDBC Driver.
-
Design BIRT Reports on Zoho CRM Data
Provide current Zoho CRM data to your embedded analytics.
-
How to Access PingOne Data Using Entity Framework
This article shows how to access PingOne data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with live Amazon S3 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Amazon S3 data in Jitterbit.
-
Create Data Visualizations in Cognos BI with Google Cloud Storage Data
Access Google Cloud Storage data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Pipelines with Live Testmonitor Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Testmonitor from Google Cloud Data Fusion, enabling the integration of live Testmonitor data into the building and management of effective data pipelines.
-
Build Charts with Helpscout Data in Clear Analytics
Create dynamic charts and perform analytics based on Helpscout data in Clear Analytics.
-
Create Datasets from Helpscout in Domo Workbench and Build Visualizations of Helpscout Data in Domo
Use the CData Software ODBC Driver for Helpscout to create datasets from Helpscout data in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Snapchat Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Snapchat Ads data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Quickbase Data from PowerBuilder via JDBC
This article demonstrates how to access Quickbase data from PowerBuilder using the Quickbase JDBC Driver.
-
Create Slack-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Slack Data from OutSystems and build custom enterprise apps using live Slack data.
-
Analyze Dynamics CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Dynamics CRM data with the CData JDBC Driver for Dynamics CRM.
-
Connect to MongoDB Data from PowerBuilder via JDBC
This article demonstrates how to access MongoDB data from PowerBuilder using the MongoDB JDBC Driver.
-
Manage Reckon Accounts Hosted Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Reckon Accounts Hosted.
-
Automated Continuous Asana Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Asana replication to Amazon S3.
-
Automated Continuous Greenhouse Replication to Vertica
Use CData Sync for automated, continuous, customizable Greenhouse replication to Vertica.
-
Integrate Mistral AI with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mistral AI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mistral AI data.
-
Search External SAP HANA XS Advanced Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP HANA XS Advanced data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP HANA XS Advanced Data objects that you can access from apps and the dashboard.
-
How to Seamlessly Import Google Ad Manager Data into IBM SPSS Modeler
Integrate Google Ad Manager data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Multiple IBM Cloud Object Storage Accounts
Replicate multiple IBM Cloud Object Storage accounts to one or many databases.
-
Integrating Claude Code CLI with Wistia 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.
-
Automate MailerSend Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MailerSend data from PowerShell? This article demonstrates how to utilize the MailerSend Cmdlets for tasks like connecting to MailerSend data, automating operations, downloading data, and more.
-
Integrating GitHub Copilot with SAP HANA 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.
-
Connect to and Visualize Live Calendly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Calendly data.
-
How to connect PolyBase to Outreach.io
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Outreach.io data.
-
How to Build an ETL App for ActiveCampaign Data in Python with CData
Create ETL applications and real-time data pipelines for ActiveCampaign data in Python with petl.
-
How to Build an ETL App for SAP Netweaver Gateway Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Netweaver Gateway data in Python with petl and the CData Connect AI Python SDK.
-
Connect to YouTube Analytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live YouTube Analytics data.
-
Integrating Claude Code CLI with Front 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.
-
Connect to Presto Data from PowerBuilder via ADO.NET
This article demonstrates how to access Presto data from Appeon PowerBuilder using the CData ADO.NET Provider for Presto.
-
Connect to GitHub Data in Aqua Data Studio
Access GitHub data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Trello Data in TIBCO Spotfire through ADO.NET
Integrate Trello data into dashboards in TIBCO Spotfire.
-
How to Connect the Power BI Service to Cloudant: Complete Guide
Connect to the CData Software Power BI Connector for Cloudant from PowerBI.com to provide real-time Cloudant data across the organization.
-
Integrate Cline with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Confluence data from within your IDE.
-
Connect to Tickspot Data from a Connection Pool in Jetty
The Tickspot JDBC Driver supports connection pooling: This article shows how to connect faster to Tickspot data from Web apps in Jetty.
-
Publish Crystal Reports on Salesforce Marketing Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce Marketing data.
-
Getting Started with the CData Tableau Connector for WordPress
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for WordPress.
-
How to Query Live Timely Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Timely data data in natural language using Python.
-
How to integrate Spotify with Apache Airflow
Access and process Spotify data in Apache Airflow using the CData JDBC Driver.
-
Bind Live Couchbase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Couchbase data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Connect Flowise AI Agents to Live WordPress 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 WordPress data without replication.
-
Automated Continuous Attio Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Attio replication to Google Cloud SQL.
-
Connect to Zuora Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Zuora.
-
How to Connect to & Open ZohoInvoice Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoInvoice to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Bitbucket Data in HULFT Integrate
Connect to Bitbucket as a JDBC data source in HULFT Integrate
-
How to Access Live Pipeline CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pipeline CRM enables you to integrate Pipeline CRM data into workflows built using Microsoft Power Automate Desktop.
-
Publish Azure Synapse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Synapse data.
-
Connect Twilio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Twilio data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Migrating data from MYOB AccountRight to Snowflake using CData SSIS Components.
Easily push MYOB AccountRight data to Snowflake using the CData SSIS Tasks for MYOB AccountRight and Snowflake.
-
How to Connect to Live FTP Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your FTP data for you.
-
How to Query Miro Data in MySQL Workbench
Execute MySQL queries against live Miro data from MySQL Workbench.
-
How to integrate Oracle Sales with Apache Airflow
Access and process Oracle Sales data in Apache Airflow using the CData JDBC Driver.
-
Use Agno to Talk to Your Microsoft Dataverse 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 Microsoft Dataverse data for you.
-
Object-Relational Mapping (ORM) with IBM Cloud Object Storage 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 IBM Cloud Object Storage data into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData Python Connector for Pipeliner CRM
Learn to install and license the CData Python Connector and configure a connection to live Pipeliner CRM data.
-
How to connect to Blackbaud FE NXT Data in DBVisualizer
Integrate Blackbaud FE NXT data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Nuclia Data from PowerShell
Write a quick PowerShell script to query Nuclia data. Use connectivity to the live data to replicate Nuclia data to SQL Server.
-
Integrating Parallel Data in Talend Cloud Data Management Platform
Connect Parallel Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Excel Spreadsheet Automation on Zoho Inventory Data with the QUERY Formula
Pull data from Zoho Inventory, automate spreadsheets, and more with the QUERY formula.
-
Connect to Gong Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Gong data from Filemaker Pro on Mac.
-
Create Informatica Mappings From/To an ODBC Data Source for Missive
Create an ODBC connection to Missive in Informatica and browse and transfer Missive data.
-
Natively Connect to Sendwithus Data in PHP
The CData ODBC driver for Sendwithus enables you to create PHP applications with connectivity to Sendwithus data. Leverage the native support for ODBC in PHP.
-
ETL ScrapingBee in Oracle Data Integrator
This article shows how to transfer ScrapingBee data into a data warehouse using Oracle Data Integrator.
-
Connect Salesforce Data 360 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesforce Data 360 with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for ChartMogul Data (MySQL Remoting via JDBC)
Use the Remoting features of the ChartMogul JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create HubSpot-Connected Nintex Workflows
Use CData Connect AI to connect to HubSpot Data from Nintex Workflow Cloud and build custom workflows using live HubSpot data.
-
How to Easily Query Instagram Data in OpenOffice Base
Connect to Instagram data in OpenOffice Base using the CData ODBC Driver for Instagram and generate reports with live data insights.
-
How to import HDFS Data into Apache Solr
Use the CData Software JDBC Driver for HDFS in Data Import Handler and create an automated import of HDFS data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Python Connector for Neo4J
Learn to install and license the CData Python Connector and configure a connection to live Neo4J data.
-
Manage SpaceX Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SpaceX.
-
Build Dashboards with Gong Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gong data in Dundas BI.
-
Build a Singer.io Tap for Zoho CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho CRM data using the CData Python Connector.
-
How to Connect to Live FHIR Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live FHIR data without replication.
-
Interact with Live Epicor Kinetic Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Epicor Kinetic data.
-
Connect to ZohoMarketingHub Data in NetBeans
Connect to ZohoMarketingHub data in NetBeans with the data source configuration wizard.
-
Automated Continuous Discourse Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Discourse replication to IBM DB2.
-
Build Apps with Live ShipEngine Data Using the Low-Code Development Platform of Mendix
Connect ShipEngine data with Mendix to build apps using the CData API Driver for JDBC.
-
Create Data Visualizations Based On Microsoft Ads Data in Mode
Use CData Connect AI to connect to Microsoft Ads Data from Mode and build visualizations using live Microsoft Ads data.
-
Use ChatGPT to Talk to Your Slack 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 Slack data for you.
-
Replicate Multiple Greenhouse Accounts
Replicate multiple Greenhouse accounts to one or many databases.
-
Access Placid Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Placid data from HeidiSQL.
-
Enable the QuickBooks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with QuickBooks data.