Instruction to feed data to Migration Dashboard

Cloud Migration dashboard presents sliced and diced data of your datacenter that provides key insights on, resource utilization and cost. You can plan and track migration of resources. Also, compare cost and configuration of resources before and after migration, with the help of tags.

Follow the below steps to know how to feed data to Migration Dashboard.

  1. Navigate to My Company > Bulk Upload page.
  2. Click Template from the drop-down list and select Cloud Migration and click Download.
  3. The template file will be downloaded to your system. the file will be in .CSV format.
  4. Add data of your private cloud in the downloaded template file.
  5. You can provide data of your Physical Machines, Virtual Hosts and Virtual Machines. Based on the type of data you have. Certain fields are mandatory.
  6. Refer to the table below to know the mandatory fields for Physical Machines, Virtual Hosts and Virtual Machines. Also, follow the instructions shared for successful upload of data.
    Table 1. Instructions
    Field Name Data Format Mandatory Instructions
    Format (Max. Count) Physical Machine Virtual Hosts Virtual Machine
    Vendor-name NVARCHAR2(256) Yes Yes Yes

    Vendor Name is name of ISV.

    The value should be one of the following options,

    1. vMWare
    2. OpenStack
    region NVARCHAR2(256) Yes Yes Yes
    1. Enter the name of the region where the datacenter is located in.
    2. The supported data format is NVARCHAR2.
    3. Maximum of 256 characters is supported.
    datacenter_name NVARCHAR2(256) Yes Yes Yes
    1. Enter the name of the datacenter where the resource is located.
    2. The supported data format is NVARCHAR2.
    3. Maximum of 256 characters is supported.
    host_name NVARCHAR2(256) Yes Yes Yes
    1. The supported data format is NVARCHAR2.
    2. Maximum of 256 characters is supported.
    host_CPU_count NUMBER(5) Yes Yes No
    1. Enter the CPU count of the respective resource.
    2. Only numbers are accepted.
    3. Maximum of 5 digits is supported.
    host_CPU_core NUMBER(5) Yes Yes No
    1. Enter the CPU core of the respective resource.
    2. Only numbers are accepted.
    3. Maximum of 5 digits is supported.
    host_memory (in GB) NUMBER(5) Yes Yes Yes
    1. Enter the memory capacity of the respective resource.
    2. Only numbers are accepted.
    3. Maximum of 5 digits is supported.
    isv_resource_id NVARCHAR2(256) Yes Yes Yes
    1. isv_resource_id is the id that is assigned to the resources while launching the resource.
    2. The supported data format is NVARCHAR2.
    3. Maximum of 256 characters is supported.
    instance_CPU_count NUMBER(5) Yes No Yes
    1. Enter the CPU count of the respective VM.
    2. Only numbers are accepted.
    3. Maximum of 5 digits is supported.
    instance_CPU_core NUMBER(5) Yes No Yes
    1. Enter the CPU core of the respective VM.
    2. Only numbers are accepted.
    3. Maximum of 5 digits is supported.
    instance_memory NUMBER(5) Yes No Yes
    1. Enter the memory capacity of the respective VM.
    2. Only numbers are accepted.
    3. Maximum of 5 digits is supported.
    Guest_OS NVARCHAR2(256) No No Yes
    1. Enter the OS name of the respective resource.
    2. The supported data format is NVARCHAR2.
    3. Maximum of 256 characters is supported.
    resource_cost_per_day Decimal(20,6) No No Yes
    1. Enter the cost associated with the respective resource.
    2. You can enter the values in decimals.
    3. Up to 6 decimal value is supported.
    4. Maximum of 256 characters is supported.
    powerstate CHAR(3) No No Yes
    1. Enter the power state of the resource i.e., whether the resource is in ON state or in OFF state.
    2. The entered value can either be "Y" or "N" Where Y stands for ON and N stands for off state. Any other input will fail the record.
    power_on_date DATE (yyyy_mm_dd) No No Yes
    1. Enter the date on which the resource was powered on.
    2. The input should be in Date format3. The supported date format is yyyy_mm_dd. Any other date format will fail the record.
    suspend_on_date DATE (yyyy_mm_dd) No No No
    1. Enter the date on which the resource was suspended.
    2. The input should be in Date format.
    3. The supported date format is yyyy_mm_dd. Any other date format will fail the record.
    annotations Alphanumeric, = (equals), : (hyphen) No No No
    1. Enter the tags associate with the resource.
    2. The tags should be added in the following format only -
      • tags1=value1;tags2=value2;tags3=value3;
      • All tags should end with;. Even if it is just one tag.
    migration_flag CHAR(1) Yes Yes Yes
    1. Mark whether the resource has to be migrated or not.
    2. The entered value can either be "Y" or "N" Where Y stands for Yes and N stands for No state. Any other input will fail the record.
  7. Now that all the data is added to the template file, upload the same template file. Under Bulk upload page, click on Upload template.