CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to Keap Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Keap in Filemaker Pro for Mac or Windows.
-
Connect to Kafka Data from a Connection Pool in JBoss
Integrate Apache Kafka into Java servlets: Use the Management Console in JBoss to install the Kafka JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Landbot Data
Use CData Power BI Connectors to visualize Landbot in Power BI.
-
Viewing Float Data in RAD Studio Data Explorer
How to view Float in RAD Studio Data Explorer using the CData ODBC Driver for Float.
-
Replicate Presto Data in Heroku for Use in Salesforce Connect
Replicate Presto to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Workable Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Workable and the SQL Gateway to access Workable from Google Apps Script.
-
Build Charts with FHIR Data in Clear Analytics
Create dynamic charts and perform analytics based on FHIR in Clear Analytics.
-
Build Semantic Layer Views for Adobe Analytics Data in APOS Live Data Gateway
Use the CData Connector for Adobe Analytics in APOS Live Data Gateway to build Semantic Layer Views for Adobe Analytics.
-
Integrating Boomi Agentstudio with DB2 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to IBM DB2, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to import Mocean Data into Apache Solr
Use the CData Software JDBC Driver for Mocean in Data Import Handler and create an automated import of Mocean to Apache Solr Enterprise Search platform.
-
Build Automated CSV-Connected Workflows in Zapier
Use CData Connect AI to connect to live CSV/TSV Files and build automated workflows in Zapier.
-
Integrating Cursor CLI with Gmail 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.
-
Query Foursquare Data as a MySQL Database in Node.js
Execute MySQL queries against Foursquare from Node.js.
-
Replicate Authorize.Net Data to Multiple Databases via the CData Sync CLI
Replicate Authorize.Net to disparate databases with a single configuration.
-
Visualize Live Jira Assets Data in the Power BI Service
Use CData Connect AI to connect to live Jira Assets and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Discourse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Discourse.
-
Build Visualizations of Microsoft Ads Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Ads in Birst.
-
How to create OpenWeatherMap federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for OpenWeatherMap in MySQL .
-
Connecting Pipedream with ShipStation Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ShipStation data in real time.
-
Natively Connect to Salesloft Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesloft. Leverage the native support for ODBC in PHP.
-
Connect to HBase Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apache HBase.
-
Connect to Calendly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Calendly in the Denodo Virtual DataPort Administrator.
-
How to load MySQL data into Elasticsearch via Logstash
Introducing a simple method to load MySQL data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize Microsoft Dataverse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Dataverse (CDS).
-
Automate eBay Data Replication to Azure Synapse
Use CData Sync to customize and automate eBay replication to Azure Synapse.
-
How to use SQLAlchemy ORM to access Contentful Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Contentful.
-
Use JayDeBeApi to access Workable Data in Python
Use standard Python scripting and the development environment of your choice to access live Workable.
-
Use ChatGPT to Talk to Your API 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 API for you.
-
Create a Data Access Object for Humanity Data using JDBI
A brief overview of creating a SQL Object API for Humanity in JDBI.
-
Use Dash to Build to Web Apps on Reckon Data
Create Python applications that use pandas and Dash to build Reckon-connected web apps.
-
Connect to Splunk from a Connection Pool in WebLogic
Use the CData JDBC Driver for Splunk to connect to Splunk from Web applications running on WebLogic.
-
Connect to Wave Financial Data in RazorSQL
Connect to Wave Financial from wizards and query Wave Financial from the GUI in the RazorSQL database management tool.
-
Integrate with SAP Ariba Procurement Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Ariba Procurement to a JSON file on disk.
-
Build Agents in Relevance AI with Access to Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Blackbaud FE NXT within intelligent agent workflows.
-
Explore Geographical Relationships in LaunchDarkly Data with Power Map
Create data visualizations with LaunchDarkly in Power Map.
-
Automated Continuous Billsby Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Billsby replication to Apache Cassandra.
-
Getting Started with the CData SSIS Components for Teradata
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Teradata.
-
Create Reports with PDFMonkey Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PDFMonkey.
-
Publish MYOB AccountRight-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MYOB AccountRight.
-
Automated Continuous FreeAgent Replication to MongoDB
Use CData Sync for automated, continuous, customizable FreeAgent replication to MongoDB.
-
Getting Started with the CData Tableau Connector for Vault CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Vault CRM.
-
Connect to Recurly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Recurly using standard SQL.
-
Query Azure Synapse Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Azure Synapse and perform CRUD operations on Azure Synapse from Node.js.
-
Integrating Claude Code CLI with Pipeline CRM 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.
-
How to connect to Aha! Data with Squirrel SQL client
Connect to Aha! and execute queries in the Squirrel SQL Client.
-
Connect to Odoo Data from PowerBuilder via JDBC
This article demonstrates how to access Odoo ERP from PowerBuilder using the Odoo JDBC Driver.
-
Excel Spreadsheet Automation on Eventbrite Data with the QUERY Formula
Pull data from Eventbrite, automate spreadsheets, and more with the QUERY formula.
-
Use Manus AI to Talk to Your Basecamp 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 Basecamp.
-
Prepare, Blend, and Analyze MailChimp Data in Alteryx Designer (ODBC)
Build workflows to access live MailChimp for self-service data analytics.
-
Process & Analyze Adobe Experience Manager Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Adobe Experience Manager Data.
-
Import Pinterest Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Pinterest. In this article, you will use the OData format to import Pinterest into Microsoft Power Query.
-
Build AI/ML Models with Live Bitly Data using Dataiku
Connect Bitly Data with Dataiku using the CData API Driver for JDBC.
-
Load Eventbrite Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Eventbrite to a database.
-
How to Connect the Power BI Service to Nuclia: Complete Guide
Connect to the CData Software Power BI Connector for Nuclia from PowerBI.com to provide real-time Nuclia across the organization.
-
Process & Analyze Insightly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Insightly Data.
-
How to Access Live Zoho Books Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Books enables you to integrate Zoho Books into workflows built using Microsoft Power Automate Desktop.
-
How to Connect DBeaver to PingOne via a JDBC Driver
Manage PingOne with visual tools in DBeaver like the query browser.
-
Automated Continuous API Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable API replication to Azure SQL Database.
-
Choosing the Best Method to Connect Pipeliner CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pipeliner CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Azure Analysis Services Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Analysis Services and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build a Simple VCL Application for Pinterest Data
How to build a simple VCL Application to view Pinterest in RAD Studio using the CData ODBC Driver for Pinterest.
-
How to create Visio diagrams from Spark Data
Automatically update Apache Spark SQL with the changes you make to Visio master shapes.
-
Stream Greenhouse Data into Apache Kafka Topics
Access and stream Greenhouse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
A PostgreSQL Interface for AgileCRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the AgileCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Smartsheet Data in Coginiti Pro
Connect to and query live Smartsheet from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Google Forms Data in Sisense
Create an ElastiCube in Sisense app with access to Google Forms.
-
Connect to Cohere Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Campaigner Data Replication to Azure Data Lake
Use CData Sync to customize and automate Campaigner replication to Azure Data Lake.
-
Create Oracle Service Cloud Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle Service Cloud from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Real-Time Hugging Face Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Hugging Face in ColdFusion.
-
How to Visualize Epicor Kinetic Data in Python with pandas
Use pandas and other modules to analyze and visualize live Epicor Kinetic in Python.
-
Automated Continuous Attio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Attio replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for Tally in SAS for Real-Time Reporting and Analytics
Connect to real-time Tally ERP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Tally.
-
Connect to Oracle HCM Cloud Data in RazorSQL
Connect to Oracle HCM Cloud from wizards and query Oracle HCM Cloud from the GUI in the RazorSQL database management tool.
-
Prepare, Blend, and Analyze Gumroad Data in Alteryx Designer (ODBC)
Build workflows to access live Gumroad for self-service data analytics.
-
ServiceDesk Plus Reporting in OBIEE with the ServiceDesk Plus JDBC Driver
Deploy the ServiceDesk Plus JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Visualizations of CockroachDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CockroachDB in Birst.
-
A PostgreSQL Interface for HBase Data (MySQL Remoting via JDBC)
Use the Remoting features of the HBase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate WooCommerce Data Replication to Azure Data Lake
Use CData Sync to customize and automate WooCommerce replication to Azure Data Lake.
-
How to Design Google Calendar Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Google Calendar from mobile and tablet Power Apps.
-
Integrating Antigravity CLI with Active Directory via CData CLI
Connect Active Directory to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Power BI Reports on Real-Time Nethunt Data
Use the CData ODBC Driver for Nethunt to visualize Nethunt in Power BI Desktop.
-
A PostgreSQL Interface for Facebook Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Facebook Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating GitHub Copilot CLI with Elorus 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.
-
Automated Continuous NetSuite SuiteAnalytics Replication to MongoDB
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to MongoDB.
-
Getting Started with the CData Python Connector for SAP Concur
Learn to install and license the CData Python Connector
-
Create Freshdesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Freshdesk data access from reports, embedded analytics, and more.
-
Integrating Gong Data in Talend Cloud Data Management Platform
Connect Gong Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to YouTube Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for YouTube Analytics and the SQL Gateway to access YouTube Analytics from Google Apps Script.
-
Use the CData Software JDBC Driver for Factorial in MicroStrategy Desktop
Connect to Factorial in MicroStrategy Desktop using the CData Software JDBC Driver for Factorial.
-
How to connect PolyBase to Humanity
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Humanity.
-
Viewing Ontraport Data in RAD Studio Data Explorer
How to view Ontraport in RAD Studio Data Explorer using the CData ODBC Driver for Ontraport.
-
DataBind Charts to Asana Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Asana from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
A PostgreSQL Interface for Oracle Sales Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Sales ODBC Driver to create a PostgreSQL entry-point for data access.
-
Working with Front Data in LINQPad
Execute LINQ queries to Front in LINQPad.
-
How to Connect to Live Slack Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Slack securely in real time.
-
Connect to Real-Time Gorgias Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Gorgias in Power Apps.
-
Integrating Cursor CLI with Paylocity 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.
-
Use Grok to Talk to Your Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache Spark SQL for you.
-
Connect to HCL Domino Data in RapidMiner
Integrate HCL Domino with standard components and data source configuration wizards in RapidMiner Studio.