I have been asked to find the answer to question. We are currently looking at a solution, but wish to know if we have the stored in SQL Server 2008 R2, could we sit an Oracle Repository and OBIEE 11g on top of this or would we need to either:
a. Transfer all the data into an Oracle database for the reportistory to be created
b. Spend a lot of money creating a link that would allow the two to talk
If b is possible, would the cost in terms of time, resources etc. exceed the cost of option a.
Sorry if this a really stupid question but I have been asked to find out before we go down a solution route. Better to sound sill now then further down the road when hit the issue.