Importing data into Strategy Recommendations - Migration Hub Strategy Recommendations

Importing data into Strategy Recommendations

As an alternative to using the application data collector, you can import information about the applications and servers for which you want migration and modernization recommendations.

When you import data, the recommendations are not as in-depth as they are when you use the data collector. For example, you cannot use source code analysis on imported data.

This section describes how to use the application import template to import data into Strategy Recommendations in the Migration Hub console.

To import data

  1. Using the AWS account that you created in Setting up Strategy Recommendations, sign in to the AWS Management Console and open the Migration Hub console at https://console.aws.amazon.com/migrationhub/.

  2. In the Migration Hub console navigation pane, choose Strategy and then choose Data sources.

  3. Choose the Imports tab.

  4. Choose Download import template to download the application import template.

  5. Fill out the template and then upload it to an Amazon S3 bucket.

  6. Return to the Imports tab and then choose Import.

  7. Enter a name for your import, enter the Amazon S3 object URI for your filled out data template and then choose Start import.

The Strategy Recommendations import template

The import template that you download is a .json file as shown in the following example.

{ "ImportFormatVersion": 1, "Resources": [ { "ResourceType": "SERVER", "ResourceName": "", "ResourceId": "", "IpAddress": "", "OSDistribution": "", "OSType": "", "HostName": "", "OSVersion": "", "CPUArchitecture": "" }, { "ResourceType": "PROCESS", "ResourceName": "", "ResourceId": "", "ApplicationType": "", "DotNetFrameworkVersion": "", "ApplicationVersion": "", "DotNetCoreVersion": "", "JdkVersion": "", "ProgrammingLanguage": "", "DatabaseType": "", "DatabaseVersion": "", "DatabaseEdition": "", "AssociatedServerIds": [] } ] }

To help you fill out the import template, the valid values for the data fields are listed in the following table.

Name

Description

Type

Required

Valid values

ApplicationType

The type of application

String

Yes

"Tomcat", "JBoss", "Spring", "IIS", "Mongo DB", "DB2", "Maria DB", "MySQL", "Oracle", "SQLServer", "Sybase", "PostgreSQLServer", "Cassandra", "IBM WebSphere", "Oracle WebLogic", "Java Generic"

ApplicationVersion

The version of the application

String

Yes

"IIS 1.0", "IIS 2.0", "IIS 3.0", "IIS 4.0", "IIS 5.0", "IIS 5.1", "IIS 6.0", "IIS 7.0", "IIS 7.5", "IIS 8.0", "IIS 8.5", "IIS 10.0"

AssociatedServerIds

A list of server IDs on which the process is running.

String

Yes

The ResourceId from the "ResourceType": "SERVER" that you defined.

CPUArchitecture

The CPU architecture

String

No

"32bit", "64bit"

DatabaseEdition

The edition of the database

String

No

SQLServer "Microsoft SQL Server Standard", "Microsoft SQL Server Enterprise", "Microsoft SQL Server Workgroup", "Microsoft SQL Server Developer", "Microsoft SQL Server Web", "Microsoft SQL Server Express"

Oracle "Oracle Server Standard One Edition", "Oracle Server Standard Edition", "Oracle Server Enterprise Edition", "Oracle Server Express Edition", "Oracle Server Personal Edition"

DatabaseType

The type database

String

No

"SQLServer", "Oracle", "Sybase", "Mongo DB", "Maria DB", "Apache Cassandra", "MySQL", "IBM DB2", "PostgreSQLServer"

DatabaseVersion

The version of the database

String

No

SQLServer "Microsoft SQL Server 2000", "Microsoft SQL Server 2005", "Microsoft SQL Server 2008", "Microsoft SQL Server 2008 R2", "Microsoft SQL Server 2012", "Microsoft SQL Server 2014", "Microsoft SQL Server 2016", "Microsoft SQL Server 2017", "Microsoft SQL Server 2019"

