Registering a system for Innovation Suite
- Open the System page by completing one of the following steps:
- If you are on the Help tab and registering your initial system, select Migrate Data from the list, and then click Register Systems.
- If you are registering an additional system, select Configuration > Register & Configure Systems.
- Click Create
. - From the Type list, select Innovation Suite.
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 that this Innovation Suite system is part of. You can select from the list of options configured on the Environments page.
Location
The location of the database. Options are:
- Local
- Remote
ARS Version
The AR System version. This choice affects the way in which BMC Helix Data Manager interacts with the AR System data dictionary. Subtle differences in the underlying AR System data dictionary hold the metadata for an AR System application between versions. This value is important for application discovery to run correctly.
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)
API
Select this option if you want to enable AR System API connections to this server. This is used to build AR System workflow and not for any other operation. You must provide an AR System Administrator user and password to successfully build workflow. (You cannot register a user without a password.)
If you select this option, the Remedy API tab appears next to the Database tab. Complete these fields as described in step 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 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.
Catalog - Physical Db Name
The actual database name of the catalog system.
Catalog - Logical Db Name
The actual database name that is used for configurational operations.
Tenant - Physical Db Name
The actual database name of the catalog system.
Tenant - Logical Db Name
The actual database name that is used for configurational operations.
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 ARADMIN.
Catalog - Physical Db Name
The actual database name of the catalog system.
Catalog - Logical Db Name
The actual database name that is used for configurational operations.
Tenant - Physical Db Name
The actual database name of the catalog system.
Tenant - Logical Db Name
The actual database name that is used for configurational operations.
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.
Catalog - Physical Db Name
The actual database name of the catalog system.
Catalog - Logical Db Name
The actual database name that is used for configurational operations.
Tenant - Physical Db Name
The actual database name of the catalog system.
Tenant - Logical Db Name
The actual database name that is used for configurational operations.
Sybase
Service Name/SID
Select Service Name or SID, and enter the corresponding value in the field below.
Catalog - Physical Db Name
The actual database name of the catalog system.
Catalog - Logical Db Name
The actual database name that is used for configurational operations.
Tenant - Physical Db Name
The actual database name of the catalog system.
Tenant - Logical Db Name
The actual database name that is used for configurational operations.
HDM User
The name of the database user that BMC Helix Data Manager will use to access the underlying database. The manual database configuration scripts typically use “hdm” as the database user name.
Do not use the ARADMIN/ARAdmin user for this connection. You can run the greater part of discovery with the same database user as used by the AR System server, but data migration should not be run with that name.
HDM Password
The password for the database user that BMC Helix Data Manager uses to access the database. Use one that meets your local security policy.
- (Optional) If you selected Remote for the Location field:
- Select Enabled for Data Migration.
- 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.
If you selected the API check box in step 3, click the Remedy API tab, and complete the following fields.
This information is required if you want to build AR System workflow by using BMC Helix Data Manager. All other functions are performed directly at the database tier.Field
Description
Server Address
The IP address or network name of the server that will be connected to. If this server is an AR System server group, the server must have Administrator rights. When building workflow as part of an upgrade, we strongly recommend that only one server is active during the build process.
Remedy User Name
The user name of the AR System Administrator user.
Remedy Password
The AR System password for the AR System Administrator user.
Remedy Port
The port on which the database server is listening for incoming SQL connections. Set as 0 if using a port mapper.
- 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)