CData Software - Knowledge Base
Recent Articles
-
Automated Continuous xBase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable xBase replication to Google BigQuery.
-
Access Live IBM Informix Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Informix from your Google Sheets.
-
Integrate with Grafana Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Grafana to a JSON file on disk.
-
Connect to ZarMoney Data in DBeaver
Use the CData ODBC Driver to connect to ZarMoney in DBeaver.
-
Excel Spreadsheet Automation on PolarTeamPro Data with the QUERY Formula
Pull data from PolarTeamPro, automate spreadsheets, and more with the QUERY formula.
-
Build Voice Agents in ElevenLabs with access to Live OneNote Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft OneNote.
-
Using the CData Software ODBC Driver for SAS xpt in PyCharm
Connect to SAS xpt as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAS xpt.
-
Bridge QuickBooks Connectivity with Apache NiFi
Access and process QuickBooks Desktop in Apache NiFi using the CData JDBC Driver.
-
Migrating data from Snapchat Ads to Google BigQuery using CData SSIS Components.
Easily push Snapchat Ads to Google BigQuery using the CData SSIS Tasks for Snapchat Ads and Google BigQuery.
-
Getting Started with the CData JDBC Driver for Printify
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Printify.
-
Access Scrapfly Data from MySQL in Amazon QuickSight
Connect to Scrapfly and build visualizations of Scrapfly using a MySQL Connection in Amazon QuickSight.
-
Build an OLAP Cube in SSAS from Google Cloud Storage Data
Establish a connection to Google Cloud Storage data from SQL Server Analysis Services, and use the Google Cloud Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Access SAP SuccessFactors LMS Data Using Entity Framework
This article shows how to access SAP SuccessFactors LMS using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to ZohoInvoice Data from Spring Boot
Connect to ZohoInvoice in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live Azure DevOps Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Azure DevOps data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous Certinia Replication to MongoDB
Use CData Sync for automated, continuous, customizable Certinia replication to MongoDB.
-
How to Connect to Live Gong Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Gong through natural language.
-
How to publish and share Wistia Data dashboards with Tableau Server
The CData ODBC driver for Wistia enables you integrate Wistia into Tableau dashboards.
-
Manage Printify Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Printify.
-
Access Live Elasticsearch Data in TIBCO Data Virtualization
Use the Elasticsearch Tibco DV Adapter to create a Elasticsearch data source in TIBCO Data Virtualization Studio and gain access to live Elasticsearch from your TDV Server.
-
Build JSON-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to JSON Services from Zoho Analytics and import live JSON.
-
Connect iContact to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect iContact with IBM WebSphere for seamless data integration and connectivity.
-
How to Create Power BI Visual Reports with Real-Time Sendwithus Data
Use CData Power BI Connectors to visualize Sendwithus in Power BI.
-
Getting Started with the CData SSIS Components for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Snapchat Ads.
-
Use Microsoft Copilot Studio to talk to your Asana 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 Asana for you.
-
Query Oracle Service Cloud Data in DataGrip
Create a Data Source for Oracle Service Cloud in DataGrip and use SQL to query live Oracle Service Cloud.
-
Connect to Zoom Data in CloverDX (formerly CloverETL)
Transfer Zoom using the visual workflow in the CloverDX data integration tool.
-
Build Snapchat Ads-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Snapchat Ads to explore live Snapchat Ads Data in Cursor to assist with building Snapchat Ads-powered applications.
-
How to Connect the Power BI Service to Google Directory: Complete Guide
Connect to the CData Software Power BI Connector for Google Directory from PowerBI.com to provide real-time Google Directory across the organization.
-
Query Calendly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Calendly from Node.js.
-
How to Use a Microsoft Access Database to Update Blackbaud FE NXT Data in Real Time
Update Blackbaud FE NXT data by creating a linked table in Microsoft Access with the CData Blackbaud FE NXT ODBC Driver.
-
LINQ to ZohoPeople Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the ZohoPeople Data Provider.
-
Analyze Act CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Act CRM in Microsoft R Open.
-
Natively Connect to Coinbase Data in PHP
The CData ODBC driver for Coinbase enables you to create PHP applications with connectivity to Coinbase. Leverage the native support for ODBC in PHP.
-
Connect to SAP BusinessObjects BI Data in DBArtisan
Use wizards in DBArtisan to configure SAP BusinessObjects BI as a data source.
-
How to Access Live BambooHR Data in Power Automate Desktop via ODBC
The CData ODBC Driver for BambooHR enables you to integrate BambooHR into workflows built using Microsoft Power Automate Desktop.
-
Query, Visualize, and Share live Procore Data in Redash
Use CData Connect AI to connect to live Procore in Redash for querying, visualizing, and sharing.
-
Query SAP Netweaver Gateway Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Netweaver Gateway from Node.js.
-
Integrating OpenCode Terminal with xBase 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.
-
Build AI/ML Models with Live Hive Data using Dataiku
Connect Hive Data with Dataiku using the CData JDBC Driver for Hive.
-
Connect to Oracle Eloqua Data in Jaspersoft Studio
Execute SQL to remote Oracle Eloqua in Jaspersoft Studio.
-
Consume Anaplan OData Feeds in PowerBuilder
This article demonstrates how to consume Anaplan as OData feeds from PowerBuilder using the API Server.
-
Build Dashboards with Sybase IQ Data in DBxtra
Create dynamic dashboards and perform analytics based on Sybase IQ in DBxtra.
-
Deploy the ADO.NET Provider for SAP HANA on an SSRS Report Server
Connect to SAP HANA 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.
-
Automated Continuous FHIR Replication to Oracle
Use CData Sync for automated, continuous, customizable FHIR replication to Oracle.
-
DataBind Controls to Chargebee Data in C++Builder
DataBind to Chargebee in C++Builder with standard components and controls.
-
Use Dash to Build Web Apps on Google Drive Data via CData Connect AI
Build interactive Dash web apps on live Google Drive using pandas and the CData Connect AI Python SDK.
-
Use the CData API Server to Access Presto Data in Microsoft PowerPivot
Use the CData API Server to connect to live Presto in the Power Pivot business intelligence tool.
-
Automated Continuous Egnyte Replication to Oracle
Use CData Sync for automated, continuous, customizable Egnyte replication to Oracle.
-
Integrating Antigravity CLI with Microsoft Dynamics CRM via CData CLI
Connect Microsoft Dynamics CRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Object-Relational Mapping (ORM) with Mocean 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 Mocean into a Java-based ORM framework, Hibernate.
-
Lakebase Reporting in OBIEE with the Lakebase JDBC Driver
Deploy the Lakebase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Informatica Mappings From/To an ODBC Data Source for Active Directory
Create an ODBC connection to Active Directory in Informatica and browse and transfer Active Directory.
-
Visualize ActiveCampaign 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 ActiveCampaign into TIBCO Spotfire.
-
How to connect to Hubstaff Data from Spring Boot
Connect to Hubstaff in a Spring Boot Application using the CData API Driver for JDBC
-
Replicate Multiple Dynamics 365 Accounts
Replicate multiple Dynamics 365 accounts to one or many databases.
-
Automated Continuous Airtable Replication to SQL Server
Use CData Sync for automated, continuous, customizable Airtable replication to SQL Server.
-
Analyze Google Spanner Data in Cognos Analytics
Use CData Connect AI to connect to Google Spanner Data from Cognos Analytics and analyze live Google Spanner.
-
Connect Demio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Demio using the CData Python MCP Server.
-
How to Access Live Google Cloud Storage Data in Visual Studio Code via Cline
Run CData MCP Server for Google Cloud Storage on Windows Subsytem for Linux (WSL) and connect to live Google Cloud Storage from the Cline extension in Visual Studio Code.
-
Use the CData Software JDBC Driver for SageHR in MicroStrategy Web
Connect to SageHR in MicroStrategy Web using the CData Software JDBC Driver for SageHR.
-
Automated Continuous Perplexity Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Perplexity replication to AlloyDB.
-
Integrate SAP Business Warehouse Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Business Warehouse from Informatica Cloud.
-
Automated Continuous Parquet Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Parquet replication to delimited files (CSV/TSV).
-
Automated Continuous ClickTime Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ClickTime replication to delimited files (CSV/TSV).
-
Getting Started with the CData ODBC Driver for Excel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Excel.
-
Use the CData Software ODBC Driver for Databricks in MicroStrategy Desktop
Connect to Databricks in MicroStrategy Desktop using the CData Software ODBC Driver for Databricks.
-
Automated Continuous WooCommerce Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable WooCommerce replication to Azure SQL Database.
-
Integrate Goose with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Ads from within the local AI agent.
-
Connect to Tally Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Tally to connect to Tally ERP and execute queries in PowerBuilder.
-
Building Dynamic Web Pages with Epicor Kinetic Data Using AngularJS
Create single-page applications with live connectivity to Epicor Kinetic using the CData API Server.
-
Visualize Foursquare Data in Tableau
The CData ODBC driver for Foursquare enables you integrate Foursquare into Tableau dashboards.
-
Automate JotForm Data Replication to Couchbase
Use CData Sync to Customize and automate JotForm replication to Couchbase.
-
Provide OData Services of Elasticsearch Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Elasticsearch by developing a WCF Service Application.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Clio
Provide connectivity to Clio through an SAP BusinessObjects universe.
-
Create Avalara AvaTax Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Avalara AvaTax from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze Telegram Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Telegram with the CData JDBC Driver for Telegram.
-
Use Agno to Talk to Your Raisers Edge NXT 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 Raisers Edge NXT for you.
-
Migrating data from Elorus to Snowflake using CData SSIS Components.
Easily push Elorus to Snowflake using the CData SSIS Tasks for Elorus and Snowflake.
-
Build Semantic Layer Views for Asana Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Asana.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live IBM Informix using the Model Context Protocol.
-
Build Visualizations of Recurly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Recurly in Birst.
-
Build Google Contacts-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Contacts to explore live Google Contacts Data in Claude Code to assist with building Google Contacts-powered applications.
-
Automated Continuous Oracle Financials Cloud Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to MongoDB.
-
Replicate Multiple ServiceNow Accounts via the CData Sync CLI
Replicate multiple ServiceNow accounts to one or many databases.
-
Integrating Exact Online Data in Talend Cloud Data Management Platform
Connect Exact Online Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Exact Online.
-
Access PDFMonkey Data from MySQL in Amazon QuickSight
Connect to PDFMonkey and build visualizations of PDFMonkey using a MySQL Connection in Amazon QuickSight.
-
Build Agents in Relevance AI with Access to Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Atlassian Jira within intelligent agent workflows.
-
Create Dynamic Jira Grids Using the Infragistics XamDataGrid
Learn how you can connect Jira to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Microsoft Teams Data to Multiple Databases
Replicate Microsoft Teams to disparate databases with a point-and-click configuration.
-
Consume LinkedIn OData Feeds in SAP Lumira
Use the API Server to create data visualizations on LinkedIn feeds that reflect any changes in SAP Lumira.
-
Build Charts with Delighted Data in Clear Analytics
Create dynamic charts and perform analytics based on Delighted in Clear Analytics.
-
Publish Crystal Reports on Vimeo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Vimeo.
-
Use the CData Software ODBC Driver for SuiteCRM in MicroStrategy Desktop
Connect to SuiteCRM in MicroStrategy Desktop using the CData Software ODBC Driver for SuiteCRM.
-
Build Freshdesk-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Freshdesk to explore live Freshdesk Data in Cursor to assist with building Freshdesk-powered applications.
-
Build Apps with Live Rebilly Data Using the Low-Code Development Platform of Mendix
Connect Rebilly with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Live Toggl Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Toggl using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Microsoft Exchange Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to SQL Server.
-
Query Adobe Target Data as a MySQL Database in Node.js
Execute MySQL queries against Adobe Target from Node.js.
-
How to create an RPA flow for SQL Server Data in UiPath Studio
Use the SQL Server ODBC Driver to create workflows that access real-time Microsoft SQL Server without any coding.