Create a domain
A metadata domain is a Pentaho term that represents all of 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 through the Pentaho Server by publishing or exporting the domain to an .xmi file, and placing the file in your Pentaho solutions folder.
In summary, a domain represents all of the associated modeled business entities. A domain can be viewed as a metadata “document.” Each solution is restricted to have, at most, one domain. A solution repository can contain multiple solutions. A domain must be published as an XMI file in the solution repository root directory. The Metadata Editor works with one domain at time, for example, a Sales domain that defines the relationships and entities used by sales team.
When you first launch the Metadata Editor, a new domain is automatically created. You can immediately begin adding connections, tables, columns, and more. If you want to start fresh with a new domain, selectfrom the main menu.
There are several procedures associated with creating a new domain.
Setting up a database connection
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.
Set up a database connection
Right-click Connections in the navigation pane.
Select New Connection.The Database Connection dialog box appears.
Enter a Connection Name.
Define your database connection as needed.
Click Test to ensure that your entries are correct.
Click OK to save your connection. The list of tables in your database to be imported appear. If you want to find a specific table, enter the table name in the search box or use a regular expression. Select the tables you want to import and click OK or Cancel when you are done.NoteYou do not need to import tables at this point. See Import physical tables and columns for more information.
Add a new database type
First, note the Connection Type list in the dialog box. This is the list of database connections that the Pentaho Metadata Editor and metadata models can support. The list is quite extensive. If you do not see your database in the Connection Type list, you may be able to add it.
To add a new database type, you must copy the JDBC driver archive for your database into the PME install directory ...\metadata-editor\lib. Restart the Pentaho Metadata Editor, and you will see your database in the Connection Type list.
Method of access
Under Connection Type, you will see the Access list. Defining a JDBC or OBDC connection typically requires all of the remaining fields associated with the General tab to have the correct information. If you are into abstracting those details from your metadata domain, then use the JNDI method of access.
The JNDI access method keeps your server implementation cleaner as well; once you publish your domain to the server, as long as you have defined the JNDI connections with the same names, you still have a good implementation where your database information is only described to the JNDI layer. To take advantage of the JNDI method of access in the Pentaho Metadata Editor, you must define your database connection information in a properties file for the editor.
Import physical tables and columns
A business model contains all of the logical, abstract business objects and relationships that model your physical database objects in such a way that underlying changes to the physical database objects have minimal impact on your business, your business intelligence application, and your end users. There can be multiple business models in a single domain. A business model currently supports one database connection, and consists of business tables, relationships, and a multiple business views.
Fortunately, when you import a physical table, all of the table's columns come with it, so the import is a one step exercise instead of two. Later, you can remove the columns you do not want in the connection or the model. Below is an example of an import from HSQLDB (Hypersonic):
Right-click the Sample Data Example node in the navigation pane then select Import Tables from the menu.A dialog box that contains all physical tables available in the database appears.
Select the tables you want to include.NotePress the SHIFT or CTRL key to select multiple tables.
Click OK when you are done.
Import tables inside a schema
Right-click on the connection and select Import from Explorer.A dialog box that contains all physical tables available in the database appears.
Navigate under the Schema's folder to locate the correct table(s) to import.NoteYou must select the individual tables. Selecting the top level schema exclusively results in an error message.
Create a business model
Create the logical mapping of business objects to the physical tables and columns.
Build a business view
Build a collection of business categories that represents the view of your model, typically used by your end users.