Skip to main content

SQL Custom Connection Profile & Default Dynamic Host List

The SQL Data Collector requires a custom Connection Profile and Host List. You can use the SQL SERVERS default host list with this data collector for the SQL Solution. The host inventory option during host list creation requires you to configure the Connection Profile first.

Connection Profile​

Create a Connection Profile and set the following information on the User Credentials window.

  • For an Active Directory account:

    • Select Account Type – Active Directory Account

    • Domain – dropdown menu with available trusted domains will appear. Either enter the short domain name in the textbox or select a domain from the menu.

    • User name – Enter the user name

    • Password Storage – Choose the option you want for credential password storage:

      • Application – Uses the configured Profile Security setting as selected at the Settings > Application node. See the Application topic for additional information.
      • CyberArk – Uses the CyberArk Enterprise Password Vault. See the CyberArk Integration topic for additional information. The password fields don't apply for CyberArk password storage.

    • Password – Enter the password

    • Confirm – Re-enter the password

  • For a SQL account:

    • Select Account Type – SQL Authentication
    • User name – Enter user name
    • Password Storage – Application (Uses the configured Profile Security setting as selected at the Settings > Application node. See the Application topic for additional information.)
    • Password – Enter the password
    • Confirm – Re-enter the password

See the Connection topic for additional information.

Host List​

The required host list depends on the database for which you use the SQL data collector.

Default Dynamic Host List (SQL)​

Jobs using the SQL Data Collector can use the SQL Servers default host list. This is a dynamic host list that Access Analyzer populates from hosts in the Host Master Table which meet the host inventory criteria for the list, IsSQLServer = True. Since the SQL Servers host list is default, it is available to jobs and job groups for host assignment. See the Host Management topic for additional information.

Oracle / MySQL / PostgreSQL / Db2​

You must configure jobs in the Oracle, MySQL, PostgreSQL, or Db2 solution that use the SQL Data Collector to query a host list with the servers containing the target databases. Set up the list of hosts that you need to monitor. Be sure to use a specific host name (if forcing the connection to a secondary host) or just the server name if connecting to the server. See the Host Management topic for additional information.

Additionally, you must add the database instances to the Filter page in the query configuration. See the SQL: Filter topic for additional information.