…communicates with SQL Server and Server Express. It installs alongside SQL on the same server using Microsoft Internet Information Services (IIS).
Users sign in and access SQL databases under role permissions. Users create editable worksheets and datasheets from the SQL Table and View object columns. Columns are set visible and unlocked by role administrators.
Data editing becomes possible whenever SQL Table objects have primary keys and SOCKETWorx role permissions are set. Editing and View-Only roles lift SQL data from hidden SQL silos. Empower users with easy-to-use querying filters and sorts so they can create views and reports independently.
All setup and controls are accessed through modern HTML 5 web browsers like Edge, Chrome, and Firefox. Dashboarding, Reporting, and Datasheets modules included.
SQL Use Cases
SOCKETWorx SQL is a website interface to databases.
It installs within minutes on LAN, WAN, or VPS Windows servers, and runs under Microsoft Internet Information Services (IIS).
Securely connects people with SQL databases and schemas.
SOCKETWorx Connections lifts data from SQL silos for business roles.
Create web forms within minutes.
Import forms from Excel files.
Add system fields to enhance forms
Assign forms to SQL records one by one or in bulk.
Create multiple forms for the same datasets
Retrieve data on mobile devices.
Capture Work-In-Progress data entries and revision snapshots.
View, modify, and add data against forms.
Integrate with Work Orders.
Provides users access to SQL data.
Save data view by selecting columns.
Add Static, Dynamic, and image fields.
Import Excel files to mimic them.
Filter and sort data with expression builders.
Launch spreadsheet mode for data entry.
Enable Work Orders to control data change.
Set Reports to issue in bulk
Set output file naming conventions.
Export and share formatted Excel reports.
Set mandatory Document requirements.
Tacitly assign files by using column data.
Assigning Documents to records where users need them.
Creating smarter PDF files with LINKWorx.