Define a data source

To design an aggregate table, you must first establish a connection with your target relational database, then select the OLAP model to optimize. You can connect to any relational database that is supported by Mondrian. In some instances, you may need to define additional parameter-related values for your JDBC driver.
Sample data source connection to Pentaho Aggregation Designer

Sample data source connection to Pentaho Aggregation Designer

To define a data source connection, perform the following steps:

In the Pentaho Aggregation Designer toolbar, click Connection to open the Connect to Data Source dialog box.
Click Configure.
The Connection Properties dialog box appears.
In the Connection Name field, enter a name for your connection; this is a free-text field.
A connection name uniquely defines a connection.
In the Connection Type list, select a database.
In the Access list, keep the default choice, which should be Native (JDBC).
In the Settings section, enter the following information:
1. Type the host name of the database server into the Host Name field.
2. In the Database Name field, type the name of the database you're connecting to.
3. In the Port Number field, enter the TCP port number.
4. (Optional) In the User Name and Password fields, type the user name and password used to connect to the database.
Click Test.
If the settings you typed in are correct, a success message appears.
Click OK.
(Optional) If you must define additional parameters for your JDBC driver, or if you want to enter your server settings manually, follow these instructions:
1. Click Options in the left panel.
2. Enter the parameter name and value for the settings you need to specify.
  For example, PORT (parameter name), 1025 (parameter value).
3. Click Test when your settings are entered.
  A success message appears if everything was typed in correctly.
4. Click OK.