CData Software - Knowledge Base
Recent Articles
-
Integrate Google's Vertex AI Agent with Live Confluence 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 Confluence data within intelligent workflows.
-
Automate Planio Data Replication to Azure Synapse
Use CData Sync to customize and automate Planio data replication to Azure Synapse.
-
Integrating Claude Code CLI with Omnisend 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.
-
Provide OData Services of Unbounce Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Unbounce data by developing a WCF Service Application.
-
Access Live Sybase Data in AWS Lambda
Connect to live Sybase data in AWS Lambda using the CData JDBC Driver.
-
Visualize Discourse Data in Sisense
Create an ElastiCube in Sisense app with access to Discourse data.
-
Connect to Elasticsearch from Asprova with CData Software ODBC Driver for Elasticsearch
This article shows how to connect faster to Elasticsearch data from Asprova.
-
Integrate Live MailerLite Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MailerLite data and integrate live MailerLite data into apps built in Microsoft Power Apps.
-
How to Query Live Close Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Close data data in natural language using Python.
-
Analyze Airtable Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Airtable data in Microsoft R Open.
-
Build Semantic Layer Views for SendPulse Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SendPulse data.
-
Automated Continuous Zoom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoom replication to Azure SQL Database.
-
Automated Continuous BenchmarkEmail Replication to Snowflake
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Snowflake.
-
Integrate Autopilot Data in the Pentaho Report Designer
Publish reports based on Autopilot data in the Pentaho BI tool.
-
Create Copper Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Copper from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Reports with Rootly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rootly data.
-
Connect to PayPal 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 PayPal data.
-
Use the CData Software ODBC Driver for Unbounce in MicroStrategy Desktop
Connect to Unbounce data in MicroStrategy Desktop using the CData Software ODBC Driver for Unbounce.
-
Integrate Lakebase Data in the Pentaho Report Designer
Publish reports based on Lakebase data in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Oracle Sales in MicroStrategy Desktop
Connect to Oracle Sales data in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle Sales.
-
Manage Twilio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Twilio.
-
How to Build an ETL App for SAP Business One Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Business One data in Python with petl.
-
Automated Continuous SAP HANA XS Advanced Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Amazon S3.
-
Search External SparkPost Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SparkPost data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SparkPost Data objects that you can access from apps and the dashboard.
-
How to connect PolyBase to Rootly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Rootly data.
-
Create Reports with Sage Intacct Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage Intacct data.
-
How to integrate Metabase with Databricks Data
Use CData Connect AI to connect to live Databricks data and create an interactive dashboard in Metabase from Databricks data.
-
Query Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data through a conversational interface.
-
Automate Contentful Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Contentful data from PowerShell? This article demonstrates how to utilize the Contentful Cmdlets for tasks like connecting to Contentful data, automating operations, downloading data, and more.
-
Access Live Jumpseller 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 Jumpseller data through MCP integration.
-
Connect to Egnyte Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Egnyte as an External Source in Dremio.
-
Use JayDeBeApi to access Excel Online Data in Python
Use standard Python scripting and the development environment of your choice to access live Excel Online data.
-
Access Live SQL Analysis Services Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SQL Analysis Services data from your Google Sheets.
-
Connect to Quickbase Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Quickbase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build a PostgreSQL Interface for eBay Data using the CData JDBC Driver
Use the Remoting features of the eBay JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Attio Data in Alteryx Designer (Connect AI)
Build workflows to access live Attio data for self-service data analytics.
-
Build Charts with Sugar CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Sugar CRM data in Clear Analytics.
-
A Feature Comparison of Drivers for NoSQL
An article comparing the available features and functionality of CData Software Drivers for MongoDB.
-
Use Dash to Build to Web Apps on Avro Data
Create Python applications that use pandas and Dash to build Avro-connected web apps.
-
Excel Spreadsheet Automation on Zoho Recruit Data with the QUERY Formula
Pull data from Zoho Recruit, automate spreadsheets, and more with the QUERY formula.
-
Replicate Vault CRM Data to Multiple Databases
Replicate Vault CRM data to disparate databases with a point-and-click configuration.
-
Integrate with Dropbox Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dropbox data to a JSON file on disk.
-
Create SSAS Tabular Models from Keap Data
How to build a SQL Server Analysis Service Tabular Model from Keap data using CData drivers.
-
DataBind Controls to Dynamics CRM Data in C++Builder
DataBind to Dynamics CRM data in C++Builder with standard components and controls.
-
Deploy the ADO.NET Provider for Insightly on an SSRS Report Server
Connect to Insightly data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automate LaunchDarkly Data Replication to Azure Synapse
Use CData Sync to customize and automate LaunchDarkly data replication to Azure Synapse.
-
Integrating Antigravity CLI with Sage 300 data via CData CLI
Connect Sage 300 data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query, Visualize, and Share live Apollo Data in Redash
Use CData Connect AI to connect to live Apollo data in Redash for querying, visualizing, and sharing.
-
Use Claude to Talk to Your DB2 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 DB2 data for you.
-
Query SAP Hybris C4C Data in DataGrip
Create a Data Source for SAP Hybris C4C in DataGrip and use SQL to query live SAP Hybris C4C data.
-
Use the CData SSIS Components to Insert New or Update Existing SuiteCRM Records from SQL Server
Easily push SQL Server data to SuiteCRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SuiteCRM or update existing records with data from a SQL Server database.
-
Build an OLAP Cube in SSAS from Hacker News Data
Establish a connection to Hacker News data data from SQL Server Analysis Services, and use the Hacker News Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Workable 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 Workable and work with Workable data in your FileMaker application.
-
Build Agents in Relevance AI with Access to Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft OneDrive data within intelligent agent workflows.
-
Connect to Dropbox Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Dropbox Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Sybase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sybase replication to SQL Server.
-
Create Google Sheets-Connected Nintex Workflows
Use CData Connect AI to connect to Google Sheets Data from Nintex Workflow Cloud and build custom workflows using live Google Sheets data.
-
Connecting Moonlit Workflow with LinkedIn 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 LinkedIn data in real time.
-
Connect to GetResponse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GetResponse to connect to GetResponse data and execute queries in PowerBuilder.
-
How to Easily Query WordPress Data in OpenOffice Base
Connect to WordPress data in OpenOffice Base using the CData ODBC Driver for WordPress and generate reports with live data insights.
-
How to connect and process SAP Hybris C4C data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Hybris C4C data.
-
Connect to Oracle Financials Cloud Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Financials Cloud to connect to Oracle Financials Cloud data and execute queries in PowerBuilder.
-
Access OnePageCrm Data from MySQL in Amazon QuickSight
Connect to OnePageCrm and build visualizations of OnePageCrm data using a MySQL Connection in Amazon QuickSight.
-
Use Grok to Talk to Your Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Exa data for you.
-
Prepare, Blend, and Analyze Raisers Edge NXT Data in Alteryx Designer (ODBC)
Build workflows to access live Raisers Edge NXT data for self-service data analytics.
-
Integrate LibreChat with Live Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Freshteam data from within the chat interface.
-
Integrating LangChain with Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoho Projects data within automated workflows.
-
Migrating data from Jira to Databricks using CData SSIS Components.
Easily push Jira data to Databricks using the CData SSIS Tasks for Jira and Databricks.
-
Getting Started with the CData SSIS Components for Google Directory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Directory.
-
Automated Continuous Notion Replication to Oracle
Use CData Sync for automated, continuous, customizable Notion replication to Oracle.
-
Natively Connect to Paymo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Paymo data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for BigQuery in MicroStrategy Desktop
Connect to BigQuery data in MicroStrategy Desktop using the CData Software JDBC Driver for BigQuery.
-
Connect to Pingdom Data in CloverDX (formerly CloverETL)
Transfer Pingdom data using the visual workflow in the CloverDX data integration tool.
-
Viewing Pipeline CRM Data in RAD Studio Data Explorer
How to view Pipeline CRM data in RAD Studio Data Explorer using the CData ODBC Driver for Pipeline CRM.
-
Query Azure Synapse Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure Synapse entities in PHP by modeling them as objects.
-
Create Reports with TigerGraph Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date TigerGraph data.
-
Bridge NetSuite Connectivity with Apache NiFi
Access and process NetSuite data in Apache NiFi using the CData JDBC Driver.
-
Create Act CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Act CRM Data from Nintex Workflow Cloud and build custom workflows using live Act CRM data.
-
Build Azure Analysis Services-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Azure Analysis Services Data and create custom apps in Bubble.
-
LINQ to PingOne 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 PingOne Data Provider.
-
How to Connect to Live MongoDB 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 MongoDB data for you.
-
Integrate Workable Data in the Pentaho Report Designer
Publish reports based on Workable data in the Pentaho BI tool.
-
DataBind Charts to FHIR Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FHIR 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.
-
Build Testmonitor-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Testmonitor Data and create custom apps in Mendix.
-
Publish Google Campaign Manager 360-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Campaign Manager 360 data.
-
Integrate Theia IDE with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Okta data from within the development environment.
-
How to Connect to Live Instagram 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 Instagram data without replication.
-
DataBind Controls to Shippo Data in C++Builder
DataBind to Shippo data in C++Builder with standard components and controls.
-
Access Live Azure Analysis Services Data in AWS Lambda
Connect to live Azure Analysis Services data in AWS Lambda using the CData JDBC Driver.
-
Build Dashboards with Perplexity Data in Dundas BI
Create dynamic dashboards and perform analytics based on Perplexity data in Dundas BI.
-
Replicate PabblySubscriptions Data to Multiple Databases via the CData Sync CLI
Replicate PabblySubscriptions data to disparate databases with a single configuration.
-
Model, Search, and Visualize Live Omnisend Data in ThoughtSpot
Use CData Connect AI to connect to live Omnisend data for modeling, searching, and visualizing.
-
Integrating OpenCode with Kafka 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.
-
Build Apps with Live SingleStore Data Using the Low-Code Development Platform of Mendix
Connect SingleStore data with Mendix to build apps using the CData JDBC Driver for SingleStore.
-
Connect to Quickbase Data in Claris FileMaker Pro
Use the CData ODBC Driver for Quickbase in FileMaker Pro to connect to Quickbase and work with Quickbase data in your FileMaker applications.
-
Edit and Search External PostgreSQL Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of PostgreSQL data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PostgreSQL Data objects that you can access from apps and the dashboard.
-
Access Live Simplesat Data in Coginiti Pro
Connect to and query live Simplesat data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Choosing the Best Method to Connect ZohoDesk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoDesk data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Bitbucket Data Replication to Azure Synapse
Use CData Sync to customize and automate Bitbucket data replication to Azure Synapse.
-
Visualize Bitly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bitly data.