CData Software - Knowledge Base
Recent Articles
-
Integrating OpenCode with LightSpeedRetail 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 MVC Applications with Connectivity to Workable Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Workable from an ASP.NET MVC application.
-
Connect to Datadog Data from a Connection Pool in JBoss
Integrate Datadog data into Java servlets: Use the Management Console in JBoss to install the Datadog JDBC Driver.
-
Integrating Shopify Data in Talend Cloud Data Management Platform
Connect Shopify Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Shopify.
-
Automated Continuous ZohoSubscriptions Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to SQL Server.
-
Analyze Paddle Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Paddle data in Microsoft R Open.
-
Access Live Zuora Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zuora data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Supabase 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 Supabase data through MCP integration.
-
Replicate HubSpot Data to Multiple Databases via the CData Sync CLI
Replicate HubSpot data to disparate databases with a single configuration.
-
Use Biml to Build SSIS Tasks to Replicate Tanda Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tanda data to SQL Server.
-
How to connect to Dotmailer Data with Squirrel SQL client
Connect to Dotmailer data and execute queries in the Squirrel SQL Client.
-
Build eBay-Connected Apps in Choreo
Use CData Connect AI to connect to eBay Data from Choreo and build custom apps using live eBay data.
-
How to Connect DBeaver to Float via a JDBC Driver
Manage Float data with visual tools in DBeaver like the query browser.
-
Create Datasets from Sentry in Domo Workbench and Build Visualizations of Sentry Data in Domo
Use the CData Software ODBC Driver for Sentry to create datasets from Sentry data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Couchbase Data in RapidMiner
Integrate Couchbase data with standard components and data source configuration wizards in RapidMiner Studio.
-
Mixpanel Reporting in OBIEE with the Mixpanel JDBC Driver
Deploy the Mixpanel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
ETL CampaignMonitor in Oracle Data Integrator
This article shows how to transfer CampaignMonitor data into a data warehouse using Oracle Data Integrator.
-
Build a Singer.io Tap for Figshare With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Figshare data using the CData Python Connector.
-
Building Dynamic Web Pages with Spark Data Using AngularJS
Create single-page applications with live connectivity to Spark using the CData API Server.
-
Create Data Visualizations in Cognos BI with Google Translate Data
Access Google Translate data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData ODBC Driver for Zuora
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zuora.
-
Visualize Live ActiveCampaign Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ActiveCampaign data into custom reports in Power BI.
-
Automated Continuous Brex Replication to SQL Server
Use CData Sync for automated, continuous, customizable Brex replication to SQL Server.
-
Access Live Excel Online Data in Coginiti Pro
Connect to and query live Excel Online data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Enable the AgileCRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with AgileCRM data.
-
Back Up Salesforce Data 360 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce Data 360. In this article, we will employ an SSIS workflow to populate a database with Salesforce Data 360 data data.
-
How to connect SharePoint with HBase Data through external lists
Provide HBase data to SharePoint users as an external list.
-
Integrating OpenCode with Demio 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Data Lake Storage
Create an ODBC connection to Azure Data Lake Storage in Informatica and browse and transfer Azure Data Lake Storage data.
-
Automated Continuous Flowlu Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Flowlu replication to Azure SQL Database.
-
Integrating Claude Code CLI with Oracle 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 to Azure Table Data in RapidMiner
Integrate Azure Table data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use JayDeBeApi to access Simplesat Data in Python
Use standard Python scripting and the development environment of your choice to access live Simplesat data.
-
Connect to Live Egnyte Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Egnyte in CData Connect AI and connect to your Egnyte data from PostgreSQL.
-
Automated Continuous Mailjet Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mailjet replication to MongoDB.
-
How to use SQLAlchemy ORM to access FreshBooks Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of FreshBooks data.
-
How to Create Power BI Visual Reports with Real-Time Grafana Data
Use CData Power BI Connectors to visualize Grafana data in Power BI.
-
How to connect and process ZeroBounce data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZeroBounce data.
-
Create Reports from Salesforce CRM Analytics Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce CRM Analytics data and create custom reports in Looker Studio.
-
CData AWS Glue Connector Trial
You can test and build out Proofs-of-Concept for the CData AWS Glue Connectors using the CData JDBC Drivers.
-
Integrate Clio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Clio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Clio data.
-
Access Live Acumatica Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Acumatica data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Claude Code with Gong Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Gong data within assisted coding and automated development workflows.
-
Seamlessly Bring Oracle Sales Data into Retool Using CData Connect AI
Integrate Oracle Sales data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Excel Spreadsheet Automation on Placid Data with the QUERY Formula
Pull data from Placid, automate spreadsheets, and more with the QUERY formula.
-
Use Biml to Build SSIS Tasks to Replicate Stack Exchange Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Stack Exchange data to SQL Server.
-
DataBind Charts to SurveyMonkey Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SurveyMonkey data 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.
-
Building Dynamic Web Pages with Airtable Data Using AngularJS
Create single-page applications with live connectivity to Airtable using the CData API Server.
-
Integrate Live Teamwork Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Teamwork data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to HDFS Data in Ruby
Connect to HDFS data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Operational Reporting on SendPulse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SendPulse data.
-
Connect to Sendwithus from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sendwithus to connect to Sendwithus data from Web applications running on WebLogic.
-
Replicate Multiple ConvertAPI Accounts via the CData Sync CLI
Replicate multiple ConvertAPI accounts to one or many databases.
-
Extract, Transform, and Load Google Tasks Data in Informatica PowerCenter
Create a simple Workflow for Google Tasks data in Informatica PowerCenter.
-
Build Automated Procore-Connected Workflows in Zapier
Use CData Connect AI to connect to live Procore data and build automated workflows in Zapier.
-
Publish Reports with Zoho Inventory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Inventory data.
-
Build an OLAP Cube in SSAS from SAP BusinessObjects BI Data
Establish a connection to SAP BusinessObjects BI data data from SQL Server Analysis Services, and use the SAP BusinessObjects BI Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous MYOB AccountRight Replication to Vertica
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Vertica.
-
Rapidly Develop HelloSign-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 HelloSign.
-
Create HDFS-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to HDFS Data from Klipfolio and build custom visualizations using live HDFS data.
-
Build AI/ML Models with Live Power BI XMLA Data using Dataiku
Connect Power BI XMLA Data with Dataiku using the CData JDBC Driver for Power BI XMLA.
-
Connect to and Query Wistia Data in QlikView over ODBC
Create data visualizations with Wistia data in QlikView.
-
Integrate Live Parallel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Parallel data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Jira Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Jira replication to IBM DB2.
-
Getting Started with the CData Connect AI Python SDK for GitHub
Install the CData Connect AI Python SDK to read and write live GitHub data with standard DB-API 2.0 Python code.
-
Create Apps from API Data in Qlik Sense Cloud
Use CData Connect AI to connect to API Data and build apps from live API data in Qlik Sense Cloud.
-
How to load Missive data into Elasticsearch via Logstash
Introducing a simple method to load Missive data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Access SAP Business Warehouse Data Using Entity Framework
This article shows how to access SAP Business Warehouse data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect Amazon QuickSight to Jira Assets Data
Create a connection to Jira Assets data in CData Connect AI and insert Jira Assets data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access ElevenLabs Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ElevenLabs data from your Oracle system.
-
Load Freshservice Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Freshservice data to a database.
-
Connect to SQL Analysis Services Data in RazorSQL
Connect to SQL Analysis Services from wizards and query SQL Analysis Services data from the GUI in the RazorSQL database management tool.
-
Automated Continuous CircleCI Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CircleCI replication to AlloyDB.
-
Build PostgreSQL-Connected Apps in Choreo
Use CData Connect AI to connect to PostgreSQL Data from Choreo and build custom apps using live PostgreSQL data.
-
Replicate Multiple Excel Online Accounts via the CData Sync CLI
Replicate multiple Excel Online accounts to one or many databases.
-
Access Google Spanner Data from MySQL in PHP
Connect to Google Spanner through the standard MySQL libraries in PHP.
-
Create Power BI Reports on Real-Time Attio Data
Use the CData ODBC Driver for Attio to visualize Attio data in Power BI Desktop.
-
SFTP Reporting in OBIEE with the SFTP JDBC Driver
Deploy the SFTP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Building Dynamic Web Pages with Microsoft Entra ID Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Entra ID using the CData API Server.
-
Excel Spreadsheet Automation on SpaceX Data with the QUERY Formula
Pull data from SpaceX, automate spreadsheets, and more with the QUERY formula.
-
Design BIRT Reports on Excel Data
Provide current Excel data to your embedded analytics.
-
Query DocuSign Data in ColdFusion
Write standard ColdFusion data access code to connect to DocuSign data.
-
Microsoft Exchange Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Exchange data through CData Connect AI using different applications and tools.
-
Create Pipedrive-Connected Applications in Appsmith
Connect to Pipedrive Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Pipedrive data.
-
How to Visualize Pushbullet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pushbullet data in Python.
-
Access Live Microsoft Dataverse Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Dataverse data from your Google Sheets.
-
How to Query Exa Data in MySQL Workbench
Execute MySQL queries against live Exa data from MySQL Workbench.
-
Integrating Microsoft OneDrive Data in Talend Cloud Data Management Platform
Connect Microsoft OneDrive Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft OneDrive.
-
Connect to Sage 200 Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Sage 200 data.
-
How to Work with Monday.com Data in ETL Validator JDBC
Connect to Monday.com from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Reports with Bitly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bitly data.
-
Integrate Freshservice with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshservice with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshservice data.
-
Automated Continuous Humanity Replication to Oracle
Use CData Sync for automated, continuous, customizable Humanity replication to Oracle.
-
How to integrate Rootly with Apache Airflow
Access and process Rootly data in Apache Airflow using the CData JDBC Driver.
-
Replicate Wrike Data to Multiple Databases
Replicate Wrike data to disparate databases with a point-and-click configuration.
-
Integrate with SAS Data Sets Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAS Data Sets data in SnapLogic.
-
Interact with Live MailerLite Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live MailerLite data.
-
Access Adobe Analytics Data from MySQL in PHP
Connect to Adobe Analytics through the standard MySQL libraries in PHP.
-
Connect to Templated Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Templated data in the Denodo Virtual DataPort Administrator.
-
How to create an RPA flow for Google Contacts Data in UiPath Studio
Use the Google Contacts ODBC Driver to create workflows that access real-time Google Contacts data without any coding.