Smart Data Management
Smart Data Management (SDM) is a configuration based Generic Single Page Framework, which can render Data Dynamically irrespective of data types and provide user an easy way to Add, Edit or Delete any data in dataset via Metadata Configuration (DB/XML) and Database Store Procedures.
In Enterprise DWH, most ETLs provide the ways to manage extraction, loading, cleansing and transformation according to predefined business logics through ETL processes.
Any shortfall in logic and subsequent correction in logic delays the availability of correct data in presentation layer for business consumption
Often it is essential to rectify the dimensional data at Data Analyst / Business Analyst level but ETLs don’t provide rich UI to handle the data manipulation; rather most of the users either rely on Data Manipulation Language like SQL or tools like TOAD, SQL Developer, Dbeaver and many more.
These tools provide rich functionality but fail to provide controlled access to user at object/attribute level. They are more specific to development environment rather than to business users.
What is SDM ?
- A solution that is targeted to provide Business Users an easy to use, enrich interface to manipulate data across database tables.
- Controlled access UI framework driven through metadata configuration and legacy database routines.
- Allowing users to add, edit, view or delete data as per enterprise data access protocols.
- Capable of providing interface for all modern databases.
KEY HIGHLIGHTS Enabled with latest grid technology SYNCFUSION
- Metadata based configuration-controlled application Enabled with latest grid technology SYNCFUSION
- Designed using Microsoft Blazor (an open source technology) and is compatible with all modern web-browsers Enabled with latest grid technology SYNCFUSION
- Single Page web application tailored by best industry coding practices Enabled with latest grid technology SYNCFUSION
- Enabled with latest grid technology SYNCFUSION Enabled with latest grid technology SYNCFUSION
-
Dynamic and Lightweight Code, No change in code is required on application side for
Enabled with latest grid technology SYNCFUSION
- Any New Dataset Enabled with latest grid technology SYNCFUSION
- Change/Modify column values Enabled with latest grid technology SYNCFUSION
- Addition/Deletion of any column value To/From Existing Dataset
- Column Based Filters
- Less code, easy to handle (no need to rewrite code to render pages on the server)
- Easy, fast, simplified and streamlined development and deployment
- Minimal Testing effort
- Lightweight application for hosting
- Export the Data in Excel or pdf format
- Order, Sort, Group By, Hide/Show Columns (Column Chooser)
- Supported by Smart Rules for enhanced user experience
- Flexible to integrate will all existing applications using iframe
- Application’s core functionality is driven through user-controlled metadata
- Configure Connection String of Data Source
- Can work with multiple data sources distinguished by connection string
- Controlled access of data source through configuration i.e. specific columns can be made editable or non-editable
- Pre-defined filters can be configured & further extended to include customized filters on storage-side based on Stored Procedures.