Microsoft® SQL Server™ (herein abbreviated as MS SQL Server) is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
Note
|
The on-premise DataSight software offering does not include Microsoft SQL Server. MS SQL Server Express Edition is available for free, but to a limited database size of 10GB.
|
DataSight relies on MS SQL Server to host all databases. DataSight can be configured to interface with the free version of MS SQL Server Express as a standalone database on a single computer. MS SQL Server Express is available in 32-bit and 64-bit editions and is an entry-level, free database that is ideal for learning and building desktop and small server data-driven applications of up to 10 GB. The free download of MS SQL Server Express requires a Microsoft account.
All instances of MS SQL Server are the responsibility of the client to install and manage as per their organisation's guidelines. Please ensure that the licensing of all MS SQL Server installations are appropriate to your usage.
Related Articles
Microsoft SQL Server Privileges
Administrators need to be aware of the how Microsoft SQL Server privileges for users are managed within DataSight. We can group DataSight users or administrators into four different categories. User Category Limited User Standard User Advanced User ...
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 ...
Configure MS SQL Server
Create your DSWeb Database Launch DataSight Administrator. With the necessary privileges, login to the server where your database is to be created. Click New DSWeb Database in the DataSight Database group of the DataSight Administrator Ribbon. The ...
Microsoft SQL views of Pivoted Datasheets
Reported: January 31, 2017. Version(s) affected: DataSight 3.0 and 3.1. Issue: Microsoft SQL views of pivoted datasheets are not saved in pivoted tables. Linking the views to other software products such as Microsoft Excel, then does not produce the ...
Server Requirements
DataSight requires Microsoft SQL Server to host database(s) and does not lock any data. DataSight maintains full ODBC and XML compliance. All data stored and managed by DataSight is open to other systems – there is no middleware or additional cost ...