CData Software - Knowledge Base
Recent Articles
-
Visualize Live XML Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live XML data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate Simplesat Data Replication to Azure Data Lake
Use CData Sync to customize and automate Simplesat data replication to Azure Data Lake.
-
Getting Started with the CData ADO.NET Provider for Optimizely
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Rapidly Develop PhantomBuster-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 PhantomBuster.
-
How to Work with Teamgate Data in AWS Glue Jobs Using JDBC
Connect to Teamgate from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build ServiceDesk Plus-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ServiceDesk Plus Data from Zoho Analytics and import live ServiceDesk Plus data.
-
Connect to SQL Analysis Services Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SQL Analysis Services data.
-
Access Dynamics 365 Business Central Data from MySQL in Amazon QuickSight
Connect to Dynamics 365 Business Central and build visualizations of Dynamics 365 Business Central data using a MySQL Connection in Amazon QuickSight.
-
Automate Grafana Data Replication to SAP HANA
Use CData Sync to customize and automate Grafana data replication to SAP HANA.
-
DataBind Controls to Google Calendar Data in Delphi
DataBind to Google Calendar data in Delphi with standard data access components and controls.
-
Integrate with Webflow Data in JReport Designer
Create charts and reports based on Webflow data in JReport Designer.
-
Connect to SAP BusinessObjects BI 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 BusinessObjects BI.
-
Access Live Keap Data in Coginiti Pro
Connect to and query live Keap data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Gong Data from HeidiSQL
Use CData Connect AI to connect to and query live Gong data from HeidiSQL.
-
Build LDAP-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live LDAP objects without replication.
-
How to Access Live SAP BusinessObjects BI Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP BusinessObjects BI enables you to integrate SAP BusinessObjects BI data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous xBase Replication to Vertica
Use CData Sync for automated, continuous, customizable xBase replication to Vertica.
-
Integrating Codex with Amazon DynamoDB 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.
-
Write a Simple Go Application to work with SAP Concur Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Concur data.
-
Access Live Aha! Data in Coginiti Pro
Connect to and query live Aha! data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize CSV Data in TIBCO Spotfire through OData
Integrate CSV data into dashboards in TIBCO Spotfire.
-
View Reports on Real-Time Paymo Data in Power BI Report Server
Use the CData ODBC Driver for Paymo to visualize Paymo data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Visualize Authorize.Net Data in Python with pandas
Use pandas and other modules to analyze and visualize live Authorize.Net data in Python.
-
How to Work with Marketo Data in ETL Validator JDBC
Connect to Marketo from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Excel Spreadsheet Automation on Autopilot Data with the QUERY Formula
Pull data from Autopilot, automate spreadsheets, and more with the QUERY formula.
-
How to Visualize Grafana Data in Python with pandas
Use pandas and other modules to analyze and visualize live Grafana data in Python.
-
Build a PostgreSQL Interface for Vercel Data using the CData JDBC Driver
Use the Remoting features of the Vercel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Amplitude Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amplitude replication to Apache Kafka.
-
Build Dashboards with SAP Concur Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Concur data in Dundas BI.
-
Visualize Discord Data in Sisense
Create an ElastiCube in Sisense app with access to Discord data.
-
Integrate with Elorus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Elorus data to a JSON file on disk.
-
Automate Microsoft Teams Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Teams data from PowerShell? This article demonstrates how to utilize the Microsoft Teams Cmdlets for tasks like connecting to Microsoft Teams data, automating operations, downloading data, and more.
-
Build AI Agents with Zoho Inventory Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Zoho Inventory data through CData Connect AI.
-
Automated Continuous Google Ad Manager Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Apache Kafka.
-
Getting Started with the CData Connect AI Python SDK for Slack
Install the CData Connect AI Python SDK to read and write live Slack data with standard DB-API 2.0 Python code.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jodoo
Provide connectivity to Jodoo data through an SAP BusinessObjects universe.
-
Access Live SurveyMonkey Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SurveyMonkey data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to load Humanity data into Elasticsearch via Logstash
Introducing a simple method to load Humanity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Work with Clio Data in FoxPro
Load Clio data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query, Visualize, and Share live Google Directory Data in Redash
Use CData Connect AI to connect to live Google Directory data in Redash for querying, visualizing, and sharing.
-
Connecting Pipedream with Impala 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 Impala data in real time.
-
Analyze Salesforce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce from Power Pivot. You will use the Table Import Wizard to load Salesforce data. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from ZohoSubscriptions to Databricks using CData SSIS Components.
Easily push ZohoSubscriptions data to Databricks using the CData SSIS Tasks for ZohoSubscriptions and Databricks.
-
Connect to Active Directory Data in HULFT Integrate
Connect to Active Directory as a JDBC data source in HULFT Integrate
-
Visualize Live Spotify Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Spotify data.
-
Connecting Moonlit Workflow with AgileCRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your AgileCRM data in real time.
-
How to Access Sage Cloud Accounting Data Using Entity Framework
This article shows how to access Sage Cloud Accounting data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Dash to Build to Web Apps on Azure Analysis Services Data
Create Python applications that use pandas and Dash to build Azure Analysis Services-connected web apps.
-
How to connect PolyBase to Parquet
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Parquet data.
-
Access Microsoft Teams Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Teams data from your Oracle system.
-
Connect to Harvest Data from PowerBuilder via JDBC
This article demonstrates how to access Harvest data from PowerBuilder using the Harvest JDBC Driver.
-
Integrate LibreChat with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Service Cloud data from within the chat interface.
-
How to connect PolyBase to Anaplan
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Anaplan data.
-
Automated Continuous Demio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Demio data replication to OneLake in Microsoft Fabric.
-
Integrate Cline with Live Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Shortcut data from within your IDE.
-
Integrate with Flowlu Data in JReport Designer
Create charts and reports based on Flowlu data in JReport Designer.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Coda
Provide connectivity to Coda data through an SAP BusinessObjects universe.
-
Visualize Live Adobe Analytics Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Analytics data into custom reports in Power BI.
-
Integrate Adobe Target Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Adobe Target data and integrate live Adobe Target data into your Power Automate tasks.
-
Connect Front Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Front data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connecting Agentforce with SAP Fieldglass Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAP Fieldglass data for you.
-
Visualize Sentry 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 Sentry data into TIBCO Spotfire.
-
Connect to Aweber Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Aweber data from Filemaker Pro on Mac.
-
Query Zoom Data in DataGrip
Create a Data Source for Zoom in DataGrip and use SQL to query live Zoom data.
-
Use Dash to Build Web Apps on Bitbucket Data via CData Connect AI
Build interactive Dash web apps on live Bitbucket data using pandas and the CData Connect AI Python SDK.
-
How to Work with Spark Data in AWS Glue Jobs Using JDBC
Connect to Spark from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Theia IDE with Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live GitLab data from within the development environment.
-
Connect to and Visualize Live Google Drive Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Drive data.
-
Connect to Office 365 Data in Aqua Data Studio
Access Office 365 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Grok to Talk to Your CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your CSV data for you.
-
Create SSAS Tabular Models from Hive Data
How to build a SQL Server Analysis Service Tabular Model from Hive data using CData drivers.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Monday.com
Provide connectivity to Monday.com data through an SAP BusinessObjects universe.
-
Process & Analyze PolarTeamPro Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PolarTeamPro Data.
-
Build AI Agents with CapsuleCRM Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live CapsuleCRM data through CData Connect AI.
-
How to Connect to Live QuickBooks 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 QuickBooks data without replication.
-
Integrate Dify with Live Xero Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Xero data.
-
How to connect to Couchbase Data from Spring Boot
Connect to Couchbase in a Spring Boot Application using the CData JDBC Driver for Couchbase
-
Integrate Cline with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Act-On data from within your IDE.
-
Integrate with live SAP Fieldglass Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Fieldglass data in Jitterbit.
-
Connect to Access Data in Claris FileMaker Pro
Use the CData ODBC Driver for Access in FileMaker Pro to connect to Access and work with Access data in your FileMaker applications.
-
Visualize Live Google Cloud Storage Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Cloud Storage data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live TaxJar Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to TaxJar data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
LINQ to Simplesat Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Simplesat Data Provider.
-
Automate Microsoft Dataverse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Dataverse data from PowerShell? This article demonstrates how to utilize the Microsoft Dataverse Cmdlets for tasks like connecting to Microsoft Dataverse data, automating operations, downloading data, and more.
-
Automated Continuous Google Campaign Manager 360 Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MySQL.
-
Automated Continuous Calendly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Calendly replication to IBM DB2.
-
Connect to and Query QuickBooks Data in QlikView over ODBC
Create data visualizations with QuickBooks data in QlikView.
-
How to Visualize Google Cloud Storage Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Cloud Storage data in Python.
-
Automated Continuous Google Tasks Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Tasks replication to AlloyDB.
-
Integrate Zoom with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoom with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoom data.
-
Explore Geographical Relationships in Okta Data with Power Map
Create data visualizations with Okta data in Power Map.
-
DataBind Controls to Toggl Data in C++Builder
DataBind to Toggl data in C++Builder with standard components and controls.
-
Analyze WooCommerce Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of WooCommerce data and visualize live WooCommerce data in Infragistics Reveal.
-
Add WooCommerce Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for WooCommerce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Facebook Ads Data into Power Automate Desktop using CData Connect
CData Connect for Facebook Ads Data enables you to integrate Facebook Ads data into workflows built using Microsoft Power Automate Desktop.
-
Edit and Search External Cloudant Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Cloudant data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cloudant Data objects that you can access from apps and the dashboard.
-
Use Azure AI Foundry to Talk to Your Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Amazon Marketplace data for you.
-
Connect to SparkPost Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to SparkPost and work with SparkPost data in your FileMaker application.
-
Replicate Google Contacts Data in Heroku for Use in Salesforce Connect
Replicate Google Contacts data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.