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.
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.
Dashboards are created and maintained using an HTML5 interface in a web browser. A dashboard consists of a page and each page can contain multiple rectangular tiles. The tiles can be resized and re-positioned, the tile can display published content from Publisher or display any valid web address.
The Sharperlight Excel® Add-in gives end-users easy access to the Query Builder and a drilldown data explorer. The Sharperlight queries are ancored in the worksheets, using formulas and the construction of these formulas is wizard driven through the Query Builder. These formulas fully support cell referencing and automatic recalculation, so results will refresh as filters are changed or when a recalculation is forced.
Sharperlight has multiple methods of data capture. From within Microsoft Excel, the Sharperlight Add-in can validate and bulk load records using its template driven Writeback interface. The are also Writeback formulas where the Sharperlight formula can be over-written, the input value is interpreted and updated in the data source whilst the cell is reverted back to the formula. In the web Sharperlight can generate web entry forms and entry grids.
The Query Builder is a user interface with separate panes for filters, field selection and output. Simple enough for the infrequent user but it does have deep functionality with menus on each pane title and fields have right hand click menus. In the filter pane the user can select between different query styles using the mode filter and when the user selects the table, it becomes the focus for the query structure and it populates the fields and relationships in the selection pane.
The Scheduler is an automation interface for the execution of tasks on a recurring and ad-hoc basis. Each task can have many actions and a task can be executed manually or a schedule. To allow concurrent activity, the Scheduler is only available on installations that have five or more full licenses.
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. Often referred to as Agile Datamarts, Sharperlight has a simple end-user interface called Materialised Query for designing and populating physical tables based on a query.
Sharperlight is an application framework for interacting with complex operational databases and it controls all data interactions using an abstraction layer called a Datamodel. These models are developed and maintained using a Studio designer and at the lowest level they encapsulate data structures, relationships and business rules.
The data definition is only part of the story, datamodels have a rich command language and data access can be controlled and modified based on system, user and data events. Datamodels are also fully multi-lingual, just like the Sharperlight application, and a datamodel can combine .NET code and package WinForms and web content.
Whilst many Sharperlight customers utilise it for spreadsheet integration, self-service reporting, web reporting and dashboarding; it has a much bigger picture. Sharperlight has a secure gateway and a web service, a datamodelling concept that can unify information from numerous data sources and the tools to quickly develop datamodels and user content.
Datamodel and application interfaces are secured on the server using Site Setup. User authentication is available as a native login, using Windows Authentication, Active Directory Groups and LDAP Groups. A datamodel can have its own data security layer which secures the visible query objects and enforces record level security.
The report designer provides more control on the positioning and layout of report pages, and it addresses many of the printing limitations inherit in web browser rendering. It uses a third party component library to provide the reporting engine and a graphical What You See Is What You Get (WYSIWG) designer interface.
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.