Through Sharperlight's Bidirectional Writeback system, your data is securely shared between all your enterprise locations, updated and validated in real-time via the intuitive data entry and reporting interface.
Use Sharperlight Foundry to create new operational data applications that plug into existing Sharperlight solutions and the dynamic Sharperlight Datamodel Layer. Present data with ease across mobiles, tablets and desktop browsers. Capture date into the new solution - All with Sharperlight tools. Each new application is secured using the Sharperlight security layer and single sign-on access.
Track and share from anywhere. Secure and configurable platform-optimised apps turn any smart device into a powerful data entry system. Connect all your enterprise business systems with intelligent, context-sensitive tools, ensuring clean & valid data every time.
Use the Sharperlight Excel® Addin to bulk load data or the Web-Channel to capture data in a browser.
Create highly specialised, business-aware datamodels designed to fit the needs of your organisation. Sharperlight Studio provides detailed features for comprehensive datamodel and connection template development.
Enterprise reporting at a fraction of the cost**. Get detailed and accurate, real-time reports, sent automatically on individually configured schedules for each stakeholder. Works out of the box, with full customisation options and on-demand delivery.
The Sharperlight Excel® Add-in gives users easy access to the Query Builder and Explorer from within Microsoft Excel. The Sharperlight queries are anchored in the worksheets, using formulas and the construction of these formulas is wizard driven through the Query Builder interface. These formulas fully support cell referencing and automatic recalculation, so the result set will refresh as filters are changed or when recalculation is forced. The formulas are also Drilldown points where the result set can be drilled into, using Explorer.
The Query Builder is the common user interface that is shared across the Sharperlight presentation layers. Irrespective of whether a query is crafted in Microsoft Excel®, in Publisher or using the Sharperlight web client, it is the same Query Builder that users interact with. This consistent look and feel for crafting queries is extremely important for an end-user audience because it accelerates the learning curve and simplifies the transition to other interfaces.
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.
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.
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.
The Scheduler is an automation interface for the execution of tasks on a recurring and ad-hoc basis. Each task can have multiple actions and a task can be executed manually or based on a schedule. The Scheduler is installed and accessed just like any other Sharperlight desktop application but tasks can only be run on installations that have five or more full licenses.
The Sharperlight Web Channel is the common term for the web service that delivers published queries. This terminology is used because the list page can be branded with a custom title.
The Page Designer introduces more control on the positioning and layout of report pages, and it addresses many of the printing limitations inherit in a web browser deployment. It uses a third party component library to provide the reporting engine and a graphical What You See Is What You Get (WYSIWYG) report designer.
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.
Build custom connectors to your own databases, make that hard to access data visible and accessible by all stakeholders.
MAXIMO – Reduce maintenance labour costs with Maximo—a comprehensive solution for managing assets, operations and maintenance. Sharperlight add significant value, lowered costs and instant access to Data from MAXIMO and integration through the Maximo web server. Both the SQL Server and Oracle versions are supported. Clients who use this connector can effortlessly and securely access and publish data far more effectively than the inbuilt systems and BIRT and integrated with all your other systems.
The various Human Resource and Payroll Management modules contained within the integrated HR software solution provide the foundation on which our customers build their Human Resource and Payroll strategies. These modules can be selected either individually, or as part of a totally integrated Human Resource software solution, to deliver a dedicated, multi-functional and highly-flexible Human Resource solution.
Sharperlight connects to Chris21 to deliver advanced reporting capability to Chris21 users as well as integrations to other systems.
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.
Sharperlight has advanced Connectors to:
CUSTOM connectors to Sharepoint and CMS
MYOB PayGlobal is the payroll and HR management solution for big business. the Sharperlight Datamodel connector for PayGlobal uses advanced integrated security to control reporting and data through the datamodel. This is far more advanced than all the other reporting tools that have no capability of securing data after extraction to the reporting solution.
The Sharperlight framework is used in many business sectors, including Finance, Government, Farming and Mining, Healthcare, Retail, Sports and Education. Sharperlight is not dependent but rather will adapt to your vertical.
With the concept of Custom Connectors you can quickly and easily add a new connector to the framework.
A sophisticated yet easy-to-use Abalone Management System (AMS)
OGA are the world leaders in Sea Ranching technology for the culture of Greenlip Abalone. Tracking abalone stocks is critical, requiring assessment of mortality and size growth to establishing underwater biomass estimates of both shell and meat weight.
Sharperlight stepped in to provide comprehensive on-water tablet and mobile phone entry and access to cloud-stored data, following every aspect of underwater abalone movement. AMS reports project theoretical growth rates for business forecasting and, as the data becomes available, tracks against actual results.
ATG drives productivity and gross profit through competition between sales staff.
Each sale that is made through their ICE system gets reflected in the ATG solution, aggregating into a Dashboard that shows all products and employees per store.
ATG uses Sharperlight to target, track and report progress of shop floor sales staff; reporting from actual POS, financial and targeting systems, to generate in-shift data to drive gross profit margins.
Sales staff are driven through incentives, as directed on a monthly basis, through targets defined by Australia’s leading telecommunication company Telstra®.
ATG services T-Life® shops with targets and incentives as the sales happen, and assists store managers with reporting requirements made easy with Sharperlight.
This industry leader embarked on an asset management system upgrade but while doing so discovered their reporting tool was being sun-setted. They decided to replace the tool and seize the opportunity to address their poor cost management visibility and inability to access reports via the web.
Sharperlight by philight was chosen; working together, the new reporting framework was implemented in a short period of time over a large database of 60 million transactions processing 450,000 – 500,000 transactions per month. It was all successfully completed on time and with no adverse effects.
Significant benefits were achieved immediately; improved asset management; accurate tracking of both asset maintenance & costs vs. budget; government compliance; improved productivity, less duplication and less rework. In addition, the framework has been so successful that the IT department want to replace their SQL reports with SharperLight versions to reduce rework and improve security.
The University of Western Australia (UWA) decided to upgrade their asset management system, Maximo®, but found their existing reporting tool was not compatible. With multiple databases; a focus on quality & compliance; and a need to easily generate accurate key reports in Excel®, Word® and HTML, they started a search for a replacement system.
Sharperlight by philight was chosen; working with the UWA team, the new reporting framework was implemented in a relatively short period of time.
UWA reaped significant benefits; more accurate information, improved data security, time and resource savings, compliance, and happy staff.