CData Software - Knowledge Base
Recent Articles
-
Connecting Mastra with Amazon Athena Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Amazon Athena data, no replication required.
-
Publish Bugsnag-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bugsnag data.
-
Query Live Instagram 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 Instagram data directly from the development environment.
-
DataBind Controls to SageHR Data in C++Builder
DataBind to SageHR data in C++Builder with standard components and controls.
-
How to Seamlessly Import Oracle Eloqua Reporting Data into IBM SPSS Modeler
Integrate Oracle Eloqua Reporting data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AI/ML Models with Live Cosmos DB Data using Dataiku
Connect Cosmos DB Data with Dataiku using the CData JDBC Driver for Cosmos DB.
-
How to Visualize Basecamp Data in Python with pandas
Use pandas and other modules to analyze and visualize live Basecamp data in Python.
-
Access Live REST Data in AWS Lambda
Connect to live REST data in AWS Lambda using the CData JDBC Driver.
-
A PostgreSQL Interface for Freshteam Data (MySQL Remoting via JDBC)
Use the Remoting features of the Freshteam JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Asana Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Asana data into custom reports in Power BI.
-
Publish Reports with QuickBooks Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Online data.
-
Connect to Copper Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Copper data using standard SQL.
-
How to Connect to Live Trello Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Trello data for you.
-
Build Dynamics 365-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Dynamics 365 data and build Dynamics 365-connected web apps with Axios.
-
Create Power BI Reports on Real-Time CapsuleCRM Data
Use the CData ODBC Driver for CapsuleCRM to visualize CapsuleCRM data in Power BI Desktop.
-
How to Work with Sendwithus Data in ETL Validator JDBC
Connect to Sendwithus from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live Oracle Sales Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Sales Data in CData Connect AI and connect to your Oracle Sales data from MicroStrategy.
-
Automated Continuous HDFS Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HDFS replication to Amazon S3.
-
Getting Started with the CData Tableau Connector for Apify
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create FreshBooks-Connected Applications in Appsmith
Connect to FreshBooks Data via CData Connect AI in Appsmith and create custom business applications with real-time access to FreshBooks data.
-
Connecting Agentforce with Google Calendar Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google Calendar data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft Ads
Create Microsoft Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Prepare, Blend, and Analyze SAP Fieldglass Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Fieldglass data for self-service data analytics.
-
Automated Continuous IBM Informix Replication to SQL Server
Use CData Sync for automated, continuous, customizable IBM Informix replication to SQL Server.
-
How to Connect to Live MongoDB Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your MongoDB data for you.
-
Analyze HCL Domino Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HCL Domino data with the CData JDBC Driver for HCL Domino.
-
Validate REST Data with QuerySurge
Access and validate REST data in QuerySurge using the CData JDBC Driver.
-
Seamlessly Bring Google Ad Manager Data into Retool Using CData Connect AI
Integrate Google Ad Manager data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Validate Zoho Books Data with QuerySurge
Access and validate Zoho Books data in QuerySurge using the CData JDBC Driver.
-
Build MVC Applications with Connectivity to Webex Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Webex from an ASP.NET MVC application.
-
Integrate Google's Antigravity Agent with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Klaviyo data using the Model Context Protocol.
-
Prepare, Blend, and Analyze Phoenix Data in Alteryx Designer (ODBC)
Build workflows to access live Phoenix data for self-service data analytics.
-
Integrate Superchat with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Superchat with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Superchat data.
-
Connect to Real-Time Asana Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Asana and Dataflow to import and use Asana data in Power Apps.
-
How to Connect to MySQL Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MySQL data. Leverage the pyodbc module for ODBC in Python.
-
Build Paymo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Paymo data.
-
Natively Connect to Zoho Inventory Data in PHP
The CData ODBC driver for Zoho Inventory enables you to create PHP applications with connectivity to Zoho Inventory data. Leverage the native support for ODBC in PHP.
-
Connect to and Visualize Live Active Directory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Active Directory data.
-
Bind Live IBM Cloud Object Storage Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live IBM Cloud Object Storage data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Use the CData ODBC Driver for Redshift from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Redshift to connect to Redshift data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Redshift data in Excel.
-
Connect to and Query Azure Synapse Data in QlikView over ODBC
Create data visualizations with Azure Synapse data in QlikView.
-
Create Data Visualizations in Cognos BI with Couchbase Data
Access Couchbase data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous ConvertKit Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ConvertKit replication to PostgreSQL.
-
Connect to Gumroad Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Gumroad.
-
Build Data Flows from Adobe Commerce to SQL Server using SSIS
Easily back up Adobe Commerce data to SQL Server using the SSIS components for Adobe Commerce.
-
Integrating Codex with SAP Hybris C4C 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.
-
Automate Codat Data Replication to Couchbase
Use CData Sync to Customize and automate Codat data replication to Couchbase.
-
How to Connect to Live Bright Data Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Bright Data data for you.
-
Automate Mailjet Data Replication to Couchbase
Use CData Sync to Customize and automate Mailjet data replication to Couchbase.
-
Create Informatica Mappings From/To an ODBC Data Source for Pipeline CRM
Create an ODBC connection to Pipeline CRM in Informatica and browse and transfer Pipeline CRM data.
-
Build JSON-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 JSON services without replication.
-
Launch the CData Sync Azure VM on Microsoft Azure
Host the Windows edition of CData Sync on Microsoft Azure using the CData Sync Azure VM.
-
Connecting Moonlit Workflow with Redis 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 Redis data in real time.
-
Validate PostgreSQL Data with QuerySurge
Access and validate PostgreSQL data in QuerySurge using the CData JDBC Driver.
-
Connect to ShipEngine Data in DBArtisan
Use wizards in DBArtisan to configure ShipEngine data as a data source.
-
How to Connect the Power BI Service to BenchmarkEmail: Complete Guide
Connect to the CData Software Power BI Connector for BenchmarkEmail from PowerBI.com to provide real-time BenchmarkEmail data across the organization.
-
Integrating LlamaIndex with Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Asana data in real time.
-
Create Dashboards and Visualize Live LDAP Objects in Geckoboard
Use CData Connect AI to connect to live LDAP objects and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect to Live Oracle 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 Oracle data without replication.
-
Query Pipeliner CRM Data in DataGrip
Create a Data Source for Pipeliner CRM in DataGrip and use SQL to query live Pipeliner CRM data.
-
Connect to Smartsheet Data in Google Apps Script via Connect AI
Use CData Connect AI to access Smartsheet data in Google Apps Script.
-
Getting Started with the CData Tableau Connector for Stripe
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Stripe.
-
Use Manus AI to Talk to Your MailerLite 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 MailerLite data.
-
Automated Continuous Short.io Replication to MySQL
Use CData Sync for automated, continuous, customizable Short.io replication to MySQL.
-
How to work with Google Forms Data in Apache Spark using SQL
Access and process Google Forms Data in Apache Spark using the CData Software JDBC Driver.
-
Rapidly Develop Active Directory-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Active Directory.
-
Query Live NetSuite 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 NetSuite data directly from the development environment.
-
Prepare, Blend, and Analyze Miro Data in Alteryx Designer (ODBC)
Build workflows to access live Miro data for self-service data analytics.
-
Model Sybase IQ Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sybase IQ, enabling the direct import of real-time Sybase IQ data.
-
Build a Singer.io Tap for PolarTeamPro With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PolarTeamPro data using the CData Python Connector.
-
Choosing the Best Method to Connect Teamgate to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Teamgate data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect SharePoint with Parquet Data through external lists
Provide Parquet data to SharePoint users as an external list.
-
How to Create Power BI Visual Reports with Real-Time CockroachDB Data
Use CData Power BI Connectors to visualize CockroachDB data in Power BI.
-
Query Mailjet Data in DataGrip
Create a Data Source for Mailjet in DataGrip and use SQL to query live Mailjet data.
-
Automated Continuous PabblySubscriptions Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to PostgreSQL.
-
How to Access Live Excel Online Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Excel Online enables you to integrate Excel Online data into workflows built using Microsoft Power Automate Desktop.
-
Automate Retently Data Replication to SAP HANA
Use CData Sync to customize and automate Retently data replication to SAP HANA.
-
Use CData Connect AI to Access Elasticsearch Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Elasticsearch data in the Power Pivot business intelligence tool.
-
Moving Data from Shopify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Shopify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Edit and Search External DB2 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of DB2 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create DB2 Data objects that you can access from apps and the dashboard.
-
Use the CData Software ODBC Driver for ClickUp in MicroStrategy
Connect to ClickUp data in MicroStrategy Developer using the CData Software ODBC Driver for ClickUp.
-
Automated Continuous ZohoPeople Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoPeople data replication to OneLake in Microsoft Fabric.
-
Replicate Typeform Data to Multiple Databases
Replicate Typeform data to disparate databases with a point-and-click configuration.
-
Create SAP Concur-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Concur Data from OutSystems and build custom enterprise apps using live SAP Concur data.
-
Integrate Open WebUI with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Instagram data from within the chat interface.
-
Integrate Live Mailjet Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Mailjet from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Mailjet data.
-
Excel Spreadsheet Automation on PagerDuty Data with the QUERY Formula
Pull data from PagerDuty, automate spreadsheets, and more with the QUERY formula.
-
Connect to Campaigner Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Campaigner data.
-
How to connect to Redis Data from Spring Boot
Connect to Redis in a Spring Boot Application using the CData JDBC Driver for Redis
-
Publish Reports with Salesforce Pardot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce Pardot data.
-
How to Work with BenchmarkEmail Data in ETL Validator JDBC
Connect to BenchmarkEmail from ETL Validator jobs using the CData Software JDBC Driver.
-
Bridge Box Connectivity with Apache NiFi
Access and process Box data in Apache NiFi using the CData JDBC Driver.
-
Integrate Cursor with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP SuccessFactors LMS data from within the editor.
-
Connect to LDAP Objects in DBArtisan
Use wizards in DBArtisan to configure LDAP objects as a data source.
-
Use Grok to Talk to Your WordPress 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 WordPress data for you.
-
Build AI/ML Models with Live SAP Netweaver Gateway Data using Dataiku
Connect SAP Netweaver Gateway Data with Dataiku using the CData JDBC Driver for SAP Netweaver Gateway.
-
How to connect PolyBase to PhantomBuster
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PhantomBuster data.
-
Connect to QuickBooks Online Data from HeidiSQL
Use CData Connect AI to connect to and query live QuickBooks Online data from HeidiSQL.
-
How to Visualize Phoenix 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 Phoenix data in Python.
-
Import and Visualize HubSpot Data in Power View
Create data visualizations based on HubSpot data in Excel.