Registering a system for BMC Helix ITSM: Smart IT

To get stared with the data migration for BMC Helix ITSM: Smart IT, register a system for Smart IT and Openfire.

To register a system

1. Log in to BMC Helix Data Manger.
2. Navigate to the Configurations tab and select Register & Configure Systems.
3. On the System page, navigate to the System Info tab.
4. Click the Create icon.
   The Create, Modify, and Delete buttons appear on the left side. After clicking Create or Modify, the fields are enabled for input.
   

5. From the Type list, select Relational Database.

   Warning

   Important

   You must select the Type value as Relational Database while registering a source system and target system for Smart IT and Openfire.

6. Complete the following fields:

   Field	Description
   Display Name	The name of the system as it will be displayed in BMC Helix Data Manager. This is a descriptive name and does not need to match the network address.
   Environment	The name of the environment.
   Location	The location of the database. Options are: Local Remote
   System Type	The type of system. This is for display purposes only and does not affect the behavior of BMC Helix Data Manager when interacting with this system. Options are: Development Production QA UAT (user acceptance testing)

7. If you selected Local for the Location field, complete the following fields on the Database tab.

   Field		Description
   Database Type		The type of database that is hosting the system. The options are: MS SQL Oracle PostgresSQL Sybase Depending on the option you select, the fields will change on the tab.
   Network Address		The network address for the database server hosting Remedy. BMC Helix Data Manager Engine must be able to resolve this address. The BMC Helix Data Manager Workbench never directly accesses the Remedy server.
   Port		The port on which the Smart IT database server is listening for incoming SQL connections.
   Use Windows Authentication		If selected, BMC Helix Data Manager uses Window Authentication.
   Enabled for Data Migration		If selected, the system is enabled for migrating data, and one of the following fields appears (depending on the database type you selected): DB Collation—Manually add the database collation value (for example, SQL_Latin1_General_CP1_CI_AS). Or allow the field to be automatically completed by selecting Action > Get Character Database Set after you register the system. DB Character Set—Enter the respective database character set value.
   MS SQL	Instance Name	The name of the database MS SQL instance name. The name can be the name of the physical machine, or the DBA can define the name.
   	Database Name	The MS SQL database name, typically SmartIT.
   	Migration Mode	The migration mode that will be used. Options are: Bcp JDBC
   Oracle	Service Name/SID	Select Service Name or SID, and enter the corresponding value in the field below.
   	Schema Name	The Oracle schema name, typically SmartIT admin.
   PostgresSQL	Instance Name	The name of the database PostgresSQL instance name. The name can be the name of the physical machine, or the DBA can define the name.
   	Database Name	The PostgresSQL database name, typically SmartIT.
   Sybase	Service Name/SID	Select Service Name or SID, and enter the corresponding value in the field below.
   	Schema Name	The Sybase schema name, typically SmartIT admin.
   HDM User		The name of the database user that BMC Helix Data Manager will use to access the Smart IT database server and the underlying Smart IT database. The manual database configuration scripts typically use “hdm” as the database user name.
   HDM Password		The password for the database user that BMC Helix Data Manager uses to access the Smart IT database server and the underlying Smart IT database. Use one that meets your local security policy.

   The following image shows an example:
   

8. (Optional) If you selected Remote for the Location field, complete the following fields on the Database tab.

1. 1. Select Enabled for Data Migration.
   2. Complete one of the following fields, which appears based on the type of database you selected:
      • DB Collation—Manually add the database collation value (for example, SQL_Latin1_General_CP1_CI_AS). Or allow the field to be automatically completed by selecting Action > Get Character Database Set after you register the system.
      • DB Character Set—Enter the respective database character set value.

2. On the Schemas tab, click the Create icon, and complete the following fields:

   Field	Description
   Schema Name	The schema name of the database.
   Logical Name	The logical name of the database. Important: For Smart IT source system, you must specify the logical names of Business and System schemas as Business and System. The following image shows an example: For Smart IT target system, specify the value as Default. The following image shows an example:

3. Click the Save () button on the System Info tab.

Where to go from here

Actions-you-can-perform-on-a-system-you-have-registered (to test connectivity)

Discovering-data-dictionaries