Skip to main content
OnCommand Workflow Automation 5.1

Set up a data source

Contributors netapp-aoife

You must set up a connection with a data source in OnCommand Workflow Automation (WFA) to acquire data from the data source.

  • For Active IQ Unified Manager 6.0 and later, you must have created a database user account on the Unified Manager server.

    See the OnCommand Unified Manager Online Help for details.

  • The TCP port for incoming connections on the Unified Manager server must be open.

    See the documentation on your firewall for details.

    The following are the default TCP port numbers:

    TCP port number Unified Manager server version Description

    3306

    6.x

    MySQL database server

  • For Performance Advisor, you must have created an Active IQ Unified Manager user account with a minimum role of GlobalRead.

    See the OnCommand Unified Manager Online Help for details.

  • For VMware vCenter Server, you must have created a user account on the vCenter Server.

    See the VMware vCenter Server documentation for details.

    Note

    You must have installed VMware PowerCLI. If you want to execute workflows only on vCenter Server data sources, setting up Unified Manager server as a data source is not required.

  • The TCP port for incoming connections on the VMware vCenter Server must be open.

    The default TCP port number is 443. See the documentation on your firewall for details.

You can add multiple Unified Manager server data sources to WFA using this procedure. However, you must not use this procedure if you want to pair Unified Manager server 6.3 and later with WFA and use the protection functionality in Unified Manager server.

For more information about pairing WFA with Unified Manager server 6.x, see the OnCommand Unified Manager Online Help.

Note While setting up a data source with WFA, you must be aware that Active IQ Unified Manager 6.0, 6.1, and 6.2 data source types are deprecated in the WFA 4.0 release, and these data source types will not be supported in future releases.
Steps
  1. Access WFA using a web browser.

  2. Click Settings, and under Setup click Data Sources.

  3. Choose the appropriate action:

    To…​ Do this…​

    Create a new data source

    Click New icon on the toolbar.

    Edit a restored data source if you have upgraded WFA

    Select the existing data source entry, and click Edit icon on the toolbar.

    If you have added a Unified Manager server data source to WFA and then upgraded the version of the Unified Manager server, WFA will not recognize the upgraded version of the Unified Manager server. You must delete the previous version of the Unified Manager server and then add the upgraded version of the Unified Manager server to WFA.

  4. In the New Data Source dialog box, select the required data source type, and enter a name for the data source and the host name.

    Based on the selected data source type, the port, user name, password, and timeout fields might be automatically populated with the default data, if available. You can edit these entries as required.

  5. Choose an appropriate action:

    For…​ Do this…​

    Active IQ Unified Manager 6.3 and later

    Enter the credentials of the Database User account that you created on the Unified Manager server. See OnCommand Unified Manager Online Help for details on creating a database user account.

    Note

    You must not provide the credentials of an Active IQ Unified Manager Database User account that was created using the command-line interface or the ocsetup tool.

    VMware vCenter Server (only for windows)

    (only for windows) Enter the user name and password of the user that you created on the VMware vCenter server.

  6. Click Save.

  7. In the Data Sources table, select the data source, and click Acquire now icon on the toolbar.

  8. Verify the status of the data acquisition process.