CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live NetSuite Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live NetSuite data without replication.
-
Publish Reports with SharePoint Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SharePoint data.
-
Natively Connect to ZohoInvoice Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoInvoice data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Clio in MicroStrategy
Connect to Clio data in MicroStrategy Developer using the CData Software JDBC Driver for Clio.
-
Integrate ZendeskSell Data in Pentaho Data Integration
Build ETL pipelines based on ZendeskSell data in the Pentaho Data Integration tool.
-
How to create an RPA flow for Aweber Data in UiPath Studio
Use the Aweber ODBC Driver to create workflows that access real-time Aweber data without any coding.
-
Automated Continuous ShipStation Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ShipStation replication to IBM DB2.
-
Use Claude to Talk to Your VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your VWO data for you.
-
Integrate Theia IDE with Live GraphQL 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 GraphQL data from within the development environment.
-
How to connect to LinkedIn Data in DBVisualizer
Integrate LinkedIn data with visual data analysis tools and data connection wizards in DBVisualizer
-
Bidirectional Access to Splunk Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Splunk data in Filemaker Pro for Mac or Windows.
-
Moving Data from GitLab to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live GitLab data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to & Open Zoho Projects Data in Microsoft Excel
This article uses the CData ODBC driver for Zoho Projects to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to Live BambooHR Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live BambooHR data securely in real time.
-
Provide OData Services of Strava Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Strava data by developing a WCF Service Application.
-
Build a PostgreSQL Interface for Google Spanner Data using the CData JDBC Driver
Use the Remoting features of the Google Spanner JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import Microsoft Entra ID Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft Entra ID in Data Import Handler and create an automated import of Microsoft Entra ID data to Apache Solr Enterprise Search platform.
-
Natively Connect to Google Spanner Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Spanner data. Leverage the native support for ODBC in PHP.
-
Integrate LibreChat with Live Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Bright Data data from within the chat interface.
-
How to Connect to Live Wave Financial Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Wave Financial data through natural language.
-
Connect to and Query Retently Data in QlikView over ODBC
Create data visualizations with Retently data in QlikView.
-
Connect to Gong Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Gong data.
-
Automate Amazon Athena Data Replication to Couchbase
Use CData Sync to Customize and automate Amazon Athena data replication to Couchbase.
-
Use Databricks Agent Bricks to Talk to Your Okta Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Okta data for you.
-
Consume TaxJar OData Feeds in SAP Lumira
Use the API Server to create data visualizations on TaxJar feeds that reflect any changes in SAP Lumira.
-
How to Connect to Live AlloyDB 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 AlloyDB data for you.
-
Getting Started with the CData Python Connector for Flowlu
Learn to install and license the CData Python Connector and configure a connection to live Flowlu data.
-
Moving Data from ServiceDesk Plus to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ServiceDesk Plus data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Workday Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Workday data with the CData JDBC Driver for Workday.
-
DataBind Charts to Invoiced Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Invoiced 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.
-
Access Live Google Cloud Storage Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Cloud Storage data from your Excel spreadsheets.
-
Build an OLAP Cube in SSAS from Google Ad Manager Data
Establish a connection to Google Ad Manager data data from SQL Server Analysis Services, and use the Google Ad Manager Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Dashboards and Visualize Live Optimizely Data in Geckoboard
Use CData Connect AI to connect to live Optimizely data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Query Live SAP SuccessFactors Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP SuccessFactors data data in natural language using Python.
-
Integrate Rebilly Data in Pentaho Data Integration
Build ETL pipelines based on Rebilly data in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with Oracle Eloqua Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Eloqua data.
-
Visualize Autopilot 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 Autopilot data into TIBCO Spotfire.
-
Integrate Cline with Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle Sales data from within your IDE.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Chargebee
Provide connectivity to Chargebee data through an SAP BusinessObjects universe.
-
Import Sugar CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Sugar CRM Data from Azure Data Factory and import live Sugar CRM data.
-
Automated Continuous Pinecone Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pinecone replication to delimited files (CSV/TSV).
-
Connect to LinkedIn Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LinkedIn data.
-
DataBind Charts to Email Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Email 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.
-
Getting Started with the CData JDBC Driver for REST
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for REST.
-
Integrate Hugging Face Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Hugging Face data from Informatica Cloud.
-
Build a Simple VCL Application for Snowflake Data
How to build a simple VCL Application to view Snowflake data in RAD Studio using the CData ODBC Driver for Snowflake.
-
Natively Connect to ConvertAPI Data in PHP
The CData ODBC driver for ConvertAPI enables you to create PHP applications with connectivity to ConvertAPI data. Leverage the native support for ODBC in PHP.
-
Integrate Google Calendar Data into Power Automate Desktop using CData Connect
CData Connect for Google Calendar Data enables you to integrate Google Calendar data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Moosend Data in RapidMiner
Integrate Moosend data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Query Oracle SCM Data in MySQL Workbench
Execute MySQL queries against live Oracle SCM data from MySQL Workbench.
-
Prepare, Blend, and Analyze PabblySubscriptions Data in Alteryx Designer (ODBC)
Build workflows to access live PabblySubscriptions data for self-service data analytics.
-
Connect to Redshift Data in NetBeans
Connect to Redshift data in NetBeans with the data source configuration wizard.
-
Integrating Codex with AlloyDB 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.
-
Process & Analyze OnePageCrm Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live OnePageCrm Data.
-
Publish Cvent-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Cvent data.
-
Connect to Discord Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Discord to connect to Discord data and execute queries in PowerBuilder.
-
Bridge Coinbase Connectivity with Apache NiFi
Access and process Coinbase data in Apache NiFi using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for Google Calendar on an SSRS Report Server
Connect to Google Calendar 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 Xero Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Xero data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Reply.io Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Reply.io replication to Apache Cassandra.
-
Integrate LinkedIn Data into Power Automate Desktop using CData Connect
CData Connect for LinkedIn Data enables you to integrate LinkedIn data into workflows built using Microsoft Power Automate Desktop.
-
Connect to and Query xBase Data in QlikView over ODBC
Create data visualizations with xBase data in QlikView.
-
Connect and Query Live Greenplum Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Greenplum data into Databricks and enable direct, live querying and analysis without replication.
-
Design BIRT Reports on Oracle Sales Data
Provide current Oracle Sales data to your embedded analytics.
-
Explore Geographical Relationships in Email Data with Power Map
Create data visualizations with Email data in Power Map.
-
Automate Quaderno Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Quaderno data from PowerShell? This article demonstrates how to utilize the Quaderno Cmdlets for tasks like connecting to Quaderno data, automating operations, downloading data, and more.
-
Use CData Connect AI to Access Asana Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Asana data in the Power Pivot business intelligence tool.
-
How to Connect to Live HubSpot Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your HubSpot data for you.
-
Use Microsoft Copilot Studio to talk to your Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft OneDrive data for you.
-
Use the CData Software JDBC Driver for LinkedIn in MicroStrategy
Connect to LinkedIn data in MicroStrategy Developer using the CData Software JDBC Driver for LinkedIn.
-
How to connect PolyBase to Amazon Athena
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon Athena data.
-
Analyze Bannerbear Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Bannerbear data and visualize Bannerbear data in SAP Analytics Cloud.
-
Query MailerSend Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MailerSend data from Node.js.
-
Connect to Azure DevOps Data in ACL Analytics
Connect to Azure DevOps data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure DevOps data.
-
Query Azure DevOps Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure DevOps entities in PHP by modeling them as objects.
-
Import and Visualize Autopilot Data in Power View
Create data visualizations based on Autopilot data in Excel.
-
Provide OData Services of Optimizely Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Optimizely data by developing a WCF Service Application.
-
Use JayDeBeApi to access Square Data in Python
Use standard Python scripting and the development environment of your choice to access live Square data.
-
ETL MarkLogic in Oracle Data Integrator
This article shows how to transfer MarkLogic data into a data warehouse using Oracle Data Integrator.
-
How to Access Live Google Ad Manager Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Ad Manager enables you to integrate Google Ad Manager data into workflows built using Microsoft Power Automate Desktop.
-
How to update eBay from Excel
This article explains how to transfer data from Excel to eBay using the Excel Add-In for eBay.
-
Build Dashboards with ChargeOver Data in Dundas BI
Create dynamic dashboards and perform analytics based on ChargeOver data in Dundas BI.
-
Integrate Theia IDE with Live YouTube Analytics 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 YouTube Analytics data from within the development environment.
-
Integrate Egnyte Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Egnyte data and integrate live Egnyte data into your Power Automate tasks.
-
ServiceNow Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ServiceNow facts in real time.
-
Build Apps with Live Everhour Data Using the Low-Code Development Platform of Mendix
Connect Everhour data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to ChartMogul Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ChartMogul and work with ChartMogul data in your FileMaker application.
-
Create SSAS Tabular Models from Google Contacts Data
How to build a SQL Server Analysis Service Tabular Model from Google Contacts data using CData drivers.
-
Build Oracle Service Cloud Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle Service Cloud data and build visualizations in Tableau Cloud.
-
Automated Continuous Bullhorn CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Azure SQL Database.
-
Easily Integrate Salesforce Data 360 Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce Data 360 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Gong Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Gong and the SQL Gateway to access Gong data from Google Apps Script.
-
Automated Continuous Front Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Front replication to Google BigQuery.
-
Getting Started with the CData JDBC Driver for NetSuite
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for NetSuite.
-
How to Query Live Highrise Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Highrise data data in natural language using Python.
-
Connect to Outreach.io Data in RazorSQL
Connect to Outreach.io from wizards and query Outreach.io data from the GUI in the RazorSQL database management tool.
-
Connect to Jira Assets Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Jira Assets data using standard SQL.
-
Use Manus AI to Talk to Your Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Blackbaud FE NXT data.
-
Process & Analyze Google Spanner Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Spanner Data.
-
Load Telegram Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Telegram data to a database.