SQL Data Catalog

Requirements

Overview

We recommend the product is installed on a Windows Server instance. Minimum requirements for this Windows Server instance:

  • Windows Server 2008 R2 SP1
  • If you are using Windows Server 2008 R2 SP1, installation upgrades security defaults to match later Windows versions:
    • TLS 1.2 enabled (part of installation)
    • SendTrustedIssuerList disabled (part of installation)
  • If using Windows Server 2016, installation allows Edge to access sites hosted on the local machine:
    • LoopbackExempt permission added to Edge (part of installation)

SQL Data Catalog uses a database to store your classifications. The SQL Server backing database must be SQL Server 2012 or higher.

On installation, you will be prompted to enter a set of Windows credentials. These credentials are used for:

  • running the Windows Service;
  • accessing the SQL Server backing database;
  • accessing any SQL Server instances that are registered in the Data Catalog, when Windows authentication is the chosen connection method.

If using an MSA please see the section on the Known Issues page

Please refer to the Database permissions page which details the specific permissions required for the user.

Browser Requirements

The default user interface for SQL Data Catalog is its unified Web UI which composes all of its capabilities under one view. While we recommend using Google Chrome for the best experience, the browser support is as follows:


On Windows, Firefox requires some additional steps:

Configure Firefox to use Windows Authentication

  • Open Firefox
  • Type about:config into the address bar
  • Type negotiate into the search box
  • Add domains to network.negotiate-auth.trusted-uris

PowerShell Requirements

To automate your workflows using Powershell you need a PowerShell version 5.1 or higher. 


Target database

The target databases are accessed in read-only mode in order to read the database schemas. SQL Data Catalog can access:

  • SQL Server 2008R2 or higher



Didn't find what you were looking for?