In the modern company data needs to be accessed from the whole organization using a common interface from each application in real time, covering consolidation, integration and analytics and Sharperlight is all of these.Sharperlight uses a data model to define and abstract the logical structure in a host database. The Datamodel is an intelligent connector to the application database and is used to augment and replace the often inadequate reporting and integration solutions of the host application – that is simplified intelligence.The Datamodel technology is bi-directional allowing for extraction and insertion for integration, aggregation and consolidation of datasets in a truly agile and flexible environment.
The Datamodel takes away the underlying complexity in the database and presents the database to the user in a friendly and understandable manner. Complexity in the database can be converted to simplicity in the front end.Users can navigate through a familiar interface using Datamodel technology that can be easily extended and maintained. Data is no longer hidden or a mystery, intelligence is made simple.
Sharperlight will revolutionize the way businesses operate by providing a framework for analytical and consolidated reporting that can pulled together quickly and presented on any device.Dashboards, report packs, integration and consolidation at real time for any application in the modern business that saves significant time and money by offering a flexible and functionally rich unified data access layer across the enterprise.
Sharperlight should be the only secured, unified and multi point access to Business Intelligence within an enterprise which can support many presentation layers like QlikView® or RoamBI®, SSRS® and the internal Sharperlight Web-Channel and presentation tools.
Any application database could be a Sharperlight source and a target for a Datamodel product.
No matter how forward thinking the Datamodel developers can are, they cannot always anticipate unique customer specific requirements. Fortunately, Datamodels are not set in stone and they can be extended at the customer site with Custom Tables and Custom Fields.
These are created and maintained from within the Query Builder but they look and behave like any other element that was provided in the underlying Datamodel.
It is sometimes useful to have the ability to stage query data into a physical data set that can be summarised for performance or fixed to allow consistent reporting over time. This concept is often referred to as an Agile Data Mart.
Materialised Query is the Sharperlight terminology for this functionality and it is a standard extension of the Query Builder interface.
Write back is the Sharperlight interface technology that writes data back to a database using Web services or API’s.
From the web data can be written back to supported systems.
From within Excel, worksheet data can be uploaded to a destination database using validation and controlled by the processes defined in the Sharperlight.
Writeback templates can be saved into the workbook and reused time and again.
Referential data as well as transactional data can be written back whilst maintaining all application controls.
Sharperlight allows permissions to be setup against companies and tables.
Every published query can be secured to user groups within Sharperlight. If a user is not within the accessible group they will not be able to see the published query in the web.