CData Software - Knowledge Base
Recent Articles
-
Connect to Drift in Google Apps Script via SQL Gateway
Use the ODBC Driver for Drift and the SQL Gateway to access Drift from Google Apps Script.
-
Integrate Cursor with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle HCM Cloud from within the editor.
-
Create Apps from Oracle SCM in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle SCM and build apps from live Oracle SCM in Qlik Sense Cloud.
-
Use the CData API Server to Access Dynamics 365 in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Dynamics 365 in the Power Pivot business intelligence tool.
-
Build a Simple VCL Application for REST
How to build a simple VCL Application to view REST in RAD Studio using the CData ODBC Driver for REST.
-
Import Real-Time LDAP Objects via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LDAP in ColdFusion.
-
Replicate AlloyDB to Multiple Databases
Replicate Google AlloyDB to disparate databases with a point-and-click configuration.
-
Query REST using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume REST entities in PHP by modeling them as objects.
-
Load Google Ads to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Ads to a database.
-
Automate YouTube Analytics Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live YouTube Analytics and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build a Simple VCL Application for Oracle Financials Cloud
How to build a simple VCL Application to view Oracle Financials Cloud in RAD Studio using the CData ODBC Driver for Oracle Financials Cloud.
-
Build Data Flows from Couchbase to SQL Server using SSIS
Easily back up Couchbase to SQL Server using the SSIS components for Couchbase.
-
Import and Visualize BigQuery in Power View
Create data visualizations based on Google BigQuery in Excel.
-
Connecting GenSpark with Exact Online via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Connect to Oracle Service Cloud from a Connection Pool in Jetty
The Oracle Service Cloud JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Service Cloud from Web apps in Jetty.
-
How to connect SharePoint with Procore through external lists
Provide Procore to SharePoint users as an external list.
-
LINQ to Kafka
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 Kafka Data Provider.
-
Connect to Power BI XMLA from Crystal Reports
Use CData Connect AI to connect to and report on live Power BI XMLA from Crystal Reports.
-
Prepare, Blend, and Analyze Vault CRM in Alteryx Designer (Connect AI)
Build workflows to access live Veeva Vault & Vault CRM for self-service data analytics.
-
Create Sage Intacct Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sage Intacct data access from reports, embedded analytics, and more.
-
Automated Continuous Avalara AvaTax Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Apache Kafka.
-
Build Semantic Layer Views for WordPress in APOS Live Data Gateway
Use the CData Connector for WordPress in APOS Live Data Gateway to build Semantic Layer Views for WordPress.
-
How to Connect the Power BI Service to Sage 200: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Use Grok to Talk to Your Azure Active Directory 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 Azure Active Directory for you.
-
Automated Continuous SAP Ariba Procurement Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to OneLake in Microsoft Fabric.
-
Operational Reporting on Splunk from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Splunk.
-
Easily Integrate BigQuery in Lazarus Pascal IDE
Learn how to easily integrate live Google BigQuery in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Validate Zendesk with QuerySurge
Access and validate Zendesk in QuerySurge using the CData JDBC Driver.
-
Connecting Moonlit Workflow with Hive 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 Apache Hive in real time.
-
Connect to GitHub in DBeaver
Use the CData ODBC Driver to connect to GitHub in DBeaver.
-
Build Automated Workflows with Live Azure Active Directory in Workato
Use CData Connect AI to connect to live Azure Active Directory and build automated workflows in Workato.
-
Visualize PingOne from Tableau
Use the Tableau Desktop business intelligence tool to connect to PingOne.
-
Automated Continuous Printful Replication to Vertica
Use CData Sync for automated, continuous, customizable Printful replication to Vertica.
-
Use the CData ODBC Driver for Microsoft Exchange from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Exchange to connect to Microsoft Exchange from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Exchange in Excel.
-
How to Connect DBeaver to Google Ads via a JDBC Driver
Manage Google Ads with visual tools in DBeaver like the query browser.
-
Automated Continuous Google Spanner Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Google Spanner replication to Microsoft Access.
-
DataBind Controls to Twilio in Delphi
DataBind to Twilio in Delphi with standard data access components and controls.
-
How to Connect to Live Redshift 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 Amazon Redshift for you.
-
Build Automated Excel Online-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Excel Online and build automated workflows in Zapier.
-
Integrating Claude Code with MariaDB via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MariaDB within assisted coding and automated development workflows.
-
How to Connect to Live ADP Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ADP securely in real time.
-
Access Live NetSuite 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 NetSuite CRM & ERP through MCP integration.
-
Connect to Microsoft OneDrive in Aqua Data Studio
Access Microsoft OneDrive from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize Oracle Financials Cloud Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Financials Cloud in Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft SQL Server within intelligent workflows.
-
Connect to Salesforce Data Cloud Using the Script Function in Claris FileMaker Pro
-