Intro to the SQL Spreads Designer
  • Dark
    Light
  • PDF

Intro to the SQL Spreads Designer

  • Dark
    Light
  • PDF

Intro

SQL Spreads is a data management solution where a Designer creates database connected Excel documents; SQL Spreads documents. The SQL Spreads documents can then be shared with non-technical users (Data Editors) who are responsible for the data and can use the SQL Spreads documents to manage the SQL Server data through Excel.

This part of the knowledgebase will go through how you create and setup SQL Spreads Excel documents to maintain data in SQL Server.

SQL Spreads documents are created using the SQL Spreads Designer that is shown on the right-side of Excel. Click the Design Mode button in the SQL Spreads tab in Excel to open the SQL Spreads Designer:
image.png

SQL Spreads in Data Editor mode

For non-technical end users, SQL Spreads can be installed in Data Editor mode where all the configuration options, like the Designer, are locked down. A Data Editor can only work with data in a SQL Spreads document created by a Designer.

The Data Editor mode is controlled by the license key. When you purchase a SQL Spreads subscription or lifetime license, the license key you receive will activate SQL Spreads in Design mode. To switch one or several license keys to Data Editor mode, please send an email to support@sqlspreads.com with the license keys you would like to use in Data Editor mode and we will switch the key to Data Editor mode.

Working with multiple tables, databases and SQL Servers

  • You can connect several SQL Server tables (from the same or different databases) to a SQL Spreads document by adding them into separate sheets in the Excel document.
  • One SQL Spreads document connects to one SQL Server instance. If you have several SQL Servers, you will have to create one SQL Spreads document per SQL Server.

All settings are stored in the document

When you create a new SQL Spreads document, all the configurations that you do in the SQL Spreads Designer are stored within the Excel file. So you can easily share your new solution by just sending the file to other users. All users will need to have the SQL Spreads Add-In installed with a valid license.


Was this article helpful?