Use Sharperlight archive your legacy data with a robust transformation service by simply adding the Sharperlight data access layer.
Sharperlight has been successfully utilised in data archiving projects by minimising the required migration phase while still allowing reporting from multiple systems to deliver a unified report.
The Foundry is a light data modelling tool that combines the creation of the source tables, design of the Datamodel and the preparation of a web interface for data entry and enquiry. A project in the Foundry can be deployed multiple times, each iteration will wipe the existing tables, Datamodel and published queries. When the solution has been finalised, the Datamodel can then be enhanced in the Studio.
The concept of a Materialised Query introduces a simple end-user interface for designing and populating databases that contain physical tables that are generated based on defined queries. The data can be refreshed at will or on schedule, or it can be held indefinitely as an audit history. Most importantly, the materialised databases are presented to the end-user as just another Datamodel, and they can be queried using all the normal Sharperlight functionality and presentation layers.
The Sharperlight Service delivers remote access to Datamodels and it has a REST Service that can render Query Builder queries in a browser. This web delivery supports filtering and the end-users can change the filter values and refresh the output. Multiple output layouts are available for the same query, so the same data set can be rendered as a table, chart, pivot table and an RSS feed.
Reports often need to be filtered, grouped, re-ordered and accumulated in ways that are different to the existing data structures in underlying data set. Report Rows provides a user interface for maintaining row layouts, that can be bound to output columns in the Query Builder. The Report Rows designer can be opened from the Filters menu in the Query Builder and it can be added to the desktop using the Applications menu.
Sharperlight can present dynamic tables, charts, pivot tables and presentation reports using its own web service. It has an application called Publisher, for managing and configuring these published queries. Each query can be filtered and refreshed in the web, and it will return the latest data.
Sharperlight has Connector covering:
Sharperlight offers multi company reporting and support for custom tables and fields out of the box. We support SAP HANA and on premise and writeback to both on premise and HANA.
Save time, visualise data and provide rapid self service reports better than Business ObjectsTM.