Load Data From External PostgreSQL Database

Good evening,

We were able to set a connection with our in-house postgres Database. However we are not able
to load schemas, tables , records in any visual element like STD DashBoard. Can you provide some documentation and information about this topic?

Thanks a lot.

Best Regards.

Gianluca Pironti

Hello @gpironti

STDashboard uses Mondrian to load the multidimensional cube models defined in a Mondrian schema (xml file).

Once the connection is defined from the Manage Data Sources section, it’s necessary to upload the schema from the Import Analysis option.

The definition of the Mondrian schema can be done through the tool Pentaho Schema Workbench.

Best regards