Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Bind Live ADP Data in Wijmo FlexGrid with CData API Server

With CData API Server, easily create OData endpoints for live ADP data
Access Live Paylocity in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Paylocity from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
How to Connect to & Open LinkedIn in Microsoft Excel

This article uses the CData ODBC driver for LinkedIn to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
Use the CData Software JDBC Driver for Email in MicroStrategy Web

Connect to Email in MicroStrategy Web using the CData Software JDBC Driver for Email.
Back Up Apache Parquet to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Parquet. In this article, we will employ an SSIS workflow to populate a database with Apache Parquet data.
LINQ to Exact Online

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 Exact Online Data Provider.
Automate Google Ads Replication to SAP HANA

Use CData Sync to customize and automate Google Ads replication to SAP HANA.
Prepare, Blend, and Analyze Zoho Inventory in Alteryx Designer (ODBC)

Build workflows to access live Zoho Inventory for self-service data analytics.
Build Semantic Layer Views for Confluence in APOS Live Data Gateway

Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Atlassian Confluence.
Connect to eBay in JRuby

Create a simple JRuby app with access to live eBay.
Working with Drift in LINQPad

Execute LINQ queries to Drift in LINQPad.
Build Google Spanner-Connected Apps in Bubble

Use CData Connect AI to create an OData feed for Google Spanner and create custom apps in Bubble.
Analyze LinkedIn Ads in SAP Analytics Cloud

Use CData Connect AI to create an OData API on top of LinkedIn Ads and visualize LinkedIn Ads in SAP Analytics Cloud.
Natively Connect to SAP Concur in PHP

The CData ODBC driver for SAP Concur enables you to create PHP applications with connectivity to SAP Concur. Leverage the native support for ODBC in PHP.
Configure the CData JDBC Driver for Access in a Connection Pool in Tomcat

Connect to Microsoft Access from a connection pool in Tomcat.
How to Access HDFS Using Entity Framework

This article shows how to access Apache HDFS using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
How to connect to Oracle Sales in DBVisualizer

Integrate Oracle Sales with visual data analysis tools and data connection wizards in DBVisualizer
Automated Continuous Power BI XMLA Replication to Oracle

Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Oracle.
Connect to Sage Intacct as an External Data Source using PolyBase

Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Sage Intacct.
Automate Bing Ads Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Bing Ads and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
Back Up Twilio to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Twilio. In this article, we will employ an SSIS workflow to populate a database with Twilio data.
Build Charts with Typeform in Clear Analytics

Create dynamic charts and perform analytics based on Typeform in Clear Analytics.
Connect to Zoho CRM in Google Apps Script via SQL Gateway

Use the ODBC Driver for Zoho CRM and the SQL Gateway to access Zoho CRM from Google Apps Script.
Connect to FHIR from Filemaker Pro (Mac)

Use CData Connect AI to connect to and query live FHIR from Filemaker Pro on Mac.
Integrating LangChain with Smartsheet via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Smartsheet within automated workflows.
Build Dashboards with Shippo in Dundas BI

Create dynamic dashboards and perform analytics based on Shippo in Dundas BI.
Easily Integrate Printify in Lazarus Pascal IDE

Learn how to easily integrate live Printify in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
Getting Started with the CData JDBC Driver for JSON

Complete guide to installing, licensing, and connecting with the CData JDBC Driver for JSON.
Connect to Tally in Claris FileMaker Pro