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 Administrator

      DataSight Administrator is a standalone program that focuses solely on the DataSight-related features on the Microsoft SQL server, providing a Windows-based interface between SQL Server and DataSight. Database or IT administrators can use DataSight ...

    • DataSight 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. Within DataSight Security, you can: Create and manage new users using the ...