CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to SharePoint Excel Services from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SharePoint Excel Services in Filemaker Pro for Mac or Windows.
-
Connect Azure Synapse to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Synapse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Consume TaxJar OData Feeds in SAP Lumira
Use the API Server to create data visualizations on TaxJar feeds that reflect any changes in SAP Lumira.
-
Build MVC Applications with Connectivity to FTP
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FTP from an ASP.NET MVC application.
-
Access Zoho Projects in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Zoho Projects.
-
How to Connect DBeaver to Highrise via a JDBC Driver
Manage Highrise CRM with visual tools in DBeaver like the query browser.
-
View Reports on Real-Time Jira Service Management in Power BI Report Server
Use the CData ODBC Driver for Jira Service Management to visualize Atlassian Jira Service Management in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Freshdesk as an External Source in Dremio
Use the CData JDBC Driver to connect to Freshdesk as an External Source in Dremio.
-
How to Connect to & Open Okta in Microsoft Excel
This article uses the CData ODBC driver for Okta to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Oracle Service Cloud in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle Service Cloud and visualize Oracle Service Cloud in SAP Analytics Cloud.
-
Connect to Exact Online as an External Source in Dremio
Use the CData JDBC Driver to connect to Exact Online as an External Source in Dremio.
-
Query IBM Cloud Object Storage from Node.js
Use the OData endpoint of the CData API Server to connect to your IBM Cloud Object Storage and perform CRUD operations on IBM Cloud Object Storage from Node.js.
-
A PostgreSQL Interface for Adobe Commerce using the CData ODBC Driver
Use the SQL Gateway and Adobe Commerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Azure Table in PHP
The CData ODBC driver for Azure Table enables you to create PHP applications with connectivity to Azure Table Storage. Leverage the native support for ODBC in PHP.
-
Analyze SAP Ariba Procurement in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Ariba Procurement in Microsoft R Open.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live QuickBooks Time within intelligent workflows.
-
Prepare, Blend, and Analyze Google Drive in Alteryx Designer (Connect AI)
Build workflows to access live Google Drive for self-service data analytics.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Email to Power BI dashboards. Simply drag and drop Email into data visuals on the Power BI canvas.
-
Automated Continuous Kafka Replication to SQL Server
Use CData Sync for automated, continuous, customizable Kafka replication to SQL Server.
-
Build Charts with Freshdesk in Clear Analytics
Create dynamic charts and perform analytics based on Freshdesk in Clear Analytics.
-
Connect to Power BI XMLA from PowerBuilder via ADO.NET
This article demonstrates how to access Power BI XMLA from Appeon PowerBuilder using the CData ADO.NET Provider for Power BI XMLA.
-
Seamlessly Bring Google Calendar into Retool Using CData Connect AI
Integrate Google Calendar data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Zoho Books Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Books replication to Snowflake.
-
Import Real-Time DB2 via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use IBM DB2 in ColdFusion.
-
Replicate Multiple Vertica Accounts
Replicate multiple Vertica accounts to one or many databases.
-
Create Power BI Reports on Real-Time Pinterest
Use the CData ODBC Driver for Pinterest to visualize Pinterest in Power BI Desktop.
-
Stream SQL Analysis Services into Apache Kafka Topics
Access and stream SQL Analysis Services in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Biml to Build SSIS Tasks to Replicate Kintone to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Kintone to SQL Server.
-
Integrating Gumloop with Twitter via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Twitter within automated workflows.
-
How to Access Wave Financial Using Entity Framework
This article shows how to access Wave Financial using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Quickbase in SpagoBI
Create reports featuring live Quickbase in SpagoBI Studio. Host Quickbase reports on SpagoBI Server.
-
How to Query Live Google Ads in Claude Desktop
Connect to and query live Google Ads in Claude Desktop using CData Code Assist MCP.
-
A PostgreSQL Interface for Box (MySQL Remoting via JDBC)
Use the Remoting features of the Box JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations Based On Square in Mode
Use CData Connect AI to connect to Square from Mode and build visualizations using live
-
Connect to Twilio from Asprova with CData Software ODBC Driver for Twilio
This article shows how to connect faster to Twilio data from Asprova.
-
How to integrate SuiteCRM with Apache Airflow
Access and process SuiteCRM in Apache Airflow using the CData JDBC Driver.
-
Replicate Authorize.Net to Multiple Databases via the CData Sync CLI
Replicate Authorize.Net to disparate databases with a single configuration.
-
Access Live Freshdesk in AWS Lambda (with IntelliJ IDEA)
Connect to live Freshdesk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Outreach.io in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Outreach.io into TIBCO Spotfire.
-
Access Live Wave Financial in AWS Lambda (with IntelliJ IDEA)
Connect to live Wave Financial in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData PowerShell Cmdlets for Monday.com
-