pyadomd

library0.1.1pypypiunverified

A pythonic library for querying SSAS (SQL Server Analysis Services) tabular and multidimensional data models using ADOMD.NET. Version 0.1.1, alpha stage, low release cadence.

analytics

pip install pyadomd

github ↗homepage ↗

INSTALL

IMPORT

SIG · PYADOMD

pyadomd

analyticspythonv0.1.1

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

Pyadomd

✓ import pyadomd

✗ from pyadomd import Pyadomd

Connect to SSAS, run MDX query, and print results using context manager.

import os from pyadomd import AdomdConnection conn_str = f"Data Source={os.environ.get('SSAS_SERVER', 'localhost')};Catalog={os.environ.get('SSAS_CATALOG', 'AdventureWorks')};Integrated Security=SSPI" with AdomdConnection(conn_str) as conn: cursor = conn.cursor() cursor.execute("SELECT [Measures].[Internet Sales Amount] ON 0, [Date].[Calendar Year].MEMBERS ON 1 FROM [Adventure Works]") for row in cursor.fetchall(): print(row)

Debug

Known issues

gotchaLibrary is in early alpha (0.1.1); API may change without notice. Not recommended for production.

fix

Pin version and test thoroughly before deployment.

affects: all

deprecatedThe import path 'import Pyadomd' or 'from Pyadomd import ...' is wrong. Module name is lowercase 'pyadomd'.

fix

Use 'from pyadomd import AdomdConnection'.

affects: all

gotchaRequires .NET Framework or Mono runtime on the machine (ADOMD.NET dependency). Not cross-platform by default.

fix

Ensure ADOMD.NET is installed (via SQL Server features or standalone) or use Windows.

affects: all

gotchaConnection string must match SSAS provider; Integrated Security=SSPI is typical for Windows auth.

fix

Use 'Integrated Security=SSPI' or 'User ID=...;Password=...' for SQL auth.

affects: all

Upgrade

Version history

0.1.1latest on PyPI · released Jan 22, 2022

Audit

Dependencies

No dependency data recorded yet.

Agent activity

39 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/Andboye/Pyadomd ↗

homepagehttps://github.com/Andboye/Pyadomd ↗