CData Software - Knowledge Base
Recent Articles
-
DataBind Charts to Google Ad Manager Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Ad Manager 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.
-
Connect to MessageBird in SpagoBI
Create reports featuring live MessageBird in SpagoBI Studio. Host MessageBird reports on SpagoBI Server.
-
Analyze Datadog Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Datadog and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect and Query Live Cloudant Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live IBM Cloudant into Databricks
-
Visualize CapsuleCRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CapsuleCRM.
-
Access Flowlu Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Flowlu from your Oracle system.
-
Automated Continuous Cvent Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Cvent replication to OneLake in Microsoft Fabric.
-
Connect to Smartsheet Data from PowerBuilder via ADO.NET
This article demonstrates how to access Smartsheet from Appeon PowerBuilder using the CData ADO.NET Provider for Smartsheet.
-
Connect to Freshdesk Data in Google Apps Script via Connect AI
Use CData Connect AI to access Freshdesk in Google Apps Script.
-
Publish Crystal Reports on Flowlu Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Flowlu.
-
Access Live Basecamp Data in AWS Lambda
Connect to live Basecamp in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Excel Add-In for Webex
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Webex.
-
ETL Azure Synapse in Oracle Data Integrator
This article shows how to transfer Azure Synapse into a data warehouse using Oracle Data Integrator.
-
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.
-
Build MVC Applications with Connectivity to Greenplum Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Greenplum from an ASP.NET MVC application.
-
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.
-
Extend Google Sheets with Smartsheet Data
Make calls to Smartsheet from Google Apps Script via the API Server.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Avaza to Power BI dashboards. Simply drag and drop Avaza into data visuals on the Power BI canvas.
-
Access Live Lakebase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Lakebase from your Google Sheets.
-
Create SSAS Tabular Models from Quaderno Data
How to build a SQL Server Analysis Service Tabular Model from Quaderno using CData drivers.
-
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.
-
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.
-
Build Apps with Live Veeva Vault & Vault CRM in Adalo using CData Connect AI
Use CData Connect AI to integrate live Veeva Vault & Vault CRM into the Adalo platform and build custom mobile and web applications with real-time Veeva Vault & Vault CRM.
-
Replicate Google Analytics Data to Multiple Databases
Replicate Google Analytics to disparate databases with a point-and-click configuration.
-
Automated Continuous SAP HANA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP HANA replication to Google BigQuery.
-
Bidirectional Access to Wistia Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Wistia in Filemaker Pro for Mac or Windows.
-
Integrating TaxJar Data in Talend Cloud Data Management Platform
Connect TaxJar Data with Talend Cloud Data Management Platform using the CData JDBC Driver for TaxJar.
-
Query ZohoDesk Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ZohoDesk entities in PHP by modeling them as objects.
-
Validate OData Services with QuerySurge
Access and validate OData in QuerySurge using the CData JDBC Driver.
-
Back Up Cohere 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 Cohere data.
-
Viewing Typeform Data in RAD Studio Data Explorer
How to view Typeform in RAD Studio Data Explorer using the CData ODBC Driver for Typeform.
-
Manage DocuSign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for DocuSign.
-
Integrate with Avro Data in JReport Designer
Create charts and reports based on Apache Avro in JReport Designer.
-
Connect to CloudConvert Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CloudConvert.
-
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.
-
Automated Continuous LightSpeedRetail Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Apache Cassandra.
-
Integrating Claude Code CLI with Supabase 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.
-
Access Live FTP Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to FTP Servers from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous TaxJar Replication to Vertica
Use CData Sync for automated, continuous, customizable TaxJar replication to Vertica.
-
Analyze AdRoll Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of AdRoll and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Microsoft Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Ads.
-
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.
-
Import Real-Time Opsgenie Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Opsgenie in ColdFusion.
-
Connect to Google Calendar Data in ACL Analytics
Connect to Google Calendar via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Calendar.
-
Query Sage 300 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage 300 from Node.js.
-
Publish Reports with Drip Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Drip.
-
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.
-
Automated Continuous Microsoft Exchange Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Apache Kafka.
-
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.
-
How to connect Amazon QuickSight to IBM Informix Data
Create a connection to IBM Informix in CData Connect AI and insert IBM Informix into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Calendly Data from PowerShell
Write a quick PowerShell script to query Calendly. Use connectivity to the live data to replicate Calendly to SQL Server.
-
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.
-
How to create an RPA flow for Bright Data Data in UiPath Studio
Use the Bright Data ODBC Driver to create workflows that access real-time Bright Data without any coding.
-
Automated Continuous HubSpot Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HubSpot replication to AlloyDB.
-
How to create an RPA flow for Cassandra Data in UiPath Studio
Use the Cassandra ODBC Driver to create workflows that access real-time Apache Cassandra without any coding.
-
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.
-
Build Visualizations of RSS Feeds in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of RSS Feeds in Birst.
-
Connect to Zoho Books Data in DBeaver
Use the CData ODBC Driver to connect to Zoho Books in DBeaver.
-
Connect to PostgreSQL Data in DBeaver
Use the CData ODBC Driver to connect to PostgreSQL in DBeaver.
-
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.
-
Visualize Salesloft 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 Salesloft into TIBCO Spotfire.
-
Integrate Cline with Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Table Storage from within your IDE.
-
How to connect to DB2 Data with Squirrel SQL client
Connect to IBM DB2 and execute queries in the Squirrel SQL Client.
-
Automated Continuous Oracle Eloqua Reporting Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Oracle.
-
Build Visualizations of SAP Fieldglass Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Fieldglass in Birst.
-
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.
-
Create SSAS Tabular Models from Brex Data
How to build a SQL Server Analysis Service Tabular Model from Brex using CData drivers.
-
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.
-
Integrate PingOne with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PingOne with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PingOne.
-
Access Live SuiteCRM Data in TIBCO Data Virtualization
Use the SuiteCRM Tibco DV Adapter to create a SuiteCRM data source in TIBCO Data Virtualization Studio and gain access to live SuiteCRM from your TDV Server.
-
How to Query Live Procore Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Procore data in natural language using Python.
-
Connect to Avro Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Copper Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Copper.
-
Integrate LibreChat with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live LinkedIn from within the chat interface.
-
How to Access Live Optimizely Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Optimizely from the Cline extension in Visual Studio Code.
-
How to connect to Outlook Data from Spring Boot
Connect to Outlook in a Spring Boot Application using the CData API Driver for JDBC
-
Choosing the Best Method to Connect ScrapingBee to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ScrapingBee from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
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.
-
Write a Simple Go Application to work with Paymo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Paymo.
-
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.
-
How to connect and process Mistral AI from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mistral AI.
-
Access Live Gumroad Data in AWS Lambda
Connect to live Gumroad in AWS Lambda using the CData JDBC Driver.
-
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.
-
Visualize Dropbox Data in Sisense
Create an ElastiCube in Sisense app with access to Dropbox.
-
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.
-
Use the CData Software JDBC Driver for Optimizely in MicroStrategy Web
Connect to Optimizely in MicroStrategy Web using the CData Software JDBC Driver for Optimizely.
-
Use the CData Software JDBC Driver for Avalara AvaTax in MicroStrategy Desktop
Connect to Avalara AvaTax in MicroStrategy Desktop using the CData Software JDBC Driver for Avalara AvaTax.
-
Use the CData ODBC Driver for Onfleet in Microsoft Power Query
You can use the CData Onfleet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Onfleet into Microsoft Power Query.
-
Visualize BigQuery Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google BigQuery.
-
Visualize HDFS Data in TIBCO Spotfire through OData
Integrate Apache HDFS into dashboards in TIBCO Spotfire.