Giter Club home page Giter Club logo

mstrio-py's Introduction

MicroStrategy Logo

image image image

mstrio: Simple and Secure Access to MicroStrategy Data

mstrio provides a high-level interface for Python and R and is designed to give data scientists and developers simple and secure access to MicroStrategy data. It wraps MicroStrategy REST APIs into simple workflows, allowing users to connect to their MicroStrategy environment, fetch data from cubes and reports, create new datasets, and add new data to existing datasets. And, because it enforces MicroStrategy's user and object security model, you don't need to worry about setting up separate security rules.

With mstrio, it's easy to integrate cross-departmental, trustworthy business data in machine learning workflows and enable decision-makers to take action on predictive insights in MicroStrategy reports, Dossiers, HyperIntelligence Cards, and customized, embedded analytical applications.

MicroStrategy for Jupyter is an extension for Jupyter Notebook which provides a graphical user interface for mstrio-py methods with the help of which user can perform all of the import and export actions without writing a single line of code manually. MicroStrategy for Jupyter is contained within mstrio-py package and is available after installation and enabling as Jupyter extension.

Table of Contents

Main Features

Main features of mstrio-py allows to access MicroStrategy data:

  • Connect to your MicroStrategy environment using Connection class (see examples)
  • Import and filter data from a Cube or Report into a Pandas DataFrame (see examples)
  • Export data into MicroStrategy by creating or updating Dataset (see examples)

Since version 11.3.0.1, mstrio-py includes also administration modules:

  • Application management module (see examples)
  • Server management module (see examples)
  • User and Usergroup management modules (see examples)
  • Subscription and Schedules management modules (see examples)
  • Document and Dossiers in User Library modules (see examples)
  • User Connections management module
  • Privilege and Security Role management modules

Documentation

Detailed information about mstrio-py package can be found in official documentation.

Installation

Prerequisites

mstrio-py

  • Python 3.6+
  • MicroStrategy 2019 Update 4 (11.1.4)+

MicroStrategy for Jupyter

Install the mstrio-py Package

Note: it is not recommended to install mstrio-py in an Anaconda environment. For a seamless experience, install and run it in Python's virtual environment instead.

Installation is easy when using pip. Read more about installation on MicroStrategy's product documentation.

pip install mstrio-py

Enable the Jupyter Notebook extension

Once mstrio-py is installed you can install and enable the Jupyter Notebook extension by using the commands below:

jupyter nbextension install connector-jupyter --py --sys-prefix
jupyter nbextension enable connector-jupyter --py --sys-prefix

Versioning & Changelog

Current version: 11.3.0.2 (11 January 2021). Check out Changelog to see what's new.

Functionalities may be added to mstrio either in combination with annual MicroStrategy platform releases or through updates to platform releases. To ensure compatibility with APIs supported by your MicroStrategy environment, it is recommended to install a version of mstrio that corresponds to the version number of your MicroStrategy environment.

mstrio-py is divided into two separate modules, first of which is meant for data-science related activities, while the second one is for administrative tasks. Former requires at least MicroStrategy 2019 Update 4 (11.1.4), latter works with 11.2.1 and higher but all features are available with MicroStrategy 11.3.0.

If you intend to use mstrio with MicroStrategy version older than 11.1.4, refer to the PyPI package archive to download mstrio 10.11.1, which is supported on:

  • MicroStrategy 2019 (11.1)
  • MicroStrategy 2019 Update 1 (11.1.1)
  • MicroStrategy 2019 Update 2 (11.1.2)
  • MicroStrategy 2019 Update 3 (11.1.3)

Refer to the PyPI package archive for a list of available versions.

To install a specific, archived version of mstrio, choose the desired version available on PyPI package archive and install with pip, as follows:

pip install mstrio-py==10.11.1

More Resources

Other

"Jupyter" and the Jupyter logos are trademarks or registered trademarks of NumFOCUS.

mstrio-py's People

Contributors

apiotrowskimicrostrategy avatar dholmblad avatar drzamich avatar expobrain avatar pott-mstr avatar sabgit avatar scottrigney avatar ssainz avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.