13.6 ZENworks Database Policy

This policy identifies the location of the ZENworks Database object. If you selected to install the ZENworks database, you should configure and enable this policy.

NOTE:In previous versions of ZENworks for Desktops, you configured and enabled the ZENworks Database policy using the Service Location Package. In ZENworks for Desktops 4.x and later, you can also configure and enable this policy in the Server Package.

The ZENworks Database policy in the Server Package lets you configure only the Inventory database. The ZENworks Database policy in the Service Location Package lets you configure both the Inventory database and the Application Management databases.

If backward compatibility with an existing ZENworks Database policy for ZENworks for Desktops 3.x is important, you might want to configure this policy in the Service Location Package. However, there is improved manageability if you configure this policy in the Server Package. Configuring the ZENworks Database policy in the Server Package allows you to associate the policy with individual servers rather than with containers.

Sybase: If you are using a Sybase database, the Database object might have been installed with default property values, depending on whether you selected to install Desktop Management Inventory. In either case, follow the applicable steps under Configuring the ZENworks Database Object for Sybase, then continue with Setting Up the ZENworks Database Policy.

Oracle: If you are using an Oracle database, you need to create the Database object and enter the required property values. In this case, follow the steps under Configuring the ZENworks Database Object for Oracle, then continue with Setting Up the ZENworks Database Policy.

13.6.1 Configuring the ZENworks Database Object for Sybase

While performing the following steps, you can get detailed information about each dialog box by clicking the Help button.

  1. In ConsoleOne, right-click the Database object, then click Properties.

    The ZENworks Database tab should be displayed.

  2. Fill in the applicable fields, keeping the user name and password pairs together:

    Database (Read-Write) User Name: Secures read and write access to the database file.

    Database (Read-Write) Password: Secures read and write access to the database file.

    Database (Read Only) User Name: Secures only read access to the database file.

    Database (Read Only) Password: Secures only read access to the database file.

    Database (Write Only) User Name: Secures only write access to the database file.

    Database (Write Only) Password: Secures only write access to the database file.

  3. To change any default JDBC* driver type information, click the JDBC Driver Information tab, then edit the fields:

    • Driver
    • Protocol
    • Subprotocol
    • SubName
    • Port
    • Flag
    • Database Service Name
  4. If you will use an ODBC driver for the database file, click the ODBC Driver Information tab, then fill in the fields:

    • Driver Filename
    • Data Source Name
    • Connection Parameters
  5. Click OK to save the database property changes.

Continue with Setting Up the ZENworks Database Policy.

13.6.2 Configuring the ZENworks Database Object for Oracle

While performing the following steps, you can get detailed information about each dialog box by clicking the Help button.

  1. In ConsoleOne, right-click the container where the Database object is to be created, click New, click Object, click ZENworks Database, then click OK.

  2. Specify a name for the Database object, click Define Additional Properties, then click OK.

    The ZENworks Database tab should be displayed.

  3. Select the DN of the server where the database files are to be stored.

  4. (Optional) Specify the IP address of the server.

  5. Fill in the applicable fields, keeping the user name and password pairs together:

    Database (Read-Write) User Name: Secures read and write access to the database file.

    Database (Read-Write) Password: Secures read and write access to the database file.

    Database (Read Only) User Name: Secures only read access to the database file.

    Database (Read Only) Password: Secures only read access to the database file.

    Database (Write Only) User Name: Secures only write access to the database file.

    Database (Write Only) Password: Secures only write access to the database file.

  6. To specify the JDBC driver type, click the JDBC Driver Information tab, click the Populate Fields With Default Values For An Oracle Database button, then click Populate Now.

  7. To change any default JDBC driver type information, edit the fields:

    • Driver
    • Protocol
    • SubProtocol
    • SubName
    • Port
  8. If you will use an ODBC driver for the database file, click the ODBC Driver Information tab, then fill in the fields:

    • Driver Filename
    • Data Source Name
    • Connection Parameters
  9. Click OK to save the database property changes.

Continue with Setting Up the ZENworks Database Policy.

13.6.3 Setting Up the ZENworks Database Policy

While performing the following steps, you can get detailed information about each dialog box by clicking the Help button.

  1. In ConsoleOne, right-click the Server Package or the Service Location Package, then click Properties.

    The General tab is displayed.

  2. Select the check box under the Enabled column for the ZENworks Database policy.

    This both selects and enables the policy.

  3. Click Properties.

  4. Select the database DN, then click OK.

  5. When you have finished configuring all of the policies for this package, continue with the steps under Section 14.5, Associating the Service Location Package to associate the policy package.