CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SendGrid
Provide connectivity to SendGrid through an SAP BusinessObjects universe.
-
Build Pipelines with Live Adobe Commerce in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Adobe Commerce from Google Cloud Data Fusion, enabling the integration of live Adobe Commerce into the building and management of effective data pipelines.
-
Connect and Query Live HCL Domino Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live HCL Domino into Databricks
-
Connect to ActiveCampaign from a Connection Pool in JBoss
Integrate ActiveCampaign into Java servlets: Use the Management Console in JBoss to install the ActiveCampaign JDBC Driver.
-
Connect to Jira from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Jira to connect to Atlassian Jira and execute queries in PowerBuilder.
-
How to pipe Microsoft Project to CSV in PowerShell
Use standard PowerShell cmdlets to access Microsoft Project tables.
-
Integrate with Kafka in JReport Designer
Create charts and reports based on Apache Kafka in JReport Designer.
-
Bridge Avalara AvaTax Connectivity with Apache NiFi
Access and process Avalara AvaTax in Apache NiFi using the CData JDBC Driver.
-
Analyze Facebook in Looker
Use CData Connect AI to connect to Facebook from Looker and build custom apps using live Facebook.
-
Getting Started with the CData JDBC Driver for PingOne
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PingOne.
-
Automate Zoho Books Replication to SAP HANA
Use CData Sync to customize and automate Zoho Books replication to SAP HANA.
-
Connect to Reckon from a Connection Pool in WebLogic
Use the CData JDBC Driver for Reckon to connect to Reckon from Web applications running on WebLogic.
-
Automated Continuous Google Directory Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Directory replication to Azure SQL Database.
-
Bridge FTP Connectivity with Apache NiFi
Access and process FTP Servers in Apache NiFi using the CData JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live Marketo
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Marketo.
-
How to connect and process SQL Analysis Services from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SQL Analysis Services.
-
Connect to Dropbox from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dropbox to connect to Dropbox and execute queries in PowerBuilder.
-
Import SAP Hybris C4C into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Hybris C4C and provide access to live SAP Hybris C4C for custom reports in the Power BI Service.
-
Connect to SAP Fieldglass in DBArtisan
Use wizards in DBArtisan to configure SAP Fieldglass as a data source.
-
Automated Continuous DocuSign Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable DocuSign replication to Amazon Redshift.
-
How to Query Live Sage Cloud Accounting in Perplexity MacOS Desktop
Connect to and query live Sage Cloud Accounting in Perplexity Desktop using CData Code Assist MCP.
-
How to connect and process Oracle Eloqua from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Eloqua.
-
How to Connect to JotForm in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to JotForm. Leverage the pyodbc module for ODBC in Python.
-
Deploy the ADO.NET Provider for Drift on an SSRS Report Server
Connect to Drift 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.
-
Amazon Marketplace Reporting in OBIEE with the Amazon Marketplace JDBC Driver
Deploy the Amazon Marketplace JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to eBay in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to eBay. Leverage the pyodbc module for ODBC in Python.
-
Perform Batch Operations with Microsoft Exchange in Apache NiFi
Connect to Microsoft Exchange and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Visualizations of ADP in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ADP in Birst.
-
Connect Oracle to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Database using the CData Python MCP Server.
-
How to Access Live IBM Informix in Power Automate Desktop via ODBC
The CData ODBC Driver for IBM Informix enables you to integrate IBM Informix into workflows built using Microsoft Power Automate Desktop.
-
Visualize Oracle Eloqua in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle Eloqua into TIBCO Spotfire.
-
Automated Continuous Microsoft OneLake Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to SingleStore.
-
Integrate QuickBooks Time into Automated Tasks with Power Automate
Use CData Connect AI to connect to QuickBooks Time and integrate live QuickBooks Time into your Power Automate tasks.
-
LINQ to Power BI XMLA
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 Power BI XMLA Data Provider.
-
How to Connect to & Open Okta in Microsoft Excel
This article uses the CData ODBC driver for Okta to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Vault CRM from MySQL in PHP
Connect to Vault CRM through the standard MySQL libraries in PHP.
-
LINQ to BambooHR
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 BambooHR Data Provider.
-
Connect and Visualize Live Excel Online Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Excel Online into the Databricks platform and create visualization dashboards with real-time Microsoft Excel Online.
-
Connect Email to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Email using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import Oracle HCM Cloud into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Oracle HCM Cloud. In this article, you will use the OData format to import Oracle HCM Cloud into Microsoft Power Query.
-
Access Live Azure Analysis Services in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Analysis Services from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Publish Adobe Commerce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Adobe Commerce.
-
Connect to SAP BusinessObjects BI in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP BusinessObjects BI and connect to SAP BusinessObjects BI in Akorbi Digital RunMyProcess.
-
Building Dynamic Web Pages with LinkedIn Using AngularJS
Create single-page applications with live connectivity to LinkedIn using the CData API Server.
-
Model MySQL Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MySQL, enabling the direct import of real-time MySQL.
-
Connect to Microsoft Project in Claris FileMaker Pro
-