Data Warehousing Build and Management Tools
Published: July 29, 2003
Data warehousing build and management tools partners create tools, including extraction, transformation, and loading tools, that are primarily focused on data movement and transformation from source databases into a data warehouse. In order to become Microsoft Data Warehousing Alliance (DWA) members, independent software vendor (ISV) partners must have their applications independently certified to ensure compliance with SQL Server 2000. Several partners in this category are in the midst of the testing process.
|
|
|
|
Tezauri™ represents integrated banking business intelligence solution, which provides all-inclusive, useful, timely and high-quality information according to needs of all management levels in the bank.
Tezauri Solution is based on n-tier architecture. On the server side, central data warehouse runs on SQL Server 2005. ETL applications that integrate all banks informational potentials from internal and external sources is developed in Integration services 2005(SSIS). Multidimensional databases (based on data marts) with definition of cubes (measures and dimensions) and data mining models runs on Analysis Services 2005. Share Point Portal Server 2003 is used as portal integration and collaboration platform for end-users.
Reporting system is based on Reporting services 2005 and Microsoft Office 2003 Applications(mostly MS Excel) on the client side and also Business Scorecard Manager 2005(Maestro) for corporate and specific scorecards that give additional business value on Tezauri to higher level of management. End-user applications are web oriented will be developed in Visual Studio 2005(Whidbey) and will be run on .NET framework. Web services will be developed as data integration services between Tezauri solution and eventual end-user 3rd party applications.
|
|
