Microsoft SQL

This guide provides step-by-step instructions for connecting Microsoft SQL Server to Unistream.

Prerequisites

You will need:

• Access to your SQL Server instance

• Administrator privileges to create a new user (or existing user credentials)

• Host address and port number

• Unistream platform credentials

---

Step 1: Configure Access in SQL Server

Before connecting to Unistream, you need to create a dedicated user in SQL Server and grant appropriate permissions.

1.1 Create Login and User

Connect to your SQL Server (using SQL Server Management Studio or another tool) and run the following commands:

-- Switch to your database
USE [<database>];

-- Create a login
CREATE LOGIN <username> WITH PASSWORD = '<password>';

-- Create a user for the login
CREATE USER <username> FOR LOGIN <username>;

Replace:

• <database> with your actual database name

• <username> with your desired username

• <password> with a secure password

1.2 Grant Permissions

Choose the appropriate permission level based on your needs:

Option A: Grant Access to Entire Database

GRANT SELECT ON DATABASE::<database> TO <username>;

This grants read access to all tables in the database.

Option B: Grant Access to All Tables in a Schema

GRANT SELECT ON SCHEMA::<schema> TO <username>;

Replace:

• <schema> with your schema name (e.g., dbo)

Option C: Grant Access to a Specific Table

GRANT SELECT ON [<schema>].[<table>] TO <username>;

Replace:

• <schema> with your schema name

• <table> with your table name

Option D: Grant Access to Specific Columns

GRANT SELECT ON [<schema>].[<table>] ([<column1>], [<column2>], ...) TO <username>;

Replace:

• <schema> with your schema name

• <table> with your table name

• <column1>, <column2>, etc. with your column names

1.3 Example: Complete Setup

Here's a complete example for a database named SalesDB:

USE [SalesDB];

-- Create login and user
CREATE LOGIN unistream_user WITH PASSWORD = 'SecureP@ssw0rd123!';
CREATE USER unistream_user FOR LOGIN unistream_user;

-- Grant read access to all tables in the database
GRANT SELECT ON DATABASE::SalesDB TO unistream_user;

---

Step 2: Connect to Unistream

2.1 Add SQL Server Source

1. In Unistream, navigate to Lake

2. Click Add Source

3. Select Microsoft SQL Server

2.2 Configure Connection

Fill in the General Fields:

• Name: Enter a descriptive name for your connection (e.g., "Production SQL Server")

• Code: Enter a unique code identifier (e.g., "prod_mssql")

Fill in the Connection Details:

• Host: Your SQL Server address

• Port: SQL Server port (default: 1433)

• Username: The username you created in Step 1 (e.g., unistream_user)

• Password: The password you set in Step 1

• (Optional) Database: The name of the database you want to connect to (e.g., SalesDB)

2.3 Test and Save

1. Click Test Connection to verify the connection is working

2. If the connection is successful, you'll see a success message

3. Click Add to save your connection

Need Help?

If you encounter any issues not covered in this guide, please contact Unistream support