Requirements
With their multitude of fields, tables and column names, transactional systems are not meant to serve reporting and analysis requirements. To overcome this limitation, many companies turn to enterprise data warehouses. Created by extracting data from operational or transactional systems (like ERP systems) and loading them to an analysis and reporting-friendly database, data warehouses are repositories of data that can be accessed in ways that enable both fast and effective management decision-making.

Solution
Herculean is SAPIENCE™’s ETL and data warehouse design tool inculcating best practice methodologies for extraction and transformation needs. Herculean can provide a more effective means of giving end-users access to data they need for analysis from any data source and integrate and move it into any target environment for analysis. Herculean offers an unparalleled performance in highly heterogeneous environments, being able to assimilate an unlimited variety of data types for reliable, on-time business intelligence.

High Usability: With Herculean, users no longer need to have extensive knowledge of database source formats, integration rules and target application prerequisites. Herculean is instrumental in leveraging returns on data warehouses, data marts, spreadsheets and reporting applications, while offering a low cost of ownership and a high usability.

Process Design: The Herculean client consists of an easy to use graphical user interface, equipped with a drag-and-drop functionality for building complex data integration rules, without requiring any manual coding. Visual mapping and transformation logic can be used to specify how data should be integrated and where it should go.

Predefined Library: Herculean maintains an extensive library of pre-built extraction and transformation functions that can be used in mappings as needed, thus saving the user time and effort.

Engine Based: Being engine driven Herculean allows users to be free of using code generation technology and keeps a repository of transformation rules and metadata.

Flexibility: Analytical requirements compel systems to be refreshed on a regular basis. Herculean lets users provide a one-time definition of the organizational business rules, on the basis of which it will update the warehouse as and when specified.