GoldenSource has selected Sunopsis ETL as a recommended tool for the efficient extraction of highly normalized data from the GoldenSource Datamodel into a data mart for intelligent queries and reporting. The Sunopsis ETL tool was selected for scalability and the way it complements GoldenSource’s own data management technology.
The GoldenSource Datamodel is the foundation of the applications within the GoldenSource Enterprise Data Management suite. Within the Datamodel the data is highly normalized to insure consistency.
The Sunopsis ETL tool implements an innovative Extract, Load and Transform (E-L-T) approach, where transformations are performed as close to the data as possible, increasing the performance of the processes while decreasing their cost. This architectural approach generates native and optimized SQL code for each Relational Data Base Management System (RDBMS), both source and target repositories, and orchestrates the execution of the statements created. As a combined offering, GoldenSource and Sunopsis can deliver the strategic architecture organizations need to solve their data management issues and realize the full benefits of that data.