CData Software - Knowledge Base
Recent Articles
-
Bridge EnterpriseDB Connectivity with Apache NiFi
Access and process EnterpriseDB in Apache NiFi using the CData JDBC Driver.
-
How to connect PolyBase to ChartMogul
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ChartMogul.
-
Connect to Cassandra Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apache Cassandra.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Instantly
Provide connectivity to Instantly through an SAP BusinessObjects universe.
-
How to Access Live Microsoft Entra ID Data in Visual Studio Code via Cline
Run CData MCP Server for Microsoft Entra ID on Windows Subsytem for Linux (WSL) and connect to live Microsoft Entra ID from the Cline extension in Visual Studio Code.
-
Build Automated ActiveCampaign-Connected Workflows in Zapier
Use CData Connect AI to connect to live ActiveCampaign and build automated workflows in Zapier.
-
Integrate Live Cloudant Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to IBM Cloudant and integrate live IBM Cloudant into apps built in Microsoft Power Apps.
-
Automated Continuous Gorgias Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Gorgias replication to AlloyDB.
-
Build Dashboards with Dynamics 365 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Dynamics 365 in Dundas BI.
-
Visualize Live Sage Intacct Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sage Intacct using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Object-Relational Mapping (ORM) with SAP Ariba Source 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 SAP Ariba Source into a Java-based ORM framework, Hibernate.
-
Connect to Freshservice Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshservice to connect to Freshservice and execute queries in PowerBuilder.
-
Automate SharePoint Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft SharePoint and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build AI Agents with Act CRM 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 Act CRM through CData Connect AI.
-
Add Zuora Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zuora with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate Multiple Snapchat Ads Accounts
Replicate multiple Snapchat Ads accounts to one or many databases.
-
DataBind Controls to EnterpriseDB Data in Delphi
DataBind to EnterpriseDB in Delphi with standard data access components and controls.
-
Building Dynamic Web Pages with ServiceNow Data Using AngularJS
Create single-page applications with live connectivity to ServiceNow using the CData API Server.
-
Query ClickTime Data in ColdFusion
Write standard ColdFusion data access code to connect to ClickTime.
-
Access Live Facebook 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 Facebook through MCP integration.
-
How to work with JotForm Data in Apache Spark using SQL
Access and process JotForm Data in Apache Spark using the CData Software JDBC Driver.
-
Use Dash to Build Web Apps on Klaviyo Data via CData Connect AI
Build interactive Dash web apps on live Klaviyo using pandas and the CData Connect AI Python SDK.
-
Integrate Goose with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle Financials Cloud from within the local AI agent.
-
How to connect and process Paddle from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Paddle.
-
Extract, Transform, and Load Printify Data in Informatica PowerCenter
Create a simple Workflow for Printify in Informatica PowerCenter.
-
Connect to CouchDB Data from PowerBuilder via JDBC
This article demonstrates how to access Apache CouchDB from PowerBuilder using the CouchDB JDBC Driver.
-
Query Live Redis Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Redis directly from the development environment.
-
How to Connect to Live Salesforce 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 Salesforce & Force.com for you.
-
Connect to Microsoft Planner Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Planner from PowerBuilder using the Microsoft Planner JDBC Driver.
-
Build REST-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to REST and build web apps with connectivity to live REST.
-
Integrate GetResponse Data in the Pentaho Report Designer
Publish reports based on GetResponse in the Pentaho BI tool.
-
How to Connect to Live Facebook Ads Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Facebook Ads for you.
-
Build MVC Applications with Connectivity to MariaDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MariaDB from an ASP.NET MVC application.
-
Create Data Visualizations Based On Cloudant Data in Mode
Use CData Connect AI to connect to Cloudant Data from Mode and build visualizations using live
-
Getting Started with the CData Python Connector for DocuSign
Learn to install and license the CData Python Connector
-
Build Automated Workflows with Live Microsoft Dataverse Data in Workato
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build automated workflows in Workato.
-
Connect to CSV Data from a Connection Pool in JBoss
Integrate CSV/TSV Files into Java servlets: Use the Management Console in JBoss to install the CSV JDBC Driver.
-
Create Basecamp-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Basecamp Data from Klipfolio and build custom visualizations using live Basecamp.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesloft
Provide connectivity to Salesloft through an SAP BusinessObjects universe.
-
Connect and Query Live Google Campaign Manager 360 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Campaign Manager 360 into Databricks
-
Automated Continuous ZohoDesk Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoDesk replication to IBM DB2.
-
Integrating Boomi Agentstudio with Microsoft Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Ads, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Using the CData Software ODBC Driver for VWO in PyCharm
Connect to VWO as an ODBC data source in PyCharm using the CData Software ODBC Driver for VWO.
-
Access Avaza Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Avaza from your Oracle system.
-
Getting Started with the CData Connect AI Python SDK for Elasticsearch
Install the CData Connect AI Python SDK to read and write live Elasticsearch with standard DB-API 2.0 Python code.
-
Use the CData Software JDBC Driver for VWO in MicroStrategy Web
Connect to VWO in MicroStrategy Web using the CData Software JDBC Driver for VWO.
-
Connect to CapsuleCRM Data in DBArtisan
Use wizards in DBArtisan to configure CapsuleCRM as a data source.
-
Integrating GitHub Copilot CLI with Xero Accounting 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 FreeAgent Replication to SQLite
Use CData Sync for automated, continuous, customizable FreeAgent replication to SQLite.
-
Create Freshdesk-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Freshdesk Data from Klipfolio and build custom visualizations using live Freshdesk.
-
Integrate Live Avro Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Retently Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Retently from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import and Visualize Mailgun Data in Power View
Create data visualizations based on Mailgun in Excel.
-
Prepare, Blend, and Analyze AfterShip Data in Alteryx Designer (ODBC)
Build workflows to access live AfterShip for self-service data analytics.
-
Integrating Codex CLI with Moosend 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 a PostgreSQL Interface for FHIR Data using the CData JDBC Driver
Use the Remoting features of the FHIR JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Couchbase in MicroStrategy Desktop
Connect to Couchbase in MicroStrategy Desktop using the CData Software ODBC Driver for Couchbase.
-
Getting Started with the CData ODBC Driver for Cvent
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cvent.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for TigerGraph
Provide connectivity to TigerGraph through an SAP BusinessObjects universe.
-
Connect to SAP Business One Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Business One from PowerBuilder using the SAP Business One JDBC Driver.
-
How to Query Live AgileCRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live AgileCRM data in natural language using Python.
-
Build MVC Applications with Connectivity to Hive Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Hive from an ASP.NET MVC application.
-
Azure Analysis Services Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure Analysis Services through CData Connect AI using different applications and tools.
-
Publish AlloyDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google AlloyDB.
-
Use the CData ODBC Driver for ServiceNow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ServiceNow to connect to ServiceNow from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ServiceNow in Excel.
-
Visualize Google Cloud Storage Data in Sisense
Create an ElastiCube in Sisense app with access to Google Cloud Storage.
-
A PostgreSQL Interface for Elasticsearch Data (MySQL Remoting via JDBC)
Use the Remoting features of the Elasticsearch JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Adobe Experience Manager with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Adobe Experience Manager with External Services.
-
How to Seamlessly Import Auth0 Data into IBM SPSS Modeler
Integrate Auth0 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create SAP Netweaver Gateway-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Nintex Workflow Cloud and build custom workflows using live SAP Netweaver Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for Aha!
Create Aha! data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Live Power BI XMLA Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Power BI XMLA directly from the development environment.
-
Automated Continuous Azure Data Lake Storage Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Google Cloud SQL.
-
Integrate Google Drive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Drive from Informatica Cloud.
-
Integrating Cursor CLI with Azure Analysis Services 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 Agno to Talk to Your Zoho Projects 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 Zoho Projects for you.
-
Integrate with Facebook Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Facebook to a JSON file on disk.
-
Connect Wistia to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Wistia using the CData Python MCP Server.
-
Automate Oracle SCM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle SCM replication to Azure Data Lake.
-
Build Microsoft Teams-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Microsoft Teams Data from Zoho Analytics and import live Microsoft Teams.
-
Integrate with Cosmos DB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure Cosmos DB in SnapLogic.
-
Connect to Azure DevOps Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure DevOps from Crystal Reports.
-
Publish SendInBlue-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SendInBlue.
-
Automated Continuous Aircall Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Aircall replication to Azure SQL Database.
-
Connect to SurveyMonkey Data from Crystal Reports
Use CData Connect AI to connect to and report on live SurveyMonkey from Crystal Reports.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle
Provide connectivity to Oracle Database through an SAP BusinessObjects universe.
-
Integrating Kiro CLI with Google Calendar 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 Query Live PingOne Data in Perplexity MacOS Desktop
Connect to and query live PingOne Data in Perplexity Desktop using CData MCP Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HCL Domino
Provide connectivity to HCL Domino through an SAP BusinessObjects universe.
-
Publish Crystal Reports on Google Directory Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Directory.
-
Connect to Office 365 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Office 365 from Appeon PowerBuilder using the CData ADO.NET Provider for Office 365.
-
Integrate LibreChat with Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Table Storage from within the chat interface.
-
Create Mocean Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mocean data access from reports, embedded analytics, and more.
-
Connecting Moonlit Workflow with Kintone 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 Kintone in real time.
-
Analyze Cloudant Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of IBM Cloudant and visualize IBM Cloudant in SAP Analytics Cloud.
-
Viewing Slack Data in RAD Studio Data Explorer
How to view Slack in RAD Studio Data Explorer using the CData ODBC Driver for Slack.
-
How to integrate Harvest with Apache Airflow
Access and process Harvest in Apache Airflow using the CData JDBC Driver.
-
Integrating Antigravity CLI with Microsoft Office 365 via CData CLI
Connect Microsoft Office 365 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Datasets from SAP Business Warehouse in Domo Workbench and Build Visualizations of SAP Business Warehouse Data in Domo
Use the CData Software ODBC Driver for SAP Business Warehouse to create datasets from SAP Business Warehouse in Domo Workbench and then build visualizations in the Domo service.
-
Create Azure Analysis Services-Connected Nintex Workflows
Use CData Connect AI to connect to Azure Analysis Services Data from Nintex Workflow Cloud and build custom workflows using live Azure Analysis Services.