CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Samanage Data Using the Low-Code Development Platform of Mendix
Connect Samanage data with Mendix to build apps using the CData API Driver for JDBC.
-
Create Apps from Google Analytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Analytics Data and build apps from live Google Analytics data in Qlik Sense Cloud.
-
Integrate with Microsoft Entra ID Data in JReport Designer
Create charts and reports based on Microsoft Entra ID data in JReport Designer.
-
Integrating LangChain with HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on HubSpot data within automated workflows.
-
How to Connect to Live XML 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 XML data for you.
-
Connect to Marketo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Marketo data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to Onfleet Data in DBVisualizer
Integrate Onfleet data with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze GetResponse Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of GetResponse data and visualize GetResponse data in SAP Analytics Cloud.
-
Connect to Airtable Data in HULFT Integrate
Connect to Airtable as a JDBC data source in HULFT Integrate
-
Access LinkedIn Ads Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LinkedIn Ads data from your Oracle system.
-
Connect to HDFS Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HDFS to connect to HDFS data and execute queries in PowerBuilder.
-
How to Build an ETL App for Perplexity Data in Python with CData
Create ETL applications and real-time data pipelines for Perplexity data in Python with petl.
-
Publish Crystal Reports on Acumatica Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Acumatica data.
-
Connect to Freshservice Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Freshservice data from Filemaker Pro on Mac.
-
Build Microsoft Dataverse-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Microsoft Dataverse Data from Zoho Analytics and import live Microsoft Dataverse data.
-
Access Live Freshteam Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Freshteam data from your Google Sheets.
-
How to Work with SAP HANA Data in ETL Validator JDBC
Connect to SAP HANA from ETL Validator jobs using the CData Software JDBC Driver.
-
LINQ to VWO 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 VWO Data Provider.
-
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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for AlloyDB
Provide connectivity to AlloyDB data through an SAP BusinessObjects universe.
-
Query FTP Data as a MySQL Database in Node.js
Execute MySQL queries against FTP data from Node.js.
-
How to Query Factorial Data in MySQL Workbench
Execute MySQL queries against live Factorial data from MySQL Workbench.
-
How to create an RPA flow for Mouseflow Data in UiPath Studio
Use the Mouseflow ODBC Driver to create workflows that access real-time Mouseflow data without any coding.
-
Rapidly Develop Microsoft Dataverse-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 Microsoft Dataverse.
-
Integrate Freshservice Data into Power Automate Desktop using CData Connect
CData Connect for Freshservice Data enables you to integrate Freshservice data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Real-Time Dynamics 365 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Dynamics 365 and Dataflow to import and use Dynamics 365 data in Power Apps.
-
Automated Continuous Reckon Accounts Hosted Replication to Snowflake
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Snowflake.
-
Build Pipelines with Live ServiceNow Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ServiceNow from Google Cloud Data Fusion, enabling the integration of live ServiceNow data into the building and management of effective data pipelines.
-
Import Real-Time JotForm Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use JotForm data in ColdFusion.
-
How to Easily Query Box Data in OpenOffice Base
Connect to Box data in OpenOffice Base using the CData ODBC Driver for Box and generate reports with live data insights.
-
Moving Data from Mixpanel to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mixpanel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous LDAP Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LDAP replication to Google BigQuery.
-
Visualize Authorize.Net Data in Sisense
Create an ElastiCube in Sisense app with access to Authorize.Net data.
-
Integrate Live JSON Services into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to JSON services and integrate live JSON services into apps built in Microsoft Power Apps.
-
Access Live Cassandra Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cassandra data from your Excel spreadsheets.
-
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.
-
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.
-
How to create Visio diagrams from Google Contacts Data
Automatically update Google Contacts data with the changes you make to Visio master shapes.
-
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.
-
Analyze Google Campaign Manager 360 Data in Looker
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Looker and build custom apps using live Google Campaign Manager 360 data.
-
Integrating Dataiku with Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Okta data.
-
Connect to SharePoint Data from HeidiSQL
Use CData Connect AI to connect to and query live SharePoint data from HeidiSQL.
-
How to Access Live Demio Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Demio enables you to integrate Demio data into workflows built using Microsoft Power Automate Desktop.
-
JSON Reporting in OBIEE with the JSON JDBC Driver
Deploy the JSON JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Power BI Reports on Real-Time Grafana Data
Use the CData ODBC Driver for Grafana to visualize Grafana data in Power BI Desktop.
-
How to integrate JSON with Apache Airflow
Access and process JSON services in Apache Airflow using the CData JDBC Driver.
-
ETL Outreach.io in Oracle Data Integrator
This article shows how to transfer Outreach.io data into a data warehouse using Oracle Data Integrator.
-
Create Data Visualizations Based On Gmail Data in Mode
Use CData Connect AI to connect to Gmail Data from Mode and build visualizations using live Gmail data.
-
Automated Continuous Front Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Front data replication to OneLake in Microsoft Fabric.
-
Integrate Cursor with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Impala data from within the editor.
-
Analyze BigCommerce Data in Looker
Use CData Connect AI to connect to BigCommerce Data from Looker and build custom apps using live BigCommerce data.
-
How to Connect Snapchat Ads 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 Snapchat Ads data in real time using natural language.
-
How to Connect to Live Adobe Target 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 Adobe Target data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Jodoo
Create Jodoo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Live Perplexity Data in the Power BI Service
Use CData Connect AI to connect to live Perplexity data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a Simple VCL Application for Quaderno Data
How to build a simple VCL Application to view Quaderno data in RAD Studio using the CData ODBC Driver for Quaderno.
-
Analyze BigQuery Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of BigQuery data and visualize BigQuery data in SAP Analytics Cloud.
-
Visualize EnterpriseDB Data in Sisense
Create an ElastiCube in Sisense app with access to EnterpriseDB data.
-
Connect to Xero Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Xero data in Airbyte.
-
Connect to Amazon Marketplace Data in RapidMiner
Integrate Amazon Marketplace data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create a Data Access Object for Xero Data using JDBI
A brief overview of creating a SQL Object API for Xero data in JDBI.
-
Back Up VWO data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with VWO data data.
-
Use Dash to Build to Web Apps on FTP Data
Create Python applications that use pandas and Dash to build FTP-connected web apps.
-
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.
-
Write a Simple Go Application to work with CircleCI Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to CircleCI data.
-
Connect Tally Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Tally data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Antigravity CLI with ActiveCampaign data via CData CLI
Connect ActiveCampaign data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate Multiple Notion Accounts
Replicate multiple Notion accounts to one or many databases.
-
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.
-
Trigger Splunk IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Splunk with standard wizards in Logic Apps.
-
Process & Analyze Zoho Books Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Books Data.
-
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.
-
Automated Continuous Quickbase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Quickbase replication to Google BigQuery.
-
DataBind Controls to Okta Data in Delphi
DataBind to Okta data in Delphi with standard data access components and controls.
-
Integrating Kiro with Twilio 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 OData Services in Google Apps Script via Connect AI
Use CData Connect AI to access OData services in Google Apps Script.
-
Query Live Square 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 Square data through a conversational interface.
-
Connect to LeadDesk Data in JRuby
Create a simple JRuby app with access to live LeadDesk data.
-
How to Connect to Live Grafana 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 Grafana data for you.
-
Natively Connect to Azure Synapse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Synapse data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP SuccessFactors LMS.
-
Object-Relational Mapping (ORM) with Monday.com Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Monday.com data into a Java-based ORM framework, Hibernate.
-
View Reports on Real-Time Exact Online Data in Power BI Report Server
Use the CData ODBC Driver for Exact Online to visualize Exact Online data in Power BI Desktop and then publish them to Power BI Report Server.
-
Design BIRT Reports on Dynamics 365 Data
Provide current Dynamics 365 data to your embedded analytics.
-
Integrate Zoom Data in Pentaho Data Integration
Build ETL pipelines based on Zoom data in the Pentaho Data Integration tool.
-
Build Monday.com-Connected Apps in Choreo
Use CData Connect AI to connect to Monday.com Data from Choreo and build custom apps using live Monday.com data.
-
How to integrate Metabase with Square Data
Use CData Connect AI to connect to live Square data and create an interactive dashboard in Metabase from Square data.
-
Rapidly Develop Instagram-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 Instagram.
-
Seamlessly Bring SQL Analysis Services Data into Retool Using CData Connect AI
Integrate SQL Analysis Services data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
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.
-
How to Connect to Sybase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sybase data. Leverage the pyodbc module for ODBC in Python.
-
Build Jira-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Jira data and build web apps with connectivity to live Jira data.
-
Integrate Cline with Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live iContact data from within your IDE.
-
Automated Continuous Grafana Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Grafana data replication to OneLake in Microsoft Fabric.
-
Natively Connect to Tavily Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Tavily data. Leverage the native support for ODBC in PHP.
-
Excel Spreadsheet Automation on Confluence Data with the QUERY Formula
Pull data from Confluence, automate spreadsheets, and more with the QUERY formula.
-
How to create an RPA flow for Twilio Data in UiPath Studio
Use the Twilio ODBC Driver to create workflows that access real-time Twilio data without any coding.
-
How to connect Amazon QuickSight to Google Spanner Data
Create a connection to Google Spanner data in CData Connect AI and insert Google Spanner data into Amazon QuickSight SPICE to build interactive dashboards.
-
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.
-
Build a PostgreSQL Interface for Coinbase Data using the CData JDBC Driver
Use the Remoting features of the Coinbase JDBC Driver to create a PostgreSQL entry-point for data access.