Learn more
 

CData Software - Knowledge Base

Recent Phoenix ODBC Articles

Use the CData Software ODBC Driver for Phoenix in MicroStrategy Desktop

Connect to Apache Phoenix in MicroStrategy Desktop using the CData Software ODBC Driver for Phoenix.

Viewing Phoenix in RAD Studio Data Explorer

How to view Apache Phoenix in RAD Studio Data Explorer using the CData ODBC Driver for Phoenix.

Author and Share Power BI Reports on Real-Time Phoenix

Use the CData ODBC Driver for Phoenix to visualize Apache Phoenix in Power BI Desktop and then upload to the Power BI service.

Query Phoenix as a MySQL Database in Node.js

Execute MySQL queries against Apache Phoenix from Node.js.

How to connect PolyBase to Phoenix

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Phoenix.

Build Charts with Phoenix in Clear Analytics

Create dynamic charts and perform analytics based on Apache Phoenix in Clear Analytics.

Create Reports with Phoenix in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Apache Phoenix.

Visualize Phoenix in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Apache Phoenix into TIBCO Spotfire.

Replicate Phoenix from PowerShell

Write a quick PowerShell script to query Apache Phoenix. Use connectivity to the live data to replicate Apache Phoenix to SQL Server.

How to Connect to & Open Phoenix in Microsoft Excel

This article uses the CData ODBC driver for Phoenix to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

How to create an RPA flow for Phoenix in UiPath Studio

Use the Phoenix ODBC Driver to create workflows that access real-time Apache Phoenix without any coding.

How to publish and share Phoenix dashboards with Tableau Server

The CData ODBC driver for Phoenix enables you integrate Apache Phoenix into Tableau dashboards.

Use the CData ODBC Driver for Phoenix from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Phoenix to connect to Apache Phoenix from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Phoenix in Excel.

How to Access Live Phoenix in Power Automate Desktop via ODBC

The CData ODBC Driver for Phoenix enables you to integrate Apache Phoenix into workflows built using Microsoft Power Automate Desktop.

How to Connect to Phoenix in Python on Linux/UNIX

Create Python applications on Linux/UNIX machines with connectivity to Apache Phoenix. Leverage the pyodbc module for ODBC in Python.