Set up a data source

Contributors

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

What you’ll need

  • For Active IQ Unified Manager versions earlier than 6.0, you must have run the latest version of the ocsetup tool on the Unified Manager server to enable and configure remote read-only access to the database.

  • For Active IQ Unified Manager6.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

    2638

    5.x

    Sybase SQL Anywhere database server

    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.

  • 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.

About this task

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 versions earlier than 6.0

    Enter the user name and password that you used for overriding the default credentials while running ocsetup tool.

    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.

    Performance Advisor for (Active IQ Unified Manager versions earlier than 6.0)

    Enter the credentials of an Active IQ Unified Manager user with a minimum role of GlobalRead.

    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.

  6. Click Save.

  7. Optional: 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.