CData Software - Knowledge Base
Recent Articles
-
Connect and Visualize Live Office 365 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Office 365 data into the Databricks platform and create visualization dashboards with real-time Office 365 data.
-
Visualize Live Parquet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Parquet data.
-
Integrate Live PayPal Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to PayPal data and integrate live PayPal data into apps built in Microsoft Power Apps.
-
Access Avalara AvaTax Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Avalara AvaTax data from HeidiSQL.
-
Replicate Multiple DB2 for i Accounts
Replicate multiple DB2 for i accounts to one or many databases.
-
Connect to Aha! Data in Ruby
Connect to Aha! data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to SAP Fieldglass Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP Fieldglass.
-
Automated Continuous ElevenLabs Replication to MongoDB
Use CData Sync for automated, continuous, customizable ElevenLabs replication to MongoDB.
-
Query CloudConvert Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CloudConvert data from Node.js.
-
Connect to JSON Services from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time JSON services using standard SQL.
-
Connect to Quaderno Data in Jaspersoft Studio
Execute SQL to remote Quaderno data in Jaspersoft Studio.
-
Build Semantic Layer Views for Dotmailer Data in APOS Live Data Gateway
Use the CData Connector for Dotmailer in APOS Live Data Gateway to build Semantic Layer Views for Dotmailer data.
-
Automated Continuous Google Campaign Manager 360 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Google BigQuery.
-
Process & Analyze ZohoDesk Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoDesk Data.
-
Building Dynamic Web Pages with Amazon S3 Data Using AngularJS
Create single-page applications with live connectivity to Amazon S3 using the CData API Server.
-
How to Connect to PDFMonkey Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PDFMonkey data. Leverage the pyodbc module for ODBC in Python.
-
How to work with VWO Data in Apache Spark using SQL
Access and process VWO Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze Workable Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Workable from Power Pivot. You will use the Table Import Wizard to load Workable data. You can visually build the import query or use any SQL supported by the driver.
-
Create Dashboards and Visualize Live xBase Data in Geckoboard
Use CData Connect AI to connect to live xBase data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Live Dropbox Data in MicroStrategy through CData Connect AI
Create a live connection to Dropbox Data in CData Connect AI and connect to your Dropbox data from MicroStrategy.
-
Automate Strava Data Replication to Couchbase
Use CData Sync to Customize and automate Strava data replication to Couchbase.
-
Integrate with Figshare Data in JReport Designer
Create charts and reports based on Figshare data in JReport Designer.
-
Seamlessly Bring PostgreSQL Data into Retool Using CData Connect AI
Integrate PostgreSQL data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to WooCommerce Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live WooCommerce data.
-
How to Connect the Power BI Service to ConstantContact: Complete Guide
Connect to the CData Software Power BI Connector for ConstantContact from PowerBI.com to provide real-time ConstantContact data across the organization.
-
Use the CData Software ODBC Driver for BigCommerce in SAS for Real-Time Reporting and Analytics
Connect to real-time BigCommerce data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for BigCommerce.
-
Getting Started with the CData Connect AI Python SDK for Adobe Analytics
Install the CData Connect AI Python SDK to read live Adobe Analytics data with standard DB-API 2.0 Python code.
-
How to Connect the Power BI Service to Amazon S3: Complete Guide
Connect to the CData Software Power BI Connector for Amazon S3 from PowerBI.com to provide real-time Amazon S3 data across the organization.
-
Create a Data Access Object for CampaignMonitor Data using JDBI
A brief overview of creating a SQL Object API for CampaignMonitor data in JDBI.
-
Access Live ConvertKit Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ConvertKit data into the statistical analysis tools available in SAS JMP. This article shows how to use ConvertKit data in the Graph Builder and Query Builder.
-
Trigger Oracle Sales IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Oracle Sales with standard wizards in Logic Apps.
-
Integrate Open WebUI with Live BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live BenchmarkEmail data from within the chat interface.
-
Visualize Zuora Data in Sisense
Create an ElastiCube in Sisense app with access to Zuora data.
-
Getting Started with the CData ODBC Driver for ClickUp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ClickUp.
-
Automated Continuous Hugging Face Replication to SQL Server
Use CData Sync for automated, continuous, customizable Hugging Face replication to SQL Server.
-
Build JSON-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live JSON services.
-
Building Dynamic Web Pages with MailChimp Data Using AngularJS
Create single-page applications with live connectivity to MailChimp using the CData API Server.
-
Connect to Salesforce Pardot Data in HULFT Integrate
Connect to Salesforce Pardot as a JDBC data source in HULFT Integrate
-
How to create an RPA flow for Rebilly Data in UiPath Studio
Use the Rebilly ODBC Driver to create workflows that access real-time Rebilly data without any coding.
-
Workday Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Workday data through CData Connect AI using different applications and tools.
-
Automated Continuous Mode Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mode replication to Apache Kafka.
-
Stream Bannerbear Data into Apache Kafka Topics
Access and stream Bannerbear data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live PayPal Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PayPal data from your Google Sheets.
-
Design BIRT Reports on Miro Data
Provide current Miro data to your embedded analytics.
-
Configure the CData JDBC Driver for ConstantContact in a Connection Pool in Tomcat
Connect to ConstantContact data from a connection pool in Tomcat.
-
Import Real-Time Aha! Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Aha! data in ColdFusion.
-
Use Microsoft Copilot Studio to talk to your Oracle Sales 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 Oracle Sales data for you.
-
Replicate RabbitMQ Data from PowerShell
Write a quick PowerShell script to query RabbitMQ data. Use connectivity to the live data to replicate RabbitMQ data to SQL Server.
-
Analyze Odoo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Odoo data in Microsoft R Open.
-
How to Connect to Live Google Forms Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Forms data without replication.
-
Connect and Visualize Live Optimizely Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Optimizely data into the Databricks platform and create visualization dashboards with real-time Optimizely data.
-
Build Automated Workflows with Live Egnyte Data in Workato
Use CData Connect AI to connect to live Egnyte data and build automated workflows in Workato.
-
Back Up Excel Online data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel Online. In this article, we will employ an SSIS workflow to populate a database with Excel Online data data.
-
Analyze Webex Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Webex from Power Pivot. You will use the Table Import Wizard to load Webex data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to and Query Oracle Data in QlikView over ODBC
Create data visualizations with Oracle data in QlikView.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesforce Data 360
Provide connectivity to Salesforce Data 360 data through an SAP BusinessObjects universe.
-
Automated Continuous Freshsales Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Freshsales replication to AlloyDB.
-
Connect to Float Data in RapidMiner
Integrate Float data with standard components and data source configuration wizards in RapidMiner Studio.
-
Natively Connect to Act CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Act CRM data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ODBC Driver for Dropbox
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dropbox.
-
Connect to SuiteCRM Data from a Connection Pool in Jetty
The SuiteCRM JDBC Driver supports connection pooling: This article shows how to connect faster to SuiteCRM data from Web apps in Jetty.
-
Connect LeadDesk to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LeadDesk data using the CData Python MCP Server.
-
Integrating LlamaIndex with Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Databricks data in real time.
-
Rapidly Develop OData-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 OData.
-
Query Odoo Data as a SQL Server Database in Node.js
Execute SQL Server queries against Odoo data from Node.js.
-
Automated Continuous Google Cloud Storage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to PostgreSQL.
-
Query Hugging Face Data in DataGrip
Create a Data Source for Hugging Face in DataGrip and use SQL to query live Hugging Face data.
-
Publish Crystal Reports on Jira Assets Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Jira Assets data.
-
Publish Crystal Reports on Pipedrive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pipedrive data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for IBM Cloud Object Storage
Provide connectivity to IBM Cloud Object Storage data through an SAP BusinessObjects universe.
-
Connect Webex Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Webex data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software ODBC Driver for Bannerbear in MicroStrategy Web
Connect to Bannerbear data in MicroStrategy Web using the CData Software ODBC Driver for Bannerbear.
-
Stream XML Data into Apache Kafka Topics
Access and stream XML data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Natively Connect to Power BI XMLA Data in PHP
The CData ODBC driver for Power BI XMLA enables you to create PHP applications with connectivity to Power BI XMLA data. Leverage the native support for ODBC in PHP.
-
DataBind Charts to Clockify Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Clockify 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.
-
Use the CData Software JDBC Driver for GetResponse in MicroStrategy
Connect to GetResponse data in MicroStrategy Developer using the CData Software JDBC Driver for GetResponse.
-
Analyze Zoho CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoho CRM data and visualize Zoho CRM data in SAP Analytics Cloud.
-
Replicate Multiple Xero Accounts
Replicate multiple Xero accounts to one or many databases.
-
Automated Continuous Teamwork Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Teamwork replication to Apache Kafka.
-
Create Datasets from Tally in Domo Workbench and Build Visualizations of Tally Data in Domo
Use the CData Software ODBC Driver for Tally to create datasets from Tally data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Klipfolio Data in Excel 365 Online (Excel for the web)
Connect to Klipfolio data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Google Contacts Data from PowerShell
Write a quick PowerShell script to query Google Contacts data. Use connectivity to the live data to replicate Google Contacts data to SQL Server.
-
Tanda Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Tanda facts in real time.
-
Build Semantic Layer Views for Microsoft Teams Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Teams data.
-
Connect to Spotify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Spotify data in the Denodo Virtual DataPort Administrator.
-
How to connect to Avalara AvaTax Data in DBVisualizer
Integrate Avalara AvaTax data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to ActiveCampaign Data with Squirrel SQL client
Connect to ActiveCampaign data and execute queries in the Squirrel SQL Client.
-
Stream Adobe Commerce Data into Apache Kafka Topics
Access and stream Adobe Commerce data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software JDBC Driver for Gong in MicroStrategy Desktop
Connect to Gong data in MicroStrategy Desktop using the CData Software JDBC Driver for Gong.
-
Access Live CSV Data in Excel 365 Online (Excel for the web)
Connect to CSV data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Data Flows from Oracle to SQL Server using SSIS
Easily back up Oracle data to SQL Server using the SSIS components for Oracle.
-
Building Dynamic Web Pages with Certinia Data Using AngularJS
Create single-page applications with live connectivity to Certinia using the CData API Server.
-
Use the CData Software ODBC Driver for Accelo in MicroStrategy Web
Connect to Accelo data in MicroStrategy Web using the CData Software ODBC Driver for Accelo.
-
Create Dashboards and Visualize Live Cosmos DB Data in Geckoboard
Use CData Connect AI to connect to live Cosmos DB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Seamlessly Import Azure Table Data into IBM SPSS Modeler
Integrate Azure Table data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Apps with Live Azure Synapse data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Synapse data into the Adalo platform and build custom mobile and web applications with real-time Azure Synapse data.
-
A PostgreSQL Interface for Front Data (MySQL Remoting via JDBC)
Use the Remoting features of the Front JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Zoho CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho CRM replication to AlloyDB.
-
Automate ChargeOver Data Replication to Azure Data Lake
Use CData Sync to customize and automate ChargeOver data replication to Azure Data Lake.
-
Visualize Reckon Data in Tableau
The CData ODBC driver for Reckon enables you integrate Reckon data into Tableau dashboards.