CData Software - Knowledge Base
Recent Articles
-
Integrate Shopify with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Shopify with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Shopify.
-
Connect to Live OData Services in PostGresSQL Interface through CData Connect AI
Create a live connection to OData in CData Connect AI and connect to your OData from PostgreSQL.
-
Automate WordPress Data Replication to Couchbase
Use CData Sync to Customize and automate WordPress replication to Couchbase.
-
Query Pipedrive Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pipedrive from Node.js.
-
How to update SAP Business One from Excel
This article explains how to transfer data from Excel to SAP Business One using the Excel Add-In for SAP Business One.
-
Automated Continuous Attio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Attio replication to Amazon S3.
-
Integrate Goose with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Twilio from within the local AI agent.
-
Build Dashboards with Tally Data in DBxtra
Create dynamic dashboards and perform analytics based on Tally ERP in DBxtra.
-
Integrate LibreChat with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Snowflake from within the chat interface.
-
Deploy the ADO.NET Provider for CapsuleCRM on an SSRS Report Server
Connect to CapsuleCRM 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 Google Analytics 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 Google Analytics into a Java-based ORM framework, Hibernate.
-
Integrating Kiro CLI with LaunchDarkly 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.
-
Integrate Live PDFMonkey Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PDFMonkey to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize NetSuite Data in TIBCO Spotfire through ADO.NET
Integrate NetSuite CRM & ERP into dashboards in TIBCO Spotfire.
-
Connect to Telegram Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Telegram as an External Source in Dremio.
-
Publish Azure DevOps-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure DevOps.
-
Create Google Cloud Storage-Connected Dashboards in Grafana
Connect to Google Cloud Storage Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Cloud Storage.
-
Connect to Bitbucket Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bitbucket and the SQL Gateway to access Bitbucket from Google Apps Script.
-
Connect to Dotmailer Data from PowerBuilder via JDBC
This article demonstrates how to access Dotmailer from PowerBuilder using the Dotmailer JDBC Driver.
-
Use the CData Software JDBC Driver for Miro in MicroStrategy
Connect to Miro in MicroStrategy Developer using the CData Software JDBC Driver for Miro.
-
Connect to SAP Business One Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Business One Data and connect to SAP Business One in Akorbi Digital RunMyProcess.
-
Integrating Boomi Agentstudio with Google Directory Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Directory, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
A PostgreSQL Interface for Google Translate Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Translate JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to use SQLAlchemy ORM to access Zoho Recruit Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Recruit.
-
Create Data Visualizations in Cognos BI with Microsoft Planner Data
Access Microsoft Planner as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to OneNote in SpagoBI
Create reports featuring live Microsoft OneNote in SpagoBI Studio. Host OneNote reports on SpagoBI Server.
-
Replicate Hubstaff Data to Multiple Databases via the CData Sync CLI
Replicate Hubstaff to disparate databases with a single configuration.
-
How to connect to Blackbaud FE NXT Data with Squirrel SQL client
Connect to Blackbaud FE NXT and execute queries in the Squirrel SQL Client.
-
Visualize Missive Data in Tableau
The CData ODBC driver for Missive enables you integrate Missive into Tableau dashboards.
-
Use Microsoft Copilot Studio to talk to your Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Azure DevOps for you.
-
Enable the Oracle Financials Cloud JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Financials Cloud.
-
Connect to Qualaroo Data from a Connection Pool in Jetty
The Qualaroo JDBC Driver supports connection pooling: This article shows how to connect faster to Qualaroo from Web apps in Jetty.
-
Visualize Demio Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Demio.
-
Using the CData Software ODBC Driver for Unbounce in PyCharm
Connect to Unbounce as an ODBC data source in PyCharm using the CData Software ODBC Driver for Unbounce.
-
Visualize Google Analytics Data in Sisense
Create an ElastiCube in Sisense app with access to Google Analytics.
-
How to use SQLAlchemy ORM to access Zuora Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zuora.
-
Connect to SAP Ariba Procurement Data in RazorSQL
Connect to SAP Ariba Procurement from wizards and query SAP Ariba Procurement from the GUI in the RazorSQL database management tool.
-
Visualize Ontraport Data in TIBCO Spotfire through ADO.NET
Integrate Ontraport into dashboards in TIBCO Spotfire.
-
Analyze Marketo Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Marketo and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Query xBase Data in MySQL Workbench
Execute MySQL queries against live xBase from MySQL Workbench.
-
How to Create Power BI Visual Reports with Real-Time Oracle HCM Cloud Data
Use CData Power BI Connectors to visualize Oracle HCM Cloud in Power BI.
-
Access Google Drive Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Drive from HeidiSQL.
-
Migrating data from Flowlu to Google BigQuery using CData SSIS Components.
Easily push Flowlu to Google BigQuery using the CData SSIS Tasks for Flowlu and Google BigQuery.
-
Create Apps from Google Spanner Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Spanner Data and build apps from live Google Spanner in Qlik Sense Cloud.
-
Automate Elasticsearch Data Replication to Azure Data Lake
Use CData Sync to customize and automate Elasticsearch replication to Azure Data Lake.
-
Work with LightSpeedRetail Data in FoxPro
Load LightSpeedRetail into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Outreach.io Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Outreach.io replication to OneLake in Microsoft Fabric.
-
Create Power BI Reports on Real-Time SAS xpt Data
Use the CData ODBC Driver for SAS xpt to visualize SAS XPORT in Power BI Desktop.
-
How to Connect DBeaver to Dropbox via a JDBC Driver
Manage Dropbox with visual tools in DBeaver like the query browser.
-
Integrate Cursor with Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live YouTube Analytics from within the editor.
-
Feed Azure Analysis Services Data into FineReport
How to set Azure Analysis Services as a JDBC data source in FineReport.
-
Process & Analyze EnterpriseDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live EnterpriseDB Data.
-
Replicate Multiple Cloudant Accounts via the CData Sync CLI
Replicate multiple Cloudant accounts to one or many databases.
-
Create Elasticsearch-Connected Dashboards in Grafana
Connect to Elasticsearch Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Elasticsearch.
-
Connect and Query Live Redshift Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon Redshift into Databricks
-
Bind Live Salesforce Data 360 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Data 360 data
-
Integrate Dynamics CRM Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Dynamics CRM in the Pentaho Data Integration tool.
-
Integrating Kiro CLI with Jumpseller 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.
-
Edit and Search External Twilio Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Twilio to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Twilio Data objects that you can access from apps and the dashboard.
-
Use Claude to Talk to Your Sage Intacct 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 Sage Intacct for you.
-
How to Access Codat Data Using Entity Framework
This article shows how to access Codat using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to LinkedIn Ads Data from IntelliJ
Integrate connectivity to LinkedIn Ads with wizards in IntelliJ.
-
Build Dashboards with HCL Domino Data in DBxtra
Create dynamic dashboards and perform analytics based on HCL Domino in DBxtra.
-
Publish CouchDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache CouchDB.
-
Automated Continuous Dynamics 365 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Apache Cassandra.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Entra ID
Provide connectivity to Microsoft Entra ID through an SAP BusinessObjects universe.
-
Everhour Reporting in OBIEE with the Everhour JDBC Driver
Deploy the Everhour JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build MVC Applications with Connectivity to Placid Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Placid from an ASP.NET MVC application.
-
Configure the CData JDBC Driver for Gumroad in a Connection Pool in Tomcat
Connect to Gumroad from a connection pool in Tomcat.
-
Connect to Live NetSuite Data in MicroStrategy through CData Connect AI
Create a live connection to NetSuite Data in CData Connect AI and connect to your NetSuite CRM & ERP from MicroStrategy.
-
Visualize SAS xpt Data in Tableau
The CData ODBC driver for SAS xpt enables you integrate SAS XPORT into Tableau dashboards.
-
How to Connect to Live Act CRM Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Act CRM for you.
-
Integrate Apollo Data in the Pentaho Report Designer
Publish reports based on Apollo in the Pentaho BI tool.
-
How to integrate Metabase with Zoho Books Data
Use CData Connect AI to connect to live Zoho Books and create an interactive dashboard in Metabase from Zoho Books.
-
Query HDFS Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache HDFS.
-
How to Seamlessly Import QuickBooks Online Data into IBM SPSS Modeler
Integrate QuickBooks Online data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Pushbullet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pushbullet.
-
How to Connect to Live Amazon Marketplace 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 Amazon Marketplace for you.
-
DataBind Controls to MongoDB Data in Delphi
DataBind to MongoDB in Delphi with standard data access components and controls.
-
How to connect and process Demio from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Demio.
-
How to connect to Sage 300 Data with Squirrel SQL client
Connect to Sage 300 and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData SSIS Components for Typeform
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Typeform.
-
Access Live Zoho Books Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Books from your Google Sheets.
-
Access Live Tally Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Tally data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Analyze Shopify Data in Looker
Use CData Connect AI to connect to Shopify Data from Looker and build custom apps using live Shopify.
-
Access Retently Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Retently.
-
Integrating Quickbase Data in Talend Cloud Data Management Platform
Connect Quickbase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Quickbase.
-
Integrating GitHub Copilot CLI with MongoDB 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 Clio Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Clio replication to PostgreSQL.
-
Bidirectional Access to Kintone Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Kintone in Filemaker Pro for Mac or Windows.
-
Excel Spreadsheet Automation on Active Directory Data with the QUERY Formula
Pull data from Active Directory, automate spreadsheets, and more with the QUERY formula.
-
Consume Marketo OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Marketo feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData Python Connector for Hubstaff
Learn to install and license the CData Python Connector
-
Build SAP Hybris C4C-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP Hybris C4C Data from Zoho Analytics and import live SAP Hybris C4C.
-
Use the CData Software JDBC Driver for ShipStation in MicroStrategy Desktop
Connect to ShipStation in MicroStrategy Desktop using the CData Software JDBC Driver for ShipStation.
-
Integrating Dataiku with SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SendGrid.
-
Access Paylocity Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Paylocity from HeidiSQL.
-
Connect to Shopify Data in JRuby
Create a simple JRuby app with access to live Shopify.
-
Using the CData Software ODBC Driver for Slack in PyCharm
Connect to Slack as an ODBC data source in PyCharm using the CData Software ODBC Driver for Slack.
-
Connect to Microsoft Dataverse Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Dataverse (CDS) using standard SQL.