CData Software - Knowledge Base
Recent Articles
-
Build SAS Data Sets-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAS Data Sets Data and create custom apps in Bubble.
-
Integrate eBay Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to eBay and integrate live eBay into your Power Automate tasks.
-
Working with Beeminder Data in LINQPad
Execute LINQ queries to Beeminder in LINQPad.
-
Visualize SAP HANA XS Advanced Data in TIBCO Spotfire through ADO.NET
Integrate SAP HANA XS Advanced into dashboards in TIBCO Spotfire.
-
Connect to Todoist Data in Aqua Data Studio
Access Todoist from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Live NetSuite Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live NetSuite CRM & ERP into custom reports in Power BI.
-
Create CloudConvert Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CloudConvert from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Freshdesk Data in RazorSQL
Connect to Freshdesk from wizards and query Freshdesk from the GUI in the RazorSQL database management tool.
-
Connect to Active Directory Data from a Connection Pool in JBoss
Integrate Active Directory into Java servlets: Use the Management Console in JBoss to install the Active Directory JDBC Driver.
-
Easily Integrate ZarMoney Data in Lazarus Pascal IDE
Learn how to easily integrate live ZarMoney in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Google Contacts with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Contacts with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Contacts.
-
Extend Google Sheets with Couchbase Data
Make calls to Couchbase from Google Apps Script via the API Server.
-
DataBind Charts to Microsoft Exchange Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Exchange 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.
-
Rapidly Develop ZarMoney-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 ZarMoney.
-
Integrate Twilio Data in the Pentaho Report Designer
Publish reports based on Twilio in the Pentaho BI tool.
-
Build Apps with Live Facebook Data Using the Low-Code Development Platform of Mendix
Connect Facebook with Mendix to build apps using the CData JDBC Driver for Facebook.
-
Use JayDeBeApi to access Yelp Data in Python
Use standard Python scripting and the development environment of your choice to access live Yelp.
-
DataBind Charts to Sybase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sybase 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.
-
Connect and Visualize Live Azure DevOps Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure DevOps into the Databricks platform and create visualization dashboards with real-time Azure DevOps.
-
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.
-
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 CLI with SendInBlue 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.
-
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.
-
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 Apache Phoenix 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 and execute queries in the Squirrel SQL Client.
-
Connect to Cloudflare Data in Jaspersoft Studio
Execute SQL to remote Cloudflare in Jaspersoft Studio.
-
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 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 Atlassian Jira 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 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 ERP/NetWeaver in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData ADO.NET Provider for Drift
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
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.
-
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.
-
Access Okta Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Okta 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 in Dundas BI.
-
Integrate Live EnterpriseDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Replicate Zoho Inventory Data from PowerShell
Write a quick PowerShell script to query Zoho Inventory. Use connectivity to the live data to replicate Zoho Inventory to SQL Server.
-
Model, Search, and Visualize Live Office 365 Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Office 365 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.
-
Connect to Google Analytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Analytics from Crystal Reports.
-
DataBind Controls to LeadDesk Data in Delphi
DataBind to LeadDesk 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.
-
Build Stripe-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Stripe to explore live Stripe Data in Gemini Code Assist to assist with building Stripe-powered applications.
-
Connect to HubDB Data in JRuby
Create a simple JRuby app with access to live HubDB.
-
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 Microsoft Office 365 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 to Apache Solr Enterprise Search platform.
-
Visualize JDBC-ODBC Bridge Data in Sisense
Create an ElastiCube in Sisense app with access to JDBC-ODBC Bridge.
-
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 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.
-
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 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 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.
-
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 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 in JReport Designer.
-
How to Query Act-On Data in MySQL Workbench
Execute MySQL queries against live Act-On 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 from within the chat interface.
-
Explore Geographical Relationships in Blackbaud FE NXT Data with Power Map
Create data visualizations with Blackbaud FE NXT in Power Map.
-
DataBind Charts to SingleStore Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SingleStore 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.
-
Replicate Google Translate Data from PowerShell
Write a quick PowerShell script to query Google Translate. Use connectivity to the live data to replicate Google Translate 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 Apache Phoenix.
-
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 in MicroStrategy Desktop using the CData Software ODBC Driver for Contentful.
-
Integrate Tickspot Data in Pentaho Data Integration
Build ETL pipelines based on Tickspot 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 using standard SQL.
-
How to Query SAP Business Warehouse Data in MySQL Workbench
Execute MySQL queries against live SAP Business Warehouse 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 Microsoft Office 365 in MicroStrategy Desktop using the CData Software ODBC Driver for Office 365.
-
Automate MarkLogic Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live MarkLogic and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
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 with the CData JDBC Driver for Google Sheets.
-
Connect to Parquet Data in Aqua Data Studio
Access Apache Parquet 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 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 in CData Connect AI and insert Act-On into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Query Live HDFS Data in Perplexity MacOS Desktop
Connect to and query live HDFS Data in Perplexity Desktop using CData MCP Server.
-
Integrate Helpscout Data in the Pentaho Report Designer
Publish reports based on Helpscout in the Pentaho BI tool.
-
Integrate HBase Data into Power Automate Desktop using CData Connect
CData Connect for HBase Data enables you to integrate Apache HBase into workflows built using Microsoft Power Automate Desktop.