CData Software - Knowledge Base
Recent Articles
-
How to Easily Query SAP ByDesign Data in OpenOffice Base
Connect to SAP ByDesign data in OpenOffice Base using the CData ODBC Driver for SAP ByDesign and generate reports with live data insights.
-
How to connect SharePoint with SAP Concur Data through external lists
Provide SAP Concur to SharePoint users as an external list.
-
Building Dynamic Web Pages with ZarMoney Data Using AngularJS
Create single-page applications with live connectivity to ZarMoney using the CData API Server.
-
Build AdRoll-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to AdRoll and build web apps with connectivity to live AdRoll.
-
Visualize Azure Analysis Services Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Analysis Services.
-
Automated Continuous Stripe Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Stripe replication to Apache Kafka.
-
Query Jira Data in DataGrip
Create a Data Source for Jira in DataGrip and use SQL to query live Atlassian Jira.
-
How to Import Data from Cassandra into Google Sheets
Import Apache Cassandra into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous SAP HANA Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP HANA replication to Oracle.
-
Publish SAP Hybris C4C-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Hybris C4C.
-
Create Dynamic Grafana Grids Using the Infragistics XamDataGrid
Learn how you can connect Grafana to Infragistics XamDataGrid to build dynamic grids.
-
Build Visualizations of SAP HANA Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA in Birst.
-
Viewing Google Drive Data in RAD Studio Data Explorer
How to view Google Drive in RAD Studio Data Explorer using the CData ODBC Driver for Google Drive.
-
Integrating Vimeo Data in Talend Cloud Data Management Platform
Connect Vimeo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Validate PDFMonkey Data with QuerySurge
Access and validate PDFMonkey in QuerySurge using the CData JDBC Driver.
-
Import Real-Time SAP Netweaver Gateway Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Netweaver Gateway in ColdFusion.
-
Integrating Cursor CLI with Basecamp 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 Bright Data Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bright Data and the SQL Gateway to access Bright Data from Google Apps Script.
-
Access Live Mailjet Data in Coginiti Pro
Connect to and query live Mailjet from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for MailerSend in MicroStrategy Desktop
Connect to MailerSend in MicroStrategy Desktop using the CData Software ODBC Driver for MailerSend.
-
Connect to Reckon Data in CloverDX (formerly CloverETL)
Transfer Reckon using the visual workflow in the CloverDX data integration tool.
-
Integrating GitHub Copilot CLI with Apache Hive 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.
-
Load Aweber Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Aweber to a database.
-
Integrating GitHub Copilot CLI with Hacker News 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 Work with Freshservice Data in AWS Glue Jobs Using JDBC
Connect to Freshservice from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Visualize Dropbox Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dropbox in Python.
-
How to Connect to Live WordPress Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live WordPress securely in real time.
-
DataBind Controls to Auth0 Data in C++Builder
DataBind to Auth0 in C++Builder with standard components and controls.
-
Connect to Timely Data in DBArtisan
Use wizards in DBArtisan to configure Timely as a data source.
-
Integrate Wrike Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Wrike from Informatica Cloud.
-
Connect to Humanity Data in CloverDX (formerly CloverETL)
Transfer Humanity using the visual workflow in the CloverDX data integration tool.
-
Integrate with ZohoInvoice Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoInvoice to a JSON file on disk.
-
Integrate Live Excel Online Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Excel Online and integrate live Microsoft Excel Online into apps built in Microsoft Power Apps.
-
Publish SendPulse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SendPulse.
-
How to connect to Freshsales Data in DBVisualizer
Integrate Freshsales with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Access Mouseflow Data Using Entity Framework
This article shows how to access Mouseflow using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build an OLAP Cube in SSAS from Templated Data
Establish a connection to Templated data from SQL Server Analysis Services, and use the Templated Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connecting Mastra with Okta Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Okta, no replication required.
-
Integrate Open WebUI with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Planner from within the chat interface.
-
Extract, Transform, and Load WordPress Data in Informatica PowerCenter
Create a simple Workflow for WordPress in Informatica PowerCenter.
-
Connect to Pipeline CRM 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 Pipeline CRM and work with Pipeline CRM in your FileMaker application.
-
Connect to Reckon Data in JRuby
Create a simple JRuby app with access to live Reckon.
-
Create SSAS Tabular Models from HCL Domino Data
How to build a SQL Server Analysis Service Tabular Model from HCL Domino using CData drivers.
-
Integrating LangChain with Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Freshdesk within automated workflows.
-
Build Data Flows from Instantly to SQL Server using SSIS
Easily back up Instantly to SQL Server using the SSIS components for Instantly.
-
Migrating data from Okta to Google BigQuery using CData SSIS Components.
Easily push Okta to Google BigQuery using the CData SSIS Tasks for Okta and Google BigQuery.
-
Build Act CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Act CRM and build Act CRM-connected web apps with Axios.
-
Integrate Theia IDE with Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Natively Connect to MessageBird Data in PHP
The CData ODBC driver for MessageBird enables you to create PHP applications with connectivity to MessageBird. Leverage the native support for ODBC in PHP.
-
Use Grok to Talk to Your Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache Impala for you.
-
Access Live Smartsheet Data in AWS Lambda
Connect to live Smartsheet in AWS Lambda using the CData JDBC Driver.
-
Natively Connect to NetSuite Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to NetSuite CRM & ERP. Leverage the native support for ODBC in PHP.
-
Automated Continuous EnterpriseDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Google Cloud SQL.
-
Analyze ShipStation Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ShipStation and visualize live ShipStation in Infragistics Reveal.
-
Design BIRT Reports on Salesforce CRM Analytics Data
Provide current Salesforce CRM Analytics to your embedded analytics.
-
Automated Continuous GitHub Replication to Oracle
Use CData Sync for automated, continuous, customizable GitHub replication to Oracle.
-
Visualize Google Analytics Data in TIBCO Spotfire through OData
Integrate Google Analytics into dashboards in TIBCO Spotfire.
-
Connect to Retently Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData Tableau Connector for eBay
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for eBay.
-
Analyze MessageBird Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MessageBird and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
A PostgreSQL Interface for CloudConvert Data (MySQL Remoting via JDBC)
Use the Remoting features of the CloudConvert JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Mastra with Microsoft OneDrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Microsoft OneDrive, no replication required.
-
Integrate LibreChat with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Dynamics 365 Business Central from within the chat interface.
-
Use CData Connect AI to Access SurveyMonkey Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SurveyMonkey in the Power Pivot business intelligence tool.
-
Visualize BenchmarkEmail Data in TIBCO Spotfire through OData
Integrate BenchmarkEmail into dashboards in TIBCO Spotfire.
-
A PostgreSQL Interface for Google Sheets Data using the CData ODBC Driver
Use the SQL Gateway and Google Sheets ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy Desktop
Connect to Sage Business Cloud Accounting in MicroStrategy Desktop using the CData Software JDBC Driver for Sage Cloud Accounting.
-
Connect to and Query TaxJar Data in QlikView over ODBC
Create data visualizations with TaxJar in QlikView.
-
Implementing the CData JDBC Driver ITokenStore Interface
This guide explains how to implement the ITokenStore interface in CData JDBC Drivers to manage OAuth token persistence across distributed and cloud-based applications.
-
Feed Zoho Creator Data into FineReport
How to set Zoho Creator as a JDBC data source in FineReport.
-
Using the CData Software ODBC Driver for Dynamics NAV in PyCharm
Connect to Dynamics NAV as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics NAV.
-
Use the CData Software ODBC Driver for Freshdesk in MicroStrategy Desktop
Connect to Freshdesk in MicroStrategy Desktop using the CData Software ODBC Driver for Freshdesk.
-
Integrate Cline with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Reckon Accounts Hosted from within your IDE.
-
Integrating OpenCode Terminal with Clio 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.
-
Automated Continuous Bannerbear Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bannerbear replication to Google BigQuery.
-
Analyze Greenhouse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Greenhouse from Power Pivot. You will use the Table Import Wizard to load Greenhouse. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Live Epicor Kinetic Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Epicor Kinetic in CData Connect AI and connect to your Epicor Kinetic from PostgreSQL.
-
How to Connect DBeaver to YouTube Analytics via a JDBC Driver
Manage YouTube Analytics with visual tools in DBeaver like the query browser.
-
Integrate Live Wave Financial Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Wave Financial to Blue Prism using the CData ODBC Driver for Wave Financial to create automated workflows for repetitive business tasks.
-
Connect to CapsuleCRM Data in Aqua Data Studio
Access CapsuleCRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Tanda Data from PowerBuilder via ADO.NET
This article demonstrates how to access Tanda from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Import Real-Time LionDesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LionDesk in ColdFusion.
-
How to Import Data from Microsoft OneDrive into Google Sheets
Import Microsoft OneDrive into a Google spreadsheet that is automatically refreshed.
-
Validate VWO Data with QuerySurge
Access and validate VWO in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Pipeliner CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to delimited files (CSV/TSV).
-
Replicate ZeroBounce Data from PowerShell
Write a quick PowerShell script to query ZeroBounce. Use connectivity to the live data to replicate ZeroBounce to SQL Server.
-
How to publish and share Tickspot Data dashboards with Tableau Server
The CData ODBC driver for Tickspot enables you integrate Tickspot into Tableau dashboards.
-
Build Egnyte-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Egnyte Data in GitHub Copilot to assist with building Egnyte-powered applications.
-
Connect to Spark Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Spark SQL from Appeon PowerBuilder using the CData ADO.NET Provider for Apache Spark.
-
How to Create Power BI Visual Reports with Real-Time AfterShip Data
Use CData Power BI Connectors to visualize AfterShip in Power BI.
-
Import Real-Time Vault CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Veeva Vault & Vault CRM in ColdFusion.
-
Build Microsoft Entra ID-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Azure Active Directory to explore live Microsoft Entra ID Data in Claude Code to assist with building Microsoft Entra ID-powered applications.
-
Access Redis Data from MySQL in Amazon QuickSight
Connect to Redis and build visualizations of Redis using a MySQL Connection in Amazon QuickSight.
-
Provide OData Services of SageHR Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SageHR by developing a WCF Service Application.
-
Working with PDFMonkey Data in LINQPad
Execute LINQ queries to PDFMonkey in LINQPad.
-
Visualize Live PostgreSQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live PostgreSQL into custom reports in Power BI.
-
How to integrate Metabase with Snapchat Ads Data
Use CData Connect AI to connect to live Snapchat Ads and create an interactive dashboard in Metabase from Snapchat Ads.
-
Connect to and Visualize Live MariaDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MariaDB.
-
Replicate Accelo Data to Multiple Databases via the CData Sync CLI
Replicate Accelo to disparate databases with a single configuration.
-
Use the CData API Server to Access FTP Data in Microsoft PowerPivot
Use the CData API Server to connect to live FTP Servers in the Power Pivot business intelligence tool.