Registering a system for Smart IT

To get started 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 Create .
   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	Name of the source or target system.  The Display name need not match the network address.
   Environment	Name of the environment that this Smart IT system is part of. Select DEFAULT.
   Location	Location of the database. Options are: Local Remote
   System Type	This option is for display purposes only, it does not affect the behavior of BMC Helix Data Manager when it interacts with this system. Options are: Development Production QA UAT (user acceptance testing)

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

   Field		Description
   Database Type		Type of database that is hosting the system. Options are: MS SQL Oracle PostgresSQL Sybase Depending on the option you select, the fields will change on the tab.
   Network Address		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		Port on which the Smart IT database server is listening for incoming SQL connections.
   Use Windows Authentication		Option to use Window Authentication. If selected, BMC Helix Data Manager uses Window Authentication.
   Enabled for Data Migration		Option to enable the system for data migration. If selected, the system is enabled for migrating data, and one of the following fields appear, 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	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	MS SQL database name, typically SmartIT.
   	Migration Mode	Migration mode that will be used. Options are: Bcp JDBC
   Oracle	Service Name/SID	Service name or SID value. Select Service Name or SID, and enter the corresponding value in the field below.
   	Schema Name	Oracle schema name, typically SmartIT admin.
   PostgresSQL	Instance Name	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	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	Sybase schema name, typically SmartIT admin.
   HDM User		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		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 Create , and complete the following fields:

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

3. Click Save () 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