About the Sample Database

The sample database that is supplied with SBM contains real data, which you can use to test your installation. The database is designed to get SBM up and running quickly, allowing users to test and use the features that are available without having to manually add all of the necessary data. The sample database is a single database that contains all of the tables for each of the SBM databases.

SQL Server Sample Database

This section describes how to connect to SQL Server and import the sample database. SBM Configurator can only import the sample database into SQL Server locally. If your SQL Server instance is hosted on a remote server, consult your DBA and restore the sample.bak file manually using the SQL Server native tools.

The sample.bak is packaged in a zip file located here:
installDir\Sample Database\sample_general_mssql.zip
If you restore the database manually, do not select the Use sample database option in SBM Configurator. Instead, enter the connection information for the database in which you restored the sample.bak.

Server Information

If the Use sample database option is selected, the Database Servers tab prompts you to enter the connection information for the server that will host the sample database. In the Server information section, provide the following:

Field Description
ODBC Data source Displays the current data source that is used to connect to the Application Engine database. Click Change to create a new data source, rename the default data source, or select an existing data source. For more information, see About Data Sources.
Database type Select SQL Server to host the sample database in your SQL Server DBMS.
Windows Authentication Select this check box to use Windows Authentication instead of SQL Authentication. For more information, see About Windows Authentication.
Host Enter the host name of your SQL Server machine.
Instance Enter the name of your SQL Server instance.
Port Enter the SQL Server database server port number. The default SQL Server port is 1433.

SBM Configurator also collects the credentials that are used by each server component to connect to the sample database. If you select SQL Server as the Database type, you must provide a set of existing database credentials to connect to the sample database. SBM Configurator does not create the user account in SQL Server for you; therefore, create the user account beforehand (or use an existing privileged account like sa). After you have established the user in SQL Server, enter the following:

Field Description
Database name Enter the name of a database space that will host the sample database in SQL Server. The default is sample. This database space is created in SQL Server once you perform the Import Sample Database operation.
User name Enter the name of a user account that can connect to and alter the database. The sa account appears by default.
Password Enter the user account password.
Confirm Password Enter the password again to confirm it.

Note that the password that you use has certain restrictions. For example: it can not contain prohibited terms or user names (like "Password" or "Admin"); it can not contain the name of the user currently logged on to the machine; it can not contain the machine name; it must have a combination of uppercase text, lowercase text, and numerals. For more information, review the SQL Server Express password guidelines at http://msdn.microsoft.com/en-us/library/ms143705(SQL.90).aspx.

Importing the Sample Database

To import the sample database locally, click Import Sample Database, and then enter the User name and Password of a privileged database user account that has the ability to create a new database. A progress indicator appears while the import operation runs.

Click Test connection to confirm that you can connect to the database. If the sample database has not been imported yet, the test will fail. Do not test the connection until after the database has been imported.

Click Next to proceed to the next dialog when the restore operation is finished.

Oracle Sample Database

This section describes how to connect to Oracle and import the sample database. SBM Configurator can either import the sample database into an Oracle instance that is hosted locally or on a remote server. SBM Configurator creates the sample database schema for you.

Note: You must install the Oracle client for SBM Configurator to restore the sample database. When you install the Oracle client, the client installation must include the .imp executable to enable SBM Configurator to restore the sample database.

Server Information

If the Use sample database option is selected, the Database Servers tab prompts you to enter the connection information for the server that will host the sample database. In the Server information section, provide the following:

Field Description
ODBC Data source Displays the current data source that is used to connect to the Application Engine database. Click Change to create a new data source, rename the default data source, or select an existing data source. For more information, see About Data Sources.
Database type Select Oracle to host the sample database in your Oracle DBMS.
Host Enter the host name of your Oracle server.
SID Enter the SID of your Oracle database.
Port Enter the port number of your Oracle service. The default Oracle port is 1521.

SBM Configurator also collects the credentials that are used by each server component to connect to the sample database. If you select Oracle as the Database type, you can choose to use either a set of default database credentials to connect to the sample database or enter your own custom credentials. SBM Configurator creates the user account in Oracle for you; therefore, you do not need to create it beforehand.

