Database

A Database connector is used to get data from tables and/or views in relational databases either local to the machine or across the network.

Microsoft SQL Server is a relational database that is used to store data in tables. Microsoft SQL Server Express is a lightweight version of SQL Server which is free to download, distribute and use.

To use SQL Server, an instance needs to be created. This represents a complete SQL Server which contains its own copy of the server files, databases, and security credentials. The Microsoft SQL Server Management Studio is used to create and manage SQL Server instances and so it is suggested that this is downloaded.