Connect to MS SQL Database
With Worksheets Data Studio you can connect to any MS SQL server database available in the cloud (e.g. Azure SQL, Google SQL, AWS SQL etc). Or if you are using Enterprise Version and have you own instance of Worksheet Systems. Then you can connect to any SQL database in your organization
Video Tutorial​
Create SQL Connection​
Click Create SQL Connection from the Home page or Menu Item in the Worksheets Data Studio
You can create multiple SQL Connections to the same database. Perhaps, you would use different login (in config)
If you have approprite permissions, you can modify data, create / delete database objects etc. Worksheet Systems does not modify your MS SQL database. Although
Explore database and access / modify objects​
Once SQL Connection created, you can access your database with Worksheets Data Studio - https://run.worksheet.systems/data-studio/sql/[ConnectionName]. Then you will see a database tree for your particular connect
Permissions​
On top of SQL user permissions, you can manage who can access your SQL Connection separately. You can specify permissions to Public User (any authenticated or NOT authentcated user) or specific Worksheet System's authenticated User
Here is a list of permissions you can specify
| Permissions | Description | User Access | Public Access |
|---|---|---|---|
| No Access | No access to API or inside Data Studio | V | V |
| Read / SP Execute | Read from table/view or execute stored procedure | V | V |
| Write | Also, can read / write / delete | V | V |
| SQL Execute | Everything above + ability to execute SQL commands | V | V |
| Admin | Everything above + manage user access to this SQL connection | V | V |
SQL Data Api​
Manage SQL Data API permissions to your SQL Connection. It affects any API client, including Worksheets Data Studio
Data Studio permissions​
Manage Online SQL Client permissions to your SQL Connection.
PS: Users should have SQL Data API permissions anyway
REST api for SQL Connection​
You can access your database with C#, Python, JavaScript or JSPython. More details here.