Microsoft SQL Server
Add SQL Server as a decube connection and help your team discover, document and monitor their data assets to drive data-driven insights and decisions.
Connecting to decube is as easy as providing us with credentials to your Microsoft SQL database. At a minimum, we require
Connect to Microsoft SQL
source namewill be for you to differentiate and recognize particular sources within the decube application.
A custom user would allow for a granular configuration of the user on your database and your connection to decube.
- 1.Create a New User for decube
CREATE LOGIN [decube] WITH PASSWORD=N'your_password';
- 2.Execute the following SQL statement to create a new database user and map it to the login created in the previous step
CREATE USER [decube] FOR LOGIN [decube];
- 3.Add the user to role db_datareader
EXEC sp_addrolemember N'db_datareader', N'decube'