CData Software - Knowledge Base
Recent Articles
-
Provide OData Services of Twitter from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Twitter by developing a WCF Service Application.
-
Easily Integrate Box in Lazarus Pascal IDE
Learn how to easily integrate live Box in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Procore using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Procore to a JSON file on disk.
-
Access Live Oracle Financials Cloud in Coginiti Pro
Connect to and query live Oracle Financials Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze SAP Hybris C4C with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Hybris C4C from Power Pivot. You will use the Table Import Wizard to load SAP Hybris C4C. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Live Adobe Analytics in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Analytics.
-
How to Visualize SAP ByDesign Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Business ByDesign in Python.
-
How to Connect to & Open SAS xpt in Microsoft Excel
This article uses the CData ODBC driver for SAS xpt to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use JayDeBeApi to access XML in Python
Use standard Python scripting and the development environment of your choice to access live XML Files.
-
Visualize Live Azure Data Lake Storage in the Power BI Service
Use CData Connect AI to connect to live Azure Data Lake Storage and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating LangChain with Shopify via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Shopify within automated workflows.
-
Import Real-Time JDBC-ODBC Bridge via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use JDBC-ODBC Bridge in ColdFusion.
-
Replicate Couchbase from PowerShell
Write a quick PowerShell script to query Couchbase. Use connectivity to the live data to replicate Couchbase to SQL Server.
-
Connect to MYOB AccountRight in DBeaver
Use the CData ODBC Driver to connect to MYOB AccountRight in DBeaver.
-
Use the CData ODBC Driver for XML in Microsoft Power Query
You can use the CData XML ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import XML Files into Microsoft Power Query.
-
Automated Continuous Impala Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Impala replication to Amazon S3.
-
Viewing Excel Online in RAD Studio Data Explorer
How to view Microsoft Excel Online in RAD Studio Data Explorer using the CData ODBC Driver for Excel Online.
-
Connect to Slack in RazorSQL
Connect to Slack from wizards and query Slack from the GUI in the RazorSQL database management tool.
-
Visualize SurveyMonkey in Tableau
The CData ODBC driver for SurveyMonkey enables you integrate SurveyMonkey into Tableau dashboards.
-
Connect to Microsoft Exchange from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Exchange using standard SQL.
-
Connect to Google Calendar in CloverDX (formerly CloverETL)
Transfer Google Calendar using the visual workflow in the CloverDX data integration tool.
-
Create Reports with Tally in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tally ERP.
-
Access SAS Data Sets 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 SAS Data Sets.
-
How to Query Live MongoDB in Perplexity MacOS Desktop
Connect to and query live MongoDB in Perplexity Desktop using CData Code Assist MCP.
-
How to connect SharePoint with SAS Data Sets through external lists
Provide SAS Data Sets to SharePoint users as an external list.
-
How to Connect to & Open Email in Microsoft Excel
This article uses the CData ODBC driver for Email to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Natively Connect to Sage Cloud Accounting in PHP
The CData ODBC driver for Sage Cloud Accounting enables you to create PHP applications with connectivity to Sage Business Cloud Accounting. Leverage the native support for ODBC in PHP.
-
Load Azure Table to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Table Storage to a database.
-
Connect Acumatica to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Acumatica ERP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to & Open SAP Hybris C4C in Microsoft Excel
This article uses the CData ODBC driver for SAP Hybris C4C to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Jira Service Management in ColdFusion
Write standard ColdFusion data access code to connect to Atlassian Jira Service Management.
-
Automated Continuous Oracle Financials Cloud Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to OneLake in Microsoft Fabric.
-
Access Live Dropbox in Coginiti Pro
Connect to and query live Dropbox from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Email in NetBeans
Connect to Email in NetBeans with the data source configuration wizard.
-
How to Work with Klipfolio in AWS Glue Jobs Using JDBC
Connect to Klipfolio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Excel Spreadsheet Automation on LinkedIn Ads with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to import Slack into Apache Solr
Use the CData Software JDBC Driver for Slack in Data Import Handler and create an automated import of Slack to Apache Solr Enterprise Search platform.
-
Bind Live HBase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live HBase data
-
Automated Continuous EnterpriseDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to MongoDB.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle Database to Power BI dashboards. Simply drag and drop Oracle Database into data visuals on the Power BI canvas.
-
Connect to Zuora from a Connection Pool in JBoss
Integrate Zuora into Java servlets: Use the Management Console in JBoss to install the Zuora JDBC Driver.
-
Connecting Moonlit Workflow with Paylocity 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 Paylocity in real time.
-
Getting Started with the CData Tableau Connector for ADP
-