What are SQL Connectors?

This article describes how SOCKETWorx connects directly with SQL, and Azure SQL.  They are deployed to read and write data so human resource roles can process data within.

Content

Dashboard Widgets

Tables - transform into Data Views that export

Data Views - launch into worksheet mode to modify content

Data Views - Launch into datasheet mode to modify content

Reports & Datasheets exported to Excel




SOCKETWorx securely permits users to sign in under customizable business roles.  They navigate past dashboard landing pages and into Data Views, where worksheets and datasheets are populated and reports are exported to memorialize snapshots in time.


It is dependent upon self-hosted Windows Internet Information Services (IIS) because it is a web application that runs underneath.  Servers can be LAN, WAN, or VPS, and inherently become SOCKETWorx Application Servers.  

  

Communications with SQL instances must have read/write access.  Communications various content storage locations such as On-premise, O365 Sharepoint, and Amazon Web Services. 


Here is an overview of each of the web interfaces


SQL Connector Services.  

Connections - communicating with existing databases

Installs in minutes and zero programming is required.

Set cyber security sign-on measures like two-factor authentification and credential policies

Set security with Administrative, Super, and Standard User roles, or create custom ones as needed. 

Set Communications with Table and View objects and their security schemas.


Dashboard Widgets - tracking data progress

Add to numerous system widgets and arrange Connection by Connection.


Tables - transform into Data Views that export

Easily set user-friendly Table, and Field display names that double as Excel report headers

Export content by selecting from the drop downs like shown here for reports.  Reports and Datasheets can be exported by navigating to their control headers.


Data Views - launch into worksheet mode to modify content

Spreadsheet mode harnesses user adoption by making it easy to make data changes in bulk.


Data Views - launch into datasheet mode to modify content

Assign Datasheet templates to SQL records to enable worksheet form entry.


Reports & Datasheets exported to Excel

Set up versioning to colorize changes between revisions.