CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MessageBird
Provide connectivity to MessageBird through an SAP BusinessObjects universe.
-
ETL Oracle Eloqua Reporting in Oracle Data Integrator
This article shows how to transfer Oracle Eloqua Reporting into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Drip Replication to Snowflake
Use CData Sync for automated, continuous, customizable Drip replication to Snowflake.
-
Replicate Azure Data Catalog Data in Heroku for Use in Salesforce Connect
Replicate Azure Data Catalog to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Access Live Reckon Accounts Hosted Data in Visual Studio Code via Cline
Run CData MCP Server for Reckon Accounts Hosted on Windows Subsytem for Linux (WSL) and connect to live Reckon Accounts Hosted from the Cline extension in Visual Studio Code.
-
Viewing Flowlu Data in RAD Studio Data Explorer
How to view Flowlu in RAD Studio Data Explorer using the CData ODBC Driver for Flowlu.
-
How to connect to Gmail Data with Squirrel SQL client
Connect to Gmail and execute queries in the Squirrel SQL Client.
-
Connect to PingOne Data from a Connection Pool in JBoss
Integrate PingOne into Java servlets: Use the Management Console in JBoss to install the PingOne JDBC Driver.
-
Create SSAS Tabular Models from Freshsales Data
How to build a SQL Server Analysis Service Tabular Model from Freshsales using CData drivers.
-
Start and Stop Windows Services Using the CData Excel Add-In for PowerShell
Share and organize scripts, start and stop services, and create system reports from within Excel.
-
How to Connect to Microsoft OneDrive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft OneDrive. Leverage the pyodbc module for ODBC in Python.
-
How to Build an ETL App for Aircall Data in Python with CData
Create ETL applications and real-time data pipelines for Aircall in Python with petl.
-
Create Lakebase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Lakebase Data from Klipfolio and build custom visualizations using live Lakebase.
-
Integrate with live Neo4J Data in Jitterbit
Use CData Connect AI to connect to and integrate live Neo4J in Jitterbit.
-
Connect Billsby to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Billsby with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Salesforce Marketing Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Salesforce Marketing Cloud securely in real time.
-
Visualize Live Oracle Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle Database into custom reports in Power BI.
-
Integrate Open WebUI with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live eBay from within the chat interface.
-
Access Live Salesforce Data 360 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Data 360 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Import Real-Time Trello Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Trello in ColdFusion.
-
DataBind Snapchat Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Snapchat Ads with the DevExpress Windows Forms and Web controls to provide Snapchat Ads to a chart.
-
Build MVC Applications with Connectivity to Drip Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Drip from an ASP.NET MVC application.
-
Access Google Drive 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 Drive.
-
Connect to SQL Analysis Services Data in Ruby
Connect to SQL Analysis Services in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to AgileCRM Data in DBeaver
Use the CData ODBC Driver to connect to AgileCRM in DBeaver.
-
Consume Dropbox OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dropbox feeds that reflect any changes in SAP Lumira.
-
Access Live IBM Informix Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live IBM Informix through MCP integration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Adobe Experience Manager
Provide connectivity to Adobe Experience Manager through an SAP BusinessObjects universe.
-
Getting Started with the CData Excel Add-In for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure DevOps.
-
A PostgreSQL Interface for Dynamics 365 Data using the CData ODBC Driver
Use the SQL Gateway and Dynamics 365 ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live Presto Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Presto data in natural language using Python.
-
Integrating Claude Code CLI with Oracle Financials Cloud 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 Accelo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Accelo.
-
Bridge Superchat Connectivity with Apache NiFi
Access and process Superchat in Apache NiFi using the CData JDBC Driver.
-
Integrate LibreChat with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Cosmos DB from within the chat interface.
-
Connect to Paylocity Data from a Connection Pool in Jetty
The Paylocity JDBC Driver supports connection pooling: This article shows how to connect faster to Paylocity from Web apps in Jetty.
-
Replicate Data from Multiple Files in an Amazon S3 Bucket Using CData Sync
Use CData Sync to replicate multiple files from an Amazon S3 bucket to a data warehouse
-
Integrating Antigravity CLI with PivotalTracker via CData CLI
Connect PivotalTracker to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous ZohoDesk Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Google BigQuery.
-
Bridge Avalara AvaTax Connectivity with Apache NiFi
Access and process Avalara AvaTax in Apache NiFi using the CData JDBC Driver.
-
Model, Search, and Visualize Live Zoho CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Zoho CRM for modeling, searching, and visualizing.
-
Design BIRT Reports on Helpscout Data
Provide current Helpscout to your embedded analytics.
-
Migrating data from Azure DevOps to Google BigQuery using CData SSIS Components.
Easily push Azure DevOps to Google BigQuery using the CData SSIS Tasks for Azure DevOps and Google BigQuery.
-
How to create Dotmailer federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Dotmailer in MySQL .
-
How to connect and process Highrise CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Highrise CRM.
-
Explore Geographical Relationships in Greenplum Data with Power Map
Create data visualizations with Pivotal GreenPlum in Power Map.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Marketo using the Model Context Protocol.
-
How to Import Data from Mode into Google Sheets
Import Mode into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData SSIS Components for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Authorize.Net.
-
Automated Continuous Google Cloud Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to MongoDB.
-
Integrate Jumpseller with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jumpseller with External Services.
-
Connect to Gumroad Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Gumroad as an External Source in Dremio.
-
Integrate Real-Time Access to Todoist in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Todoist in real time.
-
Automated Continuous SuiteCRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SuiteCRM replication to AlloyDB.
-
Integrate Real-Time Access to Redshift in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Redshift in real time.
-
Access Live SAP Ariba Source Data in Excel 365 Online (Excel for the web)
Connect to SAP Ariba Source from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Salesforce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesforce replication to delimited files (CSV/TSV).
-
Model Dynamics 365 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365, enabling the direct import of real-time Microsoft Dynamics 365.
-
Publish Crystal Reports on Exact Online Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exact Online.
-
Establish a Live Connection with Invoiced Data using Tableau Bridge
The CData ODBC Driver for Invoiced enables you to integrate live Invoiced into Tableau Cloud dashboards using the Tableau Bridge.
-
Automate Harvest Data Replication to Azure Data Lake
Use CData Sync to customize and automate Harvest replication to Azure Data Lake.
-
Integrate Live TaxJar Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live TaxJar to Blue Prism using the CData ODBC Driver for TaxJar to create automated workflows for repetitive business tasks.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SurveyMonkey using the Model Context Protocol.
-
Access Live Authorize.Net Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Authorize.Net from your Google Sheets.
-
Connect to Google Contacts Data in JRuby
Create a simple JRuby app with access to live Google Contacts.
-
Build Dashboards with HBase Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache HBase in DBxtra.
-
How to import ServiceDesk Plus Data into Apache Solr
Use the CData Software JDBC Driver for ServiceDesk Plus in Data Import Handler and create an automated import of ServiceDesk Plus to Apache Solr Enterprise Search platform.
-
Automated Continuous Vault CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Vault CRM replication to MongoDB.
-
Create SSAS Tabular Models from AlloyDB Data
How to build a SQL Server Analysis Service Tabular Model from Google AlloyDB using CData drivers.
-
Access Deel Data from MySQL in Amazon QuickSight
Connect to Deel and build visualizations of Deel using a MySQL Connection in Amazon QuickSight.
-
Build Dashboards with AdRoll Data in DBxtra
Create dynamic dashboards and perform analytics based on AdRoll in DBxtra.
-
Import Pushbullet Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Pushbullet. In this article, you will use the OData format to import Pushbullet into Microsoft Power Query.
-
Build Pipelines with Live Exact Online Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Exact Online from Google Cloud Data Fusion, enabling the integration of live Exact Online into the building and management of effective data pipelines.
-
Getting Started with the CData Tableau Connector for Rebilly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating Cursor CLI with Teamgate 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.
-
Connect SharePoint to SQL Server through SSIS
Easily back-up SharePoint data to SQL Server using the SharePoint Data Provider for ADO.NET. This example uses an SSIS workflow to populate a database with SharePoint data using the SharePoint ADO.NET Data Provider.
-
Extend Google Sheets with FHIR Data
Make calls to FHIR from Google Apps Script via the API Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Anaplan
Create Anaplan data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Query Gong Data in MySQL Workbench
Execute MySQL queries against live Gong from MySQL Workbench.
-
DataBind Controls to Optimizely Data in C++Builder
DataBind to Optimizely in C++Builder with standard components and controls.
-
How to connect to Asana Data with Squirrel SQL client
Connect to Asana and execute queries in the Squirrel SQL Client.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Exchange Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Exchange.
-
Connect to JSON Services in ACL Analytics
Connect to JSON via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to JSON.
-
Connect to PabblySubscriptions Data in JRuby
Create a simple JRuby app with access to live PabblySubscriptions.
-
Create Data Visualizations Based On Asana Data in Mode
Use CData Connect AI to connect to Asana Data from Mode and build visualizations using live
-
Integrate Clockify Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Clockify from Informatica Cloud.
-
Visualize OnePageCrm 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 OnePageCrm into TIBCO Spotfire.
-
Access Neo4J Data from MySQL in PHP
Connect to Neo4J through the standard MySQL libraries in PHP.
-
Choosing the Best Method to Connect FreshBooks to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FreshBooks from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to & Open Discord Data in Microsoft Excel
This article uses the CData ODBC driver for Discord to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous BigCommerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable BigCommerce replication to AlloyDB.
-
Connect to and Visualize Live Printify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Printify.
-
Connect to MailChimp in SpagoBI
Create reports featuring live MailChimp in SpagoBI Studio. Host MailChimp reports on SpagoBI Server.
-
How to connect to Anaplan Data in DBVisualizer
Integrate Anaplan with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Authorize.Net Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Authorize.Net with the CData JDBC Driver for Authorize.Net.
-
Connect to Oracle Data in RazorSQL
Connect to Oracle from wizards and query Oracle Database from the GUI in the RazorSQL database management tool.
-
Connect to Real-Time WooCommerce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for WooCommerce and Dataflow to import and use WooCommerce in Power Apps.
-
Work with Live SAP Business One Data in Power Query
Use CData Connect AI to connect to SAP Business One and work with live SAP Business One in Microsoft Power Query.
-
Query, Visualize, and Share live Hive Data in Redash
Use CData Connect AI to connect to live Apache Hive in Redash for querying, visualizing, and sharing.
-
Integrate with MarkLogic Data in JReport Designer
Create charts and reports based on MarkLogic in JReport Designer.