CData Software - Knowledge Base
Recent Articles
-
Analyze AlloyDB in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google AlloyDB with the CData JDBC Driver for AlloyDB.
-
Use Biml to Build SSIS Tasks to Replicate Shopify to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Shopify to SQL Server.
-
Query Azure Active Directory from Node.js
Use the OData endpoint of the CData API Server to connect to your Azure Active Directory and perform CRUD operations on Azure Active Directory from Node.js.
-
Create ShipStation Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ShipStation data access from reports, embedded analytics, and more.
-
Extract, Transform, and Load Avro in Informatica PowerCenter
Create a simple Workflow for Apache Avro in Informatica PowerCenter.
-
Analyze SAP HANA in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP HANA and visualize SAP HANA in SAP Analytics Cloud.
-
Visualize Live OneNote of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft OneNote using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to pipe Smartsheet to CSV in PowerShell
Use standard PowerShell cmdlets to access Smartsheet tables.
-
How to Use a Microsoft Access Database to Update HubDB in Real Time
Update HubDB data by creating a linked table in Microsoft Access with the CData HubDB ODBC Driver.
-
Migrating data from Workday to Google BigQuery using CData SSIS Components.
Easily push Workday to Google BigQuery using the CData SSIS Tasks for Workday and Google BigQuery.
-
Using the CData Software ODBC Driver for Adobe Target in PyCharm
Connect to Adobe Target as an ODBC data source in PyCharm using the CData Software ODBC Driver for Adobe Target.
-
Analyze Stripe in R via JDBC
Use standard R functions and the development environment of your choice to analyze Stripe with the CData JDBC Driver for Stripe.
-
Provide OData Services of JotForm from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for JotForm by developing a WCF Service Application.
-
Access Live Avalara AvaTax in AWS Lambda
Connect to live Avalara AvaTax in AWS Lambda using the CData JDBC Driver.
-
Use Dash to Build to Web Apps on Shopify
Create Python applications that use pandas and Dash to build Shopify-connected web apps.
-
Connect to Impala from a Connection Pool in Jetty
The Impala JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Impala from Web apps in Jetty.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Trello to Power BI dashboards. Simply drag and drop Trello into data visuals on the Power BI canvas.
-
Natively Connect to ClickUp in PHP
The CData ODBC driver for ClickUp enables you to create PHP applications with connectivity to ClickUp. Leverage the native support for ODBC in PHP.
-
Build Agents in Relevance AI with Access to Live Slack via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Slack within intelligent agent workflows.
-
Use Azure AI Foundry to Talk to Your Gmail via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Gmail for you.
-
How to integrate HubSpot with Apache Airflow
Access and process HubSpot in Apache Airflow using the CData JDBC Driver.
-
How to Access eBay Using Entity Framework
This article shows how to access eBay using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Zoom in Aqua Data Studio
Access Zoom from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish Crystal Reports on Salesforce Pardot
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce Pardot.
-
Create Reports with Act CRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act CRM.
-
How to Query Live Oracle Eloqua Reporting Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Eloqua Reporting data in natural language using Python.
-
Connect to Greenhouse from a Connection Pool in Jetty
The Greenhouse JDBC Driver supports connection pooling: This article shows how to connect faster to Greenhouse from Web apps in Jetty.
-
Build Semantic Layer Views for SAP ByDesign in APOS Live Data Gateway
Use the CData Connector for SAP ByDesign in APOS Live Data Gateway to build Semantic Layer Views for SAP Business ByDesign.
-
Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy Web
Connect to Amazon DynamoDB in MicroStrategy Web using the CData Software JDBC Driver for Amazon DynamoDB.
-
Build OData-Powered Applications in Claude Code with CData Code Assist MCP
-