OLAP cube in MS analysis server using data from oracle database

Hot Topic

SQLServer2005_SSMSEE.msi & SqlServer2K5_BOL.msi
Create New Table
making two sums in one query
NET Framework error occurred during execution of user defined routine or aggregate 'getSalesOrdersHeaders'
how to install sql server 2005
SSIS Requests...
system error 126
Trimm off any extra spaces in File Connection Manager for a field
Data mapping to column 'CustomerID' was already found in the data. Make sure that no two schema definitions map to the s
SQL 2005 Upgrade Advisor question

SQL Server

Deploying reports on 2000 Reporting Serve
How to View a Scheduled Job?
Remote Execution of SSIS Packages via Web Service
I need to compare two string values and give confidence score on how much they are similar.How do we use Fuzzy look up to do it?
Msgbox/Breakpoints not working in a script component.
Help - Standard vs. Data-Driven Subscriptions
Page break occurring between a list and a table
Tell to split on change of ID
Previews OK, but then error: "Rowset not returned"
SQL Mobile Query

OLAP cube in MS analysis server using data from oracle database

Hi,

I was trying to build a OLAP cube in MS analysis server 2000 using data from oracle database. i was trying to create datasource from orcle odbc.... i have my data in oracle DB

i am not able to establish the connection.....

sometimes it says connection established .. but when i try to craete cube and select fact table i will not be able to see any tables and it says no connection established...

Is it possible to create OLAP cube in MS analysis server using data from oracle database......

or can we create datasource for the linked servers of MS sql server

thanks

Yogesh

Answer this question

OLAP cube in MS analysis server using data from oracle database

  • Kreator

    1) what version of Oracle and ODBC are you trying to connect

    2) have you tried using an OleDb Provider for Oracle instead of ODBC .

    I’ve just used OleDb to an Oracle 9i DB and connectivity was successfull.

    Leandro



  • Eduardo Baião

    BTW, AS2005 doesn't support odbc connection, so you should use OleDb connection for your solution.

  • HugoC

    thanks a lot Leandro

    yes... Oledb in analysis services worked.....

    i was tying to first establish odbc connection and then in analysis services...

    but now i think we can directly do it with analysis services datasource oledb...

    this is great and reduce lot of work ........

    thanks

    yogesh

  • Luca69

    Having had the same problem, the solution was different.

    When designing the Data Source, the connection parameters were already established in "General". I had specified them a second time in the "Impersonation Information". By choosing DEFAULT there, it worked. Before, I had chosen "Use a specific user name and password". By choosing "Default" everything worked fine.


  • OLAP cube in MS analysis server using data from oracle database
Answer this question