To create a data source, specify information about the database to be connected.
The following shows the dialog box for creating a data source.
Figure 5-12 Dialog box for creating a data source (for Microsoft SQL Server)
![[Figure]](FIGURE/ZUCN0130.GIF)
To return to the list of connection targets, click the Back button.
To create a data source:
- In the dialog box for creating a data source, specify Server and Database name.
The following describes each item in the dialog box.
- Server
Specifies the server name of the database to be connected. The permitted value is 1 to 63 bytes of alphanumeric characters, %, ~, -, _, ., /, and \. By default, this item is blank.
- Database name
Specifies the name of the database to be connected. The permitted value is 1 to 128 bytes of alphanumeric characters and symbols, excluding ", |, -, *, :, <, >, ?, /, and \. By default, this item is blank.
- ODBC data source name
Displays the value specified in the Server Setup dialog box. This item cannot be changed. The displayed value depends on the product selected in Products for connection. The following table shows the items in the Server Setup dialog box that correspond to the selected product.
Table 5-7 Items in the Server Setup dialog box that correspond to the selected product (ODBC data source name)
Selected product |
Item in the Server Setup dialog box |
Asset Information Manager |
Service name |
JP1/Software Distribution |
Connection service for JP1/SD database |
- Connection user ID
Displays the value specified in the Server Setup dialog box. This item cannot be changed. The displayed value depends on the product selected in Products for connection. The following table shows the items in the Server Setup dialog box that correspond to the selected product.
Table 5-8 Items in the Server Setup dialog box that correspond to the selected product (connection user ID)
Selected product |
Item in the Server Setup dialog box |
Asset Information Manager |
Login ID |
JP1/Software Distribution |
JP1/SD database login ID |
- Click the OK button.
The data source is created according to the specified settings. When the data source creation is completed, a message to that effect is displayed.
- Click the OK button.
The dialog box for creating a data source is closed and the list of connection targets is displayed again.
All Rights Reserved. Copyright (C) 2009, 2011, Hitachi, Ltd.