Asset Management › Engine Tasks › All Engine Tasks › Database Synchronization Task › Specify Connection Details for the Database Synchronization Task

Specify Connection Details for the Database Synchronization Task

You can initiate the synchronization of the Client Automation assets and inventory data with an existing MDB on Oracle or SQL Server by creating the Database Synchronization task. While creating the task, specify the credentials (connection properties) for the target database on the Specify connection details for the external database dialog of the Create New Task wizard.

To specify connection details for the Database Synchronization task

1. Select the type of database where data must be synchronized from the Server Type drop-down list. You can select Oracle (default) or SQL Server.
2. Enter the name of the computer that hosts the Oracle or SQL Server MDB in the Server Name field.
3. Enter information in the appropriate fields depending on the type of the target database selected:

   SID

   Lets you enter the session ID of the Oracle MDB. This ID is used to identify the database on the Oracle Server. The default value is orcl. This field is displayed when Oracle is selected as the target database.

   Instance

   Lets you enter the database instance on the SQL Server. This field is displayed when SQL Server is selected as the target database.

   Port

   Lets you enter the port number for the Oracle MDB. This field is displayed when Oracle is selected as the target database. The default value is 1521.

   DB Name

   Lets you enter the database name for the SQL Server MDB. This field is displayed when SQL Server is selected as the target database. The default value is mdb.

4. Enter the user name used when connecting to the target database in the Username field.
5. Enter the password of the user for the target database in the Password field.

You can immediately test the settings you made by clicking the Test Connection button. The DSM manager then tries to open a connection to the target database. The result of this action is displayed next to the Test Connection button, for example, Connection failed.