How to import Discovery 9.x data (Computers) into HEAT 2013.x

Version 1


    This article describes on how to import Discovery 9.x data (Computers) into HEAT 2013.x.



    Currently in HEAT 2013.x there is no option to directly integrate with DISCOVERY 9.x.In order to utilize data gathered by Discovery agents you need to exercise following procedure.

    1. Launch Discovery Control Center
    2. Select machines that you would like to export
    3. Click right mouse button to invoke context menu
    4. Look for EXPORT DATA, and click on that option
    5. Select Computer System Details from the list of Available exports and click Export… 
    6. Name the file and point out the location where CSV file with exported data shall be saved

    Once computer data is saved in ComputerDetails.csv, you may need to review its contents. Open it in EXCEL to remove unnecessary columns to match CI.Workstation fields, and save it as *.XLS file. Once it is done proceed with data import.

    • Log into HEAT under the Administrator role 
    • Go to upper right corner and click on Configure Application 
    • Choose Third-Party Integration from list on the left (System Setup section) 
    • Scroll down and click START button 
    • [Connection Manager] Click on Add New under Connection Manager 
    • [Connection Settings] Click Connection Type as Data Import 
    • Fill in Connection Name e.g. DiscoImport 
    • Choose Manual as Location 
    • Click Upload to show data file location 
    • Choose accordingly whether uploaded file is a Comma delimited or Excel Spreadsheet (XLS, XLSX) 
    • Verify date & time format settings when importing date & format columns 
    • Click Test Connection 
    • If connection is successful click Next button 
    • [Object Mapping] Add new Object Mapping name (e.g. XLSmap) 
    • Pick a Source Unique Key from list of available columns to import (e.g. Client ID) 
    • Choose a business object to import data to (e.g. CI#Computer) 
    • Click Next button 

    • [Filter Manager] if you like to create filter feel free to do it in that section 
    • Click Next button 
    • [Field Manager] HEAT will try to map automatically field based on the columns’ names from a source file. If you like you may change it, or add additional mappings
    • Click Next button

    • [Review & Publish] Click Preview button to see data import preview 
    • Verify correctness of data to be imported on the preview

      • Choose either Publish & Run Now or Publish & Test Run or
      • Verify whether the import is
      1. FINISHED > Integration History 
      2. SUCCESSFUL > Integration Log

      • Open up ErrorStats entry in Integration log for detailed info about failed import