Astera Solution and Results
The team had previously been using a number of different tools, but none of them completely met its changing requirements. SSIS was one such tool, however, the team found the learning curve a bit too steep to be practical. “Centerprise is much more user friendly, and requires less training,” said Laurence Duggan, business analyst. Tasked with allocating lean IT resources for training associated with the other ETL tools being evaluated, Duggan preferred Centerprise with its user friendly, drag-and-drop functionality. This superior functionality made the software so straightforward that it can be utilized by business users as well as IT staff, thereby shortening the training period and decreasing high training expenditures.
A solution was implemented using Centerprise where dataflows were created for each client, including data quality checks and all the required transformations for the incoming data. Most of these jobs were automated by the use of the scheduler and workflow automation features in Centerprise. “Utilizing Centerprise to review data quality rules, look up reference codes, transform data, and clean large batches of data, while automating the entire process, permits us to work with the data and make sure it’s up to specifications,” said Duggan.
The company is currently using Centerprise to synchronize, migrate, cleanse, and transform student data into a format compatible with college and career planning services and platforms.