Create a DataSight Database

Create a DataSight Database

  1. Click New Database in the DataSight Database group of the DataSight Administrator Ribbon. The Create Database view appears in the Main panel.
  2. Enter Database Database names can be alphanumeric and include spaces and underscore characters.
  3. Assign the Administrator User. You can assign any user as an Administrat DataSight users can use either Windows Authentication or SQL authentication for login details.
  4. You can check Create Current User as Default Administrator. When you create this user, the person that is currently logged in will be given dbo (database owner) permission and is the owner of the newly created DataSight database (named dbo in the security table for the database).
  5. A Microsoft SQL database has two physical files for a database; one for data and one for transaction logs. DataSight automatically sets the location and file name for these files, however you can choose alternate file names and locations. Data and log files don't have to be in the same location. You can put them onto different disks to increase database performance.
  6. Click Create. A dialogue box will open with the message Database: "<database name>" has been successfully created.

 

See also:

    • Related Articles

    • Create a DSWeb Database

      Click New DSWeb Database in the DataSight Database group of the DataSight Administrator Ribbon. The Create Database view appears in the Main panel. Enter Database Database names can be alphanumeric and include spaces and underscore characters. A ...

    • 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 ...

    • 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 ...

    • 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. ...

    • DataSight Database Management

      Manage your Databases Click Database Management in the DataSight Database group of the DataSight Administrator Ribbon. The View & Delete Database window appears in the Main panel. View a Database Select a database from the list of DataSight ...