Mapping the BMC Atrium CMDB Domain attribute

Transferring data from BMC Server Automation to BMC Atrium CMDB involves the following steps:

First, install the BMC BladeLogic Atrium Integration, which creates the jobs on the BMC Server Automation Application Server, tables, views on BMC Decision Support for Server Automation or TrueSight Server Automation - Data Warehouse, and jobs on the AI console.

Then, map the BMC Atrium CMDB Domain attribute of the BMC_ComputerSystem class to the BMC Server Automation DNS_DOMAIN_NAME property.

To map the Domain attribute to the DNS_DOMAIN_NAME property

1. Depending on which database you are using, navigate to the directory on the computer where BMC BladeLogic Atrium Integration is installed: 
   • (Oracle) BL2AIInstallationDirectory\DBScripts\oracle
   • (Microsoft SQL Server) BL2AIInstallationDirectory\DBScripts\sqlserver
2. Copy the blatrium_customization.sql file to the computer where SQL Server Client (SQL Server) or SQL Plus (Oracle) is installed.

3. Depending on which database you are using, do one of the following:

   Oracle	Log on to SQL Plus as the reports data warehouse user using the following command:  sqlplus <warehousedatabaseuserName/{{code language="none"}} <warehousedatabaseuserPassword {{/code}}> @<warehousedatabaseName>  Run the following command: Execute @blatrium_customization_oracle.sql;
   SQL Server	Run the following command from the SQL Server Client computer: sqlcmd -S <BDSSAwarehousecompName> -d <BDSSAwarehousedatabaseName> -U <BDSSAwarehousedatabaseuserName> -P <BDSSAwarehousedatabaseuserPassword> -i blatrium_customization.sql

   In the above commands: 

   • <warehousecompName> indicates the name of the computer where the BMC Decision Support for Server Automation or TrueSight Server Automation - Data Warehouse warehouse database is located.
   • <WarehousedatabaseName> indicates the name of the warehouse database.
   • {{code language="none"}}
     <warehousedatabaseuserName>
     {{/code}} indicates the name of the warehouse database user.
   • {{code language="none"}}
     <warehousedatabaseuserPassword>
     {{/code}} indicates the password of the warehouse database user.
4. On the BMC BladeLogic Atrium Integration computer, in the BL2AIInstallationDirectory, open the customizationProperties.txt file with a text editor and update the file with the BMC Remedy AR server details.
5. From the command prompt, navigate to the following directory: BL2AIInstallationDirectory\BMCBL2AtriumInstallJVM\bin.

