CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with Ontraport 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 Ontraport data into a Java-based ORM framework, Hibernate.
-
Connect to Avaza Data in RazorSQL
Connect to Avaza from wizards and query Avaza data from the GUI in the RazorSQL database management tool.
-
Explore Geographical Relationships in SFTP Data with Power Map
Create data visualizations with SFTP data in Power Map.
-
Use the CData Software ODBC Driver for Xero in MicroStrategy Web
Connect to Xero data in MicroStrategy Web using the CData Software ODBC Driver for Xero.
-
How to Connect DBeaver to Clockify via a JDBC Driver
Manage Clockify data with visual tools in DBeaver like the query browser.
-
Visualize Live Gmail Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Gmail data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Drip in SAS for Real-Time Reporting and Analytics
Connect to real-time Drip data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Drip.
-
Getting Started with the CData Excel Add-In for Workable
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Workable.
-
Build Apps with Live Quickbase Data Using the Low-Code Development Platform of Mendix
Connect Quickbase data with Mendix to build apps using the CData JDBC Driver for Quickbase.
-
Process & Analyze LinkedIn Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LinkedIn Data.
-
Automated Float Data Replication to Teradata
Use CData Sync to Customize and automate Float data replication to Teradata.
-
Integrate Sage 300 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sage 300 with External Services.
-
Automate AfterShip Data Replication to Azure Data Lake
Use CData Sync to customize and automate AfterShip data replication to Azure Data Lake.
-
Integrating Claude Code CLI with SAP SuccessFactors 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 Salesforce CRM Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesforce CRM Analytics data from HeidiSQL.
-
How to connect to FreeAgent Data from Spring Boot
Connect to FreeAgent in a Spring Boot Application using the CData API Driver for JDBC
-
Feed SAS xpt Data into FineReport
How to set SAS xpt data as a JDBC data source in FineReport.
-
How to Connect to & Open Shortcut Data in Microsoft Excel
This article uses the CData ODBC driver for Shortcut to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Rapidly Develop TigerGraph-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by TigerGraph.
-
Integrate Snowflake Data into Power Automate Desktop using CData Connect
CData Connect for Snowflake Data enables you to integrate Snowflake data into workflows built using Microsoft Power Automate Desktop.
-
Process & Analyze JDBC-ODBC Bridge Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live JDBC-ODBC Bridge Data.
-
Connect to Teradata Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Teradata to connect to Teradata data and execute queries in PowerBuilder.
-
Access Live Reckon Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Reckon data through MCP integration.
-
Import Act CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Act CRM Data from Azure Data Factory and import live Act CRM data.
-
Automated Continuous Hubstaff Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Hubstaff replication to Google Cloud SQL.
-
Build an OLAP Cube in SSAS from SAP Fieldglass Data
Establish a connection to SAP Fieldglass data data from SQL Server Analysis Services, and use the SAP Fieldglass Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Voice Agents in ElevenLabs with access to Live Adobe Commerce Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Adobe Commerce data.
-
How to create PDFMonkey federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PDFMonkey data in MySQL .
-
Use the CData Software JDBC Driver for CampaignMonitor in MicroStrategy Web
Connect to CampaignMonitor data in MicroStrategy Web using the CData Software JDBC Driver for CampaignMonitor.
-
Integrate Cline with Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sage Cloud Accounting data from within your IDE.
-
Import Jira Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Jira Data and provide access to live Jira data for custom reports in the Power BI Service.
-
Use the CData ODBC Driver for Foursquare from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Foursquare to connect to Foursquare data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Foursquare data in Excel.
-
Connect to NetSuite SuiteAnalytics Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live NetSuite SuiteAnalytics data from Filemaker Pro on Mac.
-
Query VWO Data as a SQL Server Database in Node.js
Execute SQL Server queries against VWO data from Node.js.
-
A PostgreSQL Interface for xBase Data (MySQL Remoting via JDBC)
Use the Remoting features of the xBase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Salesforce CRM Analytics in SpagoBI
Create reports featuring live Salesforce CRM Analytics data in SpagoBI Studio. Host Salesforce CRM Analytics reports on SpagoBI Server.
-
Automated Continuous SAP Ariba Source Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to MySQL.
-
Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy Desktop
Connect to Cosmos DB data in MicroStrategy Desktop using the CData Software JDBC Driver for Cosmos DB.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Teamgate
Provide connectivity to Teamgate data through an SAP BusinessObjects universe.
-
Easily Integrate QuickBooks Time Data in Lazarus Pascal IDE
Learn how to easily integrate live QuickBooks Time data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for Adobe Experience Manager in MicroStrategy Desktop
Connect to Adobe Experience Manager data in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Experience Manager.
-
Visualize SAP Netweaver Gateway Data in TIBCO Spotfire through ADO.NET
Integrate SAP Netweaver Gateway data into dashboards in TIBCO Spotfire.
-
Connect to Auth0 Data in NetBeans
Connect to Auth0 data in NetBeans with the data source configuration wizard.
-
Build Agents in Relevance AI with Access to Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Vertica data within intelligent agent workflows.
-
Connect to Hubstaff Data in CloverDX (formerly CloverETL)
Transfer Hubstaff data using the visual workflow in the CloverDX data integration tool.
-
Moving Data from Pushbullet to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pushbullet data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize ClickTime Data in TIBCO Spotfire through ADO.NET
Integrate ClickTime data into dashboards in TIBCO Spotfire.
-
Feed Redshift Data into FineReport
How to set Redshift data as a JDBC data source in FineReport.
-
Query Power BI XMLA Data as a MySQL Database in Node.js
Execute MySQL queries against Power BI XMLA data from Node.js.
-
How to connect to Gmail Data in DBVisualizer
Integrate Gmail data with visual data analysis tools and data connection wizards in DBVisualizer
-
Natively Connect to Apollo Data in PHP
The CData ODBC driver for Apollo enables you to create PHP applications with connectivity to Apollo data. Leverage the native support for ODBC in PHP.
-
Link Okta with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Okta data in Filemaker Pro for Mac or Windows.
-
Visualize Live TigerGraph Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live TigerGraph data.
-
Connect to Highrise from a Connection Pool in WebLogic
Use the CData JDBC Driver for Highrise to connect to Highrise data from Web applications running on WebLogic.
-
How to Create Power BI Visual Reports with Real-Time HubDB Data
Use CData Power BI Connectors to visualize HubDB data in Power BI.
-
AgileCRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to AgileCRM data through CData Connect AI using different applications and tools.
-
Automated Continuous Factorial Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Factorial replication to Google Cloud SQL.
-
Query Salesforce CRM Analytics Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce CRM Analytics data from Node.js.
-
Work with Hive Data in FoxPro
Load Hive data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Claude Code CLI with ZendeskSell 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 Power BI Reports on Real-Time Sage Intacct Data
Use the CData ODBC Driver for Sage Intacct to visualize Sage Intacct data in Power BI Desktop.
-
Query Google Calendar Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Calendar entities in PHP by modeling them as objects.
-
Build Dashboards with Amazon DynamoDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on Amazon DynamoDB data in Dundas BI.
-
How to connect to Nuclia Data in DBVisualizer
Integrate Nuclia data with visual data analysis tools and data connection wizards in DBVisualizer
-
Viewing FreshBooks Data in RAD Studio Data Explorer
How to view FreshBooks data in RAD Studio Data Explorer using the CData ODBC Driver for FreshBooks.
-
Connect to Live Sendwithus Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sendwithus in CData Connect AI and connect to your Sendwithus data from PostgreSQL.
-
Build a PostgreSQL Interface for Copper Data using the CData JDBC Driver
Use the Remoting features of the Copper JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports with Couchbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Couchbase data.
-
Connect to AlloyDB Data in CloverDX (formerly CloverETL)
Transfer AlloyDB data using the visual workflow in the CloverDX data integration tool.
-
Build Semantic Layer Views for QuickBooks Time Data in APOS Live Data Gateway
Use the CData Connector for QuickBooks Time in APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Time data.
-
Connect to SendInBlue Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SendInBlue to connect to SendInBlue data and execute queries in PowerBuilder.
-
Connect to Mailjet Data in DBeaver
Use the CData ODBC Driver to connect to Mailjet data in DBeaver.
-
How to connect SharePoint with Epicor Kinetic Data through external lists
Provide Epicor Kinetic data to SharePoint users as an external list.
-
Getting Started with the CData JDBC Driver for Freshservice
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Freshservice.
-
Build Dashboards with IBM Cloud Object Storage Data in Dundas BI
Create dynamic dashboards and perform analytics based on IBM Cloud Object Storage data in Dundas BI.
-
Query PingOne Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PingOne data from Node.js.
-
Build AI Agents with Authorize.Net Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Authorize.Net data through CData Connect AI.
-
Analyze Shortcut Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Shortcut data with the CData JDBC Driver for Shortcut.
-
Access Codat Data from MySQL in Amazon QuickSight
Connect to Codat and build visualizations of Codat data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Adobe Commerce Replication to Databricks
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Databricks.
-
Build Blackbaud FE NXT-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Blackbaud FE NXT data.
-
DataBind Cloudflare Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Cloudflare data to a chart.
-
Create Mailjet-Connected Business Apps in AppSheet
Connect to Mailjet Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Mailjet data.
-
Create Informatica Mappings From/To a JDBC Data Source for Stripe
Create Stripe data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Missive Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Missive and work with Missive data in your FileMaker application.
-
How to publish and share Landbot Data dashboards with Tableau Server
The CData ODBC driver for Landbot enables you integrate Landbot data into Tableau dashboards.
-
Build Agents in Relevance AI with Access to Live Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Freshteam data within intelligent agent workflows.
-
How to create Visio diagrams from Dynamics NAV Data
Automatically update Dynamics NAV data with the changes you make to Visio master shapes.
-
Use JayDeBeApi to access Qualaroo Data in Python
Use standard Python scripting and the development environment of your choice to access live Qualaroo data.
-
Enable the FormSite JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with FormSite data.
-
Use the CData Software ODBC Driver for Microsoft Dataverse in MicroStrategy
Connect to Microsoft Dataverse data in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Dataverse.
-
Build Timely Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Timely data and build visualizations in Tableau Cloud.
-
Integrate Devin with Live Shortcut Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Shortcut data.
-
Integrating Kiro with Google Spanner 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 Instagram from Asprova with CData Software ODBC Driver for Instagram
This article shows how to connect faster to Instagram data from Asprova.
-
Design BIRT Reports on Perplexity Data
Provide current Perplexity data to your embedded analytics.
-
Use the CData Software ODBC Driver for BigQuery in SAS for Real-Time Reporting and Analytics
Connect to real-time BigQuery data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for BigQuery.
-
Access Spotify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Spotify data from HeidiSQL.
-
Interact with Live Dynamics NAV Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Dynamics NAV data.
-
Build Voice Agents in ElevenLabs with access to Live Sendwithus Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sendwithus data.