Summary
This document explains the steps needed to prepare your Microsoft SQL environment for a dScribe connection.
This connector catalogs all tables, views, columns and intra-lineage between the tables and/or views. If you also make use of an Power BI connector, dependencies between both sources will be automatically documented.
Prerequisites
You have installed the dScribe agent. If you haven't yet, take a look here.
Step-by-step guide
Create a user on the SQL database you would like to catalog. The minimal rights that we require for the user are:
SELECT permission on sys.sql_expression_dependencies
VIEW DEFINITION permission
The following information will be needed to setup a connection in dScribe: hostname, database, username, password
Reached the end? Congratulations! You’re a star! ⭐