none
Using Oracle ODBC connection String in Dashboard Designer RRS feed

  • Question

  • Hi,

    I am trying to use the below oracle odbc connection string as datasource in Performance Point Dashboard Designer.

     

    Driver={Microsoft ODBC for Oracle};Server=<server name>;Uid=username;Pwd=password;

     

    it throws the following error, any what could be wrong?

     

    "The PerformancePoint Server could not connect to the specified data source. Verify that either the current user or application pool user has Read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct."

     

     

    Thanks,

    Ganesh

    Wednesday, January 30, 2008 7:29 PM

Answers

  • Hello GaneshReddy,

     

    One thing to check would be to make sure the account running the PPSMonitoring Application pool has access to the Oracle data source. Thats the account PerformancePoint uses to make that connection.

     

    Thanks,

    Jon Thomas

    Wednesday, January 30, 2008 8:15 PM
    Moderator