Creating a BMC Helix Data Manager user

To automatically create a BMC Helix Data Manager user

1. Select Configuration > Register & Configure Systems.
2. Select Action > Create HDM Database Integration.
   
3. Enter the user name and passwords and click Create Database Integration.
   A progress tracker appears and then displays a success or failure message.
4. Click Close.

(Optional) Using scripts to create a BMC Helix Data Manager user

The following sections describe how you can use scripts to create a BMC Helix Data Manager user instead of using the automatic process described above.

To create the user with Microsoft SQL scripts

The following Microsoft SQL scripts for manual integration are provided:

• create_cmt_server_login.sql
• drop_cmt_server_loging.sql
• drop_cmt_database_user.sql
• create_cmt_database_user_self_contained.sql

The files are stored in the C:\Program Files\bmc\Helix Data Manager\Engine\artifacts\manual_integration\mssql folder.

Use the create_cmt_server_login.sql and drop_cmt_server_loging.sql files to create and drop the Microsoft SQL Server login for the BMC Helix Data Manager user. You only need to apply this once per server.

Use the drop_cmt_database_user.sql and create_cmt_database_user_self_contained.sql files to drop and create the BMC Helix Data Manager user and associated objects from a specific database on a Microsoft SQL Server.

Apply these scripts to each database in the Microsoft SQL Server. The database users that these scripts create are mapped to the BMC Helix Data Manager login created above.

Change the USE [xxx] statement at the top of the database specific scripts to apply these to the correct database. For example, changing this to use [ARSYSTEM] will create or drop the BMC Helix Data Manager user and its objects from the ARSYSTEM database.

If you have multiple databases on the same server, amend the database name and apply the create_cmt_database_user_self_contained.sql script to each.

To create the user with Oracle scripts

The following Oracle scripts for manual integration are provided:

• run_as_system.sql
• run_as_cmt.sql

The files are stored in C:\Program Files\bmc\Helix Data Manager\Engine\artifacts\manual_integration\oracle folder.

Execute the run_as_system.sql file as a user with DBA privileges. The file will drop the existing BMC Helix Data Manager user and all schema objects, create the BMC Helix Data Manager user, and apply the correct privileges.

Run the run_as_cmt.sql file as the BMC Helix Data Manager user. The file will create some BMC Helix Data Manager helper functions in the BMC Helix Data Manager schema.