CData Software - Knowledge Base
Recent Articles
-
How to integrate SharePoint with Apache Airflow
Access and process SharePoint data in Apache Airflow using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for Cassandra in PyCharm
Connect to Cassandra as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cassandra.
-
Analyze Exa Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Exa data and visualize Exa data in SAP Analytics Cloud.
-
Connect to Google Tasks Data in DBArtisan
Use wizards in DBArtisan to configure Google Tasks data as a data source.
-
Integrate Cursor with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Facebook Ads data from within the editor.
-
Integrate SAP Ariba Source Data in the Pentaho Report Designer
Publish reports based on SAP Ariba Source data in the Pentaho BI tool.
-
Connect SharePoint to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SharePoint with IBM WebSphere for seamless data integration and connectivity.
-
Connect to eBay Data from PowerBuilder via ADO.NET
This article demonstrates how to access eBay data from Appeon PowerBuilder using the CData ADO.NET Provider for eBay.
-
Visualize Google Sheets Data in Tableau
The CData ODBC driver for Google Sheets enables you integrate Google Sheets data into Tableau dashboards.
-
How to connect to Dynamics CRM Data with Squirrel SQL client
Connect to Dynamics CRM data and execute queries in the Squirrel SQL Client.
-
Using the CData Software ODBC Driver for Webflow in PyCharm
Connect to Webflow as an ODBC data source in PyCharm using the CData Software ODBC Driver for Webflow.
-
Explore Geographical Relationships in Sage 300 Data with Power Map
Create data visualizations with Sage 300 data in Power Map.
-
Connect to EnterpriseDB in SpagoBI
Create reports featuring live EnterpriseDB data in SpagoBI Studio. Host EnterpriseDB reports on SpagoBI Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Everhour
Create an ODBC connection to Everhour in Informatica and browse and transfer Everhour data.
-
Replicate Multiple SAP HANA Accounts via the CData Sync CLI
Replicate multiple SAP HANA accounts to one or many databases.
-
Integrating OpenCode with Dynamics NAV 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 the CData Software JDBC Driver for DocuSign in MicroStrategy Web
Connect to DocuSign data in MicroStrategy Web using the CData Software JDBC Driver for DocuSign.
-
How to Connect DocuSign Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live DocuSign data in real time using natural language.
-
Create Power BI Reports on Real-Time Microsoft Entra ID Data
Use the CData ODBC Driver for Microsoft Entra ID to visualize Microsoft Entra ID data in Power BI Desktop.
-
Prepare, Blend, and Analyze Azure DevOps Data in Alteryx Designer (Connect AI)
Build workflows to access live Azure DevOps data for self-service data analytics.
-
Use ChatGPT to Talk to Your Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Aweber data for you.
-
Create AlloyDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for AlloyDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Acumatica Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Acumatica data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to WooCommerce Data in HULFT Integrate
Connect to WooCommerce as a JDBC data source in HULFT Integrate
-
Process & Analyze Office 365 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Office 365 Data.
-
Natively Connect to Everhour Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Everhour data. Leverage the native support for ODBC in PHP.
-
View Reports on Real-Time NASA Data in Power BI Report Server
Use the CData ODBC Driver for NASA to visualize NASA data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Cline with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Box data from within your IDE.
-
Build Apps with Live API data in Adalo using CData Connect AI
Use CData Connect AI to integrate live API data into the Adalo platform and build custom mobile and web applications with real-time API data.
-
Getting Started with the CData JDBC Driver for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for YouTube Analytics.
-
Create Excel Online-Connected Applications in Appsmith
Connect to Excel Online Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Excel Online data.
-
DataBind Charts to Aircall Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Aircall 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 Teradata to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Teradata data using the CData Python MCP Server.
-
Access Live Redis Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Redis data from your Excel spreadsheets.
-
Create Reports from Oracle Data in Looker Studio
Use CData Connect AI to gain access to live Oracle data and create custom reports in Looker Studio.
-
How to connect to NetSuite Data in DBVisualizer
Integrate NetSuite data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Microsoft Copilot Studio to talk to your Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Amazon DynamoDB data for you.
-
Query, Visualize, and Share live Stripe Data in Redash
Use CData Connect AI to connect to live Stripe data in Redash for querying, visualizing, and sharing.
-
Automated Continuous Google Sheets Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Sheets replication to Oracle.
-
Integrating Dataiku with SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Business Warehouse data.
-
Integrating LlamaIndex with Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Twitter Ads data in real time.
-
Integrate Samanage Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Samanage data from Informatica Cloud.
-
Analyze Parquet Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Parquet data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Datasets from Oracle Sales in Domo Workbench and Build Visualizations of Oracle Sales Data in Domo
Use the CData Software ODBC Driver for Oracle Sales to create datasets from Oracle Sales data in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Pipedrive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pipedrive data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Trae with Live Amazon S3 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Amazon S3 data from within the AI-powered IDE.
-
How to Connect Flowise AI Agents to Live Printify Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Printify data without replication.
-
How to Connect the Power BI Service to SAP Netweaver Gateway: Complete Guide
Connect to the CData Software Power BI Connector for SAP Netweaver Gateway from PowerBI.com to provide real-time SAP Netweaver Gateway data across the organization.
-
Automated Oracle Sales Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Sales data replication to Teradata.
-
Getting Started with the CData SSIS Components for Asana
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Asana.
-
Visualize Sendwithus Data in Sisense
Create an ElastiCube in Sisense app with access to Sendwithus data.
-
How to Access Live Basecamp Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Basecamp enables you to integrate Basecamp data into workflows built using Microsoft Power Automate Desktop.
-
Create Datasets from BambooHR in Domo Workbench and Build Visualizations of BambooHR Data in Domo
Use the CData Software ODBC Driver for BambooHR to create datasets from BambooHR data in Domo Workbench and then build visualizations in the Domo service.
-
Create PayPal-Connected Dashboards in Grafana
Connect to PayPal Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to PayPal data.
-
Integrate OpenCode with Live Shippo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Shippo data from within your AI coding agent.
-
Build Agents in Relevance AI with Access to Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ActiveCampaign data within intelligent agent workflows.
-
Use the CData Software JDBC Driver for Cloudant in MicroStrategy
Connect to Cloudant data in MicroStrategy Developer using the CData Software JDBC Driver for Cloudant.
-
Interact with Live Smartsheet Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Smartsheet data.
-
Connect to and Visualize Live Pingdom Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pingdom data.
-
Integrate Deel Data in the Pentaho Report Designer
Publish reports based on Deel data in the Pentaho BI tool.
-
How to connect and process Onfleet data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Onfleet data.
-
Connect to Nethunt Data from PowerBuilder via ADO.NET
This article demonstrates how to access Nethunt data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Back Up Parallel data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Parallel data data.
-
Connect Chargebee to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Chargebee data using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Power BI XMLA in MicroStrategy
Connect to Power BI XMLA data in MicroStrategy Developer using the CData Software ODBC Driver for Power BI XMLA.
-
Access Live Kintone Data in Excel 365 Online (Excel for the web)
Connect to Kintone data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft OneDrive
Provide connectivity to Microsoft OneDrive data through an SAP BusinessObjects universe.
-
Migrating data from Landbot to Snowflake using CData SSIS Components.
Easily push Landbot data to Snowflake using the CData SSIS Tasks for Landbot and Snowflake.
-
Build SAP ByDesign-Connected Apps in Choreo
Use CData Connect AI to connect to SAP ByDesign Data from Choreo and build custom apps using live SAP ByDesign data.
-
Publish Reports with MessageBird Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MessageBird data.
-
Back Up ZohoMarketingHub data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoMarketingHub data data.
-
Use the CData Software ODBC Driver for Mailgun in MicroStrategy Web
Connect to Mailgun data in MicroStrategy Web using the CData Software ODBC Driver for Mailgun.
-
Build SAP Business One-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Business One data.
-
Integrate Open WebUI with Live AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live AlloyDB data from within the chat interface.
-
Build Data Flows from Oracle Eloqua Reporting to SQL Server using SSIS
Easily back up Oracle Eloqua Reporting data to SQL Server using the SSIS components for Oracle Eloqua Reporting.
-
Integrating Kiro with Bright Data 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 publish and share Stack Exchange Data dashboards with Tableau Server
The CData ODBC driver for Stack Exchange enables you integrate Stack Exchange data into Tableau dashboards.
-
Use the CData Software ODBC Driver for Gorgias in MicroStrategy Desktop
Connect to Gorgias data in MicroStrategy Desktop using the CData Software ODBC Driver for Gorgias.
-
Write a Simple Go Application to work with Close Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Close data.
-
Connect to SharePoint from a Connection Pool in WebLogic
Use the CData JDBC Driver for SharePoint to connect to SharePoint data from Web applications running on WebLogic.
-
Query Acumatica Data as a MySQL Database in Node.js
Execute MySQL queries against Acumatica data from Node.js.
-
Query Live Bannerbear 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 Bannerbear data directly from the development environment.
-
Visualize YouTube Analytics Data in Sisense
Create an ElastiCube in Sisense app with access to YouTube Analytics data.
-
Publish Crystal Reports on Freshteam Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Freshteam data.
-
Link Zoho Recruit with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Recruit data in Filemaker Pro for Mac or Windows.
-
How to create LaunchDarkly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LaunchDarkly data in MySQL .
-
Integrate LibreChat with Live Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Typeform data from within the chat interface.
-
How to publish and share MailerLite Data dashboards with Tableau Server
The CData ODBC driver for MailerLite enables you integrate MailerLite data into Tableau dashboards.
-
Create Data Visualizations in Cognos BI with Pipeliner CRM Data
Access Pipeliner CRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Omnisend Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Omnisend replication to Azure SQL Database.
-
Integrate OpenCode with Live ServiceNow Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ServiceNow data from within your AI coding agent.
-
SAP HANA Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP HANA data through CData Connect AI using different applications and tools.
-
Integrating Dataiku with Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Instagram data.
-
Use Databricks Agent Bricks to Talk to Your Freshservice Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Freshservice data for you.
-
Excel Spreadsheet Automation on Tavily Data with the QUERY Formula
Pull data from Tavily, automate spreadsheets, and more with the QUERY formula.
-
Analyze JSON Services in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of JSON services and visualize JSON services in SAP Analytics Cloud.
-
Integrating Dataiku with HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live HBase data.
-
Use Manus AI to Talk to Your PayPal 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 PayPal data.
-
Integrate Live PayPal Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to PayPal from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live PayPal data.
-
Connect Twilio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Twilio data using the CData Python MCP Server.