SPS 2010 - Power Pivot - Auto Refresh - Oracle Account

Question

Hello Community!

I have configured a PowerPivot Service Application with an Unattended Secure Store Service account.  Now the users have uploaded a Excel spreadsheet that has an Oracle data source.  The Oracle data source uses a connection string with an Oracle userid and password.  Here's the problem, the users want me to configure a data refresh schedule for the PowerPivot Service Application but I do not have an Active Directory account to provide for the member account in the Unattended Secure Store Service account.  Has anyone in the community faced this problem and if so ow did you solve it?  In your answer please provide detailed guidance and clear instructions.

Thanks!

Tom

---

Tom Molskow - Senior SharePoint Architect - Microsoft Community Contributor 2011 and 2012 Award - Linked-In - SharePoint Gypsy

Answer 1

Hi,

You can import data from the data sources in the following table. PowerPivot for Excel does not install the providers that are listed for each data source. Some providers might already be installed with other applications on your computer; in other cases you will need to download and install the provider.

For more information about connect to an Oracle database in PowerPivot, check out the following articles:

http://technet.microsoft.com/en-us/library/gg399082

http://technet.microsoft.com/en-us/library/gg399158

Thanks,

Rock Wang

---

Rock Wang TechNet Community Support

Answer 2

Hello Rock Wang,

That's a good start - so are you saying I need to install the oracle data provider for this to work?  Does that data provider go on the SharePoint servers?  Which/all servers?

Thanks but still need more info,

Tom

---

Tom Molskow - Senior SharePoint Architect - Microsoft Community Contributor 2011 and 2012 Award - Linked-In - SharePoint Gypsy

Answer 3

Hi Tom Molskow,

Did you resolve this issue...? 

Thanks & Regards

Nazakath 

Answer 4

I think Oracle client needs to be configured all servers, similar to BCS.

"The Oracle client must be installed on all the computers in the farm and TNS net service must be configured to connect to Oracle from SharePoint. This is required for external lists, Web Parts, and profile pages on the server. As applications such as search run only in App Server, it is okay to install the Oracle client on the application server. Search will connect only from the application server. So in short, the Oracle client must be installed on the computers on the farm from which you will connect to Oracle. The Oracle client also must be installed on the rich client machines for the same reason."

How to: Connect to an Oracle Database Using Business Connectivity Services

Answer 5

Hello Guru,

That sounds very promising - I will give that a try and LYK.

Thanks!

Tom

---

Tom Molskow - Senior SharePoint Architect - Microsoft Community Contributor 2011 and 2012 Award - Linked-In - SharePoint Gypsy