Oracle "Oracle Database 9i Release 1", "Oracle Database 9i Release 2", "Oracle Database 10g Release 1", "Oracle Database 10g Release 2", "Oracle Database 11g Release 1", "Oracle Database 11g Release 2", "Oracle Database 12c Release 1", "Oracle Database 12c Release 2", "Oracle Database 18c","Oracle Database 19c", "Oracle Database 21c"

Sybase "SAP ASE Version 12.5", "SAP ASE Version 15.0", "SAP ASE Version 15.5", "SAP ASE Version 15.7", "SAP ASE Version 16.0"

Mongo DB "MongoDB 3.0", "MongoDB 3.2", "MongoDB 3.4", "MongoDB 3.6", "MongoDB 3.8", "MongoDB 4.0", "MongoDB 4.2"

Maria DB, "MariaDB Server 5.5", "MariaDB Server 10.1", "MariaDB Server 10.2", "MariaDB Server 10.3", "MariaDB Server 10.4", "MariaDB Server 10.5", "MariaDB Server 10.6"

Apache Cassandra "Apache Cassandra 2.1.20", "Apache Cassandra 2.1.21", "Apache Cassandra 2.1.22", "Apache Cassandra 2.2", "Apache Cassandra 3.0", "Apache Cassandra 3.1.1", "Apache Cassandra 3.11.1", "Apache Cassandra 3.11.2", "Apache Cassandra 3.11.3", "Apache Cassandra 3.11.4", "Apache Cassandra 3.11.5", "Apache Cassandra 3.11.6", "Apache Cassandra 3.11.7", "Apache Cassandra 3.11.8", "Apache Cassandra 3.11.9", "Apache Cassandra 3.11.10", "Apache Cassandra 4.0"

MySQL "MySQL Version 5.1", "MySQL Version 5.5", "MySQL Version 5.6", "MySQL Version 5.7","MySQL Version 8.0"

IBM DB2 "Db2 Version 9.1", "Db2 Version 9.5","Db2 Version 9.7", "Db2 Version 9.8","Db2 Version 10.1", "Db2 Version 10.5", "Db2 Version 11.1", "Db2 Version 11.5"

PostgreSQLServer "PostgreSQL Server 8.1", "PostgreSQL Server 8.2", "PostgreSQL Server 8.3", "PostgreSQL Server 8.4", "PostgreSQL Server 9.1", "PostgreSQL Server 9.2", "PostgreSQL Server 9.3", "PostgreSQL Server 9.4", "PostgreSQL Server 9.5"), "PostgreSQL Server 9.6", "PostgreSQL Server 10", "PostgreSQL Server 11", "PostgreSQL Server 12", "PostgreSQL Server 13"

DotNetCoreVersion

The version of .NET Core if the application is .NET Core based

String

No

".NET Core 1.0", ".NET Core 1.1", ".NET Core 2.0", ".NET Core 2.1", ".NET Core 2.2", ".NET Core 3.0", ".NET Core 3.1"

DotNetFrameworkVersion

The version of .NET Framework if the application is .NET Framework based

String

No

"DotnetFramework 1.0", "DotnetFramework 1.0 SP1", "DotnetFramework 1.0 SP2", "DotnetFramework 1.0 SP3", "DotnetFramework 1.1", "DotnetFramework 1.1 SP1", "DotnetFramework 2.0", "DotnetFramework 2.0 SP1", "DotnetFramework 2.0 SP2", "DotnetFramework 3.0", "DotnetFramework 3.0 SP1", "DotnetFramework 3.0 SP2", "DotnetFramework 3.5", "DotnetFramework 3.5 SP1", "DotnetFramework 4.0", "DotnetFramework 4.5", "DotnetFramework 4.5.1", "DotnetFramework 4.5.2", "DotnetFramework 4.6", "DotnetFramework 4.6.1", "DotnetFramework 4.6.2", "DotnetFramework 4.7", "DotnetFramework 4.7.1", "DotnetFramework 4.7.2", "DotnetFramework 4.8"

Hostname

The name of the host

String

No

Any string

IpAddress

The IP address of the server

