Define the Stratum.Server Data Source

1.   Right-click the Stratum.Server Data Source node in the main window, and select Define Stratum.Server Data Source.

2.   In the Define Stratum.Server Data Source - Select Type window, choose the type of database that will be the data source -- either SQL Server or DB2 for i.

3.   Click Next.

4.   Use the next screen that displays to enter the properties of your database.

• SQL Server Properties - Enter the name of your Stratum.Server database and name of the SQL Server server on which it resides.

OR

• DB2 for i Properties:

• Enter the name of your Stratum.Server database and name of the IBM i server on which it resides.

• Enter the directory entry of the database.

• Enter the user name and password for Stratum.Connector for Viewer to use whenever it needs to connect to the database.

• Specify the Rowset Cache Size.

5.   {Optional} Test the ability to connect to the database .

6.   Click Finish.

7.   Go to the next step in setting up the application. See Define the Analysis Services Database and Cube.