CData Software - Knowledge Base
Recent Articles
-
Replicate Act-On Data to Multiple Databases
Replicate Act-On to disparate databases with a point-and-click configuration.
-
Connect and Query Live SQL Analysis Services Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SQL Analysis Services into Databricks
-
Bidirectional Access to CSV Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate CSV/TSV Files in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time Google Translate Data in Power BI Report Server
Use the CData ODBC Driver for Google Translate to visualize Google Translate in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Zoho Projects Data in ACL Analytics
Connect to Zoho Projects via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho Projects.
-
Replicate Shortcut Data to Multiple Databases
Replicate Shortcut to disparate databases with a point-and-click configuration.
-
How to Query Live Odoo Data in Claude Desktop
Connect to and query live Odoo Data in Claude Desktop using CData MCP Server.
-
Analyze REST Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze REST in Microsoft R Open.
-
How to publish and share Email Data dashboards with Tableau Server
The CData ODBC driver for Email enables you integrate Email into Tableau dashboards.
-
Create Datasets from PabblySubscriptions in Domo Workbench and Build Visualizations of PabblySubscriptions Data in Domo
Use the CData Software ODBC Driver for PabblySubscriptions to create datasets from PabblySubscriptions in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData ODBC Driver for DocuSign from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for DocuSign to connect to DocuSign from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring DocuSign in Excel.
-
Easily Integrate Google Directory Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Directory in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect to VWO Data with Squirrel SQL client
Connect to VWO and execute queries in the Squirrel SQL Client.
-
Automated Continuous Sendwithus Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sendwithus replication to Snowflake.
-
Replicate Quaderno Data to Multiple Databases via the CData Sync CLI
Replicate Quaderno to disparate databases with a single configuration.
-
Use ChatGPT to Talk to Your Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Okta for you.
-
Migrating data from Google Directory to Google BigQuery using CData SSIS Components.
Easily push Google Directory to Google BigQuery using the CData SSIS Tasks for Google Directory and Google BigQuery.
-
Build Dashboards with ZohoExpense Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoExpense in DBxtra.
-
Query Zoom Data as a MySQL Database in Node.js
Execute MySQL queries against Zoom from Node.js.
-
Visualize Live Bitbucket Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bitbucket using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple PabblySubscriptions Accounts via the CData Sync CLI
Replicate multiple PabblySubscriptions accounts to one or many databases.
-
Design BIRT Reports on SAS Data Sets Data
Provide current SAS Data Sets to your embedded analytics.
-
Connect to Zoom Data in Aqua Data Studio
Access Zoom from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to use SQLAlchemy ORM to access Jira Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Atlassian Jira.
-
Query Suadeo Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Suadeo and perform CRUD operations on Suadeo from Node.js.
-
Connect to Google Forms Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Forms from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Bind Live DocuSign Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live DocuSign data
-
Connect to NASA Data in Aqua Data Studio
Access NASA from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live Microsoft OneDrive 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 Microsoft OneDrive for you.
-
Process & Analyze SAP HANA XS Advanced Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP HANA XS Advanced Data.
-
Connect to AgileCRM Data in NetBeans
Connect to AgileCRM in NetBeans with the data source configuration wizard.
-
How to create Visio diagrams from Presto Data
Automatically update Presto with the changes you make to Visio master shapes.
-
Getting Started with the CData Tableau Connector for Accelo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Load Exact Online Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Exact Online to a database.
-
Extract, Transform, and Load MongoDB Data in Informatica PowerCenter
Create a simple Workflow for MongoDB in Informatica PowerCenter.
-
Connect to and Visualize Live HDFS Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache HDFS.
-
Visualize Close Data in Tableau
The CData ODBC driver for Close enables you integrate Close into Tableau dashboards.
-
Integrate Open WebUI with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Klaviyo from within the chat interface.
-
Build Visualizations of Keap Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Keap in Birst.
-
Creating Microsoft OneDrive-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft OneDrive to Unqork and build custom business apps.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Teradata to Power BI dashboards. Simply drag and drop Teradata into data visuals on the Power BI canvas.
-
Connect to Real-Time ClickUp Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ClickUp in Power Apps.
-
Use the CData Software JDBC Driver for PostgreSQL in MicroStrategy Desktop
Connect to PostgreSQL in MicroStrategy Desktop using the CData Software JDBC Driver for PostgreSQL.
-
Use the CData Software ODBC Driver for Outlook in MicroStrategy Web
Connect to Outlook in MicroStrategy Web using the CData Software ODBC Driver for Outlook.
-
Create SSAS Tabular Models from HBase Data
How to build a SQL Server Analysis Service Tabular Model from Apache HBase using CData drivers.
-
Connect to Gorgias Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Presto Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Presto from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to import Quaderno Data into Apache Solr
Use the CData Software JDBC Driver for Quaderno in Data Import Handler and create an automated import of Quaderno to Apache Solr Enterprise Search platform.
-
Create SSAS Tabular Models from Landbot Data
How to build a SQL Server Analysis Service Tabular Model from Landbot using CData drivers.
-
Create Reports with AfterShip Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date AfterShip.
-
Import Real-Time Tavily Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Tavily in ColdFusion.
-
How to Build an ETL App for Teamgate Data in Python with CData
Create ETL applications and real-time data pipelines for Teamgate in Python with petl.
-
Automated Continuous Sybase IQ Replication to Oracle
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Oracle.
-
Import Real-Time Stripe Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Stripe in ColdFusion.
-
Create Power BI Reports on Real-Time Onfleet Data
Use the CData ODBC Driver for Onfleet to visualize Onfleet in Power BI Desktop.
-
Import Real-Time VWO Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use VWO in ColdFusion.
-
How to Query Guru Data in MySQL Workbench
Execute MySQL queries against live Guru from MySQL Workbench.
-
Access Live Zoho Projects Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho Projects from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData SSIS Components for SendPulse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SendPulse.
-
Publish Crystal Reports on Google Analytics Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Analytics.
-
Validate Oracle Financials Cloud Data with QuerySurge
Access and validate Oracle Financials Cloud in QuerySurge using the CData JDBC Driver.
-
Migrating data from Twitter Ads to Databricks using CData SSIS Components.
Easily push Twitter Ads to Databricks using the CData SSIS Tasks for Twitter Ads and Databricks.
-
Build Data Flows from ZohoExpense to SQL Server using SSIS
Easily back up ZohoExpense to SQL Server using the SSIS components for ZohoExpense.
-
Moving Data from Attio to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Attio data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous MessageBird Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MessageBird replication to Google BigQuery.
-
A PostgreSQL Interface for CampaignMonitor Data using the CData ODBC Driver
Use the SQL Gateway and CampaignMonitor ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Google Search-Connected Business Apps in AppSheet
Connect to Google Search Results via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Search.
-
Integrate Live Vault CRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Veeva Vault & Vault CRM and integrate live Veeva Vault & Vault CRM into apps built in Microsoft Power Apps.
-
Build a PostgreSQL Interface for YouTube Analytics Data using the CData JDBC Driver
Use the Remoting features of the YouTube Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate SAP Netweaver Gateway Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Netweaver Gateway and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use Manus AI to Talk to Your SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Microsoft SharePoint.
-
Integrating LlamaIndex with Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Salesforce Pardot in real time.
-
How to publish and share JSON Services dashboards with Tableau Server
The CData ODBC driver for JSON enables you integrate JSON into Tableau dashboards.
-
Rapidly Develop Gmail-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 Gmail.
-
Feed Webex Data into FineReport
How to set Webex as a JDBC data source in FineReport.
-
Rapidly Develop Tally-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 Tally.
-
Analyze FHIR Data in Looker
Use CData Connect AI to connect to FHIR Data from Looker and build custom apps using live FHIR.
-
How to Visualize Jira Assets 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 Jira Assets in Python.
-
Create Neo4J Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Neo4J data access from reports, embedded analytics, and more.
-
Automated Continuous Zoho Books Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoho Books replication to Vertica.
-
Automated Continuous WordPress Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable WordPress replication to OneLake in Microsoft Fabric.
-
How to load Teamgate data into Elasticsearch via Logstash
Introducing a simple method to load Teamgate data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live Google Drive 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 Drive for you.
-
Connect to PostgreSQL Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for PostgreSQL to connect to PostgreSQL and execute queries in PowerBuilder.
-
Publish Reports with Avro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Avro.
-
Getting Started with the CData Tableau Connector for Telegram
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect to SharePoint Excel Services Data from IntelliJ
Integrate connectivity to SharePoint Excel Services with wizards in IntelliJ.
-
Access Odoo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Odoo ERP from HeidiSQL.
-
Integrating LlamaIndex with Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sage Intacct in real time.
-
Connect to Live Dynamics 365 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Dynamics 365 in CData Connect AI and connect to your Microsoft Dynamics 365 from PostgreSQL.
-
Edit and Search Dynamics CRM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Dynamics CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Dynamics CRM objects that you can access from apps and the dashboard.
-
Work with MySQL Data in FoxPro
Load MySQL into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Accelo Data from PowerShell
Write a quick PowerShell script to query Accelo. Use connectivity to the live data to replicate Accelo to SQL Server.
-
Perform Batch Operations with LinkedIn Data in Apache NiFi
Connect to LinkedIn and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Use a Microsoft Access Database to Update Redshift Data in Real Time
Update Redshift data by creating a linked table in Microsoft Access with the CData Redshift ODBC Driver.
-
DataBind Charts to Avaza Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Avaza 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.
-
Integrating Kiro CLI with Perigon 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 Data Flows from Notion to SQL Server using SSIS
Easily back up Notion to SQL Server using the SSIS components for Notion.
-
Query Amazon Athena Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Amazon Athena and perform CRUD operations on Amazon Athena from Node.js.
-
Getting Started with the CData Tableau Connector for Jira
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Jira.