CData Software - Knowledge Base
Recent Articles
-
Automated Continuous JobNimbus Replication to MongoDB
Use CData Sync for automated, continuous, customizable JobNimbus replication to MongoDB.
-
How to Connect to Live BigQuery Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your BigQuery data through natural language.
-
Migrating data from SAP to Google BigQuery using CData SSIS Components.
Easily push SAP data to Google BigQuery using the CData SSIS Tasks for SAP and Google BigQuery.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Dataverse Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Dataverse data.
-
Build Gmail-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Gmail data and build Gmail-connected web apps with Axios.
-
Query Raisers Edge NXT Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Raisers Edge NXT entities in PHP by modeling them as objects.
-
Access Live ZohoSubscriptions Data in Excel 365 Online (Excel for the web)
Connect to ZohoSubscriptions data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query SAP SuccessFactors Data in DataGrip
Create a Data Source for SAP SuccessFactors in DataGrip and use SQL to query live SAP SuccessFactors data.
-
Replicate Chargebee Data to Multiple Databases via the CData Sync CLI
Replicate Chargebee data to disparate databases with a single configuration.
-
How to work with Bitly Data in Apache Spark using SQL
Access and process Bitly Data in Apache Spark using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Scrapfly
Provide connectivity to Scrapfly data through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live BenchmarkEmail Data in ThoughtSpot
Use CData Connect AI to connect to live BenchmarkEmail data for modeling, searching, and visualizing.
-
LINQ to Harvest 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 Harvest Data Provider.
-
Create Informatica Mappings From/To a JDBC Data Source for CSV
Create CSV data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Cursor with Live Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Kafka data from within the editor.
-
Visualize Act-On Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Act-On data.
-
Connect to Greenhouse Data in Claris FileMaker Pro
Use the CData ODBC Driver for Greenhouse in FileMaker Pro to connect to Greenhouse and work with Greenhouse data in your FileMaker applications.
-
Automated Continuous Google Forms Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Forms replication to Amazon S3.
-
Access Live Dynamics 365 Business Central Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dynamics 365 Business Central data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connecting Moonlit Workflow with Lakebase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Lakebase data in real time.
-
Explore Geographical Relationships in Adobe Commerce Data with Power Map
Create data visualizations with Adobe Commerce data in Power Map.
-
Build Trello-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Trello Data from Zoho Analytics and import live Trello data.
-
Getting Started with the CData ADO.NET Provider for Yelp
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate CapsuleCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CapsuleCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CapsuleCRM data.
-
Connect to Facebook Ads Data from AWS Glue
Use CData Connect AI to gain access to live Facebook Ads data from your AWS Glue jobs.
-
Connect to SAP Ariba Procurement Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Ariba Procurement data.
-
Replicate ZohoDesk Data to Multiple Databases
Replicate ZohoDesk data to disparate databases with a point-and-click configuration.
-
Connect to Salesforce CRM Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce CRM Analytics data.
-
Connect to Templated Data in Ruby
Connect to Templated data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Live Facebook 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 Facebook data through a conversational interface.
-
Connect to Demio from Asprova with CData Software ODBC Driver for Demio
This article shows how to connect faster to Demio data from Asprova.
-
How to load WooCommerce data into Elasticsearch via Logstash
Introducing a simple method to load WooCommerce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for Parallel from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Parallel to connect to Parallel data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Parallel data in Excel.
-
How to publish and share ADP Data dashboards with Tableau Server
The CData ODBC driver for ADP enables you integrate ADP data into Tableau dashboards.
-
Create Dashboards and Visualize Live IBM Informix Data in Geckoboard
Use CData Connect AI to connect to live IBM Informix data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData ADO.NET Provider for Mailjet
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live FTP Data in Excel 365 Online (Excel for the web)
Connect to FTP data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Dify with Live DocuSign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live DocuSign data.
-
Build MVC Applications with Connectivity to Adobe Experience Manager Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Experience Manager from an ASP.NET MVC application.
-
Bridge HCL Domino Connectivity with Apache NiFi
Access and process HCL Domino data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Azure Blob Storage Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Amazon Redshift.
-
Access Live Wave Financial Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Wave Financial data through MCP integration.
-
Create Data Visualizations in Cognos BI with Sybase Data
Access Sybase data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Sage Cloud Accounting Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage Cloud Accounting facts in real time.
-
Visualize Trello Data in Sisense
Create an ElastiCube in Sisense app with access to Trello data.
-
Import Real-Time Google Drive Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Drive data in ColdFusion.
-
Automated Continuous FreshBooks Replication to Databricks
Use CData Sync for automated, continuous, customizable FreshBooks replication to Databricks.
-
Publish Tally-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Tally data.
-
Analyze Adobe Target Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Adobe Target data in Microsoft R Open.
-
Connect to and Visualize Live Pipeliner CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pipeliner CRM data.
-
Automated Continuous HubSpot Replication to MongoDB
Use CData Sync for automated, continuous, customizable HubSpot replication to MongoDB.
-
Search External Guru Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Guru data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Guru Data objects that you can access from apps and the dashboard.
-
How to Work with DB2 Data in ETL Validator JDBC
Connect to DB2 from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Hugging Face Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Hugging Face replication to AlloyDB.
-
Access Live RabbitMQ Data in AWS Lambda (with IntelliJ IDEA)
Connect to live RabbitMQ data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Power BI Connector for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Adobe Experience Manager.
-
How to connect and process Redshift data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Redshift data.
-
Stream Pinecone Data into Apache Kafka Topics
Access and stream Pinecone data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
View Reports on Real-Time Avalara AvaTax Data in Power BI Report Server
Use the CData ODBC Driver for Avalara AvaTax to visualize Avalara AvaTax data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live HubSpot Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live HubSpot data securely in real time.
-
Automate Demio Data Replication to Couchbase
Use CData Sync to Customize and automate Demio data replication to Couchbase.
-
Integrate Live Gmail Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Gmail from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Gmail data.
-
How to Query Live Azure Analysis Services Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Analysis Services data data in natural language using Python.
-
How to use SQLAlchemy ORM to access SAP Netweaver Gateway Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Netweaver Gateway data.
-
Connect to Redis Data in DBeaver
Use the CData ODBC Driver to connect to Redis data in DBeaver.
-
Query Live Avro 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 Avro data through a conversational interface.
-
Integrate Jira Assets with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jira Assets with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Jira Assets data.
-
How to Connect to Live Google Ads Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Ads data without replication.
-
Analyze MariaDB Data in Cognos Analytics
Use CData Connect AI to connect to MariaDB Data from Cognos Analytics and analyze live MariaDB data.
-
Build Salesforce Pardot-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesforce Pardot data and build Salesforce Pardot-connected web apps with Axios.
-
DataBind Controls to Azure Synapse Data in C++Builder
DataBind to Azure Synapse data in C++Builder with standard components and controls.
-
Getting Started with the CData Excel Add-In for Aircall
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Aircall.
-
How to Access Live Zoho Inventory Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Inventory enables you to integrate Zoho Inventory data into workflows built using Microsoft Power Automate Desktop.
-
Visualize CloudConvert Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load CloudConvert data into TIBCO Spotfire.
-
Query MongoDB Data in DataGrip
Create a Data Source for MongoDB in DataGrip and use SQL to query live MongoDB data.
-
Automated Continuous BigCommerce Replication to MongoDB
Use CData Sync for automated, continuous, customizable BigCommerce replication to MongoDB.
-
Create Apps from Zoho Inventory Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zoho Inventory Data and build apps from live Zoho Inventory data in Qlik Sense Cloud.
-
Integrate Trae with Live JSON Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live JSON services from within the AI-powered IDE.
-
Integrate Azure Synapse Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Synapse data from Informatica Cloud.
-
How to Seamlessly Import Aha! Data into IBM SPSS Modeler
Integrate Aha! data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Configure the CData JDBC Driver for ZeroBounce in a Connection Pool in Tomcat
Connect to ZeroBounce data from a connection pool in Tomcat.
-
Visualize SendInBlue Data in TIBCO Spotfire through ADO.NET
Integrate SendInBlue data into dashboards in TIBCO Spotfire.
-
Use Agno to Talk to Your ZohoDesk 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 ZohoDesk data for you.
-
Connect to SAP Netweaver Gateway Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Netweaver Gateway data in Google Apps Script.
-
Create Apps from Freshservice Data in Qlik Sense Cloud
Use CData Connect AI to connect to Freshservice Data and build apps from live Freshservice data in Qlik Sense Cloud.
-
Visualize Live SAS xpt Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAS xpt data into custom reports in Power BI.
-
Integrating LangGraph with Shopify Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Shopify data within automated workflows.
-
Use Biml to Build SSIS Tasks to Replicate ConvertAPI Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ConvertAPI data to SQL Server.
-
Integrating OpenCode 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.
-
Object-Relational Mapping (ORM) with Perplexity Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Perplexity data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Everhour Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Everhour replication to delimited files (CSV/TSV).
-
How to Connect to Live SuiteCRM 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 SuiteCRM data for you.
-
Connect to Missive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Missive data in the Denodo Virtual DataPort Administrator.
-
Edit and Search External Email Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Email data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Email Data objects that you can access from apps and the dashboard.
-
Consume SAP SuccessFactors LMS OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP SuccessFactors LMS feeds that reflect any changes in SAP Lumira.
-
DataBind Charts to Rootly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Rootly 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.
-
A PostgreSQL Interface for Oracle Service Cloud Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Service Cloud ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple Chargebee Accounts
Replicate multiple Chargebee accounts to one or many databases.
-
Use the CData Software ODBC Driver for HelloSign in MicroStrategy Web
Connect to HelloSign data in MicroStrategy Web using the CData Software ODBC Driver for HelloSign.
-
Integrating LangChain with Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Smartsheet data within automated workflows.