6. Run the following command: java -jar "BL2AIInstallationDirectory\BLAUpdateFieldMapping.jar" "BL2AIInstallationDirectory\customizationProperties.txt".
   
   For example: java -jar "C:\Program Files (x86)\BMC Software\BL2AI\BLAUpdateFieldMapping.jar" "c:\Program Files (x86)\BMC Software\BL2AI\customizationProperties.txt"
   This command generates output similar to the following:

   true
   arServer Name :: vm-w23-cc01
   arServerPort:: 0
   arUser:: Demo
   arPassword:: sa
   INFO  31-05 17:23:19,330 - Trying to load configuration arsys_api.xml
   WARN  31-05 17:23:19,370 - Could not load optional configuration arsys_api.xml
   INFO  31-05 17:23:19,502 - Trying to load configuration default.xml
   INFO  31-05 17:23:19,516 - jrpcMode: true
   INFO  31-05 17:23:19,520 - jniLoadMode: 1
   INFO  31-05 17:23:19,521 - apiRecordingMode: 0
   INFO  31-05 17:23:19,521 - useConnectionPooling: true
   INFO  31-05 17:23:19,522 - maxProxiesPerServer: 80
   INFO  31-05 17:23:19,522 - idleConnectionsPerServer: 5
   INFO  31-05 17:23:19,523 - connectionTimeout: 0
   INFO  31-05 17:23:19,523 - connectionLifespan: 0
   INFO  31-05 17:23:19,524 - timeUnit: MINUTES
   INFO  31-05 17:23:19,524 - minimumSupportedServerRpcVersion: 12
   INFO  31-05 17:23:19,525 - connectionMaxRetries: 1
   INFO  31-05 17:23:19,525 - timeLagBetweenRetriesMillSec: 100
   INFO  31-05 17:23:19,526 - stringizeFieldAssignments: false
   INFO  31-05 17:23:19,526 - stringizeSetIfQualification: false
   INFO  31-05 17:23:19,526 - useLegacyQualParser: false
   INFO  31-05 17:23:19,527 - useLegacyAssignParser: false
   INFO  31-05 17:23:19,527 - useLegacyQualFormatter: false
   INFO  31-05 17:23:19,528 - useLegacyAssignFormatter: false
   INFO  31-05 17:23:19,531 - APITIMEOUT from system property : null
   INFO  31-05 17:23:19,578 - APITIMEOUT from Environment : null
   INFO  31-05 17:23:19,578 - AROVERLAYGROUPS from system property : null
   INFO  31-05 17:23:19,579 - AROVERLAYGROUPS from Environment : null
   INFO  31-05 17:23:22,269 - fipsProviderJsafeJCE installed = false
   INFO  31-05 17:23:23,579 - set timer period 60000 milliSec (00:01:00)
   INFO  31-05 17:23:23,622 - Connects to vm-w23-cc01 through com.bmc.arsys.api.ProxyJRpc@177600e
   INFO  31-05 17:23:23,648 - WIIntegHandler(arg[1]) Init Started
   INFO  31-05 17:23:23,649 - WIIntegHandler Connecting to AR Server Form NGIE:Config
   INFO  31-05 17:23:23,663 - WIIntegHandler Connecting to Repository Database
   INFO  31-05 17:23:23,664 - WIIntegHandler.getKettleInitialized Started
   INFO  31-05 17:23:24,023 - Using "C:\Users\ADMINI~1\AppData\Local\Temp\vfs_cache" as temporary files store.
   INFO  31-05 17:23:24,181 - WIIntegHandler.getKettleInitialized JobEntryLoader Initialized
   INFO  31-05 17:23:24,365 - WIIntegHandler Initialize Completed
   INFO  31-05 17:23:24,371 - Reading pentaho configuration from UDM:Config
   INFO  31-05 17:23:24,541 - DevtoProdExportRepository : connectRep : Repository Connection Sucessfull : PDIREPO_vm-w23-cc01_0
   INFO  31-05 17:23:25,295 - transName : BL_PULL_COMPUTERSYSTEM_BL_PULL_COMPUTERSYSTEM
   INFO  31-05 17:23:25,296 - oRepDir.getName() : BL2ATRIUM_REPO
   INFO  31-05 17:23:25,306 - existingId : 000000000000190
   INFO  31-05 17:23:25,320 - strIntegrationName : BL2ATRIUM_REPO
   INFO  31-05 17:23:25,321 - tmetaKTR.getRepositoryDirectory().getName() : BL2ATRIUM_REPO
   INFO  31-05 17:23:25,380 - Connects to vm-w23-cc01 through com.bmc.arsys.api.ProxyJRpc@1167c35
   INFO  31-05 17:23:25,394 - Trying to load configuration arsys_api.xml
   WARN  31-05 17:23:25,396 - Could not load optional configuration arsys_api.xml
   INFO  31-05 17:23:25,397 - Trying to load configuration default.xml
   INFO  31-05 17:23:27,196 - Start Time : 1370001205322 : End Time : 1370001207196 : Difference : 1874
   Updated field mapping successfully...
7. Log on to Atrium Integrator Spoon.
8. From the Tools menu, choose Database > Clear Cache.
9. Restart the BMC Remedy AR service.

To verify that the mapping is done correctly

1. Log on to Atrium Integrator Spoon.
2. From the Tools menu, choose Repository > Explore.
3. In the right pane, double-click the BL2ATRIUM_REPO repository.
4. In the right pane, double-click the BL_PULL_COMPUTERSYSTEM_BL_PULL_COMPUTERSYSTEM transformation.
5. In the transformation, right-click the icon for CMDBOutput and choose Edit step.
6. In the CMDBOutput dialog box, in the Update fields section, verify that the Domain class attribute is mapped to DNS_DOMAIN_NAME.