India: Recuperating the faith of the clientele in the company for bringing state-of-the-art products to make business more profitable and easy process working, Helical IT Solutions has launched its ambitious product, christened, HELICAL SCRUNCH into the market to solve the existing ETL issues faced by the companies.
Nitin Sahu, Co-founder, Helical IT Solutions reportedly said that, “We are really excited to launch Helical Scrunch which will further lessen the complications which exists in ETL Solutions, thus resulting in saving time and resource requirement and creation of much better high quality enterprise ETLs. We have been working on this product for the past 3 months. This will be a new revolution in the way ETLs are created and used”.
He further went on to explain that, “ETL jobs are generally created for data migration, creation of data marts and data warehouse, data integration, data replication, data cleansing etc. Though this work can be handled by database SQL, yet ETL tools are used because of its ease of usage, built in objects like aggregators, easy debugging, good auditing capabilities etc. Even ETLs have many restrictions like very low visibility & control for an ETL admin, no reusability of ETL scripts, no standardization, error and logging etc., keeping all these restrictions of ETL tools in mind, Helical IT Solution has came up with a custom framework (known as Helical Scrunch), to work on top of an ETL tool, thus removing all the restrictions of the same.”
The Helical Scrunch has been designed in such a way that the different features are pluggable which in turn from its quarter, gives the developer freedom to select which all modules are to be present. It also makes sure that the jobs created at the offing, are usable; having a standardized naming convention, features and documents etc. which further goes a long way in making sure that the jobs are reusable.
Helical Scrunch provides an extensive control to an end user/IT admin via web interface. The control is very exhaustive which includes controlling and changing ETL configurations without opening ETL job, monitor data flows, controlling what to execute what not to execute etc. Helical Scrunch also provides, via web interface, extensive reports and dashboard capabilities. The reporting capabilities thus empowers the user to have real time view of the project status, error encountered, data transfer, data flow monitoring, which all jobs are executed, which all jobs are executing etc. There will also be ability to select date range for seeing the different parameters. Visualization helps in Monitoring and Analysis. The alerting and notification feature of Helical Scrunch helps in creating different kind of alerts. These alerts and notifications are configurable. These alerts can be set on certain events or thresholds. Notifications could include email alerts etc.
Helical Scrunch has been designed in such a way that the jobs created are following standard conventions, best practices, naming conventions etc and thus they can be easily edited and highly reusable.
Furthermore, the architecture has been designed in such a way that easily any new module or feature can be added, which makes the entire framework highly extensible. Thus it can accommodate any new requirement or business logic or feature. Helical Scrunch is designed in such a way to make sure that absolutely all the ETL work is properly logged. The extensive logging mechanism helps in visualization, identifying, alerting and taking corrective action.
Helical Scrunch thus comes with various advantages. By usage of Helical Scrunch, a company can reduce ETL development time by 30-70%, and with a much better quality. Usage of this can lead to reduction of a number of resources required to execute the same project. ETL architects are not at all required and ETL developers to create generic ETL jobs and implement ETL architecture are not required. The only work involved is in terms of business logic implementation. 30-70% of lesser ETL resources might be required for the implementation of the same work. The ETL jobs created using this will be of a much higher quality.
A user interface for controlling of jobs, putting configurations, having a view of what is happening, reports, analysis etc. gives a lot of interactivity and information to the end users. Usage of Helical crunch can lead to the ETL team becoming effective and start working right from the day one. Helical Scrunch takes care of all the other things like nomenclature, standardization, creation of jobs etc. Hence, ETL team can only need to focus on the problem in hand, which is actual implementation of the business logic.