Navigation database setup

Use the Navigation Database Creation Utility page to create a navigation database. If there is no navigation database, the menu structure when you first open Infor BI Dashboards contains a menu command to create the navigation database.

The database creation process performs these tasks:

Creates the navigation database, the schema, and the default menu structure.
Creates a navigation data source that connects to the navigation database. Use the Manage Data Sources page to review or update the data source.
Sets the UnifiedNavigationConnectionName property to the default data source name which is Navigation. Use the Set Properties page to update the name.
Adds the user's ID to the Navigation Administration security group.

This table describes the fields:

Field	Description
Enter Database Creation Credentials
Database Server Type	Select SQL Server. Oracle is not supported at this time.
Database Server Name	Specify the name of the server computer on which the SQL Server database software is installed. If a SQL instance is used, it must be appended to the name. For example, MyServerName\SQL2008.
Database Administrator User Id	Specify the user ID of the database administrator or system administrator.
Database Administrator Password	Specify the password for the database administrator or system administrator user ID.
Enter New Navigation Database Information
Data Source Name	Specify the name for the navigation data source. The default is Navigation. If you specify a name other than Navigation, you must go the Set Properties page and update the name specified for UnifiedNavigationConnectionName.
Navigation Database Name	Specify the name for the navigation database. The default is DEPM_Navigation.
Navigation Database Owner Id	Specify the user ID of the navigation database owner.
Navigation Database Owner Password / Confirm Password	Specify the password for the navigation database owner.
Database Directory Location	Specify a directory or select the check box to use the default directory for Microsoft SQL Server Management Studio. For Microsoft SQL Server 2008 R2, this is the Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA directory. This directory varies with different versions of Microsoft SQL Server.
Create Database	Create the navigation database.
Create SQL Script	Optional. Create the SQL scripts to run later. After the scripts are created, click Download to download the script to a location you select. These are the names of the scripts: `DatabaseName`_CreateEmptyNavigationDatabase_SQLServer.sql `DatabaseName`_CreateNavigationSchema_SQLServer.sql For example, if you specify PMNavigation as the database name and SQL Server as the database type. These are the file names: PMNavigation_CreateEmptyNavigationDatabase_SQLServer.sql PMNavigation_CreateNavigationSchema_SQLServer.sql. The first script creates an empty database and the navigation user. The second script creates the schema and must be executed as the navigation user.
Test Connection	Test the database server connection.