Creating a data source or a net service

Create a data source (in Embedded RDB and Microsoft SQL Server) or a net service (in Oracle) in order to connect to the managing server and the Asset Information Manager Subset database created for the managing server.

Notes

Before you create a database or net service for connecting to the Asset Information Manager Subset database, stop the services in the following order.

World Wide Web Publishing Service or World Wide Web Publishing
Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset
JP1/Client Security Control - Manager (applicable if JP1/CSC is linked)

To use Asset Information Manager Subset after you have used the Database Manager, start the services in the reverse order from that listed above.

If a connection pool has been set up in the ODBC database, the connected status will not change from the time that the Asset Information Manager Subset job was stopped until the timeout time set in the connection pool elapses. Therefore, wait for the connected status to change before creating the database or net service.

To create a data source or a net service in order to connect to the database:

From the Start menu, choose Software Distribution Manager, Asset Information Manager, and then Setup.
The Setup dialog box for Asset Information Manager Subset is displayed.
Choose Create Data Source/Net Service.
The Create Data Source/Net Service dialog box appears.

Figure 10-22 Create Data Source/Net Service dialog box

JP1/Asset Information Manager

Creates a data source (in Embedded RDB and Microsoft SQL Server) or a net service (in Oracle) to connect to the Asset Information Manager Subset database.

Select this item to connect to the existing Asset Information Manager Subset database. If you use the Database Manager of Asset Information Manager Subset to create a database, there is no need to select this item because a data source (in Embedded RDB and Microsoft SQL Server) or a net service (in Oracle) is created when the database is created.

JP1/SD

Creates a data source (in Embedded RDB and Microsoft SQL Server) or a net service (in Oracle) to connect to the managing server database.

Select this item if the database type is Oracle. In Embedded RDB or Microsoft SQL Server, there is no need to select this item because a data source is created during installation.

If you have changed the database environment for the managing server, or the managing server cannot be connected (for reasons such as specification of an invalid value during installation of Asset Information Manager Subset), change the setting.
From Products for connection, select the name of the database product to be connected, and then click the Next button.
The Create Data Source dialog box appears.

The Create Data Source dialog box depends on the type of database. The following provides a description for each type.

Organization of this subsection: (1) In Embedded RDB; (2) In Microsoft SQL Server; (3) In Oracle

(1) In Embedded RDB

Create a data source in order to connect to the database specified in Products for connection.

To create a data source for Embedded RDB:

In the Create Data Source/Net Service dialog box, select the name of the database product to be connected from Products for connection, and then click the Next button.
The Create Data Source dialog box appears.
In this dialog box, specify the server and port number required in order to create a data source.

Figure 10-23 Create Data Source dialog box (for Embedded RDB)

Server

Specifies the server name or IP address of the connection-target database. The default depends on the item selected in Products for connection in the Create Data Source/Net Service dialog box.

For JP1/Asset Information Manager: local host

For JP1/SD: Space

The permitted value is 1 to 63 bytes of characters and the following symbols:

% ~ - _ . / \

Port number

Specifies the port number of the connection-target database server. The permitted value is from 5001 to 65535. The default depends on the item selected in Products for connection in the Create Data Source/Net Service dialog box.

For JP1/Asset Information Manager: 30010

For JP1/SD: 30008

ODBC data source name

Displays the name of the database connection service as the ODBC data source name, according to the selected connection target.

To change the ODBC data source name, do the following:

If you have selected JP1/Asset Information Manager from Products for connection, change the Service name setting in Database Information in the Server Setup dialog box.

If you have selected JP1/SD from Products for connection, change the Connection service for JP1/SD database setting in Link with JP1/SD in the Server Setup dialog box.

Connection user ID

Displays the database login ID that was specified at setup as the connection user ID used to log on to the database.

To change the connection user ID, do the following:

If you have selected JP1/Asset Information Manager from Products for connection, change the Login ID setting in Database Information in the Server Setup dialog box.

If you have selected JP1/SD from Products for connection, change the JP1/SD database login ID setting in Link with JP1/SD in the Server Setup dialog box.
Set the items and then click the OK button.
The data source is created.

(2) In Microsoft SQL Server

Create a data source in order to connect to the database specified in Products for connection.

To create a data source for Microsoft SQL Server:

In the Create Data Source/Net Service dialog box, select the name of the database product to be connected from Products for connection, and then click the Next button.
The Create Data Source dialog box appears.
In this dialog box, set information about the server and the database name that are required in order to create a data source.

Figure 10-24 Create Data Source dialog box (for Microsoft SQL Server)

Server

Specifies the server name or IP address of the connection-target database. There is no default.

The permitted value is 1 to 63 bytes of characters and the following symbols:

% ~ - _ . / \

Database name

Specifies the name of the connection-target database. There is no default.

The permitted value is 1 to 128 bytes of alphanumeric characters and symbols, except the following symbols and the space:

\ / * " ' | . < > ?

ODBC data source name

Displays the name of the database connection service as the ODBC data source name according to the selected connection target.

To change the ODBC data source name, do the following:

If you have selected JP1/Asset Information Manager from Products for connection, change the Service name setting in Database Information in the Server Setup dialog box.

If you have selected JP1/SD from Products for connection, change the Connection service for JP1/SD database setting in Link with JP1/SD in the Server Setup dialog box.

Connection user ID

Displays the database login ID that was specified at setup as the connection user ID used to log on to the database.

To change the connection user ID, do the following:

If you have selected JP1/Asset Information Manager from Products for connection, change the Login ID setting in Database Information in the Server Setup dialog box.

If you have selected JP1/SD from Products for connection, change the JP1/SD database login ID setting in Link with JP1/SD in the Server Setup dialog box.
Set the items and then click the OK button.
The data source is created.

(3) In Oracle

Create an Oracle net service to connect to the database specified in Products for connection.

To create an Oracle net service:

In the Create Data Source/Net Service dialog box, select the name of the database product to be connected from Products for connection, and then click the Next button.
The Create Net Service dialog box appears.
In this dialog box, specify information about the server and database name required in order to create a net service.

Figure 10-25 Create Net Service dialog box (for Oracle)

Server

Specifies the server name and IP address of the connection-target database.

There is no default. The permitted value is 1 to 63 bytes of characters and the following symbols:

% ~ - _ . / \

SID

In Oracle 8i, specify the SID of the database to be connected. In Oracle 9i, specify the service name.

There is no default. The permitted value is 1 to 8 bytes of alphanumeric characters.

Port number

Specifies the port number of the target database server. The permitted value is from 1 to 65535. The default is 1521.

Net service name

Displays the database connection service name as the net service name according to the selected connection target.

To change the net service name, do the following:

If you have selected JP1/Asset Information Manager from Products for connection, change the Service name setting in Database Information in the Server Setup dialog box.

If you have selected JP1/SD from Products for connection, change the Connection service for JP1/SD database setting in Link with JP1/SD in the Server Setup dialog box.

Connection user ID

Displays the connection user ID used to log on to the database.

To change the connection user ID, do the following:

If you have selected JP1/Asset Information Manager from Products for connection, change the Login ID setting in Database Information in the Server Setup dialog box.

If you have selected JP1/SD from Products for connection, change the JP1/SD database login ID setting in Link with JP1/SD in the Server Setup dialog box.
Set the items and then click the OK button.
The data source is created.

All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.

10.3.8 Creating a data source or a net service

(1) In Embedded RDB

(2) In Microsoft SQL Server

(3) In Oracle