Top 10 Reasons to Migrate Integration Services to Essbase Studio
Author: Christian Screen | | November 20, 2009
Sometimes I feel like I am the only evangelist out there for Essbase Studio and I wonder why that is since Essbase Studio is such a great tool. This is especially true when you look at its ability to connect to a myriad of data source such as OBIEE, Teradata, MySQL, EPMA Dimension Server, netezza, etc. Below is the top 10 list of why an organization should migrate their existing Essbase Integration Services models to Essbase Studio. If your team is not an early adopter, run it in parallel. If your team is scared of change, have them read “Who Moved My Cheese?“. Otherwise, let’s make it happen. Get with the program and enjoy the fruits of this fantastic toolset made for those who believe analytics are always evolving for the better.
Top 10 List
10. It has a familiar feel to EIS but its actually intuitive and user friendly.
9. It integrates with the new features of Essbase Server 11x. Has EIS been touched since System 9x?
7. There is a step-by-step tutorial on Essbase Studio Server made just for you (here).
6. Security provisioning and roles can be assigned in Shared Services. Delineate data modelers from administrators.
5. Essbase Integration Services is about to get sunset and Oracle Support will go bye-bye.
4. It connects to EPMA Dimension Server out-of-the-box. Ever heard of Master Data Management?
3. Essbase Studio Models are deployable with native MaXL Scripting. Have you tried to automate an EIS deployment?
2. Essbase Studio comes with an Integration Services Catalog Migration Wizard. (hint, hint)
1. Larry Ellison wants you to. Seriously, Oracle’s BI roadmap is taking Studio to the next frontier, not EIS. It’s a good train…get on it.
The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.
Learn how to fix common Log Shipping Failure errors in SQL Server. Includes step-by-step instructions, screenshots, and software script.