cancel
Showing results for 
Search instead for 
Did you mean: 

Sisense Data Models Data Dictionary

Silutions
10 - ETL
10 - ETL

Sisense documentation lists Data Dictionary as one of the product features. Documentation for that is shown here: Creating Data Dictionaries.  However, this feature only supports the creation of table and column description information. This is helpful, but in working with Sisense since 2014, I've often wished for a centralized solution that brought the table and column metadata (including descriptions) to a centralized location. In the olden days, Sisense late v5 and v6, there was a community plugin that exported an ElastiCube's metadata to a .csv file. It stopped working around v7.

Long story short, recently I decided to develop a desktop app (Windows/Mac) that utilizes several Sisense REST API's to build a Data Dictionary for a selected Data Model (Live or ElastiCube).  The app (Sisense Linux only) is now at the MVP stage.

The app exports a selected data model as both an Excel file to your local drive and uploads to a folder on the Sisense server.  The server uploaded files are used as a data source for a Data Dictionary ElastiCube.  A dashboard summarizes the dictionary data and a Pivot presents all Data Models metadata.  See screen the dashboard shot below:

DataDictionary DashboardScreenshot_BloX.png

The details on how the app functions in detail are covered in my Blog post:  https://www.silutionsconsult.com/post/sisense-data-models-data-dictionary   I'm interested in getting feedback from the community on the usefulness and features included.  I'm also glad to demo if someone is interested.

Regards, Jim

0 REPLIES 0