CData Software - Knowledge Base
Recent Articles
-
Connect to SharePoint Data in Claris FileMaker Pro
Use the CData ODBC Driver for SharePoint in FileMaker Pro to connect to SharePoint and work with Microsoft SharePoint in your FileMaker applications.
-
Create Basecamp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Basecamp data access from reports, embedded analytics, and more.
-
Automated Continuous PabblySubscriptions Replication to Databricks
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Databricks.
-
Integrate Open WebUI with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Asana from within the chat interface.
-
A PostgreSQL Interface for Gumroad Data using the CData ODBC Driver
Use the SQL Gateway and Gumroad ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Visualize Live eBay Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live eBay into the Databricks platform and create visualization dashboards with real-time eBay.
-
Write a Simple Go Application to work with Drip Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Drip.
-
How to Access Shopify Data Using Entity Framework
This article shows how to access Shopify using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Open WebUI with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Data Lake Storage from within the chat interface.
-
Work with Microsoft Dataverse Data in FoxPro
Load Microsoft Dataverse (CDS) into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Phoenix Data in Heroku for Use in Salesforce Connect
Replicate Apache Phoenix to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Dash to Build to Web Apps on Sybase Data
Create Python applications that use pandas and Dash to build Sybase-connected web apps.
-
Build Visualizations of Oracle Eloqua Reporting Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Eloqua Reporting in Birst.
-
Integrate Live SAP Hybris C4C Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Hybris C4C from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Hybris C4C.
-
Integrating ScrapingBee Data in Talend Cloud Data Management Platform
Connect ScrapingBee Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrating GitHub Copilot CLI with FreeAgent 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 the Power BI Service to Brex: Complete Guide
Connect to the CData Software Power BI Connector for Brex from PowerBI.com to provide real-time Brex across the organization.
-
Visualize Testmonitor Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Testmonitor.
-
Build AI/ML Models with Live Oracle Data using Dataiku
Connect Oracle Data with Dataiku using the CData JDBC Driver for Oracle.
-
Connect to BigCommerce Data in Claris FileMaker Pro
Use the CData ODBC Driver for BigCommerce in FileMaker Pro to connect to BigCommerce and work with BigCommerce in your FileMaker applications.
-
Query WordPress Data from Node.js
Use the OData endpoint of the CData API Server to connect to your WordPress and perform CRUD operations on WordPress from Node.js.
-
How to Connect to Live LinkedIn Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live LinkedIn Ads securely in real time.
-
Integrating GitHub Copilot CLI with Notion 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.
-
Replicate Multiple GraphQL Accounts
Replicate multiple GraphQL accounts to one or many databases.
-
A PostgreSQL Interface for Microsoft Teams Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft Teams ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Nethunt 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 Nethunt into TIBCO Spotfire.
-
Use CData Connect AI to Access BigCommerce Data in Microsoft Power Pivot
Use CData Connect AI to connect to live BigCommerce in the Power Pivot business intelligence tool.
-
Access Live Eventbrite Data in AWS Lambda
Connect to live Eventbrite in AWS Lambda using the CData JDBC Driver.
-
Salesforce CRM Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce CRM Analytics through CData Connect AI using different applications and tools.
-
Use the CData Software ODBC Driver for Perigon in MicroStrategy
Connect to Perigon in MicroStrategy Developer using the CData Software ODBC Driver for Perigon.
-
Connect to Xero Data in HULFT Integrate
Connect to Xero as a JDBC data source in HULFT Integrate
-
Build Square-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Square and build web apps with connectivity to live Square.
-
Integrating Claude Code with Oracle Sales Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Sales within assisted coding and automated development workflows.
-
Integrating Kiro CLI with Reckon 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 a Data Access Object for Campaigner Data using JDBI
A brief overview of creating a SQL Object API for Campaigner in JDBI.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Couchbase within intelligent workflows.
-
Integrate Real-Time Access to Couchbase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Couchbase in real time.
-
Connect to SAP Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create SSAS Tabular Models from Amazon Marketplace Data
How to build a SQL Server Analysis Service Tabular Model from Amazon Marketplace using CData drivers.
-
Integrate xBase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate xBase with External Services.
-
Build Dashboards with Freshsales Data in Dundas BI
Create dynamic dashboards and perform analytics based on Freshsales in Dundas BI.
-
Connect to Vimeo Data from a Connection Pool in JBoss
Integrate Vimeo into Java servlets: Use the Management Console in JBoss to install the Vimeo JDBC Driver.
-
Design BIRT Reports on Microsoft Planner Data
Provide current Microsoft Planner to your embedded analytics.
-
Publish Sugar CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sugar CRM.
-
How to load Gumroad data into Elasticsearch via Logstash
Introducing a simple method to load Gumroad data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create ShipStation-Connected Dashboards in Grafana
Connect to ShipStation Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ShipStation.
-
Build Semantic Layer Views for FreshBooks Data in APOS Live Data Gateway
Use the CData Connector for FreshBooks in APOS Live Data Gateway to build Semantic Layer Views for FreshBooks.
-
Automated Continuous Cosmos DB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Cosmos DB replication to IBM DB2.
-
Prepare, Blend, and Analyze Shopify Data in Alteryx Designer (Connect AI)
Build workflows to access live Shopify for self-service data analytics.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Online Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks Online for you.
-
How to Connect to Live Redshift Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Amazon Redshift for you.
-
Replicate Mailgun Data in Heroku for Use in Salesforce Connect
Replicate Mailgun to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Confluence Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Atlassian Confluence from your Excel spreadsheets.
-
Connect Instagram Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Instagram using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Python Connector for Opsgenie
Learn to install and license the CData Python Connector
-
Connect to and Query MYOB AccountRight Data in QlikView over ODBC
Create data visualizations with MYOB AccountRight in QlikView.
-
How to create an RPA flow for Insightly Data in UiPath Studio
Use the Insightly ODBC Driver to create workflows that access real-time Insightly without any coding.
-
Build a Singer.io Tap for Mocean With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mocean data using
-
How to Connect to Live Freshdesk 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 Freshdesk for you.
-
Integrate with Freshdesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshdesk to a JSON file on disk.
-
How to Query Live Zoho Books Data in Claude Desktop
Connect to and query live Zoho Books Data in Claude Desktop using CData MCP Server.
-
Use Manus AI to Talk to Your Slack 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 Slack.
-
Replicate Salesforce Marketing Data to Multiple Databases via the CData Sync CLI
Replicate Salesforce Marketing Cloud to disparate databases with a single configuration.
-
Back Up Square to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Square. In this article, we will employ an SSIS workflow to populate a database with Square data.
-
How to connect Amazon QuickSight to SAP Ariba Procurement Data
Create a connection to SAP Ariba Procurement in CData Connect AI and insert SAP Ariba Procurement into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Claude Code CLI with Zoho Creator 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.
-
Establish a Live Connection with Freshservice Data using Tableau Bridge
The CData ODBC Driver for Freshservice enables you to integrate live Freshservice into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to VWO Data from Spring Boot
Connect to VWO in a Spring Boot Application using the CData API Driver for JDBC
-
Use Databricks Agent Bricks to Talk to Your Active Directory Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Active Directory for you.
-
Integrate Wistia Data in the Pentaho Report Designer
Publish reports based on Wistia in the Pentaho BI tool.
-
Integrate Exact Online with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Exact Online with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Exact Online.
-
Add Okta Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Okta with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Productboard Data Using Entity Framework
This article shows how to access Productboard using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to AdRoll Data from IntelliJ
Integrate connectivity to AdRoll with wizards in IntelliJ.
-
Connect to Pinterest Data in CloverDX (formerly CloverETL)
Transfer Pinterest using the visual workflow in the CloverDX data integration tool.
-
Build Data Flows from LionDesk to SQL Server using SSIS
Easily back up LionDesk to SQL Server using the SSIS components for LionDesk.
-
Query MarkLogic Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MarkLogic entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for RabbitMQ from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for RabbitMQ to connect to RabbitMQ from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring RabbitMQ in Excel.
-
Publish JSON-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live JSON.
-
Create a Data Access Object for Klipfolio Data using JDBI
A brief overview of creating a SQL Object API for Klipfolio in JDBI.
-
Model, Search, and Visualize Live Gong Data in ThoughtSpot
Use CData Connect AI to connect to live Gong for modeling, searching, and visualizing.
-
How to Query Live Figshare Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Figshare data in natural language using Python.
-
Connect to Keap Data in Aqua Data Studio
Access Keap from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Claude to Talk to Your BigCommerce 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 BigCommerce for you.
-
Automated Continuous CapsuleCRM Replication to Vertica
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Vertica.
-
View Reports on Real-Time Google Spanner Data in Power BI Report Server
Use the CData ODBC Driver for Google Spanner to visualize Google Spanner in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Demio Data from a Connection Pool in Jetty
The Demio JDBC Driver supports connection pooling: This article shows how to connect faster to Demio from Web apps in Jetty.
-
Extract, Transform, and Load Microsoft Planner Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Planner in Informatica PowerCenter.
-
Automated Continuous MailerLite Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MailerLite replication to AlloyDB.
-
Integrate with Couchbase Data in JReport Designer
Create charts and reports based on Couchbase in JReport Designer.
-
Getting Started with the CData Connect AI Python SDK for EnterpriseDB
Install the CData Connect AI Python SDK to read and write live EnterpriseDB with standard DB-API 2.0 Python code.
-
Migrating data from Freshteam to Databricks using CData SSIS Components.
Easily push Freshteam to Databricks using the CData SSIS Tasks for Freshteam and Databricks.
-
Automate Google Forms Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Forms replication to Azure Data Lake.
-
Use Claude to Talk to Your SAP Ariba Source 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 SAP Ariba Source for you.
-
Access Live ZohoSubscriptions Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZohoSubscriptions in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Live MongoDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Mailgun Reporting in OBIEE with the Mailgun JDBC Driver
Deploy the Mailgun JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Bridge Paylocity Connectivity with Apache NiFi
Access and process Paylocity in Apache NiFi using the CData JDBC Driver.
-
Visualize Jira Assets Data in Sisense
Create an ElastiCube in Sisense app with access to Jira Assets.
-
Build Highrise-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Highrise CRM and build Highrise-connected web apps with Axios.