CData Software - Knowledge Base
Recent Articles
-
Connect and Visualize Live Azure DevOps Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure DevOps data into the Databricks platform and create visualization dashboards with real-time Azure DevOps data.
-
Create Data Visualizations Based On ZohoMarketingHub Data in Mode
Use CData Connect AI to connect to ZohoMarketingHub Data from Mode and build visualizations using live ZohoMarketingHub data.
-
Integrate Zoho Creator with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho Creator with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho Creator data.
-
Getting Started with the CData Excel Add-In for Amplitude
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amplitude.
-
Integrating GitHub Copilot with SendInBlue 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 Perplexity Data from Crystal Reports
Use CData Connect AI to connect to and report on live Perplexity data from Crystal Reports.
-
Getting Started with the CData ADO.NET Provider for Guru
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Enable the MYOB AccountRight JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MYOB AccountRight data.
-
Access Live Typeform Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Typeform data through MCP integration.
-
Automated Continuous Amazon DynamoDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to SingleStore.
-
Use the CData Software ODBC Driver for Phoenix in SAS for Real-Time Reporting and Analytics
Connect to real-time Phoenix data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Phoenix.
-
How to connect to Outreach.io Data with Squirrel SQL client
Connect to Outreach.io data and execute queries in the Squirrel SQL Client.
-
Connect to Cloudflare Data in Jaspersoft Studio
Execute SQL to remote Cloudflare data in Jaspersoft Studio.
-
Interact with Live BigCommerce Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live BigCommerce data.
-
Build a PostgreSQL Interface for Redshift Data using the CData JDBC Driver
Use the Remoting features of the Redshift JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live SQL Analysis Services Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SQL Analysis Services data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect Flowise AI Agents to Live Jira Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Jira data without replication.
-
How to Connect the Power BI Service to MailerLite: Complete Guide
Connect to the CData Software Power BI Connector for MailerLite from PowerBI.com to provide real-time MailerLite data across the organization.
-
View Reports on Real-Time SAP Data in Power BI Report Server
Use the CData ODBC Driver for SAP to visualize SAP data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Google Cloud Storage with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Cloud Storage with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Cloud Storage data.
-
Automated Continuous Teamwork Replication to SQL Server
Use CData Sync for automated, continuous, customizable Teamwork replication to SQL Server.
-
Connect to and Visualize Live Amazon Athena Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon Athena data.
-
Access Okta Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Okta data from your Oracle system.
-
Automated Continuous Freshservice Replication to SingleStore
Use CData Sync for automated, continuous, customizable Freshservice replication to SingleStore.
-
Build Dashboards with CockroachDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on CockroachDB data in Dundas BI.
-
Connect to Paymo Data from HeidiSQL
Use CData Connect AI to connect to and query live Paymo data from HeidiSQL.
-
Integrate Live EnterpriseDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live EnterpriseDB data from within the IDE.
-
Replicate Zoho Inventory Data from PowerShell
Write a quick PowerShell script to query Zoho Inventory data. Use connectivity to the live data to replicate Zoho Inventory data to SQL Server.
-
Connecting Pipedream with Figshare 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 Figshare data in real time.
-
Model, Search, and Visualize Live Office 365 Data in ThoughtSpot
Use CData Connect AI to connect to live Office 365 data for modeling, searching, and visualizing.
-
Publish Reports with Optimizely Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Optimizely data.
-
Connect to Google Analytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Analytics data from Crystal Reports.
-
DataBind Controls to LeadDesk Data in Delphi
DataBind to LeadDesk data in Delphi with standard data access components and controls.
-
Manage HCL Domino Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HCL Domino.
-
Connect to HubDB Data in JRuby
Create a simple JRuby app with access to live HubDB data.
-
Create Dynamic Reckon Grids Using the Infragistics XamDataGrid
Learn how you can connect Reckon to Infragistics XamDataGrid to build dynamic grids.
-
Automate Office 365 Data Replication to SAP HANA
Use CData Sync to customize and automate Office 365 data replication to SAP HANA.
-
Create Wistia Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Wistia from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to import SAP SuccessFactors LMS Data into Apache Solr
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in Data Import Handler and create an automated import of SAP SuccessFactors LMS data to Apache Solr Enterprise Search platform.
-
How to Connect MailerLite Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MailerLite data in real time using natural language.
-
Visualize JDBC-ODBC Bridge Data in Sisense
Create an ElastiCube in Sisense app with access to JDBC-ODBC Bridge data.
-
Excel Spreadsheet Automation on ZohoDesk Data with the QUERY Formula
Pull data from ZohoDesk, automate spreadsheets, and more with the QUERY formula.
-
How to Use a Microsoft Access Database to Update Lakebase Data in Real Time
Update Lakebase data by creating a linked table in Microsoft Access with the CData Lakebase ODBC Driver.
-
Access Splunk Data from MySQL in PHP
Connect to Splunk through the standard MySQL libraries in PHP.
-
How to Work with Datadog Data in ETL Validator JDBC
Connect to Datadog from ETL Validator jobs using the CData Software JDBC Driver.
-
Deploy the ADO.NET Provider for Bright Data on an SSRS Report Server
Connect to Bright Data data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Create Informatica Mappings From/To an ODBC Data Source for Toggl
Create an ODBC connection to Toggl in Informatica and browse and transfer Toggl data.
-
Replicate Multiple Google Ads Accounts via the CData Sync CLI
Replicate multiple Google Ads accounts to one or many databases.
-
Getting Started with the CData Tableau Connector for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Inventory.
-
Automate Oracle Financials Cloud Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Financials Cloud data replication to Azure Data Lake.
-
Automated Continuous Amplitude Replication to SQLite
Use CData Sync for automated, continuous, customizable Amplitude replication to SQLite.
-
Automated Continuous Mouseflow Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Mouseflow replication to Amazon Redshift.
-
Perform Batch Operations with Microsoft Exchange Data in Apache NiFi
Connect to Microsoft Exchange data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Analyze CockroachDB Data in Looker
Use CData Connect AI to connect to CockroachDB Data from Looker and build custom apps using live CockroachDB data.
-
Using the CData Software ODBC Driver for Mouseflow in PyCharm
Connect to Mouseflow as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mouseflow.
-
Connect to Avro Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Avro as an External Source in Dremio.
-
Visualize Live Couchbase Data in the Power BI Service
Use CData Connect AI to connect to live Couchbase data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with Freshservice Data in JReport Designer
Create charts and reports based on Freshservice data in JReport Designer.
-
How to Query Act-On Data in MySQL Workbench
Execute MySQL queries against live Act-On data from MySQL Workbench.
-
Connect to SFTP from Asprova with CData Software ODBC Driver for SFTP
This article shows how to connect faster to SFTP data from Asprova.
-
Integrate Open WebUI with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Power BI XMLA data from within the chat interface.
-
Explore Geographical Relationships in Blackbaud FE NXT Data with Power Map
Create data visualizations with Blackbaud FE NXT data in Power Map.
-
DataBind Charts to SingleStore Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SingleStore 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.
-
Publish Crystal Reports on FHIR Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FHIR data.
-
Replicate Google Translate Data from PowerShell
Write a quick PowerShell script to query Google Translate data. Use connectivity to the live data to replicate Google Translate data to SQL Server.
-
Build MVC Applications with Connectivity to Oracle Sales Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle Sales from an ASP.NET MVC application.
-
Create Phoenix-Connected Applications in Appsmith
Connect to Phoenix Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Phoenix data.
-
Build NetSuite SuiteAnalytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for NetSuite SuiteAnalytics Data and create custom apps in Bubble.
-
Use the CData Software ODBC Driver for Contentful in MicroStrategy Desktop
Connect to Contentful data in MicroStrategy Desktop using the CData Software ODBC Driver for Contentful.
-
Integrate Tickspot Data in Pentaho Data Integration
Build ETL pipelines based on Tickspot data in the Pentaho Data Integration tool.
-
Connect to Printful Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Printful data using standard SQL.
-
Access Live Aweber Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Aweber data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Query SAP Business Warehouse Data in MySQL Workbench
Execute MySQL queries against live SAP Business Warehouse data from MySQL Workbench.
-
Build MVC Applications with Connectivity to Dynamics CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics CRM from an ASP.NET MVC application.
-
Automated Continuous Airtable Replication to Snowflake
Use CData Sync for automated, continuous, customizable Airtable replication to Snowflake.
-
A PostgreSQL Interface for ADP Data using the CData ODBC Driver
Use the SQL Gateway and ADP ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Office 365 in MicroStrategy Desktop
Connect to Office 365 data in MicroStrategy Desktop using the CData Software ODBC Driver for Office 365.
-
Pushbullet Reporting in OBIEE with the Pushbullet JDBC Driver
Deploy the Pushbullet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Add Acumatica Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Acumatica with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous xBase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable xBase replication to Apache Cassandra.
-
Analyze Google Sheets Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Sheets data with the CData JDBC Driver for Google Sheets.
-
Connect to Parquet Data in Aqua Data Studio
Access Parquet data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect to Facebook Data in DBVisualizer
Integrate Facebook data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect Amazon QuickSight to Act-On Data
Create a connection to Act-On data in CData Connect AI and insert Act-On data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Helpscout Data in the Pentaho Report Designer
Publish reports based on Helpscout data in the Pentaho BI tool.
-
Integrate HBase Data into Power Automate Desktop using CData Connect
CData Connect for HBase Data enables you to integrate HBase data into workflows built using Microsoft Power Automate Desktop.
-
Integrate with OneNote Data in SnapLogic
Use CData Connect AI to connect to and integrate with live OneNote data in SnapLogic.
-
Integrating Teamgate Data in Talend Cloud Data Management Platform
Connect Teamgate Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Google Forms with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Forms with External Services.
-
Access Live Amazon Athena Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Amazon Athena data through MCP integration.
-
Connect to Sage 200 Data in RapidMiner
Integrate Sage 200 data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to import Teamwork Data into Apache Solr
Use the CData Software JDBC Driver for Teamwork in Data Import Handler and create an automated import of Teamwork data to Apache Solr Enterprise Search platform.
-
Create Cosmos DB-Connected Dashboards in Grafana
Connect to Cosmos DB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Cosmos DB data.
-
Integrate with live SAP Ariba Procurement Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Ariba Procurement data in Jitterbit.
-
Connect to Live BenchmarkEmail Data in PostGresSQL Interface through CData Connect AI
Create a live connection to BenchmarkEmail in CData Connect AI and connect to your BenchmarkEmail data from PostgreSQL.
-
Autopilot Reporting in OBIEE with the Autopilot JDBC Driver
Deploy the Autopilot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Link Campaigner with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Campaigner data in Filemaker Pro for Mac or Windows.
-
Automated Continuous Aircall Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Aircall replication to Google Cloud SQL.
-
Automated Continuous HCL Domino Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HCL Domino replication to IBM DB2.
-
How to Build an ETL App for Bitbucket Data in Python with CData
Create ETL applications and real-time data pipelines for Bitbucket data in Python with petl.