🤓 Who can do this? You will probably need your Microsoft SQL Server administrator to run these commands — you may not have access yourself.
Atlan supports the basic authentication method for fetching metadata from Microsoft SQL Server. This method uses a username and password to fetch metadata.
Create a login
To create a login with a specific password to integrate into Atlan:
CREATE LOGIN <login_name> WITH PASSWORD = '<password>';- Replace
<login_name>with the name of the login. - Replace
<password>with the password for the login.
Create a user
To create a user for that login:
CREATE USER <username> FOR LOGIN <login_name>;- Replace
<username>with the username to use when integrating Atlan. - Replace
<login_name>with the name of the login used in the previous step.
Grant permissions
Crawl assets and mine view lineage
The following grant crawls all your Microsoft SQL Server assets and mines lineage for views. As the option of least privilege access, it avoids accessing any raw data.
To grant the minimum permissions required to crawl assets and mine view lineage from Microsoft SQL Server:
GRANT VIEW DEFINITION ON DATABASE::<database_name> TO <username>;- Replace
<database_name>with the name of the database. - Replace
<username>with the username created above.
(Optional) Preview and query assets
To grant the minimum permissions required to also preview sample data and query assets from Microsoft SQL Server:
GRANT SELECT ON DATABASE::<database_name> TO <username>;- Replace
<database_name>with the name of the database. - Replace
<username>with the username created above.
🚨 Careful! You must grant permissions to the user for all the databases you want to crawl in Atlan except the system databases (
master, tempdb, msdb, model). The Microsoft SQL Server crawler will only fetch database and schema names without these permissions and no other metadata for other asset types.