26 กรกฎาคม 2555 19:58
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.
2 สิงหาคม 2555 2:47
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:
Rock Wang TechNet Community Support
2 สิงหาคม 2555 18:18
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,
11 กันยายน 2555 7:18
Hi Tom Molskow,
Did you resolve this issue...?
Thanks & Regards
11 กันยายน 2555 19:47
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."
- ทำเครื่องหมายเป็นคำตอบโดย Tom Molskow 9 ตุลาคม 2555 14:07
12 กันยายน 2555 20:32