CData Software - Knowledge Base
Recent Articles
-
Work with Spark Data in FoxPro
Load Spark data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to SuiteCRM Data from Spring Boot
Connect to SuiteCRM in a Spring Boot Application using the CData JDBC Driver for SuiteCRM
-
Create Power BI Reports on Real-Time HDFS Data
Use the CData ODBC Driver for HDFS to visualize HDFS data in Power BI Desktop.
-
Use the CData Software ODBC Driver for Flowlu in SAS for Real-Time Reporting and Analytics
Connect to real-time Flowlu data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Flowlu.
-
Create Azure Data Lake Storage-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Data Lake Storage Data from Klipfolio and build custom visualizations using live Azure Data Lake Storage data.
-
Add Typeform Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Typeform with the Informatica Enterprise Data Catalog to classify and organize data.
-
Operational Reporting on Moosend Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Moosend data.
-
Build FreshBooks-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live FreshBooks data without replication.
-
Publish Crystal Reports on Azure Synapse Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Synapse data.
-
Connect to Bannerbear Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Bannerbear data from Filemaker Pro on Mac.
-
Access Live GitLab Data in AWS Lambda
Connect to live GitLab data in AWS Lambda using the CData JDBC Driver.
-
Integrate Google's Vertex AI Agent with Live Amazon Athena 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 Amazon Athena data within intelligent workflows.
-
How to Build an ETL App for Freshteam Data in Python with CData
Create ETL applications and real-time data pipelines for Freshteam data in Python with petl.
-
Connect to Adobe Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access Adobe Analytics data from PowerBuilder using the Adobe Analytics JDBC Driver.
-
Integrate with Live Salesforce Data 360 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Data 360 from the MuleSoft Anypoint Platform to integrate live Salesforce Data 360 data into custom reports and dashboards.
-
Connect to JSON Services in JRuby
Create a simple JRuby app with access to live JSON services.
-
LINQ to Qualaroo 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 Qualaroo Data Provider.
-
Connect to eBay in SpagoBI
Create reports featuring live eBay data in SpagoBI Studio. Host eBay reports on SpagoBI Server.
-
Connect to ZendeskSell Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZendeskSell and the SQL Gateway to access ZendeskSell data from Google Apps Script.
-
Excel Spreadsheet Automation on SingleStore Data with the QUERY Formula
Pull data from SingleStore, automate spreadsheets, and more with the QUERY formula.
-
Build MVC Applications with Connectivity to Wistia Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Wistia from an ASP.NET MVC application.
-
Use Manus AI to Talk to Your Vault CRM 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 Vault CRM data.
-
Connect to Sybase IQ Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Sybase IQ data.
-
Connecting Agentforce with Certinia 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 Certinia data for you.
-
Automated Continuous Monday.com Replication to SQL Server
Use CData Sync for automated, continuous, customizable Monday.com replication to SQL Server.
-
How to Visualize Salesforce Pardot 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 Salesforce Pardot data in Python.
-
Build Dashboards with SAP Fieldglass Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Fieldglass data in DBxtra.
-
Create Informatica Mappings From/To an ODBC Data Source for DocuSign
Create an ODBC connection to DocuSign in Informatica and browse and transfer DocuSign data.
-
DataBind Controls to ShipStation Data in Delphi
DataBind to ShipStation data in Delphi with standard data access components and controls.
-
How to load Zoom data into Elasticsearch via Logstash
Introducing a simple method to load Zoom data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Bright Data Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bright Data replication to Google BigQuery.
-
Automated Continuous Sage 300 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sage 300 replication to Apache Kafka.
-
Getting Started with the CData Python Connector for CampaignMonitor
Learn to install and license the CData Python Connector and configure a connection to live CampaignMonitor data.
-
Automated Continuous Aircall Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Aircall replication to Amazon Redshift.
-
Integrate CSV Data in Pentaho Data Integration
Build ETL pipelines based on CSV data in the Pentaho Data Integration tool.
-
Integrate PhantomBuster with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PhantomBuster with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PhantomBuster data.
-
Replicate SharePoint Data to Multiple Databases
Replicate SharePoint data to disparate databases with a point-and-click configuration.
-
Integrate OpenCode with Live Egnyte Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Egnyte data from within your AI coding agent.
-
Automated Continuous Salesloft Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesloft replication to SQL Server.
-
Connect to Office 365 Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Office 365 data.
-
Connect to Instantly Data in CloverDX (formerly CloverETL)
Transfer Instantly data using the visual workflow in the CloverDX data integration tool.
-
Access Kintone Data from MySQL in PHP
Connect to Kintone through the standard MySQL libraries in PHP.
-
Connect and Query Live Acumatica Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Acumatica data into Databricks and enable direct, live querying and analysis without replication.
-
How to Query Live HubSpot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live HubSpot data data in natural language using Python.
-
How to Connect to ConvertAPI Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ConvertAPI data. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to & Open Neo4J Data in Microsoft Excel
This article uses the CData ODBC driver for Neo4J to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build AgileCRM-Connected Apps in Choreo
Use CData Connect AI to connect to AgileCRM Data from Choreo and build custom apps using live AgileCRM data.
-
Extract, Transform, and Load Acumatica Data in Informatica PowerCenter
Create a simple Workflow for Acumatica data in Informatica PowerCenter.
-
Integrate Trae with Live Moosend Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Moosend data from within the AI-powered IDE.
-
Getting Started with the CData Tableau Connector for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle HCM Cloud.
-
Automated Continuous OneNote Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable OneNote replication to Google Cloud SQL.
-
Automated SAP Hybris C4C Data Replication to Teradata
Use CData Sync to Customize and automate SAP Hybris C4C data replication to Teradata.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Email
Provide connectivity to Email data through an SAP BusinessObjects universe.
-
Analyze Spark Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Spark data and visualize live Spark data in Infragistics Reveal.
-
Integrating Dataiku with Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon DynamoDB data.
-
Integrating Codex with Pipedrive 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 QuickBooks Replication to SingleStore
Use CData Sync for automated, continuous, customizable QuickBooks replication to SingleStore.
-
Feed Snapchat Ads Data into FineReport
How to set Snapchat Ads data as a JDBC data source in FineReport.
-
Integrate Toggl Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Toggl data from Informatica Cloud.
-
Integrating Cursor with SAP ByDesign 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 integrate Metabase with Azure Synapse Data
Use CData Connect AI to connect to live Azure Synapse data and create an interactive dashboard in Metabase from Azure Synapse data.
-
Access QuickBooks Online Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access QuickBooks Online data from your Oracle system.
-
Consume Salesforce Pardot OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce Pardot data as OData feeds from PowerBuilder using the API Server.
-
Build Visualizations of Sage 200 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sage 200 data in Birst.
-
Use Microsoft Copilot Studio to talk to your Cvent 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 Cvent data for you.
-
Automated Continuous Bugsnag Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Bugsnag replication to Amazon S3.
-
Publish Crystal Reports on Zoho Projects Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Projects data.
-
How to Connect DBeaver to Cohere via a JDBC Driver
Manage Cohere data with visual tools in DBeaver like the query browser.
-
Automated Continuous Simplesat Replication to Oracle
Use CData Sync for automated, continuous, customizable Simplesat replication to Oracle.
-
Access ServiceNow Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ServiceNow data.
-
Access Browserless Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Browserless data from your Oracle system.
-
Building Dynamic Web Pages with Google Spanner Data Using AngularJS
Create single-page applications with live connectivity to Google Spanner using the CData API Server.
-
Design BIRT Reports on SAP HANA XS Advanced Data
Provide current SAP HANA XS Advanced data to your embedded analytics.
-
Getting Started with the CData Power BI Connector for Notion
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connecting GenSpark with Apollo Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apollo data without any replication or custom integration required.
-
Create Power BI Reports on Real-Time REST Data
Use the CData ODBC Driver for REST to visualize REST data in Power BI Desktop.
-
Use JayDeBeApi to access Phoenix Data in Python
Use standard Python scripting and the development environment of your choice to access live Phoenix data.
-
Query Live SAS Data Sets 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 SAS Data Sets data through a conversational interface.
-
How to Query Live MySQL Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MySQL data data in natural language using Python.
-
Connect to Okta Data in Ruby
Connect to Okta data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Live LDAP 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 LDAP objects from within the IDE.
-
Getting Started with the CData ODBC Driver for Sugar CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sugar CRM.
-
Access Marketo Data from MySQL in Amazon QuickSight
Connect to Marketo and build visualizations of Marketo data using a MySQL Connection in Amazon QuickSight.
-
Connect to SAP Netweaver Gateway Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Netweaver Gateway in FileMaker Pro to connect to SAP Netweaver Gateway and work with SAP Netweaver Gateway data in your FileMaker applications.
-
Use the CData Software JDBC Driver for Instagram in MicroStrategy
Connect to Instagram data in MicroStrategy Developer using the CData Software JDBC Driver for Instagram.
-
Automated Continuous ConstantContact Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ConstantContact replication to Amazon S3.
-
DataBind Controls to Customer.io Data in Delphi
DataBind to Customer.io data in Delphi with standard data access components and controls.
-
Automated Continuous Contentful Replication to Oracle
Use CData Sync for automated, continuous, customizable Contentful replication to Oracle.
-
How to connect to Scrapfly Data with Squirrel SQL client
Connect to Scrapfly data and execute queries in the Squirrel SQL Client.
-
Integrating LlamaIndex with ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ServiceDesk Plus data in real time.
-
Model, Search, and Visualize Live Google Campaign Manager 360 Data in ThoughtSpot
Use CData Connect AI to connect to live Google Campaign Manager 360 data for modeling, searching, and visualizing.
-
Connect to Azure Data Lake Storage Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Data Lake Storage data from Crystal Reports.
-
Integrate Real-Time Access to SAP in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP data in real time.
-
Integrate Live Reckon Accounts Hosted Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Reckon Accounts Hosted data to Blue Prism using the CData ODBC Driver for Reckon Accounts Hosted to create automated workflows for repetitive business tasks.
-
Automated Continuous Landbot Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Landbot replication to Amazon Redshift.
-
Using the CData Software ODBC Driver for SendInBlue in PyCharm
Connect to SendInBlue as an ODBC data source in PyCharm using the CData Software ODBC Driver for SendInBlue.
-
Build a Singer.io Tap for Yelp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Yelp data using the CData Python Connector.
-
Integrate Live WordPress Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live WordPress data to Blue Prism using the CData ODBC Driver for WordPress to create automated workflows for repetitive business tasks.
-
How to connect to BambooHR Data from IntelliJ
Integrate connectivity to BambooHR data with wizards in IntelliJ.
-
Visualize xBase Data in Sisense
Create an ElastiCube in Sisense app with access to xBase data.