CData Software - Knowledge Base
Recent Articles
-
Access SQL Server from MySQL in Amazon QuickSight
Connect to SQL Server and build visualizations of Microsoft SQL Server using a MySQL Connection in Amazon QuickSight.
-
Edit and Search Trello External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Trello to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Trello objects that you can access from apps and the dashboard.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Planner
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Planner.
-
Connect to Workday in JRuby
Create a simple JRuby app with access to live Workday.
-
Analyze Monday.com in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Monday.com and visualize Monday.com in SAP Analytics Cloud.
-
Use the CData SSIS Components to Insert New or Update Existing WooCommerce Records from SQL Server
Easily push SQL Server data to WooCommerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into WooCommerce or update existing records with data from a SQL Server database.
-
Building Dynamic Web Pages with Neo4J Using AngularJS
Create single-page applications with live connectivity to Neo4J using the CData API Server.
-
Build PayPal-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live PayPal and build PayPal-connected web apps with Axios.
-
Integrate QuickBooks with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks Desktop.
-
Build Agents in Relevance AI with Access to Live Microsoft Planner via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Planner within intelligent agent workflows.
-
DataBind Charts to Xero
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Xero Accounting 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.
-
Integrate Cursor with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live NetSuite CRM & ERP from within the editor.
-
Integrate with Sybase IQ using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sybase IQ to a JSON file on disk.
-
Use Agno to Talk to Your Bullhorn CRM 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 Bullhorn CRM for you.
-
Use the CData Software ODBC Driver for Teradata in MicroStrategy
Connect to Teradata in MicroStrategy Developer using the CData Software ODBC Driver for Teradata.
-
Build an OLAP Cube in SSAS from Okta
Establish a connection to Okta data from SQL Server Analysis Services, and use the Okta Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import and Visualize IBM Cloud Object Storage in Power View
Create data visualizations based on IBM Cloud Object Storage in Excel.
-
How to Connect to Live NetSuite 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 NetSuite CRM & ERP for you.
-
Build an OLAP Cube in SSAS from QuickBooks Time
Establish a connection to QuickBooks Time data from SQL Server Analysis Services, and use the QuickBooks Time Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Bullhorn CRM to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bullhorn CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Explore Geographical Relationships in Adobe Target with Power Map
Create data visualizations with Adobe Target in Power Map.
-
Connect to Adobe Commerce in Ruby
Connect to Adobe Commerce in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live PingOne in AWS Lambda (with IntelliJ IDEA)
Connect to live PingOne in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live CockroachDB of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CockroachDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build HBase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache HBase.
-
Replicate Multiple MYOB AccountRight Accounts
Replicate multiple MYOB AccountRight accounts to one or many databases.
-
Connect to PingOne from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PingOne using standard SQL.
-
How to Connect to Live MailChimp 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 MailChimp for you.
-
Build a PostgreSQL Interface for Office 365 using the CData JDBC Driver
Use the Remoting features of the Office 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Couchbase from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Couchbase from Filemaker Pro on Mac.
-
Connecting Mastra with Airtable 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 data across hundreds of enterprise sources no replication required.
-
Build a PostgreSQL Interface for SAP Hybris C4C using the CData JDBC Driver
Use the Remoting features of the SAP Hybris C4C JDBC Driver to create a PostgreSQL entry-point for data access.
-
Seamlessly Bring Bullhorn CRM into Retool Using CData Connect AI
Integrate Bullhorn CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Acumatica Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Acumatica replication to Google Cloud SQL.
-
Build Pipelines with Live Epicor Kinetic in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Epicor Kinetic from Google Cloud Data Fusion, enabling the integration of live Epicor Kinetic into the building and management of effective data pipelines.
-
DataBind Charts to Dynamics CRM
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Dynamics CRM 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.
-
Connecting Mastra with MySQL 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 data across hundreds of enterprise sources no replication required.
-
Visualize Oracle Eloqua in TIBCO Spotfire through ADO.NET
Integrate Oracle Eloqua into dashboards in TIBCO Spotfire.
-
Access Live Instagram 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 Instagram through MCP integration.
-
Analyze Adobe Experience Manager in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Adobe Experience Manager in Microsoft R Open.
-
Use the CData ODBC Driver for Parquet in Microsoft Power Query
You can use the CData Parquet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Parquet into Microsoft Power Query.
-
Build Semantic Layer Views for Sage 200 in APOS Live Data Gateway
Use the CData Connector for Sage 200 in APOS Live Data Gateway to build Semantic Layer Views for Sage 200.
-
Publish Sage 300-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sage 300.
-
Visualize SAP SuccessFactors from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP SuccessFactors.
-
Using the CData Software ODBC Driver for Aha! in PyCharm
Connect to Aha! as an ODBC data source in PyCharm using the CData Software ODBC Driver for Aha!.
-
Integrate OneNote into Power Automate Desktop using CData Connect
CData Connect for OneNote enables you to integrate Microsoft OneNote into workflows built using Microsoft Power Automate Desktop.
-
SharePoint Online: Microsoft IDCRL Authentication Deprecation (SOAP Schema)
IDCRL retirement impacts SharePoint Online SOAP Schema users. Migrate to REST Schema or apply a temporary extension.
-
Build Apps with Live SurveyMonkey in Adalo using CData Connect AI
Use CData Connect AI to integrate live SurveyMonkey into the Adalo platform and build custom mobile and web applications with real-time SurveyMonkey.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Use Biml to Build SSIS Tasks to Replicate Google Drive to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Drive to SQL Server.
-
Create SSAS Tabular Models from Redshift
How to build a SQL Server Analysis Service Tabular Model from Amazon Redshift using CData drivers.
-
Create Google Contacts-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Contacts from OutSystems and build custom enterprise apps using live Google Contacts.
-
Getting Started with the CData Tableau Connector for Oracle
-