CData Software - Knowledge Base
Recent Articles
-
Integrate Bright Data with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bright Data with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bright Data data.
-
How to Connect to Live CSV Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your CSV data for you.
-
Choosing the Best Method to Connect SAS xpt to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAS xpt data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Seamlessly Bring Zoho Books Data into Retool Using CData Connect AI
Integrate Zoho Books data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Live Kintone 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 Kintone data for you.
-
Create Data Visualizations Based On Kintone Data in Mode
Use CData Connect AI to connect to Kintone Data from Mode and build visualizations using live Kintone data.
-
Getting Started with the CData Excel Add-In for ConstantContact
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ConstantContact.
-
Create NASA Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time NASA data access from reports, embedded analytics, and more.
-
Bind Live Pipedrive Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Pipedrive data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build Apps with Live YouTube Analytics data in Adalo using CData Connect AI
Use CData Connect AI to integrate live YouTube Analytics data into the Adalo platform and build custom mobile and web applications with real-time YouTube Analytics data.
-
A PostgreSQL Interface for SAP Business Warehouse Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Business Warehouse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with Power BI XMLA Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Power BI XMLA data.
-
Visualize LaunchDarkly Data in Sisense
Create an ElastiCube in Sisense app with access to LaunchDarkly data.
-
Use the CData ODBC Driver for Monday.com in Microsoft Power Query
You can use the CData Monday.com ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Monday.com data into Microsoft Power Query.
-
Consume Oracle Eloqua OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Eloqua data as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous LDAP Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LDAP replication to Google BigQuery.
-
Connecting Moonlit Workflow with Impala 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 Impala data in real time.
-
How to integrate Keap with Apache Airflow
Access and process Keap data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Office 365 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Office 365 replication to MongoDB.
-
Rapidly Develop Opsgenie-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 Opsgenie.
-
Query Azure Data Lake Storage Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure Data Lake Storage entities in PHP by modeling them as objects.
-
Viewing Freshsales Data in RAD Studio Data Explorer
How to view Freshsales data in RAD Studio Data Explorer using the CData ODBC Driver for Freshsales.
-
How to Connect to Live Reckon Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Reckon data securely in real time.
-
Integrate OpenCode with Live Dynamics NAV Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Dynamics NAV data from within your AI coding agent.
-
Connect and Query Live Microsoft Planner Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Planner data into Databricks and enable direct, live querying and analysis without replication.
-
Build a PostgreSQL Interface for Chargebee Data using the CData JDBC Driver
Use the Remoting features of the Chargebee JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LlamaIndex with SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAS Data Sets data in real time.
-
Natively Connect to Bannerbear Data in PHP
The CData ODBC driver for Bannerbear enables you to create PHP applications with connectivity to Bannerbear data. Leverage the native support for ODBC in PHP.
-
Create SAP SuccessFactors LMS-Connected Business Apps in AppSheet
Connect to SAP SuccessFactors LMS Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP SuccessFactors LMS data.
-
Design BIRT Reports on PingOne Data
Provide current PingOne data to your embedded analytics.
-
Choosing the Best Method to Connect Oracle Eloqua Reporting to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Eloqua Reporting data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Gong Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gong data from your Excel spreadsheets.
-
Automated Continuous Templated Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Templated replication to Apache Cassandra.
-
Migrating data from Salesforce Data 360 to Google BigQuery using CData SSIS Components.
Easily push Salesforce Data 360 data to Google BigQuery using the CData SSIS Tasks for Salesforce Data 360 and Google BigQuery.
-
Access Live Mocean Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mocean data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
ETL Outreach.io in Oracle Data Integrator
This article shows how to transfer Outreach.io data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Highrise Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Highrise replication to IBM DB2.
-
Use JayDeBeApi to access Tanda Data in Python
Use standard Python scripting and the development environment of your choice to access live Tanda data.
-
Create Office 365-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Office 365 Data from Klipfolio and build custom visualizations using live Office 365 data.
-
Create Notion-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Notion Data from OutSystems and build custom enterprise apps using live Notion data.
-
Access Live AgileCRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live AgileCRM data from your Excel spreadsheets.
-
Create Informatica Mappings From/To a JDBC Data Source for Avaza
Create Avaza data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Zoom Data Using Azure Data Factory
Use CData Connect AI to connect to Zoom Data from Azure Data Factory and import live Zoom data.
-
Integrate Google's Antigravity Agent with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Freshdesk data using the Model Context Protocol.
-
Create SSAS Tabular Models from YouTube Analytics Data
How to build a SQL Server Analysis Service Tabular Model from YouTube Analytics data using CData drivers.
-
Integrate Theia IDE with Live Google Drive 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 Google Drive data from within the development environment.
-
Integrate SAP Ariba Procurement Data in Pentaho Data Integration
Build ETL pipelines based on SAP Ariba Procurement data in the Pentaho Data Integration tool.
-
Connect to Wave Financial Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Wave Financial Data and connect to Wave Financial data in Akorbi Digital RunMyProcess.
-
Connect to Calendly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Calendly and the SQL Gateway to access Calendly data from Google Apps Script.
-
Choosing the Best Method to Connect ShipEngine to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ShipEngine data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Load SAP Business One Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Business One data to a database.
-
Use the CData Software JDBC Driver for SurveyMonkey in MicroStrategy Web
Connect to SurveyMonkey data in MicroStrategy Web using the CData Software JDBC Driver for SurveyMonkey.
-
How to Work with Hive Data in ETL Validator JDBC
Connect to Hive from ETL Validator jobs using the CData Software JDBC Driver.
-
How to publish and share Mocean Data dashboards with Tableau Server
The CData ODBC driver for Mocean enables you integrate Mocean data into Tableau dashboards.
-
How to connect Amazon QuickSight to Acumatica Data
Create a connection to Acumatica data in CData Connect AI and insert Acumatica data into Amazon QuickSight SPICE to build interactive dashboards.
-
Analyze Hive Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Hive data in Microsoft R Open.
-
Integrate Theia IDE with Live Sybase 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 Sybase data from within the development environment.
-
Create Reports with Freshservice Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshservice data.
-
Automate Onfleet Data Replication to Azure Synapse
Use CData Sync to customize and automate Onfleet data replication to Azure Synapse.
-
Query Live Pinterest Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Pinterest data through a conversational interface.
-
Provide OData Services of iContact Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for iContact data by developing a WCF Service Application.
-
Connect to FHIR Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FHIR data using standard SQL.
-
Automated Continuous SAP Hybris C4C Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Snowflake.
-
How to Use a Microsoft Access Database to Update Presto Data in Real Time
Update Presto data by creating a linked table in Microsoft Access with the CData Presto ODBC Driver.
-
Explore Geographical Relationships in Scrapfly Data with Power Map
Create data visualizations with Scrapfly data in Power Map.
-
Connect and Visualize Live Acumatica Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Acumatica data into the Databricks platform and create visualization dashboards with real-time Acumatica data.
-
Build Dashboards with Excel Online Data in Dundas BI
Create dynamic dashboards and perform analytics based on Excel Online data in Dundas BI.
-
Use Azure AI Foundry to Talk to Your Smartsheet 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 Smartsheet data for you.
-
Access Live Copper Data in AWS Lambda
Connect to live Copper data in AWS Lambda using the CData JDBC Driver.
-
Integrate Live MailChimp 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 MailChimp data from within the IDE.
-
Connect to SAP Data from a Connection Pool in JBoss
Integrate SAP data into Java servlets: Use the Management Console in JBoss to install the SAP JDBC Driver.
-
Extract, Transform, and Load Everhour Data in Informatica PowerCenter
Create a simple Workflow for Everhour data in Informatica PowerCenter.
-
Visualize Sentry Data in TIBCO Spotfire through ADO.NET
Integrate Sentry data into dashboards in TIBCO Spotfire.
-
Build Dashboards with SuiteCRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on SuiteCRM data in Dundas BI.
-
Build Pipelines with Live Airtable Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Airtable from Google Cloud Data Fusion, enabling the integration of live Airtable data into the building and management of effective data pipelines.
-
Connect to OData Services in Google Apps Script via Connect AI
Use CData Connect AI to access OData services in Google Apps Script.
-
Analyze Live TaxJar Data in SAS Viya
Use CData Connect AI to connect to TaxJar data from SAS Viya and deploy self-service analytics using live TaxJar data.
-
Configure the CData JDBC Driver for LDAP in a Connection Pool in Tomcat
Connect to LDAP objects from a connection pool in Tomcat.
-
Automated Continuous QuickBooks Time Replication to AlloyDB
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to AlloyDB.
-
Import Authorize.Net Data Using Azure Data Factory
Use CData Connect AI to connect to Authorize.Net Data from Azure Data Factory and import live Authorize.Net data.
-
Choosing the Best Method to Connect MarkLogic to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MarkLogic data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Zendesk Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zendesk to connect to Zendesk data and execute queries in PowerBuilder.
-
Build MVC Applications with Connectivity to Notion Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Notion from an ASP.NET MVC application.
-
View Reports on Real-Time Stripe Data in Power BI Report Server
Use the CData ODBC Driver for Stripe to visualize Stripe data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Google's Vertex AI Agent with Live GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live GetResponse data within intelligent workflows.
-
Deploy the ADO.NET Provider for Jira Assets on an SSRS Report Server
Connect to Jira Assets 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.
-
Connect to Avro Data in Jaspersoft Studio
Execute SQL to remote Avro data in Jaspersoft Studio.
-
Connect to Elasticsearch Data from PowerBuilder via JDBC
This article demonstrates how to access Elasticsearch data from PowerBuilder using the Elasticsearch JDBC Driver.
-
Import Epicor Kinetic Data Using Azure Data Factory
Use CData Connect AI to connect to Epicor Kinetic Data from Azure Data Factory and import live Epicor Kinetic data.
-
How to create an RPA flow for Exa Data in UiPath Studio
Use the Exa ODBC Driver to create workflows that access real-time Exa data without any coding.
-
Analyze Factorial Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Factorial from Power Pivot. You will use the Table Import Wizard to load Factorial data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData ODBC Driver for Float in Microsoft Power Query
You can use the CData Float ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Float data into Microsoft Power Query.
-
Trigger Google Spanner IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Spanner with standard wizards in Logic Apps.
-
Build a Simple VCL Application for Printful Data
How to build a simple VCL Application to view Printful data in RAD Studio using the CData ODBC Driver for Printful.
-
Wave Financial Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Wave Financial data through CData Connect AI using different applications and tools.
-
Connect to Grafana Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Grafana to connect to Grafana data and execute queries in PowerBuilder.
-
Excel Spreadsheet Automation on Confluence Data with the QUERY Formula
Pull data from Confluence, automate spreadsheets, and more with the QUERY formula.
-
View Reports on Real-Time HCL Domino Data in Power BI Report Server
Use the CData ODBC Driver for HCL Domino to visualize HCL Domino data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Reports from GetResponse Data in Looker Studio
Use CData Connect AI to gain access to live GetResponse data and create custom reports in Looker Studio.
-
Connect to Databricks from Asprova with CData Software ODBC Driver for Databricks
This article shows how to connect faster to Databricks data from Asprova.