CData Software - Knowledge Base
Recent Articles
-
How to Connect to & Open Office 365 in Microsoft Excel
This article uses the CData ODBC driver for Office 365 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate SAP SuccessFactors with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP SuccessFactors with External Services.
-
Integrate Zoom in the Pentaho Report Designer
Publish reports based on Zoom in the Pentaho BI tool.
-
How to Connect to Live Reckon from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Reckon for you.
-
Object-Relational Mapping (ORM) with Pinterest Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Pinterest into a Java-based ORM framework, Hibernate.
-
Create Dynamic Avalara AvaTax Grids Using the Infragistics XamDataGrid
Learn how you can connect Avalara AvaTax to Infragistics XamDataGrid to build dynamic grids.
-
Extend Google Sheets with Tableau CRM Analytics
Make calls to the API Server from Google Apps Script.
-
Build Semantic Layer Views for SAP Hybris C4C in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Hybris C4C.
-
How to connect to Workday with Squirrel SQL client
Connect to Workday and execute queries in the Squirrel SQL Client.
-
PowerShell Scripting to Replicate Google Cloud Storage to MySQL
Write a simple PowerShell script to replicate Google Cloud Storage to a MySQL database.
-
Analyze Zoho Projects in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Projects and visualize live Zoho Projects in Infragistics Reveal.
-
Integrate Oracle Eloqua with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Eloqua with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Eloqua.
-
Connect to SAP HANA XS Advanced in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP HANA XS Advanced and the SQL Gateway to access SAP HANA XS Advanced from Google Apps Script.
-
Connect to BigQuery in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BigQuery and connect to Google BigQuery in Akorbi Digital RunMyProcess.
-
How to integrate Printify with Apache Airflow
Access and process Printify in Apache Airflow using the CData JDBC Driver.
-
Stream QuickBooks Online into Apache Kafka Topics
Access and stream QuickBooks Online in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Data Visualizations in Cognos BI with QuickBooks Online
Access QuickBooks Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automate Authorize.Net Replication to Couchbase
Use CData Sync to Customize and automate Authorize.Net replication to Couchbase.
-
Build MVC Applications with Connectivity to Azure Analysis Services
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Analysis Services from an ASP.NET MVC application.
-
Rapidly Develop Todoist-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Integrate Xero in Pentaho Data Integration
Build ETL pipelines based on Xero Accounting in the Pentaho Data Integration tool.
-
Process & Analyze eBay in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live eBay .
-
Build MVC Applications with Connectivity to Raisers Edge NXT
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Raisers Edge NXT from an ASP.NET MVC application.
-
How to Access Live Splunk in Power Automate Desktop via ODBC
The CData ODBC Driver for Splunk enables you to integrate Splunk into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ODBC Driver for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle Sales.
-
How to import SingleStore into Apache Solr
Use the CData Software JDBC Driver for SingleStore in Data Import Handler and create an automated import of SingleStore to Apache Solr Enterprise Search platform.
-
Prepare, Blend, and Analyze Sybase IQ in Alteryx Designer (ODBC)
Build workflows to access live Sybase IQ for self-service data analytics.
-
Query Dynamics NAV using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dynamics NAV entities in PHP by modeling them as objects.
-
Access Marketo as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Marketo from your Oracle system.
-
Prepare, Blend, and Analyze Oracle Financials Cloud in Alteryx Designer (ODBC)
Build workflows to access live Oracle Financials Cloud for self-service data analytics.
-
Connect to Box in CloverDX (formerly CloverETL)
Transfer Box using the visual workflow in the CloverDX data integration tool.
-
Automate Exact Online Replication to SAP HANA
Use CData Sync to customize and automate Exact Online replication to SAP HANA.
-
How to Query Live Sybase IQ in Claude Desktop
Connect to and query live Sybase IQ in Claude Desktop using the CData MCP Server.
-
Connect to SFTP in RapidMiner
Integrate SFTP with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating NetSuite in Talend Cloud Data Management Platform
-