Adding SQL Server Connection
Adding a New Database:
In the 'Manage Warehouses' section:
- Click on 'Add New', select type as 'SQL Server'
- A form will be presented to you. Fill out the necessary details for the connection.
- Host/port:
- Enter host:port of the SQL Server. For example,
localhost:1433.
- Enter host:port of the SQL Server. For example,
- Database:
- Enter the database name you want to connect to.
- Username:
- Enter the username to connect to the database.
- Password:
- Enter the password to connect to the database.
- Options (Optional):
- Additional connection options like encryption settings can be specified here.
- Host/port:
- After entering the details, click on Submit.