Connect to a Database
Connect to a database
- After launching DataSight, either On-Premise, or via the Cloud, the Connect to Database window will appear.
- Enter the following information as required (see your IT administrator to obtain these details and then keep a personal record):
- Server name: Enter the qualified name of your database server (for example, TishaPC\TishaSQL in the figure).
- Database name: Enter the qualified name of your database (for example, DEMO in the figure).
- Authentication: Select your authentication type (For example, SQL Server Authentication in the figure). For details, see Modes of User Authentication.
- User name: Enter the name of a user with access to database on the server (This is required only for SQL Server Authentication).
- Password: Enter the password of the specified user (This is required only forSQL Server Authentication).
- Then click Connect.
|
Note |
To take the most advantage of DataSight's advanced functionalities and latest fixes, it is pivotal that the DataSight SQL Server databases are kept up to date. To this end, database upgrades are now also run from the DataSight client upon initial connection to a database on the SQL Server. Users with sysadmin rights on the SQL Server can click OK to run the upgrade, before proceeding to the DataSight user interface. Users without sysadmin rights cannot perform database upgrades and will continue to access the current database version until the upgrade is run by an administrator. In the latter case, a user may experience difficulties with some DataSight features. Your IT Administrator is also able to run these upgrades from the DataSight Administrator console. Please contact your IT Administrator for assistance. |
- Once you have entered your details correctly and DataSight opens, your connection status (Connected to [database name] on [SQL server name]) will be displayed in the Status Bar of DataSight, at the bottom left of the window.
Exit current database and connect to a new database
- Click Application Tab.
- Then click Connect to Database.
- Repeat steps 2 through 4 in Connect to a database
|
Note |
It is the responsibility of the database administrator to edit database Security, Accounts and Permissions using the Security Features in DataSight and Microsoft SQL Server (refer to DataSight Administrator and Security). |
See also:
- User Authentication
Related Articles
Restore DataSight database
Thursday, 15 June 2017 Backing up a database and storing it at a secure location is excellent practice for preventing data loss. This is implemented by data houses on a regular basis. DataSight databases can be backed up and restored on the SQL ...DataSight Database Upgrade
DataSight is continually improving its database functions to deliver optimal solutions to users. For this reason, DataSight Administrator is provided with options to easily carry out the process of upgrading DataSight databases to the latest release. ...Connect to Microsoft SQL Server
When you open DataSight Administrator, you are presented with a connection window requiring specific credentials, including a user name, password and database location. A DataSight Administrator user must have the correct administrative privileges to ...Database Security
DataSight database security is a combination of Microsoft SQL Server security coupled with DataSight application security. Both forms of security need to be implemented. DataSight Administrator helps you: Create and authenticate Microsoft SQL server ...DSWeb Database Management
Manage your DSWeb Databases Click Delete DSWeb Database in the DSWeb Database group of the DataSight Administrator Ribbon. The View & Delete DSWeb Database window appears in the Main panel. View a DSWeb Database Select a database from the list of ...