CData Software - Knowledge Base
Recent Articles
-
Consume Impala OData Feeds in PowerBuilder
This article demonstrates how to consume Impala data as OData feeds from PowerBuilder using the API Server.
-
Connect to Notion Data from a Connection Pool in Jetty
The Notion JDBC Driver supports connection pooling: This article shows how to connect faster to Notion data from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Adobe Commerce in MicroStrategy Web
Connect to Adobe Commerce data in MicroStrategy Web using the CData Software ODBC Driver for Adobe Commerce.
-
Connect to Vimeo Data from a Connection Pool in Jetty
The Vimeo JDBC Driver supports connection pooling: This article shows how to connect faster to Vimeo data from Web apps in Jetty.
-
How to create Visio diagrams from MongoDB Data
Automatically update MongoDB data with the changes you make to Visio master shapes.
-
Integrate Devin with Live Oracle Service Cloud Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Oracle Service Cloud data.
-
How to Work with Zoho Projects Data in ETL Validator JDBC
Connect to Zoho Projects from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to TigerGraph Data in HULFT Integrate
Connect to TigerGraph as a JDBC data source in HULFT Integrate
-
Integrating Claude Code with Marketo Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Marketo data within assisted coding and automated development workflows.
-
A PostgreSQL Interface for OneNote Data using the CData ODBC Driver
Use the SQL Gateway and OneNote ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Optimizely Data in MySQL Workbench
Execute MySQL queries against live Optimizely data from MySQL Workbench.
-
DataBind Controls to Printful Data in C++Builder
DataBind to Printful data in C++Builder with standard components and controls.
-
Work with Live BigCommerce Data in Power Query
Use CData Connect AI to connect to BigCommerce data and work with live BigCommerce data in Microsoft Power Query.
-
Access Live Snapchat Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Snapchat Ads data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Migrating data from SparkPost to Databricks using CData SSIS Components.
Easily push SparkPost data to Databricks using the CData SSIS Tasks for SparkPost and Databricks.
-
Process & Analyze Clockify Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Clockify Data.
-
How to Connect to Rootly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Rootly data. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live Hubstaff Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Hubstaff data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from Chargebee to SQL Server using SSIS
Easily back up Chargebee data to SQL Server using the SSIS components for Chargebee.
-
Automate ZohoInvoice Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoInvoice data replication to SAP HANA.
-
Use the CData Software JDBC Driver for MessageBird in MicroStrategy
Connect to MessageBird data in MicroStrategy Developer using the CData Software JDBC Driver for MessageBird.
-
Design BIRT Reports on Stack Exchange Data
Provide current Stack Exchange data to your embedded analytics.
-
Connect to Outreach.io Data from Crystal Reports
Use CData Connect AI to connect to and report on live Outreach.io data from Crystal Reports.
-
Access Google Sheets Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Sheets data.
-
Access Google Cloud Storage Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Cloud Storage data from HeidiSQL.
-
Integrating Kiro with Shortcut 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.
-
Load Webflow Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Webflow data to a database.
-
Integrate Live Google Analytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Analytics data and integrate live Google Analytics data into apps built in Microsoft Power Apps.
-
How to Visualize ZohoInvoice 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 ZohoInvoice data in Python.
-
Replicate Keap Data to Multiple Databases
Replicate Keap data to disparate databases with a point-and-click configuration.
-
Publish Crystal Reports on SAP Netweaver Gateway Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Netweaver Gateway data.
-
How to Query Live WooCommerce Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live WooCommerce data data in natural language using Python.
-
Integrate IBM Cloud Object Storage with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate IBM Cloud Object Storage with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to IBM Cloud Object Storage data.
-
How to Connect to & Open HubSpot Data in Microsoft Excel
This article uses the CData ODBC driver for HubSpot to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData ADO.NET Provider for Miro
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Basecamp Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Basecamp replication to Azure SQL Database.
-
Access Live RSS Feeds in Coginiti Pro
Connect to and query live RSS feeds from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Grafana
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData SSIS Components to Insert New or Update Existing Freshdesk Records from SQL Server
Easily push SQL Server data to Freshdesk using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Freshdesk or update existing records with data from a SQL Server database.
-
Build Data Flows from SQL Server to NetSuite through SSIS
Easily push SQL Server data to NetSuite using the CData SSIS Tasks for NetSuite.
-
Bidirectional Access to Impala Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Impala data in Filemaker Pro for Mac or Windows.
-
Visualize Hive Data in Tableau
The CData ODBC driver for Hive enables you integrate Hive data into Tableau dashboards.
-
Access Highrise Data from MySQL in Amazon QuickSight
Connect to Highrise and build visualizations of Highrise data using a MySQL Connection in Amazon QuickSight.
-
Load xBase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load xBase data to a database.
-
Integrating Cursor with Ontraport 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.
-
Build Timely-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Timely Data and create custom apps in Bubble.
-
ETL Amazon Marketplace in Oracle Data Integrator
This article shows how to transfer Amazon Marketplace data into a data warehouse using Oracle Data Integrator.
-
Working with Tickspot Data in LINQPad
Execute LINQ queries to Tickspot data in LINQPad.
-
Connect to iContact from a Connection Pool in WebLogic
Use the CData JDBC Driver for iContact to connect to iContact data from Web applications running on WebLogic.
-
How to load TaxJar data into Elasticsearch via Logstash
Introducing a simple method to load TaxJar data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate ZohoDesk Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoDesk data from Informatica Cloud.
-
Create Informatica Mappings From/To a JDBC Data Source for Wave Financial
Create Wave Financial data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate with SAP HANA Data in JReport Designer
Create charts and reports based on SAP HANA data in JReport Designer.
-
Publish Crystal Reports on Mocean Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mocean data.
-
Feed Oracle Eloqua Reporting Data into FineReport
How to set Oracle Eloqua Reporting data as a JDBC data source in FineReport.
-
Getting Started with the CData Python Connector for Autopilot
Learn to install and license the CData Python Connector and configure a connection to live Autopilot data.
-
Operational Reporting on Float Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Float data.
-
Visualize Live GetResponse Data in the Power BI Service
Use CData Connect AI to connect to live GetResponse data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Microsoft Planner Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Planner data using standard SQL.
-
Analyze Klaviyo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Klaviyo from Power Pivot. You will use the Table Import Wizard to load Klaviyo data. You can visually build the import query or use any SQL supported by the driver.
-
Natively Connect to Instantly Data in PHP
The CData ODBC driver for Instantly enables you to create PHP applications with connectivity to Instantly data. Leverage the native support for ODBC in PHP.
-
Migrating data from Perigon to Snowflake using CData SSIS Components.
Easily push Perigon data to Snowflake using the CData SSIS Tasks for Perigon and Snowflake.
-
Add Oracle SCM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle SCM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Presto Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Presto data and integrate live Presto data into apps built in Microsoft Power Apps.
-
Build a Simple VCL Application for Nuclia Data
How to build a simple VCL Application to view Nuclia data in RAD Studio using the CData ODBC Driver for Nuclia.
-
Analyze Zoom Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoom data with the CData JDBC Driver for Zoom.
-
Access Live Timely Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Timely data through MCP integration.
-
Visualize Live Splunk Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Splunk data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Back Up Microsoft Exchange data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Exchange. In this article, we will employ an SSIS workflow to populate a database with Microsoft Exchange data data.
-
How to Build an ETL App for Asana Data in Python with CData Connect AI
Extract and transform live Asana data in Python with petl and the CData Connect AI Python SDK.
-
Create Dynamic Freshteam Grids Using the Infragistics XamDataGrid
Learn how you can connect Freshteam to Infragistics XamDataGrid to build dynamic grids.
-
Migrating data from Hacker News to Snowflake using CData SSIS Components.
Easily push Hacker News data to Snowflake using the CData SSIS Tasks for Hacker News and Snowflake.
-
Visualize Live Sendwithus Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sendwithus data into custom reports in Power BI.
-
Create Reports from Zendesk Data in Looker Studio
Use CData Connect AI to gain access to live Zendesk data and create custom reports in Looker Studio.
-
Build Discord-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Discord data and build web apps with connectivity to live Discord data.
-
DataBind Controls to Dynamics CRM Data in Delphi
DataBind to Dynamics CRM data in Delphi with standard data access components and controls.
-
Use JayDeBeApi to access Odoo Data in Python
Use standard Python scripting and the development environment of your choice to access live Odoo data.
-
Visualize ChargeOver Data in TIBCO Spotfire through ADO.NET
Integrate ChargeOver data into dashboards in TIBCO Spotfire.
-
Automated Continuous Zuora Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zuora replication to Apache Cassandra.
-
Integrate Live Azure Table Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Table from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Table data.
-
How to Connect to Live Google Contacts Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Contacts data for you.
-
Automated Continuous Trello Replication to Oracle
Use CData Sync for automated, continuous, customizable Trello replication to Oracle.
-
How to Connect the Power BI Service to Google Search: Complete Guide
Connect to the CData Software Power BI Connector for Google Search from PowerBI.com to provide real-time Google Search results across the organization.
-
Access Live Presto Data in Coginiti Pro
Connect to and query live Presto data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Salesforce Data 360 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Salesforce Data 360.
-
Visualize GetResponse Data in Sisense
Create an ElastiCube in Sisense app with access to GetResponse data.
-
Analyze Notion Data in Cognos Analytics
Use CData Connect AI to connect to Notion Data from Cognos Analytics and analyze live Notion data.
-
Access Live Gong Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gong data from your Google Sheets.
-
Build MVC Applications with Connectivity to RSS Feeds
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access RSS from an ASP.NET MVC application.
-
Build Google Forms-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Google Forms data without replication.
-
Query Salesforce Pardot Data in DataGrip
Create a Data Source for Salesforce Pardot in DataGrip and use SQL to query live Salesforce Pardot data.
-
Create SSAS Tabular Models from Oracle Eloqua Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Eloqua data using CData drivers.
-
Automated Continuous JSON Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable JSON replication to Amazon Redshift.
-
Integrating Claude Code with HubSpot Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on HubSpot data within assisted coding and automated development workflows.
-
Connect to Dropbox from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Dropbox data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build an OLAP Cube in SSAS from Square Data
Establish a connection to Square data data from SQL Server Analysis Services, and use the Square Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create an RPA flow for Apollo Data in UiPath Studio
Use the Apollo ODBC Driver to create workflows that access real-time Apollo data without any coding.
-
Create EnterpriseDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to EnterpriseDB Data from OutSystems and build custom enterprise apps using live EnterpriseDB data.
-
How to integrate Metabase with XML Data
Use CData Connect AI to connect to live XML data and create an interactive dashboard in Metabase from XML data.
-
How to integrate Metabase with Spark Data
Use CData Connect AI to connect to live Spark data and create an interactive dashboard in Metabase from Spark data.