CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Zoho Inventory Data Using the Low-Code Development Platform of Mendix
Connect Zoho Inventory with Mendix to build apps using the CData JDBC Driver for Zoho Inventory.
-
Visualize Parallel Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Parallel.
-
Migrating data from GraphQL to Databricks using CData SSIS Components.
Easily push GraphQL to Databricks using the CData SSIS Tasks for GraphQL and Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for Grafana
Create an ODBC connection to Grafana in Informatica and browse and transfer Grafana.
-
Create Datasets from Clari in Domo Workbench and Build Visualizations of Clari Data in Domo
Use the CData Software ODBC Driver for Clari to create datasets from Clari in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Cursor CLI with Jira Assets 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.
-
Getting Started with the CData Tableau Connector for Smartsheet
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Smartsheet.
-
Automate ADP Data Replication to SAP HANA
Use CData Sync to customize and automate ADP replication to SAP HANA.
-
How to Create Power BI Visual Reports with Real-Time IBM Informix Data
Use CData Power BI Connectors to visualize IBM Informix in Power BI.
-
Analyze Azure Analysis Services Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure Analysis Services with the CData JDBC Driver for Azure Analysis Services.
-
Analyze Mouseflow Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mouseflow in Microsoft R Open.
-
Integrate Cline with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Concur from within your IDE.
-
Analyze Snapchat Ads Data in Looker
Use CData Connect AI to connect to Snapchat Ads Data from Looker and build custom apps using live Snapchat Ads.
-
How to connect to SAS Data Sets Data in DBVisualizer
Integrate SAS Data Sets with visual data analysis tools and data connection wizards in DBVisualizer
-
Create SSAS Tabular Models from Timely Data
How to build a SQL Server Analysis Service Tabular Model from Timely using CData drivers.
-
Connect to TigerGraph Data in NetBeans
Connect to TigerGraph in NetBeans with the data source configuration wizard.
-
Connect to Yelp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Yelp and the SQL Gateway to access Yelp from Google Apps Script.
-
Migrating data from Airtable to Google BigQuery using CData SSIS Components.
Easily push Airtable to Google BigQuery using the CData SSIS Tasks for Airtable and Google BigQuery.
-
Create Dashboards and Visualize Live HBase Data in Geckoboard
Use CData Connect AI to connect to live Apache HBase and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect the Power BI Service to Dynamics NAV: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics NAV from PowerBI.com to provide real-time Microsoft Dynamics NAV across the organization.
-
Connect to and Visualize Live Helpscout Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Helpscout.
-
Build Greenplum-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Greenplum to explore live Greenplum Data in Cursor to assist with building Greenplum-powered applications.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Books
Provide connectivity to Zoho Books through an SAP BusinessObjects universe.
-
Build SAP SuccessFactors LMS-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP SuccessFactors LMS to explore live SAP SuccessFactors LMS Data in GitHub Copilot to assist with building SAP SuccessFactors LMS-powered applications.
-
Connect to Google Cloud Storage Data in NetBeans
Connect to Google Cloud Storage in NetBeans with the data source configuration wizard.
-
Create Dynamic Amazon Marketplace Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon Marketplace to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Bitly Data in CloverDX (formerly CloverETL)
Transfer Bitly using the visual workflow in the CloverDX data integration tool.
-
Connect to Oracle SCM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle SCM in Airbyte.
-
Build Google Directory-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Directory Data from Zoho Analytics and import live Google Directory.
-
Automated Continuous Impala Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Impala replication to delimited files (CSV/TSV).
-
Build Charts with PDFMonkey Data in Clear Analytics
Create dynamic charts and perform analytics based on PDFMonkey in Clear Analytics.
-
Connect to and Query Deel Data in QlikView over ODBC
Create data visualizations with Deel in QlikView.
-
Configure the CData JDBC Driver for Databricks in a Connection Pool in Tomcat
Connect to Databricks from a connection pool in Tomcat.
-
A PostgreSQL Interface for Mixpanel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mixpanel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Seamlessly Bring SingleStore Data into Retool Using CData Connect AI
Integrate SingleStore data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Microsoft Planner Data in TIBCO Spotfire through OData
Integrate Microsoft Planner into dashboards in TIBCO Spotfire.
-
Automated Continuous RSS Replication to MongoDB
Use CData Sync for automated, continuous, customizable RSS replication to MongoDB.
-
Integrating Cursor CLI with Outreach.io 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.
-
Use the CData API Server to Access MessageBird Data in Microsoft PowerPivot
Use the CData API Server to connect to live MessageBird in the Power Pivot business intelligence tool.
-
How to Import Data from Pipedrive into Google Sheets
Import Pipedrive into a Google spreadsheet that is automatically refreshed.
-
Create SSAS Tabular Models from Supabase Data
How to build a SQL Server Analysis Service Tabular Model from Supabase using CData drivers.
-
Connect to Perigon Data in DBeaver
Use the CData ODBC Driver to connect to Perigon in DBeaver.
-
Back Up Oracle Eloqua to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Eloqua. In this article, we will employ an SSIS workflow to populate a database with Oracle Eloqua data.
-
SAP Netweaver Gateway Reporting in OBIEE with the SAP Netweaver Gateway JDBC Driver
Deploy the SAP Netweaver Gateway JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Extend Google Sheets with Raisers Edge NXT Data
Make calls to Raisers Edge NXT from Google Apps Script via the API Server.
-
Create a Data Access Object for Mailgun Data using JDBI
A brief overview of creating a SQL Object API for Mailgun in JDBI.
-
Integrating Cursor CLI with Parallel 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 HBase Data in HULFT Integrate
Connect to HBase as a JDBC data source in HULFT Integrate
-
Access Live SAP Ariba Procurement Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Ariba Procurement from your Excel spreadsheets.
-
Integrating Sage Cloud Accounting Data in Talend Cloud Data Management Platform
Connect Sage Cloud Accounting Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage Cloud Accounting.
-
Integrating Claude Code with Microsoft Dataverse Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Dataverse (CDS) within assisted coding and automated development workflows.
-
Query Google Calendar Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Calendar from Node.js.
-
How to Design Active Directory Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Active Directory from mobile and tablet Power Apps.
-
Replicate Multiple LeadDesk Accounts via the CData Sync CLI
Replicate multiple LeadDesk accounts to one or many databases.
-
Use the CData Software JDBC Driver for Teamwork in MicroStrategy
Connect to Teamwork in MicroStrategy Developer using the CData Software JDBC Driver for Teamwork.
-
Integrating Antigravity CLI with Exa via CData CLI
Connect Exa to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Facebook Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Facebook Ads as an External Source in Dremio.
-
Connect to Freshteam Data in DBeaver
Use the CData ODBC Driver to connect to Freshteam in DBeaver.
-
Build Semantic Layer Views for Paylocity Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Paylocity.
-
Consume Nethunt OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Nethunt feeds that reflect any changes in SAP Lumira.
-
Build Pipelines with Live Trello Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Trello from Google Cloud Data Fusion, enabling the integration of live Trello into the building and management of effective data pipelines.
-
Getting Started with the CData Excel Add-In for Testmonitor
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Testmonitor.
-
Model, Search, and Visualize Live Cvent Data in ThoughtSpot
Use CData Connect AI to connect to live Cvent for modeling, searching, and visualizing.
-
Access Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics through MCP integration.
-
How to connect to Beeminder Data with Squirrel SQL client
Connect to Beeminder and execute queries in the Squirrel SQL Client.
-
Import Real-Time Microsoft Dataverse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Dataverse (CDS) in ColdFusion.
-
Automate Wistia Data Replication to Azure Synapse
Use CData Sync to customize and automate Wistia replication to Azure Synapse.
-
Work with Live LinkedIn Data in Power Query
Use CData Connect AI to connect to LinkedIn and work with live LinkedIn in Microsoft Power Query.
-
Build MVC Applications with Connectivity to HCL Domino Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HCL Domino from an ASP.NET MVC application.
-
Analyze Gong Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Gong and visualize live Gong in Infragistics Reveal.
-
Automate Cassandra Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache Cassandra replication to Azure Data Lake.
-
Connect to and Visualize Live Cloudflare Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Cloudflare.
-
Build Dashboards with Drift Data in DBxtra
Create dynamic dashboards and perform analytics based on Drift in DBxtra.
-
Migrating data from ZohoPeople to Databricks using CData SSIS Components.
Easily push ZohoPeople to Databricks using the CData SSIS Tasks for ZohoPeople and Databricks.
-
Use the CData Software ODBC Driver for Google Translate in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Translate in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Translate.
-
Use Biml to Build SSIS Tasks to Replicate MySQL Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MySQL to SQL Server.
-
Getting Started with the CData SSIS Components for Klaviyo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Klaviyo.
-
Use the CData ODBC Driver for Demio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Demio to connect to Demio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Demio in Excel.
-
Automated Continuous Google Contacts Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Contacts replication to Databricks.
-
How to Import Data from BigQuery into Google Sheets
Import Google BigQuery into a Google spreadsheet that is automatically refreshed.
-
Connect to Microsoft Planner Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Planner in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Paylocity Replication to SingleStore
Use CData Sync for automated, continuous, customizable Paylocity replication to SingleStore.
-
How to Query Live Greenplum Data in Perplexity MacOS Desktop
Connect to and query live Greenplum Data in Perplexity Desktop using CData MCP Server.
-
Query MailerLite Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MailerLite entities in PHP by modeling them as objects.
-
Build Charts with Nuclia Data in Clear Analytics
Create dynamic charts and perform analytics based on Nuclia in Clear Analytics.
-
Integrating Typeform Data in Talend Cloud Data Management Platform
Connect Typeform Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Natively Connect to Short.io Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Short.io. Leverage the native support for ODBC in PHP.
-
Connect to Adobe Analytics Data in HULFT Integrate
Connect to Adobe Analytics as a JDBC data source in HULFT Integrate
-
Automated Continuous Workday Replication to MySQL
Use CData Sync for automated, continuous, customizable Workday replication to MySQL.
-
Automate SageHR Data Replication to Azure Synapse
Use CData Sync to customize and automate SageHR replication to Azure Synapse.
-
DataBind Charts to Kafka Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Kafka from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Publish AfterShip-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live AfterShip.
-
Integrate Real-Time Access to REST in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to REST in real time.
-
Model SAP Ariba Source Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Ariba Source, enabling the direct import of real-time SAP Ariba Source.
-
How to Query Samanage Data in MySQL Workbench
Execute MySQL queries against live Samanage from MySQL Workbench.
-
Integrating Claude Code CLI with MariaDB 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.
-
Analyze Landbot Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Landbot and visualize live Landbot in Infragistics Reveal.
-
Visualize Dropbox Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Dropbox.
-
Connect to Microsoft Planner Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Planner from Filemaker Pro on Mac.
-
DataBind Controls to Telegram Data in Delphi
DataBind to Telegram in Delphi with standard data access components and controls.