Skip to main content

Register resources in NetApp Workload Factory for Databases

Contributors netapp-rlithman
PDFs

Register instances for Microsoft SQL Server and databases for Oracle so that you can monitor instance and database status, resource utilization, protection, and storage performance in NetApp Workload Factory for Databases.

You can register your resources only if they run on FSx for ONTAP file system storage.

About the task

Registering an instance (SQL Server) or database (Oracle) involves three steps: instance or database authentication, FSx for ONTAP authentication, and preparation. To prepare, install AWS, NetApp, and PowerShell modules on the instance or database, and meet the minimum requirements for Workload Factory for Databases features like error log analysis or well-architected assessment.

Workload Factory supports only Microsoft SQL Server instance and Oracle database registration and management. Depending on the AWS account credentials you select in Workload Factory, PostgreSQL hosts appear in the Inventory. Currently, Workload Factory supports unregistered PostgreSQL instances running only on Amazon Linux operating systems.

Before you begin

The host for the instance or database must appear in the Inventory. For hosts to appear in the inventory, you must grant view, planning, and analysis permissions in your AWS account.

Registering an instance in a private network

To register an instance or database in a private network without external connectivity, make the required endpoints available in the VPC and associate them with the relevant subnets. Allow port 443 in the Security Group for interface endpoints.

  • S3 Gateway/endpoint

  • ssm

  • ssmmessages

  • fsx

    If you use a proxy server for outbound EC2 connections, allow access to these domains for management operations:

  • .microsoft.com (SQL Server)

  • .powershellgallery.com (SQL Server)

  • .aws.amazon.com

  • .amazonaws.com

Register a Microsoft SQL Server instance

Registering an instance has three steps - instance authentication, FSx for ONTAP authentication, and preparation to complete missing prerequisites. You can register single or multiple instances.

Workload Factory supports registration for Failover Cluster Instance (FCI) and Standalone deployment for SQL Server.

Steps

  1. Log in using one of the console experiences.

  2. Select the menu The hamburger menu icon is used to navigate to workloads like storage and then select Databases.

  3. From the Databases menu, select Inventory.

  4. In the Inventory, select Microsoft SQL Server as the engine type.

  5. Select the Instances tab.

  6. Select to register a single instance or multiple instances.

  7. To Authenticate instances (step 1), do the following and then select Next:

    1. Select to Use the same credentials for all instances or Manage credentials manually.

    2. Authenticate SQL Server and Windows by providing user name and password information.

      If instances are authenticated, select Next.

  8. To Authenticate FSx for ONTAP (step 2), do the following:

    1. Select to Use the same credentials for all resources or Manage credentials manually.

    2. Enter the FSx for ONTAP file system user name and password, and then select Next.

      If the FSx for ONTAP file system is authenticated, select Next.

  9. To Prepare (step 3), make sure the instance(s) meets the minimum requirements.

    To meet the minimum requirements, the instance must have AWS and NetApp PowerShell modules and PowerShell 7 modules installed, and you must complete the prerequisites for at least one of the capabilities listed under Prerequisite check.

    1. Review the prerequisites in the Prerequisite check view.

      You must complete all prerequisites for a single capability like Review well-architected issues and recommendations to register the instance.

    2. Select Setup details for each capability to learn about the capability prerequisites and follow the on-screen instructions to complete any missing prerequisites for a capability.

      To enable Workload Factory to review and fix well-architected issues, complete all prerequisites under Review well-architected issues and recommendations and Fix well-architected issues.

  10. After you complete all prerequisites, Register the instance(s).

Result

Instance registration initiates. Select the Job monitoring tab to track progress.

Register an Oracle database

Registering an instance has three steps - database authentication, FSx for ONTAP authentication, and preparation to complete missing prerequisites. You can register single or multiple databases.

Steps

  1. Log in using one of the console experiences.

  2. Select the menu The hamburger menu icon is used to navigate to workloads like storage and then select Databases.

  3. From the Databases menu, select Inventory.

  4. In the Inventory, select Oracle as the engine type.

  5. Select the Databases tab.

  6. Select to register a single database or multiple databases.

  7. To Authenticate databases (step 1), do the following:

    • Select to Use the same credentials for all instances or Manage credentials manually.

    • Authenticate Oracle user and Automatic Storage Management (ASM) grid user (if applicable) by providing user name and password information.

      If databases are authenticated, select Next.

  8. To Authenticate FSx for ONTAP (step 2), do the following and then select Next:

    • Select to Use the same credentials for all resources or Manage credentials manually.

    • Enter the FSx for ONTAP file system user name and password.

      If the FSx for ONTAP file system is authenticated, select Next.

  9. To Prepare (step 3), make sure the database(s) meets required prerequisites. If all required modules are installed and prerequisites are met, select Next to register the database. Otherwise, follow these steps.

    1. Review the prerequisites in the Prerequisite check view.

      You must complete all prerequisites for a single capability like Review well-architected issues and recommendations to register the database.

    2. Select Setup details for each capability to learn about the capability prerequisites and follow the on-screen instructions to complete any missing prerequisites for a capability.

      To have Workload Factory review and fix well-architected issues for your databases, complete all prerequisites listed under Review well-architected issues and recommendations and Fix well-architected issues capabilities.

  10. After you complete the prerequisites, Register the database(s).

Result

Database registration initiates. Select the Job monitoring tab to track progress.

What's next

After registration, you can perform these tasks.