Tidal Migration’s importer will guide you through mapping your columns to our fields, create your own fields and even make associations between dependencies if you have captured these.
You can import your Excel spreadsheets into Tidal Migrations by visiting:
https://your_subdomain.tidalmg.com/#/discover/import
Preparing
You should import your data in the following order:
- Virtualization Clusters
- Servers
- Database Instances
- Applications
This order is especially important if you are planning to import dependencies for your Databases and Applications. Ie. If your Application has a dependency on a server, you need to have that server imported first for the dependency to be imported correctly.
You should have one sheet or file per type of record.
There are several default columns included for each record type, however if you have additional information you can add fields for a record and also track those. If this is the case you should do this before you import your data.
Importing your data
- Select the data type you wish to import.
- Select the sheet in your file that you want to import data from.
- Map the columns of your sheet to the fields from the drop down. If you have a column that is not present as a field and you want to import it, you can add that field.
- Click submit to import the data.
Importing Virtualization Clusters
Tidal Migration uses the following fields to map a virtualization cluster to other resources: Hypervisor Technology, Servers. For this field, you must select the property that the column will correspond to, generally this is Name.
Importing Servers
Tidal Migrations uses the following fields to map a server to other resources: FQDN, IP Addresses, Database Instances, Environment, Cluster. For these fields, you must select the property that the column will correspond to, generally this is Name.
Importing Databases
Tidal Migrations uses the following fields to map a database instance to other resources: Servers and Environment. For these fields, you must select the property that the column will correspond to, generally this is Name.
Importing Applications
Tidal Migrations uses the following fields to map an application to other resources: Servers, Database Instances, Environment, Customers. For these fields, you must select the property that the column will correspond to, generally this is Name.