CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for Quaderno Data in APOS Live Data Gateway
Use the CData Connector for Quaderno in APOS Live Data Gateway to build Semantic Layer Views for Quaderno data.
-
How to Easily Query Parquet Data in OpenOffice Base
Connect to Parquet data in OpenOffice Base using the CData ODBC Driver for Parquet and generate reports with live data insights.
-
Build Egnyte-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Egnyte Data and create custom apps in Bubble.
-
Connect to BenchmarkEmail Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to BenchmarkEmail.
-
Connect and Visualize Live Sybase IQ Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Sybase IQ data into the Databricks platform and create visualization dashboards with real-time Sybase IQ data.
-
Integrating LangChain with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Elasticsearch data within automated workflows.
-
Replicate Front Data in Heroku for Use in Salesforce Connect
Replicate Front data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for MessageBird from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MessageBird to connect to MessageBird data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MessageBird data in Excel.
-
Work with Salesforce Data 360 Data in FoxPro
Load Salesforce Data 360 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build LightSpeedRetail-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LightSpeedRetail data.
-
Integrate Cline with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP ByDesign data from within your IDE.
-
Build Oracle Financials Cloud-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle Financials Cloud Data from Choreo and build custom apps using live Oracle Financials Cloud data.
-
Create SAP SuccessFactors-Connected Business Apps in AppSheet
Connect to SAP SuccessFactors Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP SuccessFactors data.
-
Validate FreeAgent Data with QuerySurge
Access and validate FreeAgent data in QuerySurge using the CData JDBC Driver.
-
How to Visualize Vercel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Vercel data in Python.
-
Integrate Live RSS Feeds into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to RSS from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live RSS feeds.
-
Connect to Superchat in SpagoBI
Create reports featuring live Superchat data in SpagoBI Studio. Host Superchat reports on SpagoBI Server.
-
Create Datasets from Mailjet in Domo Workbench and Build Visualizations of Mailjet Data in Domo
Use the CData Software ODBC Driver for Mailjet to create datasets from Mailjet data in Domo Workbench and then build visualizations in the Domo service.
-
Feed SQL Analysis Services Data into FineReport
How to set SQL Analysis Services data as a JDBC data source in FineReport.
-
Getting Started with the CData ADO.NET Provider for Deel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create a Data Access Object for Parallel Data using JDBI
A brief overview of creating a SQL Object API for Parallel data in JDBI.
-
Integrate Cline with Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live DB2 data from within your IDE.
-
Getting Started with the CData ADO.NET Provider for Harvest
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze Mocean Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mocean data with the CData JDBC Driver for Mocean.
-
Bridge Miro Connectivity with Apache NiFi
Access and process Miro data in Apache NiFi using the CData JDBC Driver.
-
Integrating Cursor with Google Sheets 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.
-
Use Azure AI Foundry to Talk to Your SAS Data Sets 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 SAS Data Sets data for you.
-
Getting Started with the CData Connect AI Python SDK for Anaplan
Install the CData Connect AI Python SDK to read live Anaplan data with standard DB-API 2.0 Python code.
-
Visualize Live SQL Analysis Services Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SQL Analysis Services data into custom reports in Power BI.
-
DataBind Templated Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Templated data to a chart.
-
Neo4J Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Neo4J data through CData Connect AI using different applications and tools.
-
How to connect PolyBase to ConvertAPI
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ConvertAPI data.
-
Analyze Oracle Service Cloud Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Service Cloud data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to load FHIR data into Elasticsearch via Logstash
Introducing a simple method to load FHIR data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dashboards and Visualize Live Salesforce Data 360 Data in Geckoboard
Use CData Connect AI to connect to live Salesforce Data 360 data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous SageHR Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SageHR replication to Amazon Redshift.
-
Extract, Transform, and Load ZohoSubscriptions Data in Informatica PowerCenter
Create a simple Workflow for ZohoSubscriptions data in Informatica PowerCenter.
-
Add Dropbox Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dropbox with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect Float to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Float data using the CData Python MCP Server.
-
Prepare, Blend, and Analyze Facebook Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Facebook Ads data for self-service data analytics.
-
DataBind Charts to Elasticsearch Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Elasticsearch 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.
-
Connect to WordPress Data in Ruby
Connect to WordPress data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Google Forms Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Forms Data and connect to Google Forms data in Akorbi Digital RunMyProcess.
-
Query Wistia Data in ColdFusion
Write standard ColdFusion data access code to connect to Wistia data.
-
How to connect to Salesforce CRM Analytics Data from IntelliJ
Integrate connectivity to Salesforce CRM Analytics data with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Chargebee in MicroStrategy
Connect to Chargebee data in MicroStrategy Developer using the CData Software ODBC Driver for Chargebee.
-
Use Biml to Build SSIS Tasks to Replicate SendGrid Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendGrid data to SQL Server.
-
How to connect to JDBC-ODBC Bridge Data in DBVisualizer
Integrate JDBC-ODBC Bridge data with visual data analysis tools and data connection wizards in DBVisualizer
-
Easily Integrate Zoho Projects Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Projects data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to ActiveCampaign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ActiveCampaign data in the Denodo Virtual DataPort Administrator.
-
Create SSAS Tabular Models from Instantly Data
How to build a SQL Server Analysis Service Tabular Model from Instantly data using CData drivers.
-
Validate ZarMoney Data with QuerySurge
Access and validate ZarMoney data in QuerySurge using the CData JDBC Driver.
-
Model API Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and API, enabling the direct import of real-time API data.
-
How to Visualize Apollo 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 Apollo data in Python.
-
Build Automated Workflows with Live Apollo Data in Workato
Use CData Connect AI to connect to live Apollo data and build automated workflows in Workato.
-
Integrating LlamaIndex with BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on BenchmarkEmail data in real time.
-
Migrating data from SFTP to Snowflake using CData SSIS Components.
Easily push SFTP data to Snowflake using the CData SSIS Tasks for SFTP and Snowflake.
-
Automated Continuous Testmonitor Replication to Snowflake
Use CData Sync for automated, continuous, customizable Testmonitor replication to Snowflake.
-
A PostgreSQL Interface for Tally Data using the CData ODBC Driver
Use the SQL Gateway and Tally ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Azure Table Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Azure Table data for you.
-
Create Egnyte-Connected Business Apps in AppSheet
Connect to Egnyte Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Egnyte data.
-
Integrate LibreChat with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Data Lake Storage data from within the chat interface.
-
Connect to Couchbase Data from a Connection Pool in Jetty
The Couchbase JDBC Driver supports connection pooling: This article shows how to connect faster to Couchbase data from Web apps in Jetty.
-
Automated Continuous eBay Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Google BigQuery.
-
Use Dash to Build Web Apps on Avro Data via CData Connect AI
Build interactive Dash web apps on live Avro data using pandas and the CData Connect AI Python SDK.
-
Connect to Sentry Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Sentry.
-
Integrate Trae with Live Apollo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Apollo data from within the AI-powered IDE.
-
Build MVC Applications with Connectivity to Browserless Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Browserless from an ASP.NET MVC application.
-
Seamlessly Bring Paymo Data into Retool Using CData Connect AI
Integrate Paymo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating LangChain with Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Trello data within automated workflows.
-
Connect to Perigon 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 Perigon and work with Perigon data in your FileMaker application.
-
Create Power BI Reports on Real-Time Oracle SCM Data
Use the CData ODBC Driver for Oracle SCM to visualize Oracle SCM data in Power BI Desktop.
-
Access Live NASA Data in AWS Lambda
Connect to live NASA data in AWS Lambda using the CData JDBC Driver.
-
Use the CData ODBC Driver for ServiceNow in Microsoft Power Query
You can use the CData ServiceNow ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ServiceNow data into Microsoft Power Query.
-
Integrate Cursor with Live Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Timely data from within the editor.
-
Connect to Zoho Inventory Data in Jaspersoft Studio
Execute SQL to remote Zoho Inventory data in Jaspersoft Studio.
-
Connecting Pipedream with YouTube Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on YouTube Analytics data in real time.
-
Easily Integrate Bannerbear Data in Lazarus Pascal IDE
Learn how to easily integrate live Bannerbear data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Connect AI Python SDK for Coda
Install the CData Connect AI Python SDK to read live Coda data with standard DB-API 2.0 Python code.
-
Connect to Oracle SCM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle SCM data.
-
Process & Analyze PabblySubscriptions Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PabblySubscriptions Data.
-
Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy Web
Connect to Cosmos DB data in MicroStrategy Web using the CData Software JDBC Driver for Cosmos DB.
-
Getting Started with the CData Power BI Connector for Parquet
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Parquet.
-
How to import AgileCRM Data into Apache Solr
Use the CData Software JDBC Driver for AgileCRM in Data Import Handler and create an automated import of AgileCRM data to Apache Solr Enterprise Search platform.
-
Integrate with Power BI XMLA Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Power BI XMLA data in SnapLogic.
-
Automated Continuous Facebook Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable Facebook Ads replication to SingleStore.
-
Automated Continuous Monday.com Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Monday.com replication to Azure SQL Database.
-
How to Connect to Attio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Attio data. Leverage the pyodbc module for ODBC in Python.
-
Replicate Multiple Vertica Accounts
Replicate multiple Vertica accounts to one or many databases.
-
Integrate Live NetSuite SuiteAnalytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to NetSuite SuiteAnalytics data and integrate live NetSuite SuiteAnalytics data into apps built in Microsoft Power Apps.
-
How to Connect the Power BI Service to Outlook: Complete Guide
Connect to the CData Software Power BI Connector for Outlook from PowerBI.com to provide real-time Outlook data across the organization.
-
How to connect to FreeAgent Data from IntelliJ
Integrate connectivity to FreeAgent data with wizards in IntelliJ.
-
Integrate Simplesat Data in the Pentaho Report Designer
Publish reports based on Simplesat data in the Pentaho BI tool.
-
Import Real-Time Raisers Edge NXT Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Raisers Edge NXT data in ColdFusion.
-
Connect to Spotify Data in JRuby
Create a simple JRuby app with access to live Spotify data.
-
Use the CData Software ODBC Driver for Planio in MicroStrategy
Connect to Planio data in MicroStrategy Developer using the CData Software ODBC Driver for Planio.
-
Automated Continuous Figshare Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Figshare replication to Azure SQL Database.
-
LINQ to Toggl 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 Toggl Data Provider.
-
Integrate Google's Vertex AI Agent with Live Quickbase 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 Quickbase data within intelligent workflows.
-
Use Biml to Build SSIS Tasks to Replicate Freshsales Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshsales data to SQL Server.