CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Elasticsearch Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Google BigQuery.
-
Bidirectional Access to SFTP Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SFTP in Filemaker Pro for Mac or Windows.
-
Connect to PolarTeamPro Data in RazorSQL
Connect to PolarTeamPro from wizards and query PolarTeamPro from the GUI in the RazorSQL database management tool.
-
Replicate SageHR Data from PowerShell
Write a quick PowerShell script to query SageHR. Use connectivity to the live data to replicate SageHR to SQL Server.
-
Natively Connect to Toggl Data in PHP
The CData ODBC driver for Toggl enables you to create PHP applications with connectivity to Toggl. Leverage the native support for ODBC in PHP.
-
Connect to GitLab Data in Aqua Data Studio
Access GitLab from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bridge ElevenLabs Connectivity with Apache NiFi
Access and process ElevenLabs in Apache NiFi using the CData JDBC Driver.
-
Analyze Sugar CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sugar CRM and visualize Sugar CRM in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Hive in MicroStrategy
Connect to Apache Hive in MicroStrategy Developer using the CData Software ODBC Driver for Hive.
-
How to integrate PostgreSQL with Apache Airflow
Access and process PostgreSQL in Apache Airflow using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce
Create Salesforce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Pingdom Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pingdom.
-
How to use SQLAlchemy ORM to access Adobe Experience Manager Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Adobe Experience Manager.
-
How to Connect DBeaver to Google Forms via a JDBC Driver
Manage Google Forms with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Connect AI Python SDK for Basecamp
Install the CData Connect AI Python SDK to read and write live Basecamp with standard DB-API 2.0 Python code.
-
Connect to ZendeskSell Data in Aqua Data Studio
Access ZendeskSell from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Reports from Cosmos DB Data in Looker Studio
Use CData Connect AI to gain access to live Azure Cosmos DB and create custom reports in Looker Studio.
-
Integrating GitHub Copilot CLI with Amplitude 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 Databricks Agent Bricks to Talk to Your Facebook Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Facebook Ads for you.
-
Establish a Live Connection with Pushbullet Data using Tableau Bridge
The CData ODBC Driver for Pushbullet enables you to integrate live Pushbullet into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Marketo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Marketo and build Marketo-connected web apps with Axios.
-
Build Dashboards with ElevenLabs Data in DBxtra
Create dynamic dashboards and perform analytics based on ElevenLabs in DBxtra.
-
Analyze SAP Concur Data in Cognos Analytics
Use CData Connect AI to connect to SAP Concur Data from Cognos Analytics and analyze live SAP Concur.
-
Bidirectional Access to SAP SuccessFactors Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP SuccessFactors in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Excel in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Excel in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Excel.
-
Replicate Invoiced Data from PowerShell
Write a quick PowerShell script to query Invoiced. Use connectivity to the live data to replicate Invoiced to SQL Server.
-
Integrate Deel Data in Pentaho Data Integration
Build ETL pipelines based on Deel in the Pentaho Data Integration tool.
-
Create a Data Access Object for Paddle Data using JDBI
A brief overview of creating a SQL Object API for Paddle in JDBI.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Quickbase to Power BI dashboards. Simply drag and drop Quickbase into data visuals on the Power BI canvas.
-
Create CSV-Connected Dashboards in Grafana
Connect to CSV Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to CSV/TSV Files.
-
Manage Retently Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Retently.
-
Connect and Visualize Live Kintone Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Kintone into the Databricks platform and create visualization dashboards with real-time Kintone.
-
Edit and Search SAP BusinessObjects BI External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP BusinessObjects BI to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP BusinessObjects BI objects that you can access from apps and the dashboard.
-
How to connect SharePoint with eBay Data through external lists
Provide eBay to SharePoint users as an external list.
-
Build a Singer.io Tap for Act CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Act CRM data using
-
Use the CData API Server to Access SAP SuccessFactors Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP SuccessFactors in the Power Pivot business intelligence tool.
-
How to Access Superchat Data Using Entity Framework
This article shows how to access Superchat using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Sentry Data from MySQL in PHP
Connect to Sentry through the standard MySQL libraries in PHP.
-
Integrating Antigravity CLI with Azure Synapse via CData CLI
Connect Azure Synapse to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Monday.com Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Monday.com data access from reports, embedded analytics, and more.
-
Integrate Azure Table Data in Pentaho Data Integration
Build ETL pipelines based on Azure Table Storage in the Pentaho Data Integration tool.
-
Process & Analyze Elasticsearch Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Elasticsearch Data.
-
Create Dynamic Trello Grids Using the Infragistics XamDataGrid
Learn how you can connect Trello to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous LionDesk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LionDesk replication to Apache Kafka.
-
Connect to Real-Time ZohoPeople Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoPeople in Power Apps.
-
Choosing the Best Method to Connect Freshteam to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Freshteam from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Lakebase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Lakebase securely in real time.
-
Create Dynamic BigCommerce Grids Using the Infragistics XamDataGrid
Learn how you can connect BigCommerce to Infragistics XamDataGrid to build dynamic grids.
-
Integrate QuickBooks with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate QuickBooks with External Services.
-
How to Connect to Live Square Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Square without replication.
-
Publish Bannerbear-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Bannerbear.
-
Extract, Transform, and Load ConstantContact Data in Informatica PowerCenter
Create a simple Workflow for ConstantContact in Informatica PowerCenter.
-
Integrate Live Spotify Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Spotify to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Replicate Multiple Gorgias Accounts via the CData Sync CLI
Replicate multiple Gorgias accounts to one or many databases.
-
Build Semantic Layer Views for Nethunt Data in APOS Live Data Gateway
Use the CData Connector for Nethunt in APOS Live Data Gateway to build Semantic Layer Views for Nethunt.
-
Connect to PingOne Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect to Live Confluence 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 Atlassian Confluence for you.
-
Integrating OpenCode Terminal with SharePoint Excel Services 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.
-
Access Live NetSuite Data in AWS Lambda (with IntelliJ IDEA)
Connect to live NetSuite CRM & ERP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connecting GenSpark with ServiceNow Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ServiceNow without any replication or custom integration required.
-
Create Paymo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Paymo data access from reports, embedded analytics, and more.
-
Automated Continuous Sage 200 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sage 200 replication to Snowflake.
-
Use the CData Software ODBC Driver for Avro in MicroStrategy Desktop
Connect to Apache Avro in MicroStrategy Desktop using the CData Software ODBC Driver for Avro.
-
Configure the CData JDBC Driver for ClickUp in a Connection Pool in Tomcat
Connect to ClickUp from a connection pool in Tomcat.
-
Build Salesforce Marketing-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Salesforce Marketing Data and create custom apps in Mendix.
-
Bidirectional Access to Google Forms Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Forms in Filemaker Pro for Mac or Windows.
-
Import XML Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access XML Files. In this article, you will use the OData format to import XML Files into Microsoft Power Query.
-
How to Query Live Yelp Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Yelp data in natural language using Python.
-
How to load Redis data into Elasticsearch via Logstash
Introducing a simple method to load Redis data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Stream Marketo Data into Apache Kafka Topics
Access and stream Marketo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Manage Google Campaign Manager 360 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Campaign Manager 360.
-
Automated Continuous Oracle Financials Cloud Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Google BigQuery.
-
Analyze SendGrid Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SendGrid and visualize live SendGrid in Infragistics Reveal.
-
Create SSAS Tabular Models from Paddle Data
How to build a SQL Server Analysis Service Tabular Model from Paddle using CData drivers.
-
Stream Twitter Ads Data into Apache Kafka Topics
Access and stream Twitter Ads in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Bidirectional Access to Marketo Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Marketo in Filemaker Pro for Mac or Windows.
-
Seamlessly Bring Act-On Data into Retool Using CData Connect AI
Integrate Act-On data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect to Drift Data from Spring Boot
Connect to Drift in a Spring Boot Application using the CData API Driver for JDBC
-
How to Build an ETL App for Gmail Data in Python with CData Connect AI
Build ETL pipelines that read and write live Gmail in Python with petl and the CData Connect AI Python SDK.
-
Integrating Antigravity CLI with Zoho CRM via CData CLI
Connect Zoho CRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create QuickBooks Time-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to QuickBooks Time Data from Klipfolio and build custom visualizations using live QuickBooks Time.
-
Bidirectional Access to Facebook Ads Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Facebook Ads in Filemaker Pro for Mac or Windows.
-
Visualize Yelp Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Yelp.
-
Integrate Greenhouse Data into Power Automate Desktop using CData Connect
CData Connect for Greenhouse Data enables you to integrate Greenhouse into workflows built using Microsoft Power Automate Desktop.
-
Use the CData ODBC Driver for Hubstaff in Microsoft Power Query
You can use the CData Hubstaff ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Hubstaff into Microsoft Power Query.
-
Build MVC Applications with Connectivity to Impala Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Impala from an ASP.NET MVC application.
-
Use the CData Software JDBC Driver for Microsoft OneDrive in MicroStrategy Web
Connect to Microsoft OneDrive in MicroStrategy Web using the CData Software JDBC Driver for Microsoft OneDrive.
-
Integrating Cursor CLI with ShipStation 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 ZarMoney Data in DBVisualizer
Integrate ZarMoney with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate ZendeskSell Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZendeskSell from PowerShell? This article demonstrates how to utilize the ZendeskSell Cmdlets for tasks like connecting to ZendeskSell, automating operations, downloading data, and more.
-
Visualize GitHub Data in TIBCO Spotfire through OData
Integrate GitHub into dashboards in TIBCO Spotfire.
-
Use Agno to Talk to Your Adobe Analytics 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 Adobe Analytics for you.
-
Connect to and Query Close Data in QlikView over ODBC
Create data visualizations with Close in QlikView.
-
Build Semantic Layer Views for Hubstaff Data in APOS Live Data Gateway
Use the CData Connector for Hubstaff in APOS Live Data Gateway to build Semantic Layer Views for Hubstaff.
-
How to Work with Factorial Data in AWS Glue Jobs Using JDBC
Connect to Factorial from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect the Power BI Service to PayPal: Complete Guide
Connect to the CData Software Power BI Connector for PayPal from PowerBI.com to provide real-time PayPal across the organization.
-
How to Connect to Live Snowflake 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 Snowflake for you.
-
DataBind Controls to Coda Data in C++Builder
DataBind to Coda in C++Builder with standard components and controls.
-
Visualize FreshBooks Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load FreshBooks into TIBCO Spotfire.
-
Query Spark Data as a MySQL Database in Node.js
Execute MySQL queries against Apache Spark SQL from Node.js.