OrdersME Domain

Create an Orders Domain ..

The metadata domain is a Pentaho term that represents all the business objects created, stored and used in the metadata layer. A domain may consist of one or more connections, one or more models, security information, business tables, business views, categories, columns and concepts. You can create and save multiple metadata domains using the Metadata Editor.

A metadata domain is accessed by the BA Server by publishing or exporting the domain to an .xmi file, and placing the file in the Pentaho solutions repository.

In this workshop, you will…

  • Use JDBC to connect to the sampledata database

  • Import Physical Tables and Columns

  • Create a Business Model

  • Define the Relationships between the Tables

  • Define Business View

Creating a Pentaho Metadata Domain

A connection represents connection information of a specific database, and acts as the parent in the hierarchy for all physical tables and physical columns that are defined for that database.

Pentaho metadata models can connect to most common relational databases using JDBC. The Pentaho Metadata Editor (and the Pentaho Metadata Architecture) supports a vast and rich set of data sources. Before you begin defining your business model, you must first describe the database or data source that you would like to model. You do this by defining one or more connections in the editor.

New Domain
  1. To define a new domain, select: File > New > Domain File from the main menu.

  2. Right-mouse click on Connections or: File > New > Connection

New Database Connection
  1. In the Database Connection dialog, type or choose:

Field
Parameter

Connection name

mysql:sampledata

Connection Type

MySQL

Access

Naitive (JDBC)

Host name

localhost

Database Name

sampledata

Port Number

3306

User Name

pentaho_admin

Password

password

Database Connection

Adding JDBC driver

Before you can connect to a data source in any Pentaho server or client tool, you must first install the appropriate database driver.

Before copying a new JDBC driver, ensure that there is not a different version of the same JAR in the destination directory. If there is, you must remove the old JAR to avoid version conflicts.

  1. Copy the JDBC driver to:

~/Pentaho/design-tools/metadata-editor/libext/JDBC/

  1. Once the driver JAR is in place, you must restart the server or client tool.

Last updated

Was this helpful?