CData Software - Knowledge Base
Recent Articles
-
LINQ to Google Data Catalog
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 Google Data Catalog Data Provider.
-
Build Zuora-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zuora.
-
Integrate Greenhouse in Pentaho Data Integration
Build ETL pipelines based on Greenhouse in the Pentaho Data Integration tool.
-
Publish Crystal Reports on Cvent
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Cvent.
-
Deploy the ADO.NET Provider for Azure Synapse on an SSRS Report Server
Connect to Azure Synapse from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Perform Batch Operations with Presto in Apache NiFi
Connect to Presto and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Add CSV to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CSV with the Informatica Enterprise Data Catalog to classify and organize data.
-
Migrating data from Microsoft Planner to Google BigQuery using CData SSIS Components.
Easily push Microsoft Planner to Google BigQuery using the CData SSIS Tasks for Microsoft Planner and Google BigQuery.
-
Use the CData SSIS Components to Insert New or Update Existing HubSpot Records from SQL Server
Easily push SQL Server data to HubSpot using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into HubSpot or update existing records with data from a SQL Server database.
-
Connect to Aha from a Connection Pool in WebLogic
Use the CData JDBC Driver for Aha to connect to Aha! from Web applications running on WebLogic.
-
Integrate SAP ByDesign into Power Automate Desktop using CData Connect
CData Connect for SAP ByDesign enables you to integrate SAP Business ByDesign into workflows built using Microsoft Power Automate Desktop.
-
Access Google Cloud Storage from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Cloud Storage from HeidiSQL.
-
Design BIRT Reports on Airtable
Provide current Airtable to your embedded analytics.
-
Access Live Azure Data Catalog Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Catalog data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData ODBC Driver for Paylocity from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Paylocity to connect to Paylocity from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Paylocity in Excel.
-
Import GraphQL into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access GraphQL. In this article, you will use the OData format to import GraphQL into Microsoft Power Query.
-
Connect to Twilio in Google Apps Script via Connect AI
Use CData Connect AI to access Twilio in Google Apps Script.
-
How to import Elasticsearch into Apache Solr
Use the CData Software JDBC Driver for Elasticsearch in Data Import Handler and create an automated import of Elasticsearch to Apache Solr Enterprise Search platform.
-
Natively Connect to Office 365 in PHP
The CData ODBC driver for Office 365 enables you to create PHP applications with connectivity to Microsoft Office 365. Leverage the native support for ODBC in PHP.
-
Connect to Amazon DynamoDB in Ruby
Connect to Amazon DynamoDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Blackbaud FE NXT into Automated Tasks with Power Automate
Use CData Connect AI to connect to Blackbaud FE NXT and integrate live Blackbaud FE NXT into your Power Automate tasks.
-
Import Real-Time Microsoft Exchange via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Exchange in ColdFusion.
-
Automated Continuous CockroachDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CockroachDB replication to Google BigQuery.
-
Visualize Airtable in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Airtable into TIBCO Spotfire.
-
How to Connect Flowise AI Agents to Live Epicor Kinetic via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Prepare, Blend, and Analyze Harvest in Alteryx Designer (ODBC)
Build workflows to access live Harvest for self-service data analytics.
-
How to import SAP Netweaver Gateway into Apache Solr
Use the CData Software JDBC Driver for SAP Netweaver Gateway in Data Import Handler and create an automated import of SAP Netweaver Gateway to Apache Solr Enterprise Search platform.
-
Query BigQuery as a SQL Server Database in Node.js
Execute SQL Server queries against Google BigQuery from Node.js.
-
Building Dynamic Web Pages with Shippo Using AngularJS
Create single-page applications with live connectivity to Shippo using the CData API Server.
-
Connect to Facebook Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Facebook Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous ShipStation Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ShipStation replication to OneLake in Microsoft Fabric.
-
Extend Google Sheets with Twitter Ads
Make calls to the API Server from Google Apps Script.
-
Use Microsoft Copilot Studio to talk to your MYOB AccountRight via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your MYOB AccountRight for you.
-
Access Live Salesloft in TIBCO Data Virtualization
-