Skip to main content
Pentaho Documentation

Get Started with Data Models

File:/grStepGetStartedDataModel.png

When you configured your BA Server, you defined the connection information, including where the data is stored and what protocol or driver to use to connect to it. Configure Pentaho Systems shows you how to change or add connection information.

 

To create a data source, just pick one of the connections that you have already defined, then use the wizard's interactive data modeling tool to select tables and columns to drag onto the model canvas. You can then use the Data Source Model Editor to refine the model further.

Eventually, you might want to add more security, localization, or make other advanced modifications to your model. To do that, export the initial model created with the Data Source wizard, and import it into either Metadata Editor for relational data models and Schema Workbench for multidimensional data models.

Note: Relational and multidimensional models that have been edited in Metadata Editor and Schema Workbench can no longer be edited in the Data Source Model Editor.

It is time to take a look at the Data Source Wizard and see what all you can do with it. Just follow the Guide Post graphics as you work with the tutorials to create your first data models with the wizard.