locked
Error to connect oracle DB RRS feed

  • Question

  • Hello Guys,

    On my server box(SQL Server 2012), I use my BISM(in Data Tool) to load one table from oracle DB. The connection was tested successfully but loading data always ends up with the error as below.

    Note. Analysis Server has persisted any security information specified as part of the Connection string portion of the Datsource object definition.
    
    
    The provider 'OraOLEDB.Oracle' is not registered.
    
    
    The following system error occurred:  Class not registered 
    
    
    A connection could not be made to the data source with the DataSourceID of '6faa7257-f404-4dc6-9e22-50663f2cfb30', Name of 'Oracle fff2'.
    
    
    An error occurred while processing the partition 'APPLICATION_258b4794-870c-46b4-8d81-d4d9a0a4e495' in table 'APPLICATION_258b4794-870c-46b4-8d81-d4d9a0a4e495'.
    
    
    The current operation was cancelled because another operation in the transaction failed.
    
    
    Out of line object 'DataSource', referring to ID(s) '6faa7257-f404-4dc6-9e22-50663f2cfb30', has been specified but has not been used.
    
    
    Out of line object 'DataSourceView', referring to ID(s) 'Temp_DSV', has been specified but has not been used.
    
    

    Any idea to share on this?

    Thanks in advance


    Derek


    • Edited by Derek Dai Saturday, September 14, 2013 6:43 PM
    Saturday, September 14, 2013 4:49 PM

Answers

  • Hello Derek,

    Have you installed the Oracle OleDB data provider on the server? If it's a 64 SSAS server you have to install the 64 bit Oracle OleDB data provider to get it working.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Elvis Long Tuesday, September 17, 2013 7:43 AM
    • Marked as answer by Elvis Long Monday, September 23, 2013 1:03 PM
    Sunday, September 15, 2013 6:50 AM