Which are the ETL tools that are generally recommended to be used with MicroStrategy?


Les Barbusinski’s Answer: I know of no preferred ETL tool for MicroStrategy. There is some integration between MicroStrategy and Informatica PowerCenter (i.e., both can share each other’s meta data), but I don’t think that’s enough to make it a "preferred" ETL tool for MicroStrategy. Unlike some of its competitors, MicroStrategy has chosen to focus exclusively on being a leading provider of BI technology and solutions.

Chuck Kelley’s Answer: I don’t think that there is any ETL tool that is better or worse when being used with MicroStrategy. The reason I say this is that ETL takes data from a source system and loads it in a data warehouse/data mart. Then MicroStrategy’s product will access that data warehouse/data mart. The big question I would be asking is what environment does MicroStrategy work in – star schemas, snowflake schemas, relational structures, multidimensional structures, etc. Determine that and then use the best ETL for your transformational needs to build that environment.

Joe Oates’ Answer: ETL (extract, transform and load) tools are independent of a presentation tool such as MicroStrategy. The ETL tool transforms legacy data into the design for a particular data warehouse or data mart implementation. Only when the transformed data has been loaded into the data warehouse or data mart data structures, does a presentation tool like MicroStrategy access the database structures. The presentation tools do not directly access the output of the ETL tool.

It does not matter which ETL tool is used. I have worked on implementations that used ETL tools such as Informatica, Ascential, ETI and other lesser known tools that have used MicroStrategy as a presentation tool. I have also worked on implementations that did their own ETL coding in COBOL, C or even stored procedures.

The bottom line is that you should examine the complexity of the legacy system(s) data and do a careful evaluation of the features, cost and learning curve required for each of the tools and decide which one, if any, fits your situation the best.

Clay Rehm’s Answer: The best answer to this is – it should not matter. Since MicroSrategy is a query and reporting tool, how the data got to the database there should not matter. As long as the ETL designers and developers and database designers and developers did their job correctly, any reporting tool should work as expected.

If you are trying to track the migration of meta data, then this is a different question. Some tools work together and I would contact MicroStrategy directly on this question.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access