Compatible Microsoft Windows, Azure and SQL Servers.
|
Connecting people with datasets improves transaction efficiency and time-to-find. |
|
Why Connect AutoCAD to SOCKETWorx?
Access data via modern web browsers
SOCKETWorx lifts and shifts information from data silos into familiar web browsers such as Microsoft Edge, Google Chrome, and Mozilla Firefox—securely accessed through your intranet or a protected internet domain from anywhere.
Assemble, sort, and filter large datasets
Empower users to query and find information using highly functional, web-based worksheets with familiar grid controls.
Systematically capture and process data changes.
Built-in change management features track historical transactions, audit activity, and identify trends over time.
Summarize datasets with dashboard graphs.
Create dashboard views that instantly display counts, percentages, trends, and key performance indicators.
No database experience required to export reports
Users independently select database tables and columns to build worksheets and export report revisions directly to Microsoft Excel.
Deploys in minutes-not montrhs.
Installs and operates on Microsoft Windows Servers within minutes and uses default Windows components like internet information services (IIS).
Key Features:
Role based permissions access to tables, fields, viewing, editing and reporting.
SOCKETWorx installs and runs on Microsoft Windows Server within minutes, leveraging standard Windows components such as Internet Information Services (IIS).
Export directly to Microsoft Excel.
SOCKETWorx empowers users who may not possess database expertise to create personalized worksheets that export to Excel. Add and clone worksheets for specific interests and optionally set global for data entry and report standardization.
Worksheet Edit Mode:
Users, with appropriate rights, launch edit mode and benefit from bulk data changes with common tools like find and replace. Enable data change tracking to monitor and report on record history.
Datasheet Mode:
Users can launch datasheet mode and work on records one by one in form views originating from
Excel worksheets. SOCKETWorx offers many datasheet features like issuing revisions with colorized changes, and exporting Excel files that automatically associate to assets.
Security Roles and Permissions:
SOCKETWorx implements robust security features, assigning users specific roles and permissions. Roles can modify, add, or delete records if granted permissions, ensuring data integrity and multi-tier security.
Benefits:
- Data Accessibility: SOCKETWorx liberates data from silos, making it accessible to a broader pool of stakeholders and analysts. This democratization of data empowers users to derive insights and make informed decisions.
- Collaborative Environment: The platform fosters collaboration by allowing users to create and work within global views. This ensures that data is viewed and analyzed by a larger audience, promoting a collaborative approach to data-driven decision-making.
- User-Friendly Interface: SOCKETWorx’s user-friendly interface makes data management and analysis accessible to individuals without extensive SQL experience. The transition to worksheet mode and incorporation of Excel attributes enhance user comfort and efficiency.
- Security and Permissions: SOCKETWorx prioritizes data security by implementing role-based access control. Users can add new records within the bounds of their assigned security roles, ensuring data integrity while facilitating necessary updates.
SOCKETWorx transcends traditional data management paradigms, offering a dynamic and inclusive platform that empowers users to interact with SQL databases effortlessly. By combining user-friendly features, collaborative capabilities, and robust security measures, SOCKETWorx represents the future of accessible and collaborative data management. Embrace a new era of data interaction with SOCKETWorx.
SWx Report Revisions: Issue, Download, Compare & Rollback
Contents Setup Reporting Filenames – Setup Turn on Report Revision Controls – Users & Setup Issue, Download, Compare Revisions – Users Overv…
Excel Reporting – SOCKETWorx delivers from SQL Tables and Views
Contents Add Report Templates Customizing Report Templates Sharing Reports, setting them as Global Overview SOCKETWorx Core includes the SQL and C…
Asset Datasheets track change by colorizing revisions automatically.
First, what are Datasheets? Relative to this article they are Excel workbooks that are created to describe instruments, equipment, specialty items, and a…
SOCKETWorx Frequently Asked Questions
Q1: Is the solution a Cloud-Based or On-Premise application?
A: SOCKETWorx is installed on client Windows Servers using Internet Information Services (IIS).
Server Requirements: >V2012
Server Services: IIS, .Net Framework
Q2: SOCKETWorx connects to Azure and SQL Server database instances, so what versions are supported and where can they be located?
A: SQL Server (Full or Express) V2016 or greater is recommended, and there are not any connection limiations to Azure instances.
The IIS Application Identities must be set so that SOCKETWorx can communicate with the SQL instances. All SOCKETWorx/SQL Connections must be established using SQL Authentication.
Q3: What external communications are required for SOCKTEWorx?
A: SOCKETWorx will communicate with ECE’s Azure server. This server manages licenses, interface configurations, user roles, and permissions. ECE will whitelist the SOCKETWorx application server’s public IP so that it can communicate with it.
SOCKETWorx Azure is located within the Central US Region.
The latest Gateway IP Addresses can be found here:
https://docs.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture
The Gateway IP Addresses are:
Navigate to the entire FAQ Article with many more questions and answers….


