Data Import Schema

Junkshon Data Import

ASPIRE platform import allows you to import details of your on-premises environment directly into the platform so you can perform migration assessment and planning

Supported Import Fields

APSIRE platform import allows you to import data from any source. The data provided must be in the supported format for a CSV file, and the data must contain only the supported fields with the supported ranges for those fields.
 
An asterisk next to an import field name in the following table denotes that it is a required field. Each record of your import file must have at least one or more of those required fields populated to uniquely identify a server or application. Otherwise, a record without any of the required fields will fail to be imported.
Import Field Name
Description
Examples
Field Type
Length
Display

Server Name*

The hostname of the server. We recommend using the fully qualified domain name (FQDN) for this value.

ip-1-2-3-4

localhost.domain

VarChar

50

MCDB

Node Type

The type of node

Virtual

Physical

Hypervisor

VarChar

12

MCDB

Cores/CPU

The number of CPUs

4

Integer

6

MCDB

Memory

The total RAM available on the server in (GB)

64

Integer

12, two decimal places

MCDB

Avg CPU Utilisation percentage

The average CPU utilization.

45

Integer

8, two decimal places

MCDB

Peak CPU Utilisation percentage

The maximum CPU utilisation.

55

Integer

8, two decimal places

MCDB

Avg Memory Utilisation percentage

The average amount of used RAM on the server in (GB)

32

Integer

8, two decimal places

MCDB

Peak Memory Utilisation percentage

The maximum amount of used RAM on the server in (GB)

55

Integer

8, two decimal places

MCDB

Operation System Name

The name of the operating system

Windows 2012 / RedHat Linux 5

VarChar

100

MCDB

Operating System Version

The version of the operating system

16.04 / NT 6.2.8

VarChar

50

MCDB

Allocated Storage (GB)

Allocated storage to the server.

50

Integer

12, two decimal places

MCDB

Used Storage (GB)

Used storage in the server.

25

Integer

12, two decimal places

MCDB

Storage Type

The type of storage.

Block

File

Object

VarChar

30

MCDB

Min IOPS

Maximum IOPS

25

Integer

12, two decimal places

MCDB

Max IOPS

Maximum IOPS

44

Integer

12, two decimal places

MCDB

Avg IOPS

Average IOPS

33

Integer

12, two decimal places

MCDB

Hardware

The server hardware model

HPE DL380

Virtual Machine

VarChar

50

MCDB

Hardware Type

The server hardware type

Rackmount

Blade

VarChar

20

MCDB

Deployment Type

The deployment type for the server/application.

Allowed values:

On-Prem

Co-Lo

Public-Cloud

Private-Cloud

Managed-VPC

Unknown

On-Prem

VarChar

50

MCDB

Business Unit

The business unit name for the server/application

SALES

VarChar

50

MCDB

Location

The data centre location for this server/application 

DC1

VarChar

50

MCDB

Service

Description of the service this server/application supports.

Call Centre

VarChar

50

MCDB

Application*

Application2; Application3

Call Centre

VarChar

50

MCDB

Application Type

The type of application

Business Application, Infrastructure

VarChar

50

MCDB

Component

The type of application

WINNT.DLL; IE.EXE

VarChar

50

MCDB

Database Name*

The logical database name, semicolon-delimited list of database instances.

SALES01;PARTS01

VarChar

50

MCDB

Database Type

The database product type.

MYSQL5, Oracle 8i

VarChar

50

MCDB

Database Role

The database role.

Standalone, Cluster, DR Node

VarChar

50

MCDB

Database Size (GB)

The database size in (GB), you can semicolon delimiter in line with the database instance names to the assign size per instance.

250;560

Integer

10, two decimal places

MCDB

Database Log Size (GB)

The database log size of the database in (GB), you can semicolon delimiter in line with the database instance names to the assign size per instance.

100;500

Integer

10, two decimal places

MCDB

Preferred R Treatment

The preferred treatment for the node.

REHOST;REPLATFORM

VarChar

30

MCDB

Tags

A semicolon-delimited list of tags formatted.

zone1;zone2

VarChar

50

MCDB

Table notes:

Field Type:

  • VarChar – The varchar columns in the table are of variable length string that can hold either numeric or character or both.
  • Integer – is a numeric value. It defines whole numbers that can be stored in a field or column.

Display:

  • MCDB – shown in the MCDB grid.
  • Internal – used by the internal business logic of the platform.

Matching Fields

ASPIRE platform has built-in matching logic that identifies when servers it discovers match existing entries. When this logic finds a match, it updates the information for the already-existing discovered server with new values.

***Matching fields ***

The following field is used to match servers:–

  • ServerName

The following field is used to match the database instance names, these should be unique.–

  • Database Name. (logical database name)
Contact Junkshon