CData Software - Knowledge Base
Recent Articles
-
Query Couchbase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Couchbase from Node.js.
-
Create SSAS Tabular Models from SAP Netweaver Gateway Data
How to build a SQL Server Analysis Service Tabular Model from SAP Netweaver Gateway using CData drivers.
-
Automated Continuous Microsoft OneLake Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Databricks.
-
Build a Singer.io Tap for Microsoft OneDrive With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft OneDrive data using
-
Query Amazon Marketplace Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon Marketplace from Node.js.
-
Visualize Live Azure Analysis Services Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Analysis Services.
-
Connect to Apify Data in NetBeans
Connect to Apify in NetBeans with the data source configuration wizard.
-
Automated Continuous Oracle HCM Cloud Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Snowflake.
-
Load PhantomBuster Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PhantomBuster to a database.
-
Integrate with Live Gmail Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Gmail from the MuleSoft Anypoint Platform to integrate live Gmail into custom reports and dashboards.
-
How to Connect to Live Redshift Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Amazon Redshift for you.
-
Connect to Couchbase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Couchbase as an External Source in Dremio.
-
Connect to Sugar CRM Data in Ruby
Connect to Sugar CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData ADO.NET Provider for Google Calendar
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Calendar.
-
Connect to GitHub from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from GitHub, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Presto Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Presto replication to Apache Cassandra.
-
Feed Odoo Data into FineReport
How to set Odoo ERP as a JDBC data source in FineReport.
-
Connect to Freshservice Data from AWS Glue
Use CData Connect AI to gain access to live Freshservice from your AWS Glue jobs.
-
Build MVC Applications with Connectivity to Apollo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Apollo from an ASP.NET MVC application.
-
A PostgreSQL Interface for Google Analytics Data using the CData ODBC Driver
Use the SQL Gateway and Google Analytics ODBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the SAP Hybris C4C JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Hybris C4C.
-
Use the CData Software JDBC Driver for Zoho CRM in MicroStrategy Desktop
Connect to Zoho CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho CRM.
-
Moving Data from WooCommerce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live WooCommerce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live Excel Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Excel data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed LDAP to Power BI dashboards. Simply drag and drop LDAP into data visuals on the Power BI canvas.
-
Connect to Microsoft Teams Data from a Connection Pool in Jetty
The Microsoft Teams JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Teams from Web apps in Jetty.
-
Connect Office 365 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Office 365 with IBM WebSphere for seamless data integration and connectivity.
-
Connect to HDFS Data in RapidMiner
Integrate Apache HDFS with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software JDBC Driver for YouTube Analytics in MicroStrategy
Connect to YouTube Analytics in MicroStrategy Developer using the CData Software JDBC Driver for YouTube Analytics.
-
Add Front Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Front with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to WooCommerce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for WooCommerce and the SQL Gateway to access WooCommerce from Google Apps Script.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Slack
Provide connectivity to Slack through an SAP BusinessObjects universe.
-
Build FTP-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live FTP Servers and build FTP-connected web apps with Axios.
-
How to connect to Pushbullet Data from IntelliJ
Integrate connectivity to Pushbullet with wizards in IntelliJ.
-
Integrate Active Directory Data into Power Automate Desktop using CData Connect
CData Connect for Active Directory Data enables you to integrate Active Directory into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAP Concur Data from a Connection Pool in JBoss
Integrate SAP Concur into Java servlets: Use the Management Console in JBoss to install the SAP Concur JDBC Driver.
-
Publish Ontraport-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Ontraport.
-
Connect and Visualize Live MariaDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MariaDB into the Databricks platform and create visualization dashboards with real-time MariaDB.
-
Design BIRT Reports on iContact Data
Provide current iContact to your embedded analytics.
-
Import DocuSign Data Using Azure Data Factory
Use CData Connect AI to connect to DocuSign Data from Azure Data Factory and import live DocuSign.
-
Build a PostgreSQL Interface for PhantomBuster Data using the CData JDBC Driver
Use the Remoting features of the PhantomBuster JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with MySQL Data in JReport Designer
Create charts and reports based on MySQL in JReport Designer.
-
Query Pipedrive Data in DataGrip
Create a Data Source for Pipedrive in DataGrip and use SQL to query live Pipedrive.
-
Connect to Coinbase Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Coinbase and work with Coinbase in your FileMaker applications.
-
Access Live Asana Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Asana from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use Microsoft Copilot Studio to talk to your Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Contacts for you.
-
Create Dynamic Samanage Grids Using the Infragistics XamDataGrid
Learn how you can connect Samanage to Infragistics XamDataGrid to build dynamic grids.
-
Create Data Visualizations in Cognos BI with LDAP Objects
Access LDAP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to integrate Redshift with Apache Airflow
Access and process Amazon Redshift in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Apify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apify.
-
Build a Singer.io Tap for Front With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Front data using
-
Connect to Campaigner Data from PowerBuilder via JDBC
This article demonstrates how to access Campaigner from PowerBuilder using the Campaigner JDBC Driver.
-
Connecting Pipedream with Lakebase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Lakebase data in real time.
-
How to load ChargeOver data into Elasticsearch via Logstash
Introducing a simple method to load ChargeOver data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to JSON Services in RazorSQL
Connect to JSON from wizards and query JSON from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for Power BI XMLA in MicroStrategy
Connect to Power BI XMLA in MicroStrategy Developer using the CData Software JDBC Driver for Power BI XMLA.
-
Automate Shopify Data Replication to Azure Synapse
Use CData Sync to customize and automate Shopify replication to Azure Synapse.
-
Rapidly Develop Highrise-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 Highrise.
-
Visualize Blackbaud FE NXT Data in Sisense
Create an ElastiCube in Sisense app with access to Blackbaud FE NXT.
-
Build Charts with Vercel Data in Clear Analytics
Create dynamic charts and perform analytics based on Vercel in Clear Analytics.
-
Create Datasets from Avalara AvaTax in Domo Workbench and Build Visualizations of Avalara AvaTax Data in Domo
Use the CData Software ODBC Driver for Avalara AvaTax to create datasets from Avalara AvaTax in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous PivotalTracker Replication to Oracle
Use CData Sync for automated, continuous, customizable PivotalTracker replication to Oracle.
-
Automated Continuous SendPulse Replication to Snowflake
Use CData Sync for automated, continuous, customizable SendPulse replication to Snowflake.
-
Automated Continuous Google Spanner Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Spanner replication to Databricks.
-
Integrating Workday Data in Talend Cloud Data Management Platform
Connect Workday Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Workday.
-
How to connect PolyBase to Gmail
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Gmail.
-
Integrating Cursor CLI with Amazon Marketplace 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 with live Microsoft Planner Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Planner in Jitterbit.
-
Connect to SAS Data Sets Data in Ruby
Connect to SAS Data Sets in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Amazon DynamoDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amazon DynamoDB.
-
Integrating Boomi Agentstudio with Freshservice Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Freshservice, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Edit and Search Greenhouse External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Greenhouse to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Greenhouse objects that you can access from apps and the dashboard.
-
Import Real-Time Mode Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mode in ColdFusion.
-
How to Import Data from Access into Google Sheets
Import Microsoft Access into a Google spreadsheet that is automatically refreshed.
-
How to Connect to & Open Sage Intacct Data in Microsoft Excel
This article uses the CData ODBC driver for Sage Intacct to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Cloudflare Data in TIBCO Spotfire through ADO.NET
Integrate Cloudflare into dashboards in TIBCO Spotfire.
-
Integrate Theia IDE with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Establish a Live Connection with CampaignMonitor Data using Tableau Bridge
The CData ODBC Driver for CampaignMonitor enables you to integrate live CampaignMonitor into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous LinkedIn Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LinkedIn replication to Azure SQL Database.
-
Use the CData Software JDBC Driver for Azure Table in MicroStrategy Desktop
Connect to Azure Table Storage in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Table.
-
Access GraphQL 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 GraphQL.
-
Connect to Drip Data in DBeaver
Use the CData ODBC Driver to connect to Drip in DBeaver.
-
Automate xBase Data Replication to SAP HANA
Use CData Sync to customize and automate xBase replication to SAP HANA.
-
Create ConvertKit Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ConvertKit from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for SpaceX in MicroStrategy
Connect to SpaceX in MicroStrategy Developer using the CData Software ODBC Driver for SpaceX.
-
How to Seamlessly Import Basecamp Data into IBM SPSS Modeler
Integrate Basecamp data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Printify Data in Ruby
Connect to Printify in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Cassandra with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cassandra with External Services.
-
Replicate Everhour Data from PowerShell
Write a quick PowerShell script to query Everhour. Use connectivity to the live data to replicate Everhour to SQL Server.
-
Natively Connect to Datadog Data in PHP
The CData ODBC driver for Datadog enables you to create PHP applications with connectivity to Datadog. Leverage the native support for ODBC in PHP.
-
Query Elasticsearch Data in ColdFusion
Write standard ColdFusion data access code to connect to Elasticsearch.
-
How to Visualize Accelo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Accelo in Python.
-
Access Active Directory Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Active Directory from HeidiSQL.
-
Connect to Oracle Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle in FileMaker Pro to connect to Oracle and work with Oracle Database in your FileMaker applications.
-
Automate Workday Data Replication to SAP HANA
Use CData Sync to customize and automate Workday replication to SAP HANA.
-
Integrate Live Office 365 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Office 365 to Blue Prism using the CData ODBC Driver for Office 365 to create automated workflows for repetitive business tasks.
-
Build Voice Agents in ElevenLabs with access to Live SAS xpt Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAS XPORT.
-
Build Data Flows from Teradata to SQL Server using SSIS
Easily back up Teradata to SQL Server using the SSIS components for Teradata.
-
Integrate Theia IDE with Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use JayDeBeApi to access Hugging Face Data in Python
Use standard Python scripting and the development environment of your choice to access live Hugging Face.