The Lynas Server includes Data Warehouse and ETL tools that rapidly consolidate disparate data into common formats. This process enables powerful analytics of consolidated data and is a key input into the delivery of functional applications provided by all Lynas modules.
- Consolidate disparate financial data into a common chart of accounts format for consistent auditing and analytics;
- Dramatically reduce IT Capital expenses by eliminating or delaying the need to replace multiple systems in order to rapidly deliver a common view of corporate performance;
- Maintains Fiscal book of record for localization of accounting data. Useful in a multinational environment where country specific financial reporting requirements vary significantly from the corporate ERP system configuration.
- Data store for systems integration projects where data extracted from core systems may be manipulated by an end user before being transformed and returned to the same or other systems in the integration process.
Security
Access to data inside LynasDataWarehouse is secured using the same user and group security functions of the Lynas Suite.
Lynas Data Warehouse is available on Oracle or SQL databases. Data visualization is available via any Analytics solution that supports ODBC or OLE DB connection. LynasLogic provides pre-built dashboard templates and custom analytics using the QlikView Business Intelligence application.
LynasETL, powered by Talend is typically used in custom system integration and data warehousing projects.
Because LynasETL is embedded into the core of Lynas Suite, it enables the rapid, results oriented LynasSPED implementation methodology.