CData Software - Knowledge Base
Recent Articles
-
Integrate XML in Pentaho Data Integration
Build ETL pipelines based on XML Files in the Pentaho Data Integration tool.
-
Build Cosmos DB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Cosmos DB and build visualizations in Tableau Cloud.
-
Design BIRT Reports on YouTube Analytics
Provide current YouTube Analytics to your embedded analytics.
-
Connect to Confluence from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Atlassian Confluence from Filemaker Pro on Mac.
-
Create Dynamic Dynamics 365 Grids Using the Infragistics XamDataGrid
Learn how you can connect Dynamics 365 to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Real-Time Access to Smartsheet in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Smartsheet in real time.
-
How to Connect DBeaver to Quickbase via a JDBC Driver
Manage Quickbase with visual tools in DBeaver like the query browser.
-
How to publish and share Unbounce dashboards with Tableau Server
The CData ODBC driver for Unbounce enables you integrate Unbounce into Tableau dashboards.
-
Connect to Spark in HULFT Integrate
Connect to Spark as a JDBC data source in HULFT Integrate
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Project
Create an ODBC connection to Microsoft Project in Informatica and browse and transfer Microsoft Project.
-
Integrating Gumloop with Airtable via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Airtable within automated workflows.
-
How to connect PolyBase to Google Spanner
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Spanner.
-
Access BigCommerce from MySQL in PHP
Connect to BigCommerce through the standard MySQL libraries in PHP.
-
Access Dynamics NAV from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics NAV from HeidiSQL.
-
Use the CData Software JDBC Driver for MYOB AccountRight in MicroStrategy Desktop
Connect to MYOB AccountRight in MicroStrategy Desktop using the CData Software JDBC Driver for MYOB AccountRight.
-
Easily Integrate Todoist in Lazarus Pascal IDE
Learn how to easily integrate live Todoist in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Semantic Layer Views for Azure Data Catalog in APOS Live Data Gateway
Use the CData Connector for Azure Data Catalog in APOS Live Data Gateway to build Semantic Layer Views for Azure Data Catalog.
-
Provide OData Services of Google Ad Manager from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Ad Manager by developing a WCF Service Application.
-
Connect and Visualize Live Epicor Kinetic Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Epicor Kinetic into the Databricks platform and create visualization dashboards with real-time Epicor Kinetic.
-
Connect to Drift in DBeaver
Use the CData ODBC Driver to connect to Drift in DBeaver.
-
Connect to Microsoft OneDrive in SpagoBI
Create reports featuring live Microsoft OneDrive in SpagoBI Studio. Host Microsoft OneDrive reports on SpagoBI Server.
-
Connect to ActiveCampaign from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ActiveCampaign using standard SQL.
-
Use JayDeBeApi to access Spark in Python
Use standard Python scripting and the development environment of your choice to access live Apache Spark SQL.
-
Automated Continuous SAS xpt Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable SAS xpt replication to Microsoft Access.
-
Access Twitter from MySQL in PHP
Connect to Twitter through the standard MySQL libraries in PHP.
-
Visualize Google Cloud Storage in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Cloud Storage into TIBCO Spotfire.
-
Integrate Sugar CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sugar CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sugar CRM.
-
Use the CData ODBC Driver for Raisers Edge NXT from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Raisers Edge NXT in Excel.
-
Import Microsoft Project into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Project and provide access to live Microsoft Project for custom reports in the Power BI Service.
-
Consume Google Cloud Storage OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Cloud Storage feeds that reflect any changes in SAP Lumira.
-
Access Live MailChimp in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MailChimp from your Google Sheets.
-
How to Query Live Wave Financial Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Wave Financial data in natural language using Python.
-
Create Power BI Reports on Real-Time xBase
Use the CData ODBC Driver for xBase to visualize xBase in Power BI Desktop.
-
Viewing Zoom in RAD Studio Data Explorer
How to view Zoom in RAD Studio Data Explorer using the CData ODBC Driver for Zoom.
-
How to pipe Slack to CSV in PowerShell
Use standard PowerShell cmdlets to access Slack tables.
-
Visualize Office 365 in Tableau
The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.
-
Integrate Real-Time Access to MYOB AccountRight in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MYOB AccountRight in real time.
-
Publish Crystal Reports on SAP SuccessFactors
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP SuccessFactors.
-
Add Azure Data Lake Storage to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Data Lake Storage with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Azure DevOps in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure DevOps from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query Zoho CRM as a MySQL Database in Node.js
Execute MySQL queries against Zoho CRM from Node.js.
-
Analyze Live Hive in SAS Viya
Use CData Connect AI to connect to Apache Hive from SAS Viya and deploy self-service analytics using live Apache Hive.
-
How to Create Power BI Visual Reports with Real-Time Odoo
Use CData Power BI Connectors to visualize Odoo ERP in Power BI.
-
Connect to Harvest in Claris FileMaker Pro
-