Solved

How to connect Oracl databaseto SSAS

Posted on 2011-09-22
2
1,076 Views
Last Modified: 2016-02-14
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
Comment
Question by:Mulie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 36581084
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
 
LVL 35

Expert Comment

by:johnsone
ID: 36581143
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question