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.
The parameters that are listed in the following table equate to prompts or fields that you see in IBM Installation Manager.
|Database type||Microsoft SQL
Server is supported for InfoSphere MDM Standard
Edition only. The type must be
|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
|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
|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
|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.