To create the sample database in Oracle using a default schema, select Use default credentials. This creates a default schema in Oracle named sample, which uses the tablespace named users. The password for this schema is sample.

Note: If you choose to restore the sample schema into Oracle, the schema that is created is named sample; therefore, the restore process fails if a schema named sample already exists in your DBMS.

If you want to create the sample schema with different credentials, select Use custom credentials and enter the following:

Field Description
Schema/user name Enter a new schema or user name.
Password Enter the user password.
Confirm password Confirm the password.

After you enter the credentials, click Test connection to confirm that your local server can connect to the server that hosts your DBMS.

Importing the Sample Database

To import the sample database, select Import Sample Database, and then enter the Schema/User name and Password of a privileged user account that has the ability to create a new database. A progress indicator appears while the import operation runs. Click Next to proceed to the next dialog box when the restore operation is finished.

SQL Server Express Sample Database

If the suite installer does not detect that the Microsoft SQL Server Native Client is installed on your server, you are given the option to install Microsoft SQL Server Express. If you select the option to install Microsoft SQL Server Express, the Use sample database check box is selected by default during wizard mode. This section describes how to connect to Microsoft SQL Server Express and import the sample database.

Note: The instructions below apply only to the SQL Server Express instance that is installed by the SBM suite installer. If you installed SQL Server Express independently (before you installed SBM), use the instructions in SQL Server Sample Database to restore the sample database.

Entering Database Connection Information

If the Use sample database option is selected, the Database Servers tab prompts you to enter the connection information for the server that will host the sample database. When you choose to install SQL Express, the database is hosted locally; therefore, your local server information is used.

The Server information section displays the following information:

Field Description
ODBC data source Displays the current data source that is used to connect to the Application Engine database. Click Change to create a new data source, rename the default data source, or select an existing data source. For more information, see About Data Sources.
Database type Defaults to SQL Server when you choose to install Microsoft SQL Server Express.
Windows Authentication Select this check box to use Windows Authentication instead of SQL Authentication. (This field only appears when you select SQL Server as the database type.) For more information, see About Windows Authentication.
Host Contains the host name of your SQL Express server machine.
Instance Contains the name of your SQL Express instance. Defaults to SBMSQLEXPR.
Port Contains the SQL Express database server port number. The default SQL Express port is 1433.

SBM Configurator also collects the credentials that are used by each server component to connect to the sample database. If you chose to install Microsoft SQL Express during installation, a set of default credentials are created and used to connect the sample database. In wizard mode, the following default credentials are listed in read-only format:

Field Description
Database name Defaults to sample when you choose to install Microsoft SQL Server Express.
User name Defaults to sa when you choose to install Microsoft SQL Server Express.
Note: The default password for SQL Server Express is Password123.

You can change these credentials after installation if you do not want to use the default credentials; however, note that the password that you create has certain restrictions. For example: it can not contain prohibited terms or user names (like "Password" or "Admin"); it can not contain the name of the user currently logged on to the machine; it can not contain the machine name; it must have a combination of uppercase text, lowercase text, and numerals. For more information, review the SQL Server Express password guidelines at http://msdn.microsoft.com/en-us/library/ms143705(SQL.90).aspx.

To connect to SQL Server Express using custom credentials:

  1. Launch SBM Configurator.
  2. Select the Database Servers tab.
  3. In the Database and connection credentials section, select the Use custom credentials option.
  4. Change the database credentials according to your new connection criteria.

Importing the Sample Database

SBM Configurator can only import the sample database into SQL Server Express locally. If your SQL Server Express instance is hosted on a remote server, you must restore the sample database manually using the SQL Server Express native tools.

To import the sample database locally, click Import Sample Database. A progress indicator appears while the import operation runs. Click Next to proceed to the next dialog box when the restore operation is finished.

Note: The sample database is a single database that contains all of the tables for each SBM database. In other words, all the components share a single database. When you restore the sample database in SQL Express, every component database is added to the same database space (sample).