0

I am doing research to see what is the best way to take data from a live database, and transform it to be able to put the data into data cubes. Currently as a prototype, we used normal queries, to copy data from the live database as a sequence of SQL Statements, and put into the intermediate DB that is used for OLAP, but for the real thing we are considering to use MDX.

Any tips, if this is the best and most efficient way?

Mez
  • 4,666
  • 4
  • 29
  • 57

1 Answers1

1

I think you're making a mistake, you can not use MDX to load data from a db to an olap server. MDX is not an language for ETL, or I'm missing somehting.

As you're describing is a 'standard' way for doing this (actually do you need the intermediate db or a set of new tables, materialized views and views is enough)

ic3
  • 7,917
  • 14
  • 67
  • 115
  • Yes as the transformation is quite large, and the schema of the database will change in the near future, so this needs to be separate. So if executing batches of scripts after each other is the standard way, what exactly are MDX used for? – Mez Oct 19 '11 at 14:33
  • Sorry I was actually referring to "Integration Services" for the transformation, and MDX for query reading frome the cubes. – Mez Oct 19 '11 at 14:54