CData Software - Knowledge Base
Recent Articles
-
Visualize Cosmos DB Data in TIBCO Spotfire through OData
Integrate Cosmos DB data into dashboards in TIBCO Spotfire.
-
LINQ to Kintone 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 Kintone Data Provider.
-
Add Oracle SCM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle SCM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Process & Analyze Trello Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Trello Data.
-
Integrate Devin with Live PingOne Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live PingOne data.
-
Access Live Timely Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Timely data through MCP integration.
-
Connect to AgileCRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live AgileCRM data from Crystal Reports.
-
Integrating LangGraph with MailChimp Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MailChimp data within automated workflows.
-
Back Up Microsoft Exchange data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Exchange. In this article, we will employ an SSIS workflow to populate a database with Microsoft Exchange data data.
-
How to Build an ETL App for Asana Data in Python with CData Connect AI
Extract and transform live Asana data in Python with petl and the CData Connect AI Python SDK.
-
Create Dynamic Freshteam Grids Using the Infragistics XamDataGrid
Learn how you can connect Freshteam to Infragistics XamDataGrid to build dynamic grids.
-
How to Query Live Auth0 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Auth0 data data in natural language using Python.
-
Create Wave Financial-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Wave Financial Data from OutSystems and build custom enterprise apps using live Wave Financial data.
-
Prepare, Blend, and Analyze PayPal Data in Alteryx Designer (ODBC)
Build workflows to access live PayPal data for self-service data analytics.
-
Automate Sybase IQ Data Replication to SAP HANA
Use CData Sync to customize and automate Sybase IQ data replication to SAP HANA.
-
Integrating Kiro with Quaderno 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.
-
Integrate Stripe Data in Pentaho Data Integration
Build ETL pipelines based on Stripe data in the Pentaho Data Integration tool.
-
Access Live Confluence Data in Coginiti Pro
Connect to and query live Confluence data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Snowflake 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 Snowflake data.
-
Automate Azure Synapse Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Synapse data replication to Couchbase.
-
Publish Quickbase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Quickbase data.
-
Connect to Acumatica Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Acumatica data from Filemaker Pro on Mac.
-
Easily Integrate MailerSend Data in Lazarus Pascal IDE
Learn how to easily integrate live MailerSend data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Migrating data from Avaza to Databricks using CData SSIS Components.
Easily push Avaza data to Databricks using the CData SSIS Tasks for Avaza and Databricks.
-
Build Pipedrive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Pipedrive data and build web apps with connectivity to live Pipedrive data.
-
Build an OLAP Cube in SSAS from Helpscout Data
Establish a connection to Helpscout data data from SQL Server Analysis Services, and use the Helpscout Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live ServiceDesk Plus Data in Excel 365 Online (Excel for the web)
Connect to ServiceDesk Plus data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Zuora Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zuora replication to Apache Cassandra.
-
Integrate Live Azure Table Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Table from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Table data.
-
Create a Data Access Object for GitLab Data using JDBI
A brief overview of creating a SQL Object API for GitLab data in JDBI.
-
Integrate OpenCode with Live Cassandra Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Cassandra data from within your AI coding agent.
-
Build MVC Applications with Connectivity to RSS Feeds
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access RSS from an ASP.NET MVC application.
-
Build Google Forms-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 Google Forms data without replication.
-
Integrating Claude Code with HubSpot Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on HubSpot data within assisted coding and automated development workflows.
-
How to Connect to Live Kafka 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 Kafka data for you.
-
Connect to Trello Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Trello.
-
Visualize Live SAP Business Warehouse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Business Warehouse data.
-
Integrate Quickbase Data in the Pentaho Report Designer
Publish reports based on Quickbase data in the Pentaho BI tool.
-
Create EnterpriseDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to EnterpriseDB Data from OutSystems and build custom enterprise apps using live EnterpriseDB data.
-
Build AI Agents with XML Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live XML data through CData Connect AI.
-
Connect to Oracle HCM Cloud Data from AWS Glue
Use CData Connect AI to gain access to live Oracle HCM Cloud data from your AWS Glue jobs.
-
Access Salesforce Data 360 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce Data 360 data from your Oracle system.
-
Analyze Blackbaud FE NXT Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Blackbaud FE NXT from Power Pivot. You will use the Table Import Wizard to load Blackbaud FE NXT data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to QuickBooks Time Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for QuickBooks Time data.
-
Integrate FTP Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to FTP data and integrate live FTP data into your Power Automate tasks.
-
Getting Started with the CData Connect AI Python SDK for Salesloft
Install the CData Connect AI Python SDK to read and write live Salesloft data with standard DB-API 2.0 Python code.
-
Visualize Live YouTube Analytics Data in the Power BI Service
Use CData Connect AI to connect to live YouTube Analytics data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build CockroachDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live CockroachDB data and build visualizations in Tableau Cloud.
-
How to Connect the Power BI Service to CapsuleCRM: Complete Guide
Connect to the CData Software Power BI Connector for CapsuleCRM from PowerBI.com to provide real-time CapsuleCRM data across the organization.
-
Analyze Freshsales Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Freshsales data with the CData JDBC Driver for Freshsales.
-
Visualize Live SAP HANA Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP HANA data.
-
Use the CData Software ODBC Driver for SAS Data Sets in MicroStrategy
Connect to SAS Data Sets data in MicroStrategy Developer using the CData Software ODBC Driver for SAS Data Sets.
-
Provide OData Services of ZendeskSell Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZendeskSell data by developing a WCF Service Application.
-
Connect to ServiceNow from a Connection Pool in WebLogic
Use the CData JDBC Driver for ServiceNow to connect to ServiceNow data from Web applications running on WebLogic.
-
Connect to SharePoint Excel Services Data in RapidMiner
Integrate SharePoint Excel Services data with standard components and data source configuration wizards in RapidMiner Studio.
-
Work with Coinbase Data in FoxPro
Load Coinbase data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Dropbox Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dropbox data in Microsoft R Open.
-
Using the CData Software ODBC Driver for Freshservice in PyCharm
Connect to Freshservice as an ODBC data source in PyCharm using the CData Software ODBC Driver for Freshservice.
-
Access Azure Data Catalog 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 Azure Data Catalog data.
-
Publish Coda-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Coda data.
-
How to Use a Microsoft Access Database to Update Salesforce Marketing Data in Real Time
Update Salesforce Marketing data by creating a linked table in Microsoft Access with the CData Salesforce Marketing ODBC Driver.
-
Work with Live Azure Table Data in Power Query
Use CData Connect AI to connect to Azure Table data and work with live Azure Table data in Microsoft Power Query.
-
Use CData Connect AI to Access ZohoDesk Data in Microsoft Power Pivot
Use CData Connect AI to connect to live ZohoDesk data in the Power Pivot business intelligence tool.
-
Connect and Visualize Live Salesforce Marketing Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce Marketing data into the Databricks platform and create visualization dashboards with real-time Salesforce Marketing data.
-
Add OData Services to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for OData with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous ClickTime Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ClickTime replication to IBM DB2.
-
Getting Started with the CData ADO.NET Provider for Wistia
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build AI/ML Models with Live Databricks Data using Dataiku
Connect Databricks Data with Dataiku using the CData JDBC Driver for Databricks.
-
Create Data Visualizations in Cognos BI with Marketo Data
Access Marketo data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Multiple Deel Accounts
Replicate multiple Deel accounts to one or many databases.
-
How to use SQLAlchemy ORM to access Confluence Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Confluence data.
-
Build Charts with Opsgenie Data in Clear Analytics
Create dynamic charts and perform analytics based on Opsgenie data in Clear Analytics.
-
How to Visualize Microsoft Exchange Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Exchange data in Python.
-
Visualize LDAP Objects in TIBCO Spotfire through OData
Integrate LDAP objects into dashboards in TIBCO Spotfire.
-
Build an OLAP Cube in SSAS from Google Tasks Data
Establish a connection to Google Tasks data data from SQL Server Analysis Services, and use the Google Tasks Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use JayDeBeApi to access SAP HANA XS Advanced Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP HANA XS Advanced data.
-
Integrate OpenCode with Live Snapchat Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Snapchat Ads data from within your AI coding agent.
-
Create a Data Access Object for Recurly Data using JDBI
A brief overview of creating a SQL Object API for Recurly data in JDBI.
-
Use the CData Software ODBC Driver for Contentful in MicroStrategy
Connect to Contentful data in MicroStrategy Developer using the CData Software ODBC Driver for Contentful.
-
Create Dashboards and Visualize Live CouchDB Data in Geckoboard
Use CData Connect AI to connect to live CouchDB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Query PhantomBuster Data in MySQL Workbench
Execute MySQL queries against live PhantomBuster data from MySQL Workbench.
-
Stream CouchDB Data into Apache Kafka Topics
Access and stream CouchDB data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Pipeliner CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to AlloyDB.
-
Integrating LangChain with Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Contacts data within automated workflows.
-
Access Live Clari Data in Coginiti Pro
Connect to and query live Clari data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Real-Time PagerDuty Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PagerDuty data in Power Apps.
-
Access Live Gorgias Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Gorgias data into the statistical analysis tools available in SAS JMP. This article shows how to use Gorgias data in the Graph Builder and Query Builder.
-
How to connect PolyBase to Microsoft Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Ads data.
-
Access Live SAP Hybris C4C Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Hybris C4C data from your Excel spreadsheets.
-
How to Easily Query Aircall Data in OpenOffice Base
Connect to Aircall data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Migrating data from Google Forms to Databricks using CData SSIS Components.
Easily push Google Forms data to Databricks using the CData SSIS Tasks for Google Forms and Databricks.
-
Automated Continuous xBase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable xBase replication to Google Cloud SQL.
-
How to Visualize Greenhouse 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 Greenhouse data in Python.
-
Integrate Live Sage 300 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sage 300 data and integrate live Sage 300 data into apps built in Microsoft Power Apps.
-
LINQ to Exa 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 Exa Data Provider.
-
ETL Productboard in Oracle Data Integrator
This article shows how to transfer Productboard data into a data warehouse using Oracle Data Integrator.
-
How to import Salesforce Marketing Data into Apache Solr
Use the CData Software JDBC Driver for Salesforce Marketing in Data Import Handler and create an automated import of Salesforce Marketing data to Apache Solr Enterprise Search platform.
-
Automated Continuous ServiceDesk Plus Replication to SQLite
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to SQLite.
-
Use Manus AI to Talk to Your CSV 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 CSV data.
-
Replicate ZohoInvoice Data from PowerShell
Write a quick PowerShell script to query ZohoInvoice data. Use connectivity to the live data to replicate ZohoInvoice data to SQL Server.