03. Building a Pentaho Metadata Domain
The Pentaho Metadata Domain
A domain is defined as:
This page gets you started creating your first domain in the Pentaho Metadata Editor. If you are not familiar with the Pentaho metadata terminology or concepts, you may want to review the metadata model overview and metadata terminology pages.
Creating a New Domain
When you have first launched the Pentaho Metadata Editor, a new domain has been created for you by default. You can immediate begin adding connections, tables, columns, etc.
If you wish to start fresh with a new domain, select File... | New... | Domain File... from the main menu.
Follow the links below to take the next steps, or read on for more details about domains.
- 06. Building a Business View
- 04. Creating Business Tables and Columns
- 02. Importing Physical Tables and Columns
- 05. Creating Relationships Between Business Tables
- 01. Setting Up Your Database Connections
- 03. Creating a Business Model
Saving Your Domain
Saving a domain results in storing the business models, connections and other metadata you've constructed, into a metadata repository. Pentaho metadata is stored in a repository in a CWM compliant format.
To save your domain:
- From the main menu, select File... | Save, or Save As...
- You will be prompted to enter a name for your domain. Enter a suitable domain name. Since this guide will be demonstrating building a model for the Pentaho Steel Wheels samples, I will name my domain "Steel Wheels".
- You should see a few progress messages, and your domain is saved.
Opening a Domain
Once you have created more than one domain, you will want to be able to open a different domain. The Pentaho metadata Editor can have only one domain active at a time.
To open a previously saved domain:
- From the main menu, select File... | Open.
- You will be prompted with the list of domains saved in the metadata repository. Select the name of the domain you wish to open and click OK.
Deleting a Domain
To delete a previously saved domain from the metadata repository:
- From the main menu, select File... | Delete Domain.
- You will be prompted with the list of domains saved in the metadata repository. Select the name of the domain you wish to delete and click OK.
- You will be prompted with a dialog to confirm your choice to delete the domain. Click Yes, and the domain will be deleted.
Delete is Permanent
Once you delete a domain, your metadata is gone forever. So exercise caution when using delete!