A golden database is a database instance with preset data. It is contained in a template node and can be duplicated to any number of copies along with cloning from the template node.

Ensure that you prepared the environment for data refresh for which you want to generate the golden database. See Preparing a Data Refresh Environment Checklist.

Log in to the vRealize Automation console as a service architect.

Table 1. Provisioning a Golden Database Node Checklist

Task

Comments

Check Box In vRealize Orchestrator, create a data refresh workflow to publish as a catalog item.

You can use the sample data refresh workflows provided or create your own.

Check Box Create a data refresh service blueprint the data refresh workflow you created in vRealize Orchestrator.

For information about creating service blueprints, see Create a Service Blueprint.

Check Box Publish your data refresh service blueprint.

See Publish a Service Blueprint as a Catalog Item.

Check Box Create a Data Management service for catalog items such as data refresh.

See Create a Service.

Check Box Associate your data refresh catalog item with the data management service you created.

See Associate a Catalog Item with a Service.

Check Box Entitle users to your data management service and data refresh catalog item.

Log in to the vRealize Automation console as a tenant administrator or business group manager.

See Entitle a Service, Catalog Items, and Actions to a User or a Group of Users.

Check Box Select Request for the appropriate catalog item on the Service Catalog page.

Check Box Provision a golden database node for the appropriate database on the New Request page.

  1. On the Request Information tab, enter the Description.

  2. On the Register App Services Instance tab, enter the values for the Application Services address, tenant, username, and password.

  3. On the Create Database tab, enter the values for the Application Services name, owning group, version, qualifier, and deployment profile name.

  4. On the Find Import Data Task tab, retain the default values for the Application Services task name, task version, and owning group. Set the parameters on the Import tab to import the data.

  5. On the Find Run SQL Script Task tab, retain the default values for the Application Services task name, task version, and owning group.

  6. On the Mask Data tab, enter the mask data SQL script and the required database access parameters.

  7. On the Execution Settings tab, set the timeout in minutes for each task.

Click Submit to complete the request.

Check Box On the Requests page, select the completed request and check the request details for Application Services Deployment ID, name, node name, node hostname, and node IP address.