CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to LDAP: Complete Guide
Connect to the CData Software Power BI Connector for LDAP from PowerBI.com to provide real-time LDAP across the organization.
-
Automated Continuous MariaDB Replication to MySQL
Use CData Sync for automated, continuous, customizable MariaDB replication to MySQL.
-
Build Apps with Live SAP Hybris C4C Data Using the Low-Code Development Platform of Mendix
Connect SAP Hybris C4C with Mendix to build apps using the CData JDBC Driver for SAP Hybris C4C.
-
How to Access Hacker News Data Using Entity Framework
This article shows how to access Hacker News using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Bugsnag Data from a Connection Pool in Jetty
The Bugsnag JDBC Driver supports connection pooling: This article shows how to connect faster to Bugsnag from Web apps in Jetty.
-
Build AI/ML Models with Live CapsuleCRM Data using Dataiku
Connect CapsuleCRM Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Microsoft Teams Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Vertica.
-
How to work with Klipfolio Data in Apache Spark using SQL
Access and process Klipfolio Data in Apache Spark using the CData Software JDBC Driver.
-
Build a Singer.io Tap for Odoo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Odoo data using
-
Integrate Open WebUI with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live GitHub from within the chat interface.
-
Replicate Google Analytics Data to Multiple Databases
Replicate Google Analytics to disparate databases with a point-and-click configuration.
-
Build Charts with Salesforce Marketing Data in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce Marketing Cloud in Clear Analytics.
-
Consume TaxJar OData Feeds in PowerBuilder
This article demonstrates how to consume TaxJar as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData Tableau Connector for Pinterest
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Pinterest.
-
Query Azure Data Catalog Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Data Catalog from Node.js.
-
Validate OData Services with QuerySurge
Access and validate OData in QuerySurge using the CData JDBC Driver.
-
Viewing Typeform Data in RAD Studio Data Explorer
How to view Typeform in RAD Studio Data Explorer using the CData ODBC Driver for Typeform.
-
DataBind Controls to Freshservice Data in Delphi
DataBind to Freshservice in Delphi with standard data access components and controls.
-
Create SSAS Tabular Models from PayPal Data
How to build a SQL Server Analysis Service Tabular Model from PayPal using CData drivers.
-
Build Charts with MySQL Data in Clear Analytics
Create dynamic charts and perform analytics based on MySQL in Clear Analytics.
-
Visualize Live BigQuery Data in the Power BI Service
Use CData Connect AI to connect to live Google BigQuery and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with Simplesat Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Simplesat to a JSON file on disk.
-
Use the CData API Server to Access QuickBooks Time Data in Microsoft PowerPivot
Use the CData API Server to connect to live QuickBooks Time in the Power Pivot business intelligence tool.
-
Write a Simple Go Application to work with Monday.com Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Monday.com.
-
How to Work with Email Data in ETL Validator JDBC
Connect to Email from ETL Validator jobs using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access MySQL Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MySQL.
-
Back Up Okta to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Okta. In this article, we will employ an SSIS workflow to populate a database with Okta data.
-
Query Sage 300 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage 300 from Node.js.
-
Visualize Live Smartsheet Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Smartsheet into custom reports in Power BI.
-
Integrate Authorize.Net Data into Power Automate Desktop using CData Connect
CData Connect for Authorize.Net Data enables you to integrate Authorize.Net into workflows built using Microsoft Power Automate Desktop.
-
Import and Visualize ZendeskSell Data in Power View
Create data visualizations based on ZendeskSell in Excel.
-
How to Connect to & Open Office 365 Data in Microsoft Excel
This article uses the CData ODBC driver for Office 365 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access VWO Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live VWO from HeidiSQL.
-
Connect to GetResponse Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to GetResponse and work with GetResponse in your FileMaker applications.
-
Connect Outlook to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Outlook using the CData Python MCP Server.
-
Automated Continuous Microsoft Exchange Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Apache Kafka.
-
Integrate with Live Google Calendar Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Calendar from the MuleSoft Anypoint Platform to integrate live Google Calendar into custom reports and dashboards.
-
Build a PostgreSQL Interface for Grafana Data using the CData JDBC Driver
Use the Remoting features of the Grafana JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to Wave Financial Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Wave Financial 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.
-
Create Reports with Workable Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Workable.
-
Connect to Real-Time CapsuleCRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use CapsuleCRM in Power Apps.
-
Analyze IBM Cloud Object Storage Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of IBM Cloud Object Storage and visualize live IBM Cloud Object Storage in Infragistics Reveal.
-
Automated Continuous Bugsnag Replication to Snowflake
Use CData Sync for automated, continuous, customizable Bugsnag replication to Snowflake.
-
Publish Reports with Elorus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Elorus.
-
Build Dashboards with Gorgias Data in DBxtra
Create dynamic dashboards and perform analytics based on Gorgias in DBxtra.
-
DataBind Controls to Azure Analysis Services Data in C++Builder
DataBind to Azure Analysis Services in C++Builder with standard components and controls.
-
Automated Continuous Oracle Eloqua Reporting Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Oracle.
-
Connect to Trello Data from Crystal Reports
Use CData Connect AI to connect to and report on live Trello from Crystal Reports.
-
How to Build an ETL App for Unbounce Data in Python with CData
Create ETL applications and real-time data pipelines for Unbounce in Python with petl.
-
How to work with Couchbase Data in Apache Spark using SQL
Access and process Couchbase Data in Apache Spark using the CData Software JDBC Driver.
-
Build Apps with Live SendGrid in Adalo using CData Connect AI
Use CData Connect AI to integrate live SendGrid into the Adalo platform and build custom mobile and web applications with real-time SendGrid.
-
Access Live iContact Data in AWS Lambda (with IntelliJ IDEA)
Connect to live iContact in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Snowflake Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Snowflake and visualize Snowflake in SAP Analytics Cloud.
-
LINQ to Aircall 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 Aircall Data Provider.
-
Use Dash to Build Web Apps on SAS Data Sets Data via CData Connect AI
Build interactive Dash web apps on live SAS Data Sets using pandas and the CData Connect AI Python SDK.
-
Visualize Copper Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Copper.
-
Deploy the ADO.NET Provider for IBM Informix on an SSRS Report Server
Connect to IBM Informix 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.
-
Integrating OpenCode Terminal with Egnyte 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.
-
Visualize SAP Ariba Procurement 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 SAP Ariba Procurement into TIBCO Spotfire.
-
How to connect to Outlook Data from Spring Boot
Connect to Outlook in a Spring Boot Application using the CData API Driver for JDBC
-
Migrating data from CloudConvert to Snowflake using CData SSIS Components.
Easily push CloudConvert to Snowflake using the CData SSIS Tasks for CloudConvert and Snowflake.
-
Use Agno to Talk to Your Blackbaud FE 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 Blackbaud FE NXT for you.
-
Object-Relational Mapping (ORM) with Instagram 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 Instagram into a Java-based ORM framework, Hibernate.
-
How to Import Data from SingleStore into Google Sheets
Import SingleStore into a Google spreadsheet that is automatically refreshed.
-
Use the CData ODBC Driver for Spotify in Microsoft Power Query
You can use the CData Spotify ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Spotify into Microsoft Power Query.
-
Connect to Databricks Data from Crystal Reports
Use CData Connect AI to connect to and report on live Databricks from Crystal Reports.
-
How to Access Live Excel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Excel enables you to integrate Microsoft Excel into workflows built using Microsoft Power Automate Desktop.
-
Use CData Connect AI to Access EnterpriseDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live EnterpriseDB in the Power Pivot business intelligence tool.
-
Integrating OpenCode Terminal with Freshservice 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 LibreChat with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live API from within the chat interface.
-
Consume SAP Netweaver Gateway OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Netweaver Gateway feeds that reflect any changes in SAP Lumira.
-
Connect to Anaplan Data from a Connection Pool in Jetty
The Anaplan JDBC Driver supports connection pooling: This article shows how to connect faster to Anaplan from Web apps in Jetty.
-
How to Seamlessly Import Discourse Data into IBM SPSS Modeler
Integrate Discourse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Elorus-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Elorus and build web apps with connectivity to live Elorus.
-
Visualize HDFS Data in TIBCO Spotfire through OData
Integrate Apache HDFS into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Python Connector for OData
Learn to install and license the CData Python Connector
-
Back Up Shortcut to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Shortcut data.
-
Connect to Freshdesk in SpagoBI
Create reports featuring live Freshdesk in SpagoBI Studio. Host Freshdesk reports on SpagoBI Server.
-
Getting Started with the CData Power BI Connector for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Raisers Edge NXT.
-
How to Query Egnyte Data in MySQL Workbench
Execute MySQL queries against live Egnyte from MySQL Workbench.
-
Create Vertica-Connected Dashboards in Grafana
Connect to Vertica Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Vertica.
-
Integrate Grafana Data in the Pentaho Report Designer
Publish reports based on Grafana in the Pentaho BI tool.
-
Access Live ADP Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ADP from your Google Sheets.
-
Create Dynamic Odoo Grids Using the Infragistics XamDataGrid
Learn how you can connect Odoo to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze MySQL Data in Alteryx Designer (Connect AI)
Build workflows to access live MySQL for self-service data analytics.
-
Automated Continuous CouchDB Replication to SQLite
Use CData Sync for automated, continuous, customizable CouchDB replication to SQLite.
-
How to Visualize Avro Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Apache Avro in Python.
-
How to import PivotalTracker Data into Apache Solr
Use the CData Software JDBC Driver for PivotalTracker in Data Import Handler and create an automated import of PivotalTracker to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for Google Directory Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Directory.
-
Access Live Sage Intacct Data in Excel 365 Online (Excel for the web)
Connect to Sage Intacct from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Cursor with Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Bullhorn CRM from within the editor.
-
Getting Started with the CData ODBC Driver for Cloudant
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cloudant.
-
Integrate Google Spanner with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Spanner with External Services.
-
Migrating data from Aweber to Google BigQuery using CData SSIS Components.
Easily push Aweber to Google BigQuery using the CData SSIS Tasks for Aweber and Google BigQuery.
-
Automated Continuous Cloudflare Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Cloudflare replication to OneLake in Microsoft Fabric.
-
Load Gong Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Gong to a database.
-
Connect to Google Translate Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Google Translate and work with Google Translate in your FileMaker applications.
-
Analyze SharePoint Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft SharePoint with the CData JDBC Driver for SharePoint.
-
Access Mode Data from MySQL in PHP
Connect to Mode through the standard MySQL libraries in PHP.
-
Use the CData API Server to Access REST Data in Microsoft PowerPivot
Use the CData API Server to connect to live REST in the Power Pivot business intelligence tool.