Array

No

In the format xxx.xxx.xxx.xxx

JdkVersion

The version of the JDK, if the application uses the JDK

String

No

"JDK1.0", "JDK2.0", "JDK3.0", …, "JDK11.0"

OSDistribution

Windows, Windows Server, Ubuntu

String

Yes

Windows: "Windows PC" , "Windows Server"

Linux: "Ubuntu", "RHEL", "Amazon Linux", "DEBIAN", "SLES", "CENT_OS" , "ORACLE_LINUX", "FEDORA", "KALI"

OSType

The type of operating system

String

Yes

"Windows", "Linux"
OSVersion

The kernel version

String

Yes

Windows kernel version: "Windows Kernel Version 3.1", "Windows Kernel Version 3.5", "Windows Kernel Version 3.51", "Windows Kernel Version 4.0", "Windows Kernel Version 5.0", "Windows Kernel Version 5.1", "Windows Kernel Version 5.2", "Windows Kernel Version 6.0", "Windows Kernel Version 6.1", "Windows Kernel Version 6.2", "Windows Kernel Version 6.3", "Windows Kernel Version 10.0"

Windows server version: "Windows NT 3.1", "Windows NT 3.5", "Windows NT 3.51", "Windows NT 4.0", "Windows Server 2000", "Windows Server 2003", "Windows Server 2003 R2", "Windows Server 2008", "Windows Server 2008 R2", "Windows Server 2012", "Windows Server 2012 R2", "Windows Server 2016", "Windows Server 2019", "Windows Server 1709", "Windows Server 1803", "Windows Server 1809", "Windows Server 1903", "Windows Server 1909", "Windows Server 2004"

Ubuntu: "Ubuntu 4.10", "Ubuntu 5.04", "Ubuntu 5.10", "Ubuntu 6.06", "Ubuntu 6.10","Ubuntu 7.04", ,"Ubuntu 7.10", "Ubuntu 8.04", "Ubuntu 8.10", "Ubuntu 9.04", "Ubuntu 9.10", "Ubuntu 10.04", "Ubuntu 10.10", "Ubuntu 11.04", "Ubuntu 11.10, "Ubuntu 12.04", "Ubuntu 12.10", "Ubuntu 13.04", "Ubuntu 13.10", "Ubuntu 14.04", "Ubuntu 14.10", "Ubuntu 15.04", "Ubuntu 15.10", "Ubuntu 16.04", "Ubuntu 16.10", "Ubuntu 17.04", "Ubuntu 17.10", "Ubuntu 18.04", "Ubuntu 18.10", "Ubuntu 19.04", "Ubuntu 19.10", "Ubuntu 20.04", "Ubuntu 20.10", "Ubuntu 21.04"

RHEL: "RHEL 2.1", "RHEL 2.1 Update 1", "RHEL 2.1 Update 2", "RHEL 2.1 Update 3", "RHEL 2.1 Update 4", "RHEL 2.1 Update 5", "RHEL 2.1 Update 6", "RHEL 2.1 Update 7", "RHEL 3", "RHEL 3 Update 1", "RHEL 3 Update 2", "RHEL 3 Update 3", "RHEL 3 Update 4", "RHEL 3 Update 5", "RHEL 3 Update 6", "RHEL 3 Update 7", "RHEL 3 Update 8", "RHEL 3 Update 9", "RHEL 4", "RHEL 4 Update 1", "RHEL 4 Update 2", "RHEL 4 Update 3", "RHEL 4 Update 4", 4, "RHEL 4 Update 5", "RHEL 4 Update 6", , "RHEL 4 Update 7", "RHEL 4 Update 8", "RHEL 4 Update 9", "RHEL 5", "RHEL 5.1", "RHEL 5.2", "RHEL 5.3", "RHEL 5.4", "RHEL 5.5",, "RHEL 5.6", "RHEL 5.7","RHEL 5.8", "RHEL 5.9", "RHEL 5.10", "RHEL 5.11", "RHEL 6", "RHEL 6.1", "RHEL 6.2", "RHEL 6.3", "RHEL 6.4", "RHEL 6.5", "RHEL 6.6", "RHEL 6.7", "RHEL 6.8", "RHEL 6.9", "RHEL 6.10", "RHEL 7 Beta", "RHEL 7", "RHEL 7.1", "RHEL 7.2", "RHEL 7.3", "RHEL 7.4", "RHEL 7.5", "RHEL 7.6", "RHEL 7.7", "RHEL 7.8", "RHEL 7.9", "RHEL 8", "RHEL 8.1", "RHEL 8.2", "RHEL 8.3"

