I'm working on a BI center built in Sharepoint 2013, and we are seeing some oddities with our farm.
Our team as already built one PowerPivot workbook of the following:
1. MS SQL Server datastore.
2. Teradata Data Warehouse.
Now we are going after a PowerPivot that needs to connect to Oracle. I have been able to build the connection and recordset on my desktop through an ODBC driver connection. But when I post it up to the SharePoint farm we cannot get the data refresh cycle to work. It's just throwing an error that says "Invalid user credentials or permissions."
Here are the things that we have tried:
1. Installed Oracle Data Access Components for 11gR202 on the SharePoint farm to install the .NET data provider. This is the same pattern that we used on the Teradata problem.
2. Setup the Secure Store with the Account & Pwd for the connecting to the Oracle DB.
Manually built the workbook and the PowerPivot tables on the desktop connecting to the Oracle DB. Then Saved and published it up to our PowerPivot Gallery on the SharePoint site.
Have I over looked something with data connectivity to Oracle?