Skip to main content
Pentaho Documentation

Set 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.

PME Data Source

Note: While the current implementation of Pentaho Metadata Editor supports multiple connections and multiple business models in the same domain, each business model must use physical objects (columns and tables) from a single connection only.

To create a new connection...

Step Description
1 Right-click Connections in the navigation pane.
2 Select New Connection.The Database Connection dialog box appears.
3 Enter a Connection Name.
4 Define your database connection as needed.
5 Click Test to ensure that your entries as correct.
6 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.
Note: You don't need to import tables at this point. See Importing Physical Tables and Columns for more information.

Connection Types - Adding 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; however, 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.