How do I export data to BMC Atrium CMDB?

To run atriumExporter in order to create the target database

To schedule atriumExporter

To run atriumExporter from the command line

To force atriumExport to run a Full Export

To view atriumExporter log messages

The Entuity integration for BMC Atrium CMDB uses Data Export to export data from the Entuity managment database to its target database. By default, the target database is AtriumExport on the same Entuity server.

The export utility, atriumExport, exports:

• data from the target database to the import dataset (ENTUITY.IMPORT.TOPO) on the BMC Atrium CMDB.
• data that is new or has changed since the last successful export, identifying changed data through comparison of timestamps between the two databases.
• explicitly defined device and port data, also including meta data e.g. internal Entuity identifiers, timestamps etc.

atriumExporter only exports device and port data that is not already held in the import database on the BMC Atrium CMDB. This minimizes the amount of data forwarded from Entuity to BMC Atrium CMDB without compromising the integrity of the data held there.

To run atriumExporter in order to create the target database:

Before you run the Data Export BMC Atrium CMDB job for the first time, you must have already created the target Data Export database. Ensure the BMC Atrium CMDB server is running and Entuity is correctly configured to connect to the server, and ensure the Entuity database is running.

To create the target database AtriumExport:

1. From the command line on the Entuity server, navigate to entuity_home/integ/Atrium/bin.
2. Run atriumExporter:

   atriumExporter --createDatabase

   atriumExporter determines the database name from the value stored in entuity_home/etc/Atrium.cfg, and reports its progress to the command line.

To schedule atriumExporter:

atriumExporter should not be run before the Data Export job has completed.

By amending its configuration files, you can schedule atriumExporter so that it is run automatically by provost:

1. In entuity_home/etc/provost_site_specific.conf uncomment (remove the hash sign (#)) the reference to provost_atrium_exporter.conf:

   !${ENTUITY_HOME}/etc/provost_atrium_exporter.conf

   provost_atrium_exporter.conf configures provost to run atriumExporter every day at 03:00:

   job atriumExporter {
   count 1, start @03:00:00, repeat forever, interval 24h, command '${ENTUITY_HOME}${FPS}integ${FPS}Atrium${FPS}bin${FPS}atriumExporter'
   }

To run atriumExporter from the command line:

1. From the command line on the Entuity server, navigate to entuity_home/integ/Atrium/bin
2. Run atriumExporter:

   atriumExporter

   atriumExporter reports the progress of the transfer. When the value of a device or port attribute is absent but is required as an identity attribute by BMC Atrium CMDB, atriumExporter will raise an error.
3. When atriumExporter completes, it provides a summary of the export.

To force atriumExport to run a full export:

By default, atriumExporter only exports device and port data that is not already held in the import database on the BMC Atrium CMDB. This minimizes the amount of data forwarded from Entuity to BMC Atrium CMDB, improving the time taken to export data without compromising the integrity of the data held there.

You may want to override this default and run a full export, e.g. if the BMC Atrium CMDB dataset is corrupted or deleted, then a full export is required for the integration to continue functioning correctly.

To run a full export of the target database to the import dataset:

1. From the command line on the Entuity server, navigate to entuity_home/integ/Atrium/bin.
2. Run atriumExporter:

   atriumExporter --ignoreTime

To view atriumExporter log messages:

1. atriumExporter log messages are logged in entuity_home/log/atriumExporter.log. When run from the command line, they are also displayed to the command line.
2. When atriumExporter successfully completes, it will provide an export summary:

   2008-04-03 15:57:29,951 INFO com.entuity.bmc.AtriumExporter - Created CIs: Total: 0 | Modified CIs: BMC_NetworkPort=552 , BMC_PhysicalLocation=29 , BMC_ComputerSystem=46 , BMC_IPEndpoint=46 Total: 673 | Deleted CIs: Total: 0
   2008-04-03 15:57:29,951 INFO com.entuity.bmc.AtriumExporter - Time took for export:00H:01M:12S

   Where:
   • Created CIs provides a breakdown of created CIs by type and a total.
   • Modified CIs provides a breakdown of modified CIs by type and a total.
   • Deleted CIs provides a breakdown of deleted CIs by type and a total.
   • Time took for export is the elapsed time of the export.