Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1086
  • Last Modified:

How to connect Oracl databaseto SSAS

Hellow Expertes,
I was trying to deploy a cube to SSAS 2008 whos data souce was Oracle 10g. The data source and the cube are in two different servers. when I try to deploy the cube I got the follwoing error. Can somebody assist me?

Error 9 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Datasources', Name of 'Datasources'

Thanks!
0
Mulie
Asked:
Mulie
1 Solution
 
lcohanDatabase AnalystCommented:
I think you should be able to do that is you add a Linked server in SQL2008 to your ORACLE data source and then access it by using the full name qualifiiers.

How to set up and troubleshoot a linked server to an Oracle database in SQL Server
http://support.microsoft.com/kb/280106

Practical SQL Server 2008 for Oracle Professionals
http://www.google.ca/url?sa=t&source=web&cd=9&ved=0CGYQFjAI&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F6%2F9%2Fd%2F69d1fea7-5b42-437a-b3ba-a4ad13e34ef6%2FSQLServer2008forOracle.docx&ei=5Ux7Ts-yNejX0QGFv5zXAg&usg=AFQjCNEk5yTqwkuAt2oV-4jjghxIqAheGg
0
 
johnsoneSenior Oracle DBACommented:
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now