Microsoft SQL Server data source worksheet

Use the Microsoft SQL Server data source worksheet to identify parameters for the data source to which your MDM operational server is connecting.

For InfoSphere® MDM Standard Edition, all IBM® AIX®, Linux®, or Solaris data source information is stored in an odbc.ini file in the MDM_INSTALL_HOME/conf directory.

When you define the names for your databases and user accounts, consider giving the associated database instance, user account, and data source configuration the same name. You might also want to include the InfoSphere MDM version in your name. Using this naming convention can help other members of your organization and IBM Software Support understand the mapping between instances, accounts, and databases.

Attention: The Business Administration, Data Stewardship, and Product Management user applications are not supported for use with a Microsoft SQL Server database.

The parameters that are listed in the following table equate to prompts or fields that you see in IBM Installation Manager.

Table 1. Microsoft SQL Server data source worksheet
Parameter Description Your value
Database type Microsoft SQL Server is supported for InfoSphere MDM Standard Edition only. The type must be MSSQLU.  
Database host name Identify the fully qualified address of the host on which the database is installed. The default is localhost.  
Database port Identify the database port or use the default port number provided. The Microsoft SQL Server default is 1433.  
Database user name The database user name must have DBA privileges.

Restrictions on length and supported characters for user names and passwords are dependent upon any restrictions that might be imposed by your operating system.

Database password Provide a password for the database user name.  
Database name Provide a name that identifies the MDM database. The default is MDMDB.  
Database schema Specify the database schema name. By default the schema name is the same as the database application user.

The user name is case sensitive because Microsoft SQL Server uses case sensitive collation.

The default schema assigned to a user who logs in using Windows Authentication is dbo. When Windows Authentication is used during the InfoSphere MDM installation, the database objects will be created in a schema named dbo.

Database server name Specify the name of the database server to which the MDM database instance connects.  
Database file group Specify the name of a file group for the database. A file group is a logical structure to group objects (collections of files) in a database. In Microsoft SQL Server, file groups are used to help with data placement and administrative tasks such as backup and restore operations.  
Use Windows Native Authentication Choose whether you want the operational server to authenticate to the database by using Microsoft Windows credentials. The default is to use SQL Server credentials.

If you plan to use Windows Authentication, your DBA must set the default schema of the login user to the schema that will be used by IBM Installation Manager.

Installing MDM Database manually If you are planning to install the physical MDM database manually, select this option to extract the scripts that are used for manual installation.

Virtual MDM tables are installed even if this option is selected.