CData Software - Knowledge Base
Recent Articles
-
DataBind Charts to Todoist Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Todoist 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.
-
ETL RSS in Oracle Data Integrator
This article shows how to transfer RSS Feeds into a data warehouse using Oracle Data Integrator.
-
Connect to Freshservice from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Freshservice, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build an OLAP Cube in SSAS from MailerSend Data
Establish a connection to MailerSend data from SQL Server Analysis Services, and use the MailerSend Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Coda Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Coda.
-
How to Work with Dropbox Data in ETL Validator JDBC
Connect to Dropbox from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from LionDesk to Databricks using CData SSIS Components.
Easily push LionDesk to Databricks using the CData SSIS Tasks for LionDesk and Databricks.
-
ETL Bannerbear in Oracle Data Integrator
This article shows how to transfer Bannerbear into a data warehouse using Oracle Data Integrator.
-
How to Work with Mocean Data in ETL Validator JDBC
Connect to Mocean from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to CouchDB Data in CloverDX (formerly CloverETL)
Transfer Apache CouchDB using the visual workflow in the CloverDX data integration tool.
-
Build Semantic Layer Views for Oracle Eloqua Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle Eloqua.
-
How to Query Live Adobe Commerce Data in Claude Desktop
Connect to and query live Adobe Commerce Data in Claude Desktop using CData MCP Server.
-
Connecting Moonlit Workflow with Blackbaud FE NXT Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Blackbaud FE NXT in real time.
-
Build a Simple VCL Application for Oracle SCM Data
How to build a simple VCL Application to view Oracle SCM in RAD Studio using the CData ODBC Driver for Oracle SCM.
-
Getting Started with the CData Tableau Connector for Rootly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Google Ad Manager Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Google Cloud SQL.
-
Automated Continuous Toggl Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Toggl replication to PostgreSQL.
-
Extract, Transform, and Load Factorial Data in Informatica PowerCenter
Create a simple Workflow for Factorial in Informatica PowerCenter.
-
Connect to AfterShip Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for AfterShip in the Denodo Virtual DataPort Administrator.
-
Build PostgreSQL-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for PostgreSQL to explore live PostgreSQL Data in Claude Code to assist with building PostgreSQL-powered applications.
-
Access Live Salesforce Data 360 Data in Coginiti Pro
Connect to and query live Salesforce Data 360 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Mode Data from PowerBuilder via JDBC
This article demonstrates how to access Mode from PowerBuilder using the Mode JDBC Driver.
-
Rapidly Develop Adobe Analytics-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 Adobe Analytics.
-
Access Gumroad Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Gumroad from HeidiSQL.
-
A PostgreSQL Interface for LightSpeedRetail Data using the CData ODBC Driver
Use the SQL Gateway and LightSpeedRetail ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for ZohoPeople in MicroStrategy Web
Connect to ZohoPeople in MicroStrategy Web using the CData Software ODBC Driver for ZohoPeople.
-
Automated Continuous Mouseflow Replication to SQL Server
Use CData Sync for automated, continuous, customizable Mouseflow replication to SQL Server.
-
Integrating LangChain with Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Pipedrive within automated workflows.
-
Connect to Timely Data in HULFT Integrate
Connect to Timely as a JDBC data source in HULFT Integrate
-
Replicate Spark Data to Multiple Databases
Replicate Apache Spark SQL to disparate databases with a point-and-click configuration.
-
Query Amplitude Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Amplitude from Node.js.
-
Automated Continuous xBase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable xBase replication to delimited files (CSV/TSV).
-
Use the CData ODBC Driver for Excel Online from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Microsoft Excel Online from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Excel Online in Excel.
-
ETL Bright Data in Oracle Data Integrator
This article shows how to transfer Bright Data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SAP HANA Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP HANA replication to delimited files (CSV/TSV).
-
LINQ to Hugging Face 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 Hugging Face Data Provider.
-
How to connect to Zoho Projects Data with Squirrel SQL client
Connect to Zoho Projects and execute queries in the Squirrel SQL Client.
-
Design BIRT Reports on SAP Fieldglass Data
Provide current SAP Fieldglass to your embedded analytics.
-
Build AI Agents with NetSuite 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 NetSuite CRM & ERP through CData Connect AI.
-
Connect to Salesforce Data 360 Data in Jaspersoft Studio
Execute SQL to remote Salesforce Data 360 in Jaspersoft Studio.
-
Create Informatica Mappings From/To an ODBC Data Source for Email
Create an ODBC connection to Email in Informatica and browse and transfer Email.
-
Integrate Shortcut with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Shortcut with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Shortcut.
-
Analyze Marketo Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Marketo and visualize live Marketo in Infragistics Reveal.
-
Connect to Real-Time Omnisend Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Omnisend in Power Apps.
-
How to create TigerGraph federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for TigerGraph in MySQL .
-
Connect to Reckon Accounts Hosted Data in Jaspersoft Studio
Execute SQL to remote Reckon Accounts Hosted in Jaspersoft Studio.
-
Integrating GitHub Copilot CLI with Calendly 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.
-
Seamlessly Bring SAP Fieldglass Data into Retool Using CData Connect AI
Integrate SAP Fieldglass data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Analyze Sage 200 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sage 200 in Microsoft R Open.
-
Use the CData Software ODBC Driver for Square in MicroStrategy Desktop
Connect to Square in MicroStrategy Desktop using the CData Software ODBC Driver for Square.
-
Analyze Live Impala Data in SAS Viya
Use CData Connect AI to connect to Apache Impala from SAS Viya and deploy self-service analytics using live Apache Impala.
-
Integrate AfterShip with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AfterShip with External Services.
-
Query CockroachDB Data from Node.js
Use the OData endpoint of the CData API Server to connect to your CockroachDB and perform CRUD operations on CockroachDB from Node.js.
-
Choosing the Best Method to Connect Wave Financial to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Wave Financial from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live HCL Domino Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate HCL Domino into the statistical analysis tools available in SAS JMP. This article shows how to use HCL Domino in the Graph Builder and Query Builder.
-
Automated Continuous Quickbase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Quickbase replication to SQL Server.
-
Integrate Live SAP Concur Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Visualize Live SAP ByDesign Data in the Power BI Service
Use CData Connect AI to connect to live SAP Business ByDesign and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Missive Data using the CData ODBC Driver
Use the SQL Gateway and Missive ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SharePoint Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SharePoint and the SQL Gateway to access Microsoft SharePoint from Google Apps Script.
-
Automate Google Drive Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Drive and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Getting Started with the CData ODBC Driver for Zoom
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoom.
-
Access Live Reckon Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Reckon into the statistical analysis tools available in SAS JMP. This article shows how to use Reckon in the Graph Builder and Query Builder.
-
Create SAP HANA XS Advanced Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP HANA XS Advanced data access from reports, embedded analytics, and more.
-
Integrating Boomi Agentstudio with Kintone Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Kintone, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect PolyBase to Freshservice
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Freshservice.
-
DataBind Outreach.io Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Outreach.io with the DevExpress Windows Forms and Web controls to provide Outreach.io to a chart.
-
Integrate Theia IDE with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous MySQL Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MySQL replication to OneLake in Microsoft Fabric.
-
How to Query Live Google Forms Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Forms data in natural language using Python.
-
Bind Live Sugar CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sugar CRM data
-
Migrating data from Jodoo to Databricks using CData SSIS Components.
Easily push Jodoo to Databricks using the CData SSIS Tasks for Jodoo and Databricks.
-
How to Connect DBeaver to BenchmarkEmail via a JDBC Driver
Manage BenchmarkEmail with visual tools in DBeaver like the query browser.
-
Create Tickspot Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tickspot from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to OneNote Data from Spring Boot
Connect to OneNote in a Spring Boot Application using the CData JDBC Driver for OneNote
-
Integrating Kiro CLI with PivotalTracker 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 Real-Time Access to OneNote in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft OneNote in real time.
-
Connect to Pinecone Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pinecone in the Denodo Virtual DataPort Administrator.
-
Connect to Google Search from Asprova with CData Software ODBC Driver for Google Search
This article shows how to connect faster to Google Search data from Asprova.
-
How to connect to GraphQL Data from Spring Boot
Connect to GraphQL in a Spring Boot Application using the CData JDBC Driver for GraphQL
-
Automated Continuous Freshdesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Freshdesk replication to Amazon S3.
-
Integrate with MySQL Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MySQL to a JSON file on disk.
-
Create Data Visualizations in Cognos BI with ScrapingBee Data
Access ScrapingBee as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to use SQLAlchemy ORM to access Scrapfly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Scrapfly.
-
Publish Reports with JSON Services in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JSON.
-
Access Klaviyo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Klaviyo from HeidiSQL.
-
Access Live SAP HANA Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP HANA in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous MYOB AccountRight Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to PostgreSQL.
-
A PostgreSQL Interface for Klipfolio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Klipfolio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple SAP HANA XS Advanced Accounts via the CData Sync CLI
Replicate multiple SAP HANA XS Advanced accounts to one or many databases.
-
Analyze Gong Data in Looker
Use CData Connect AI to connect to Gong Data from Looker and build custom apps using live Gong.
-
Automated Continuous Yelp Replication to MongoDB
Use CData Sync for automated, continuous, customizable Yelp replication to MongoDB.
-
Box Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Box facts in real time.
-
Build Pipelines with Live Google Drive Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Drive from Google Cloud Data Fusion, enabling the integration of live Google Drive into the building and management of effective data pipelines.
-
Provide OData Services of SAP Concur Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Concur by developing a WCF Service Application.
-
Analyze Zoho Projects Data in Looker
Use CData Connect AI to connect to Zoho Projects Data from Looker and build custom apps using live Zoho Projects.
-
Build Avalara AvaTax-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Avalara AvaTax to explore live Avalara AvaTax Data in Gemini Code Assist to assist with building Avalara AvaTax-powered applications.
-
Build Agents in Relevance AI with Access to Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Stripe within intelligent agent workflows.
-
Automated Continuous Google Forms Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Forms replication to Amazon Redshift.
-
Use the CData Software JDBC Driver for Quaderno in MicroStrategy Desktop
Connect to Quaderno in MicroStrategy Desktop using the CData Software JDBC Driver for Quaderno.