Integrations > Third Party Integrations > Import From Excel Workbook Discovery > How to Import Data from Excel Workbook

How to Import Data from Excel Workbook

This task describes how to run the Import from Excel discovery. The Import from Excel Workbook job imports data from the Probe's file system (or accessible network share), so no credentials are required.

Note  

  • The Import from Excel Sample job is similar to the Import from Excel Workbook job. It differs only by reference to the sample import file.

  • This integration is configured to run in remote process.

  1. ClosedPrequisite- Set up the Import file in Excel

    For details on setting up the import file, see How to Set Up an Import File in Excel.

  2. ClosedPrerequisite - Set up permissions

    Give the Data Flow Probe read permissions on the location on the file system where the import files are stored.

  3. ClosedRun the discovery

    In the Integration Studio, create a new integration point.

    1. Provide a name and description for the integration point.

    2. Under Integration Properties > Adapter, select the Import topology from Excel Workbook adapter.

    3. Under Adapter Properties > Data Flow Probe, select the Data Flow Probe.

    4. Under Adapter Properties > Trigger CI instance select one of the following:

      • Select Existing CI (if you have a valid, existing CI). The Select Existing CI pane appears. Select the CI and click OK.

      • Create New CI (if you need to create a new CI). The Topology CI Creation Wizard appears. Create the CI using the Wizard.

        Note For details on the Topology CI Creation Wizard, see "Topology CI Creation Wizard" in the HPE Universal CMDB Data Flow Management Guide.

    5. Save the Integration Point.

    6. Run the job.

    Note For details on running an integration job, see "Integration Studio" in the HPE Universal CMDB Data Flow Management Guide.