CData Software - Knowledge Base
Recent Articles
-
How to connect to Oracle Data with Squirrel SQL client
Connect to Oracle data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Retently Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Retently data replication to OneLake in Microsoft Fabric.
-
Access Live Amazon Marketplace Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon Marketplace data from your Excel spreadsheets.
-
Miro Reporting in OBIEE with the Miro JDBC Driver
Deploy the Miro JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Webex Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Webex replication to delimited files (CSV/TSV).
-
Automated Continuous Google Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Ads replication to IBM DB2.
-
How to Connect the Power BI Service to Printify: Complete Guide
Connect to the CData Software Power BI Connector for Printify from PowerBI.com to provide real-time Printify data across the organization.
-
Work with Azure Data Lake Storage Data in FoxPro
Load Azure Data Lake Storage data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData JDBC Driver for Quaderno
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Quaderno.
-
Create Figshare-Connected Business Apps in AppSheet
Connect to Figshare Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Figshare data.
-
Integrate SparkPost with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SparkPost with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SparkPost data.
-
Integrate Browserless Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Browserless data from Informatica Cloud.
-
Getting Started with the CData ODBC Driver for Sage 300
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sage 300.
-
Explore Geographical Relationships in Bugsnag Data with Power Map
Create data visualizations with Bugsnag data in Power Map.
-
View Reports on Real-Time Sybase IQ Data in Power BI Report Server
Use the CData ODBC Driver for Sybase IQ to visualize Sybase IQ data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to MongoDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MongoDB data in Airbyte.
-
Replicate Mistral AI Data from PowerShell
Write a quick PowerShell script to query Mistral AI data. Use connectivity to the live data to replicate Mistral AI data to SQL Server.
-
Rapidly Develop AgileCRM-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 AgileCRM.
-
Access Salesloft Data from MySQL in Amazon QuickSight
Connect to Salesloft and build visualizations of Salesloft data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Pipeline CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Amazon Redshift.
-
How to connect PolyBase to SharePoint Excel Services
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SharePoint Excel Services data.
-
How to import Dynamics NAV Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics NAV in Data Import Handler and create an automated import of Dynamics NAV data to Apache Solr Enterprise Search platform.
-
DataBind Controls to Azure DevOps Data in C++Builder
DataBind to Azure DevOps data in C++Builder with standard components and controls.
-
Access Zoho Inventory Data from MySQL in PHP
Connect to Zoho Inventory through the standard MySQL libraries in PHP.
-
Feed Presto Data into FineReport
How to set Presto data as a JDBC data source in FineReport.
-
Build Semantic Layer Views for Scrapfly Data in APOS Live Data Gateway
Use the CData Connector for Scrapfly in APOS Live Data Gateway to build Semantic Layer Views for Scrapfly data.
-
Build Dashboards with Blackbaud FE NXT Data in DBxtra
Create dynamic dashboards and perform analytics based on Blackbaud FE NXT data in DBxtra.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing data for you.
-
Add Superchat Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Superchat with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Apps with Live Grafana data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Grafana data into the Adalo platform and build custom mobile and web applications with real-time Grafana data.
-
Integrate with SendGrid Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SendGrid data in SnapLogic.
-
Integrate Live Azure DevOps 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 Azure DevOps data from within the IDE.
-
Visualize Klipfolio Data in Tableau
The CData ODBC driver for Klipfolio enables you integrate Klipfolio data into Tableau dashboards.
-
Explore Geographical Relationships in Dynamics 365 Data with Power Map
Create data visualizations with Dynamics 365 data in Power Map.
-
Connect to Zuora Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zuora data from Appeon PowerBuilder using the CData ADO.NET Provider for Zuora.
-
Connect to Zuora Data in Ruby
Connect to Zuora data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Codex with ClickTime 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.
-
Consume PostgreSQL OData Feeds in PowerBuilder
This article demonstrates how to consume PostgreSQL data as OData feeds from PowerBuilder using the API Server.
-
Visualize Live Oracle Financials Cloud Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle Financials Cloud data into custom reports in Power BI.
-
Automate SAP Netweaver Gateway Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Netweaver Gateway data replication to Azure Data Lake.
-
Integrating LangChain with Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Neo4J data within automated workflows.
-
Automate Coinbase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Coinbase data replication to Azure Data Lake.
-
Configure the CData JDBC Driver for CloudConvert in a Connection Pool in Tomcat
Connect to CloudConvert data from a connection pool in Tomcat.
-
How to Work with IBM Informix Data in ETL Validator JDBC
Connect to IBM Informix from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live Google Cloud Storage Data in MicroStrategy through CData Connect AI
Create a live connection to Google Cloud Storage Data in CData Connect AI and connect to your Google Cloud Storage data from MicroStrategy.
-
Easily Integrate Oracle Service Cloud Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Service Cloud data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Sybase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sybase data and integrate live Sybase data into your Power Automate tasks.
-
Integrate Live XML Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to XML from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live XML data.
-
Query Live Amazon Marketplace 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 Amazon Marketplace data through a conversational interface.
-
Connect to Real-Time OpenWeatherMap Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use OpenWeatherMap data in Power Apps.
-
Use Biml to Build SSIS Tasks to Replicate OnePageCrm Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate OnePageCrm data to SQL Server.
-
Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy
Connect to Dynamics 365 data in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics 365.
-
Create RabbitMQ Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time RabbitMQ data access from reports, embedded analytics, and more.
-
Integrate Real-Time Access to Amazon Marketplace in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Marketplace data in real time.
-
Visualize Jumpseller Data in TIBCO Spotfire through ADO.NET
Integrate Jumpseller data into dashboards in TIBCO Spotfire.
-
Connect to Live PostgreSQL Data in PostGresSQL Interface through CData Connect AI
Create a live connection to PostgreSQL in CData Connect AI and connect to your PostgreSQL data from PostgreSQL.
-
Query Procore Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Procore data from Node.js.
-
LINQ to SAP ByDesign 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 SAP ByDesign Data Provider.
-
Build Agents in Relevance AI with Access to Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Presto data within intelligent agent workflows.
-
Create Power BI Reports on Real-Time MailerSend Data
Use the CData ODBC Driver for MailerSend to visualize MailerSend data in Power BI Desktop.
-
Bind Live Greenhouse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Greenhouse data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Connect to Live Bright Data 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 Bright Data data for you.
-
Connect to SQL Analysis Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SQL Analysis Services data in the Denodo Virtual DataPort Administrator.
-
Connect to Simplesat Data in DBeaver
Use the CData ODBC Driver to connect to Simplesat data in DBeaver.
-
Connect to Google Calendar Data from a Connection Pool in Jetty
The Google Calendar JDBC Driver supports connection pooling: This article shows how to connect faster to Google Calendar data from Web apps in Jetty.
-
Connect to Front Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Front to connect to Front data and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Twilio in MicroStrategy Desktop
Connect to Twilio data in MicroStrategy Desktop using the CData Software JDBC Driver for Twilio.
-
Prepare, Blend, and Analyze Raisers Edge NXT Data in Alteryx Designer (Connect AI)
Build workflows to access live Raisers Edge NXT data for self-service data analytics.
-
Use the CData Software JDBC Driver for Calendly in MicroStrategy
Connect to Calendly data in MicroStrategy Developer using the CData Software JDBC Driver for Calendly.
-
How to load Twilio data into Elasticsearch via Logstash
Introducing a simple method to load Twilio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Microsoft Entra ID Data from MySQL in Amazon QuickSight
Connect to Microsoft Entra ID and build visualizations of Microsoft Entra ID data using a MySQL Connection in Amazon QuickSight.
-
Build Visualizations of Printful Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Printful data in Birst.
-
Use the CData Software ODBC Driver for ConvertAPI in MicroStrategy Web
Connect to ConvertAPI data in MicroStrategy Web using the CData Software ODBC Driver for ConvertAPI.
-
Load Adobe Experience Manager Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Experience Manager data to a database.
-
Migrating data from Cloudflare to Google BigQuery using CData SSIS Components.
Easily push Cloudflare data to Google BigQuery using the CData SSIS Tasks for Cloudflare and Google BigQuery.
-
Automated Continuous Bullhorn CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bullhorn CRM data replication to OneLake in Microsoft Fabric.
-
Connect to Wistia Data from a Connection Pool in Jetty
The Wistia JDBC Driver supports connection pooling: This article shows how to connect faster to Wistia data from Web apps in Jetty.
-
Stream Sendwithus Data into Apache Kafka Topics
Access and stream Sendwithus data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Epicor Kinetic Data in DBVisualizer
Integrate Epicor Kinetic data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with Beeminder Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Beeminder data to a JSON file on disk.
-
How to Seamlessly Import Microsoft OneDrive Data into IBM SPSS Modeler
Integrate Microsoft OneDrive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Confluence Replication to Databricks
Use CData Sync for automated, continuous, customizable Confluence replication to Databricks.
-
Connect to Active Directory Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Active Directory Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use Claude to Talk to Your Adobe Analytics 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 Adobe Analytics data for you.
-
Build Impala-Connected Apps in Choreo
Use CData Connect AI to connect to Impala Data from Choreo and build custom apps using live Impala data.
-
Getting Started with the CData ADO.NET Provider for Power BI XMLA
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Power BI XMLA.
-
Integrate Cursor with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Act-On data from within the editor.
-
Access Live Egnyte Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Egnyte data into the statistical analysis tools available in SAS JMP. This article shows how to use Egnyte data in the Graph Builder and Query Builder.
-
Connect Datadog Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Datadog data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connecting Agentforce with Vertica 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 Vertica data for you.
-
Validate Pipedrive Data with QuerySurge
Access and validate Pipedrive data in QuerySurge using the CData JDBC Driver.
-
Integrating Drip Data in Talend Cloud Data Management Platform
Connect Drip Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automate Printful Data Replication to SAP HANA
Use CData Sync to customize and automate Printful data replication to SAP HANA.
-
How to Access Dropbox Data Using Entity Framework
This article shows how to access Dropbox data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import Real-Time Rootly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Rootly data in ColdFusion.
-
Build AI/ML Models with Live xBase Data using Dataiku
Connect xBase Data with Dataiku using the CData JDBC Driver for xBase.
-
Build Voice Agents in ElevenLabs with access to Live SFTP Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SFTP data.
-
Connect and Visualize Live Apify Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apify data into the Databricks platform and create visualization dashboards with real-time Apify data.
-
Analyze ZohoMarketingHub Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ZohoMarketingHub data and visualize live ZohoMarketingHub data in Infragistics Reveal.
-
Connect to Acumatica from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Acumatica data, and over 250 other data sources, right inside your Excel and Google spreadsheets!