Step by Step - Database Discovery

Aman Trivedi1
Tera Contributor

Hi Everyone,

We are planning to implement Database Discovery in our environment. We have already implemented.

  • Windows Discovery

The next phase is Database Discovery.

Databases in Scope

  • Microsoft SQL Server
  • Oracle Database
  • PostgreSQL
  • Azure SQL Database

Authentication Options Under Consideration

Option 1 – Existing Windows Service Account

Use the existing Windows Discovery service account  and grant the required database-level permissions.

Option 2 – Dedicated Database Discovery Account

Create a dedicated database discovery account (username/password) with read-only permissions specifically for ServiceNow Database Discovery.

1. Prerequisites

For each database type (MS SQL, Oracle, PostgreSQL, Azure SQL):

  • Required MID Server version/configuration
  • Network and firewall requirements
  • Supported authentication methods
  • Port requirements

 

Any documentation, implementation guides, KB articles, or real-world recommendations would be greatly appreciated.

Thank you in advance.



6 REPLIES 6

Aman Trivedi1
Tera Contributor

Hi @shubhamseth , @doug_schulze , @Doci1 , @Selva Arun , 

 

I came across your comments on one of the databse Discovery articles.

Just checking if you have implemented ServiceNow Database Discovery in the past. If so, I would appreciate your guidance on the credentials and permissions required for the following database platforms:

  1. Microsoft SQL Server
  2. Oracle Database
  3. PostgreSQL
  4. Azure SQL Database
  • What minimum database permissions are needed?
  • Can we use an existing Windows service account for discovery, or is a dedicated database account recommended/required?
  • Are there any additional prerequisites or best practices that we should be aware of?

    Thanks in Advance

Hi @shubhamseth Thanks for sharing.

Still it doesn't contain that much info related to database discovery.