CData Software - Knowledge Base
Recent Articles
-
Build Agents in Relevance AI with Access to Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure DevOps data within intelligent agent workflows.
-
Build Azure Data Lake Storage-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Azure Data Lake Storage Data and create custom apps in Mendix.
-
Connect to Contentful Data from PowerBuilder via JDBC
This article demonstrates how to access Contentful data from PowerBuilder using the Contentful JDBC Driver.
-
Create Data Visualizations Based On Pinterest Data in Mode
Use CData Connect AI to connect to Pinterest Data from Mode and build visualizations using live Pinterest data.
-
Automate Wrike Data Replication to Azure Data Lake
Use CData Sync to customize and automate Wrike data replication to Azure Data Lake.
-
Natively Connect to Mistral AI Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mistral AI data. Leverage the native support for ODBC in PHP.
-
Integrating Cursor with Webex 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.
-
How to publish and share Qualaroo Data dashboards with Tableau Server
The CData ODBC driver for Qualaroo enables you integrate Qualaroo data into Tableau dashboards.
-
Use Dash to Build to Web Apps on Lakebase Data
Create Python applications that use pandas and Dash to build Lakebase-connected web apps.
-
How to import Telegram Data into Apache Solr
Use the CData Software JDBC Driver for Telegram in Data Import Handler and create an automated import of Telegram data to Apache Solr Enterprise Search platform.
-
Configure the CData JDBC Driver for Klipfolio in a Connection Pool in Tomcat
Connect to Klipfolio data from a connection pool in Tomcat.
-
Access Live Google Drive Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Drive data from your Excel spreadsheets.
-
What You Need to Know to Migrate from Shopify REST APIs to GraphQL APIs
What is Shopify GraphQL and how to use GraphQL schema
-
How to Visualize SAP Ariba Source Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP Ariba Source data in Python.
-
Access Reckon Data from MySQL in PHP
Connect to Reckon through the standard MySQL libraries in PHP.
-
Integrating GitHub Copilot with Coda 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.
-
Automated Continuous Codat Replication to Databricks
Use CData Sync for automated, continuous, customizable Codat replication to Databricks.
-
Create Microsoft Teams-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Microsoft Teams Data from OutSystems and build custom enterprise apps using live Microsoft Teams data.
-
Build HDFS-Connected Apps in Choreo
Use CData Connect AI to connect to HDFS Data from Choreo and build custom apps using live HDFS data.
-
Build Voice Agents in ElevenLabs with access to Live Tavily Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Tavily data.
-
How to create an RPA flow for Google Cloud Storage Data in UiPath Studio
Use the Google Cloud Storage ODBC Driver to create workflows that access real-time Google Cloud Storage data without any coding.
-
How to create MailerSend federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MailerSend data in MySQL .
-
Integrating OpenCode with Spark 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.
-
Automated Continuous Authorize.Net Replication to Vertica
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Vertica.
-
Visualize Shortcut Data in Sisense
Create an ElastiCube in Sisense app with access to Shortcut data.
-
Automated Continuous LeadDesk Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LeadDesk replication to IBM DB2.
-
Feed Foursquare Data into FineReport
How to set Foursquare data as a JDBC data source in FineReport.
-
Connect to Act-On Data in Ruby
Connect to Act-On data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Cloudant Data Replication to SAP HANA
Use CData Sync to customize and automate Cloudant data replication to SAP HANA.
-
Automate Notion Data Replication to Couchbase
Use CData Sync to Customize and automate Notion data replication to Couchbase.
-
How to Create Power BI Visual Reports with Real-Time SFTP Data
Use CData Power BI Connectors to visualize SFTP data in Power BI.
-
Query Live Salesforce Data 360 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 Salesforce Data 360 data directly from the development environment.
-
Connect to Real-Time SAP SuccessFactors LMS Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP SuccessFactors LMS and Dataflow to import and use SAP SuccessFactors LMS data in Power Apps.
-
Natively Connect to Azure Data Lake Storage Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Data Lake Storage data. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for OpenWeatherMap from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for OpenWeatherMap to connect to OpenWeatherMap data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring OpenWeatherMap data in Excel.
-
Build an OLAP Cube in SSAS from Oracle Data
Establish a connection to Oracle data data from SQL Server Analysis Services, and use the Oracle Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to SendGrid Data in RazorSQL
Connect to SendGrid from wizards and query SendGrid data from the GUI in the RazorSQL database management tool.
-
Migrating data from Dropbox to Databricks using CData SSIS Components.
Easily push Dropbox data to Databricks using the CData SSIS Tasks for Dropbox and Databricks.
-
How to create Google Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Analytics data in MySQL .
-
View Reports on Real-Time FormSite Data in Power BI Report Server
Use the CData ODBC Driver for FormSite to visualize FormSite data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build AI/ML Models with Live AdRoll Data using Dataiku
Connect AdRoll Data with Dataiku using the CData API Driver for JDBC.
-
Seamlessly Bring Greenhouse Data into Retool Using CData Connect AI
Integrate Greenhouse data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect BambooHR to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live BambooHR data using the CData Python MCP Server.
-
Rapidly Develop Google Forms-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 Google Forms.
-
Integrate Open WebUI with Live Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Data Catalog data from within the chat interface.
-
Replicate Ontraport Data to Multiple Databases via the CData Sync CLI
Replicate Ontraport data to disparate databases with a single configuration.
-
How to connect Amazon QuickSight to RSS Feeds
Create a connection to RSS feeds in CData Connect AI and insert RSS feeds into Amazon QuickSight SPICE to build interactive dashboards.
-
Perform Batch Operations with OData Services in Apache NiFi
Connect to OData services and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Salesforce Marketing Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Marketing and the Script function in FileMaker Pro to connect to Salesforce Marketing and work with Salesforce Marketing data in your FileMaker application.
-
Connect to and Visualize Live Cloudant Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Cloudant data.
-
Validate Cloudflare Data with QuerySurge
Access and validate Cloudflare data in QuerySurge using the CData JDBC Driver.
-
Query Live Vertica 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 Vertica data directly from the development environment.
-
Integrate ShipEngine Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ShipEngine data from Informatica Cloud.
-
Automated Continuous Oracle Eloqua Reporting Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to IBM DB2.
-
Create Data Visualizations in Cognos BI with Kintone Data
Access Kintone data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Perplexity Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Perplexity replication to Apache Kafka.
-
How to Access Live Instantly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Instantly enables you to integrate Instantly data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Basecamp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Basecamp from Power Pivot. You will use the Table Import Wizard to load Basecamp data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Live CSV Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live CSV data into custom reports in Power BI.
-
Connect to HubSpot Data in ACL Analytics
Connect to HubSpot data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to HubSpot data.
-
Integrate Trae with Live Sage Intacct Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Sage Intacct data from within the AI-powered IDE.
-
Automated Continuous Printify Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Printify replication to Amazon Redshift.
-
Getting Started with the CData Power BI Connector for Quickbase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Quickbase.
-
Add Ontraport Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Ontraport with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Google Forms Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Forms data from Informatica Cloud.
-
Integrate Google's Vertex AI Agent with Live Timely 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 Timely data within intelligent workflows.
-
How to Connect to Live Google Forms Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Forms data securely in real time.
-
Stream Pipeliner CRM Data into Apache Kafka Topics
Access and stream Pipeliner CRM data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Python Connector for Freshsales
Learn to install and license the CData Python Connector and configure a connection to live Freshsales data.
-
Validate Salesforce Marketing Data with QuerySurge
Access and validate Salesforce Marketing data in QuerySurge using the CData JDBC Driver.
-
Publish Crystal Reports on Calendly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Calendly data.
-
Import and Visualize JobNimbus Data in Power View
Create data visualizations based on JobNimbus data in Excel.
-
How to Connect to & Open Apify Data in Microsoft Excel
This article uses the CData ODBC driver for Apify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to integrate Metabase with QuickBooks Time Data
Use CData Connect AI to connect to live QuickBooks Time data and create an interactive dashboard in Metabase from QuickBooks Time data.
-
Build MVC Applications with Connectivity to Redis Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Redis from an ASP.NET MVC application.
-
Query FreeAgent Data in ColdFusion
Write standard ColdFusion data access code to connect to FreeAgent data.
-
How to connect to LinkedIn Data with Squirrel SQL client
Connect to LinkedIn data and execute queries in the Squirrel SQL Client.
-
Stream Customer.io Data into Apache Kafka Topics
Access and stream Customer.io data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Kintone Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Kintone data from your Excel spreadsheets.
-
Easily Integrate Act-On Data in Lazarus Pascal IDE
Learn how to easily integrate live Act-On data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use Agno to Talk to Your Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Azure Data Catalog data for you.
-
LINQ to Instagram 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 Instagram Data Provider.
-
Analyze Live NetSuite SuiteAnalytics Data in SAS Viya
Use CData Connect AI to connect to NetSuite SuiteAnalytics data from SAS Viya and deploy self-service analytics using live NetSuite SuiteAnalytics data.
-
Getting Started with the CData SSIS Components for Pinecone
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Pinecone.
-
View Reports on Real-Time Oracle Eloqua Reporting Data in Power BI Report Server
Use the CData ODBC Driver for Oracle Eloqua Reporting to visualize Oracle Eloqua Reporting data in Power BI Desktop and then publish them to Power BI Report Server.
-
Publish Reports with Mouseflow Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mouseflow data.
-
Integrate SAP Fieldglass with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Fieldglass with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Fieldglass data.
-
Build a Singer.io Tap for Slack With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Slack data using the CData Python Connector.
-
How to work with Google Sheets Data in Apache Spark using SQL
Access and process Google Sheets Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live PostgreSQL Data in TIBCO Data Virtualization
Use the PostgreSQL Tibco DV Adapter to create a PostgreSQL data data source in TIBCO Data Virtualization Studio and gain access to live PostgreSQL data from your TDV Server.
-
Build Pipelines with Live SFTP Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SFTP from Google Cloud Data Fusion, enabling the integration of live SFTP data into the building and management of effective data pipelines.
-
Automated Continuous LDAP Replication to SingleStore
Use CData Sync for automated, continuous, customizable LDAP replication to SingleStore.
-
Excel Spreadsheet Automation on Browserless Data with the QUERY Formula
Pull data from Browserless, automate spreadsheets, and more with the QUERY formula.
-
Connect to Microsoft Ads Data in Jaspersoft Studio
Execute SQL to remote Microsoft Ads data in Jaspersoft Studio.
-
Automated Continuous Pipedrive Replication to Snowflake
Use CData Sync for automated, continuous, customizable Pipedrive replication to Snowflake.
-
Create ZohoExpense Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoExpense data access from reports, embedded analytics, and more.
-
Integrate AgileCRM Data in Pentaho Data Integration
Build ETL pipelines based on AgileCRM data in the Pentaho Data Integration tool.
-
Use Agno to Talk to Your BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your BigCommerce data for you.
-
Access Live Mode Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Mode data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Suadeo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Suadeo data using standard SQL.