CData Software - Knowledge Base
Recent Articles
-
How to Connect Flowise AI Agents to Live SAP ByDesign via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
A PostgreSQL Interface for Office 365 (MySQL Remoting via JDBC)
Use the Remoting features of the Office 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Square with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Square from Power Pivot. You will use the Table Import Wizard to load Square. You can visually build the import query or use any SQL supported by the driver.
-
Consume Microsoft OneDrive OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft OneDrive as OData feeds from PowerBuilder using the API Server.
-
Connect to PayPal in Google Apps Script via Connect AI
Use CData Connect AI to access PayPal in Google Apps Script.
-
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.
-
LINQ to SQL Analysis Services
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 SQL Analysis Services Data Provider.
-
Connect to BigCommerce from Asprova with CData Software ODBC Driver for BigCommerce
This article shows how to connect faster to BigCommerce data from Asprova.
-
How to Work with GraphQL in ETL Validator JDBC
Connect to GraphQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Twilio from Asprova with CData Software ODBC Driver for Twilio
This article shows how to connect faster to Twilio data from Asprova.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Asana using the Model Context Protocol.
-
Analyze Zoho Inventory in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho Inventory in Microsoft R Open.
-
Load SAP Netweaver Gateway to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Netweaver Gateway to a database.
-
Automated Continuous eBay Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable eBay replication to Azure SQL Database.
-
Bidirectional Access to Wave Financial from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Wave Financial in Filemaker Pro for Mac or Windows.
-
Load Spark to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Spark SQL to a database.
-
Import Facebook Using Azure Data Factory
Use CData Connect AI to connect to Facebook from Azure Data Factory and import live Facebook.
-
Automated Continuous JotForm Replication to Amazon S3
Use CData Sync for automated, continuous, customizable JotForm replication to Amazon S3.
-
Access MailChimp from MySQL in Amazon QuickSight
Connect to MailChimp and build visualizations of MailChimp using a MySQL Connection in Amazon QuickSight.
-
Migrating data from Dynamics 365 Business Central to Databricks using CData SSIS Components.
Easily push Dynamics 365 Business Central to Databricks using the CData SSIS Tasks for Dynamics 365 Business Central and Databricks.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live IBM Informix within intelligent workflows.
-
How to Query Live Avalara AvaTax Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Avalara AvaTax data in natural language using Python.
-
Integrate with Office 365 in JReport Designer
Create charts and reports based on Microsoft Office 365 in JReport Designer.
-
Edit and Search Square External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Square to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Square objects that you can access from apps and the dashboard.
-
Automated Continuous DB2 Replication to Databricks
Use CData Sync for automated, continuous, customizable DB2 replication to Databricks.
-
Automated Continuous Reckon Accounts Hosted Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to PostgreSQL.
-
How to Connect to Live Trello Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Trello securely in real time.
-
Use JayDeBeApi to access Sage Intacct in Python
Use standard Python scripting and the development environment of your choice to access live Sage Intacct.
-
Bridge SAP Connectivity with Apache NiFi
Access and process SAP ERP/NetWeaver in Apache NiFi using the CData JDBC Driver.
-
Build MVC Applications with Connectivity to Amazon Marketplace
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon Marketplace from an ASP.NET MVC application.
-
Connecting Agentforce with Azure Analysis Services 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 Azure Analysis Services for you.
-
Build AI/ML Models with Live Google Directory Data using Dataiku
-