CData Software - Knowledge Base
Recent Articles
-
Integrate with Live Azure Synapse Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Synapse from the MuleSoft Anypoint Platform to integrate live Azure Synapse into custom reports and dashboards.
-
How to Visualize BenchmarkEmail Data in Python with pandas
Use pandas and other modules to analyze and visualize live BenchmarkEmail in Python.
-
Analyze Google Translate Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Translate and visualize live Google Translate in Infragistics Reveal.
-
Getting Started with the CData JDBC Driver for LDAP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LDAP.
-
How to connect to Google Calendar Data from Spring Boot
Connect to Google Calendar in a Spring Boot Application using the CData JDBC Driver for Google Calendars
-
Connect to Oracle Financials Cloud Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Financials Cloud and the Script function in FileMaker Pro to connect to Oracle Financials Cloud and work with Oracle Financials Cloud in your FileMaker application.
-
Analyze Vault CRM Data in Looker
Use CData Connect AI to connect to Vault CRM Data from Looker and build custom apps using live Veeva Vault & Vault CRM.
-
How to connect SharePoint with Oracle Eloqua Data through external lists
Provide Oracle Eloqua to SharePoint users as an external list.
-
Integrate Cursor with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MYOB AccountRight from within the editor.
-
Consume SAP BusinessObjects BI OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP BusinessObjects BI feeds that reflect any changes in SAP Lumira.
-
Use the CData Software ODBC Driver for Outreach.io in MicroStrategy Web
Connect to Outreach.io in MicroStrategy Web using the CData Software ODBC Driver for Outreach.io.
-
Bind Live Simplesat Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Simplesat data
-
Quick Setup Guide for CData HubSpot Drivers
Easy guide for using CData HubSpot Drivers and Connectors for the first time.
-
Visualize Stripe 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 Stripe into TIBCO Spotfire.
-
Automated Continuous Azure DevOps Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure DevOps replication to SingleStore.
-
Connect to Postmark from Asprova with CData Software ODBC Driver for Postmark
This article shows how to connect faster to Postmark data from Asprova.
-
How to Create Power BI Visual Reports with Real-Time ZohoPeople Data
Use CData Power BI Connectors to visualize ZohoPeople in Power BI.
-
Query ShipEngine Data as a MySQL Database in Node.js
Execute MySQL queries against ShipEngine from Node.js.
-
Automated Continuous Humanity Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Humanity replication to Google BigQuery.
-
Use CData Connect AI to Access Google Analytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Analytics in the Power Pivot business intelligence tool.
-
Easily Integrate Amazon DynamoDB Data in Lazarus Pascal IDE
Learn how to easily integrate live Amazon DynamoDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Microsoft Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Ads in FileMaker Pro to connect to Microsoft Ads and work with Microsoft Ads in your FileMaker applications.
-
DataBind Controls to Google Campaign Manager 360 Data in Delphi
DataBind to Google Campaign Manager 360 in Delphi with standard data access components and controls.
-
How to connect and process Adobe Analytics from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Analytics.
-
Analyze Jira Assets Data in Looker
Use CData Connect AI to connect to Jira Assets Data from Looker and build custom apps using live Jira Assets.
-
Connect to GitLab Data in Jaspersoft Studio
Execute SQL to remote GitLab in Jaspersoft Studio.
-
How to Build an ETL App for Confluence Data in Python with CData
Create ETL applications and real-time data pipelines for Atlassian Confluence in Python with petl.
-
Integrate Acumatica Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Acumatica ERP and integrate live Acumatica ERP into your Power Automate tasks.
-
Design BIRT Reports on SAS xpt Data
Provide current SAS XPORT to your embedded analytics.
-
Connect to Smartsheet Data in DBeaver
Use the CData ODBC Driver to connect to Smartsheet in DBeaver.
-
Replicate Multiple Jira Accounts via the CData Sync CLI
Replicate multiple Jira accounts to one or many databases.
-
How to integrate VWO with Apache Airflow
Access and process VWO in Apache Airflow using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Wistia
Provide connectivity to Wistia through an SAP BusinessObjects universe.
-
How to Seamlessly Import ConstantContact Data into IBM SPSS Modeler
Integrate ConstantContact data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Stream Attio Data into Apache Kafka Topics
Access and stream Attio in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Invoiced Replication to Snowflake
Use CData Sync for automated, continuous, customizable Invoiced replication to Snowflake.
-
Integrate PabblySubscriptions Data in the Pentaho Report Designer
Publish reports based on PabblySubscriptions in the Pentaho BI tool.
-
Connecting Agentforce with Active Directory 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 Active Directory for you.
-
Connect to Aha! Data in Aqua Data Studio
Access Aha! from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
ETL Autopilot in Oracle Data Integrator
This article shows how to transfer Autopilot into a data warehouse using Oracle Data Integrator.
-
Import Real-Time Quickbase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Quickbase in ColdFusion.
-
Use the CData Software ODBC Driver for Oracle Service Cloud in MicroStrategy Web
Connect to Oracle Service Cloud in MicroStrategy Web using the CData Software ODBC Driver for Oracle Service Cloud.
-
How to Connect to Live Certinia Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Certinia for you.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SparkPost to Power BI dashboards. Simply drag and drop SparkPost into data visuals on the Power BI canvas.
-
Create Blackbaud FE NXT-Connected Dashboards in Grafana
Connect to Blackbaud FE NXT Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Blackbaud FE NXT.
-
Build Dashboards with SFTP Data in DBxtra
Create dynamic dashboards and perform analytics based on SFTP in DBxtra.
-
Create Dynamic MySQL Grids Using the Infragistics XamDataGrid
Learn how you can connect MySQL to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Box Data in Alteryx Designer (Connect AI)
Build workflows to access live Box for self-service data analytics.
-
Easily Integrate Coda Data in Lazarus Pascal IDE
Learn how to easily integrate live Coda in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
ETL Slack in Oracle Data Integrator
This article shows how to transfer Slack into a data warehouse using Oracle Data Integrator.
-
Analyze SpaceX Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SpaceX and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Query HubSpot Data as a MySQL Database in Node.js
Execute MySQL queries against HubSpot from Node.js.
-
Automated Continuous GitHub Replication to Vertica
Use CData Sync for automated, continuous, customizable GitHub replication to Vertica.
-
Access Mailgun Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Mailgun.
-
LINQ to Beeminder 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 Beeminder Data Provider.
-
Create Dynamic GitHub Grids Using the Infragistics XamDataGrid
Learn how you can connect GitHub to Infragistics XamDataGrid to build dynamic grids.
-
How to Work with MailerSend Data in ETL Validator JDBC
Connect to MailerSend from ETL Validator jobs using the CData Software JDBC Driver.
-
Build an OLAP Cube in SSAS from Instagram Data
Establish a connection to Instagram data from SQL Server Analysis Services, and use the Instagram Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to use SQLAlchemy ORM to access Reckon Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Reckon.
-
Create Reports with Postmark Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Postmark.
-
Integrate Autopilot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Autopilot with External Services.
-
Visualize Live SharePoint Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft SharePoint and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData JDBC Driver for FormSite
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FormSite.
-
Access Productboard Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Productboard from your Oracle system.
-
Automated Continuous GraphQL Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GraphQL replication to Google Cloud SQL.
-
Integrating Cursor CLI with Copper 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.
-
Publish Reports with SAP Ariba Source Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Source.
-
Automated Continuous Kintone Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Kintone replication to delimited files (CSV/TSV).
-
Import Microsoft Planner Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Planner. In this article, you will use the OData format to import Microsoft Planner into Microsoft Power Query.
-
Access Live Cosmos DB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Cosmos DB from your Excel spreadsheets.
-
Connect to Stripe Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Stripe and the SQL Gateway to access Stripe from Google Apps Script.
-
Integrate with Sage Cloud Accounting Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage Business Cloud Accounting in SnapLogic.
-
Connect to Grafana Data in CloverDX (formerly CloverETL)
Transfer Grafana using the visual workflow in the CloverDX data integration tool.
-
Visualize Azure Analysis Services 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 Azure Analysis Services into TIBCO Spotfire.
-
Connecting Mastra with SAS Data Sets Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAS Data Sets, no replication required.
-
Creating Basecamp-Connected Applications in Unqork
You can use CData Connect AI to feed Basecamp to Unqork and build custom business apps.
-
Choosing the Best Method to Connect Sugar CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sugar CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Feed SAP SuccessFactors Data into FineReport
How to set SAP SuccessFactors as a JDBC data source in FineReport.
-
Create Power BI Reports on Real-Time Quaderno Data
Use the CData ODBC Driver for Quaderno to visualize Quaderno in Power BI Desktop.
-
Build MailerSend-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MailerSend and build web apps with connectivity to live MailerSend.
-
Replicate Multiple BenchmarkEmail Accounts
Replicate multiple BenchmarkEmail accounts to one or many databases.
-
Bind Live GitLab Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live GitLab data
-
Create Landbot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Landbot data access from reports, embedded analytics, and more.
-
Use Azure AI Foundry to Talk to Your Trello 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 Trello for you.
-
Migrating data from PagerDuty to Google BigQuery using CData SSIS Components.
Easily push PagerDuty to Google BigQuery using the CData SSIS Tasks for PagerDuty and Google BigQuery.
-
Connect to Oracle Financials Cloud Data in Aqua Data Studio
Access Oracle Financials Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Tally Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Tally replication to Apache Kafka.
-
Explore Geographical Relationships in Zoho Creator Data with Power Map
Create data visualizations with Zoho Creator in Power Map.
-
Integrating Cursor CLI with Splunk 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.
-
Query Live Couchbase Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Couchbase directly from the development environment.
-
Use Dash to Build to Web Apps on OnePageCrm Data
Create Python applications that use pandas and Dash to build OnePageCrm-connected web apps.
-
Seamlessly Bring Google Campaign Manager 360 Data into Retool Using CData Connect AI
Integrate Google Campaign Manager 360 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect Hubstaff Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Hubstaff using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Theia IDE with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Google Cloud Storage-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Cloud Storage to explore live Google Cloud Storage Data in Claude Code to assist with building Google Cloud Storage-powered applications.
-
Build Automated Box-Connected Workflows in Zapier
Use CData Connect AI to connect to live Box and build automated workflows in Zapier.
-
How to import Zoho Inventory Data into Apache Solr
Use the CData Software JDBC Driver for Zoho Inventory in Data Import Handler and create an automated import of Zoho Inventory to Apache Solr Enterprise Search platform.
-
Integrate Real-Time Access to Facebook in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Facebook in real time.
-
Analyze NetSuite SuiteAnalytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of NetSuite SuiteAnalytics and visualize live NetSuite SuiteAnalytics in Infragistics Reveal.
-
Access Live Stripe Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Stripe from your Excel spreadsheets.