DEBIAN: "Debian 0.91", "Debian 0.93R5", "Debian 0.93R6", "Debian 1.1", "Debian 1.2", "Debian 1.3", "Debian 1.3.1", "Debian 1.3.1 r.6", "Debian 2.0", "Debian 2.0r1", "Debian 2.0r2", "Debian 2.0r3", "Debian 2.0r4", "Debian 2.0r5", "Debian 2.1r0", "Debian 2.1r1", "Debian 2.1r2", "Debian 2.1r3", "Debian 2.1r4", "Debian 2.1r5", "Debian 2.2r0", "Debian 2.2r1"," Debian 2.2r2", "Debian 2.2r3", "Debian 2.2r4", "Debian 2.2r5", "Debian 2.2r6", "Debian 2.2r7", "Debian 3.0r0", "Debian 3.0r1", "Debian 3.0r2", "Debian 3.0r3", "Debian 3.0r4", "Debian 3.0r5", "Debian 3.0r6", "Debian 3.1r0", "Debian 3.1r1", "Debian 3.1r2", "Debian 3.1r3", "Debian 3.1r4", "Debian 3.1r5", "Debian 3.1r6", "Debian 3.1r7", "Debian 3.1r8", "Debian 4.0r0", "Debian 4.0r1", "Debian 4.0r2", "Debian 4.0r3", "Debian 4.0r4", "Debian 4.0r5", "Debian 4.0r6", "Debian 4.0r7", "Debian 4.0r8", "Debian 4.0r9", "Debian 5.0.0", "Debian 5.0.1", "Debian 5.0.2", "Debian 5.0.3", "Debian 5.0.4", "Debian 5.0.5", "Debian 5.0.6", "Debian 5.0.7", "Debian 5.0.8", "Debian 5.0.9", "Debian 5.0.10", "Debian 6.0.0", "Debian 6.0.1", "Debian 6.0.2", "Debian 6.0.3", "Debian 6.0.4", "Debian 6.0.5", "Debian 6.0.6", "Debian 6.0.7", "Debian 6.0.8", "Debian 6.0.9", "Debian 6.0.10", "Debian 7.0.0", "Debian 7.1", "Debian 7.2", "Debian 7.3", "Debian 7.4", "Debian 7.5", "Debian 7.6", "Debian 7.7", "Debian 7.8", "Debian 7.9", "Debian 7.10", "Debian 7.11", "Debian 8.0", "Debian 8.1", "Debian 8.2", "Debian 8.3", "Debian 8.4", "Debian 8.5", "Debian 8.6", "Debian 8.7", "Debian 8.8", "Debian 8.9", "Debian 8.10", "Debian 8.11", "Debian 9.0", "Debian 9.1", "Debian 9.2", "Debian 9.3", "Debian 9.4", "Debian 9.5", "Debian 9.6", "Debian 9.7", "Debian 9.8", "Debian 9.9", "Debian 9.10", "Debian 9.11", "Debian 9.12", "Debian 9.13", "Debian 10.0", "Debian 10.1", "Debian 10.2", "Debian 10.3", "Debian 10.4", "Debian 10.5"

ProgrammingLanguage

The programming language for the application

String

No

"Java", "CSharp"

ResourceId

A unique ID for the resource

String

Yes

Any unique string

ResourceName

The name of the resource

String

Yes

Any string

ResourceType

The type of resource to import

String

Yes

"Server", "Process"