Alternative Ways to Schedule Reports to Sharepoint UNC

scheduling XI Scheduler
1

Hi Folks,

We are on 4.1 SP4 Windows 2008 R2 Sharepoint 2013 SSL

Are their other ways to send reports to Sharepoint with SSL besides email?

I heard in 4.2 we would have an option of secure SFTP?

Currently we are scheduling reports to our server and using a powershell command to copy the report into Sharepoint.

Thanks :slight_smile:

a123 (BOB member since 2011-12-28)

2

You can schedule a report to SharePoint via UNC, with two requirements:
[list][:b938cad2ad]The Desktop Experience feature must be enabled on the BO server
[:b938cad2ad]The service account that BO runs as must be given write permissions to the appropriate document library[/list]
Joe

joepeters :us: (BOB member since 2002-08-29)

3

Hi Joe,

I was told that if Sharepoint is on SSL then it would not be possible to send the reports via UNC path. Is this true?

I followed all the steps in the below URL and I even submitted a ticket with SAP who just shrugged the issue off and did not even offer a workaround.

http://bi-thinkers.blogspot.co.uk/2011/05/how-to-schedule-to-sharepoint-document.html

Thanks

a123 (BOB member since 2011-12-28)

4

Did you try appending ā€œ@SSLā€ to the server name (ex. \sharepointserver@ssl\docs)? See here

I would try it from your desktop first, and then try it on the server if it works.

joepeters :us: (BOB member since 2002-08-29)

5

Hi Joe

I tried to append @SSL on my personal workstation but I received a windows explorer error" Windows canā€™t find ā€˜//sharepointserver@ssl/docsā€™ It works if I use ā€˜\sharepointserver\docsā€™ .

I am wondering besides web client on my personal machine if I need to enable anything else?

Thanks :slight_smile:

a123 (BOB member since 2011-12-28)

6

So \sharepointserver\docs works on your workstation? Thatā€™s interesting. It should work from the BO server too, if everything is set up right. I would try the following tests, in order.

  1. RDP into the BO server as yourself and try \sharepointserver\docs in Windows Explorer. If it works, proceed. If not, then make sure Desktop Experience is installed and the service is running.

  2. RDP into the BO server as the BO service account. If you canā€™t access \sharepointserver\docs, then the problem is related to the service accountā€™s access to the library. If you can access it, then proceed.

  3. Finally, schedule a report to \sharepointserver\docs. If it fails, then something else is going on. Enable tracing on the job server, run it again, and check the logs for any hint of the problem.

joepeters :us: (BOB member since 2002-08-29)

7

Thank you joepeters for your help :slight_smile:

I tried steps 1 & 2 which worked so I moved to step 3 still failed. I enabled tracing on the job server and spent 2 hours search through the logs to find any information but could not find anything. I plan on revisiting the log files when I have time.

But if I understand correctly even if your sharepoint deployment is using SSL you can still use unc path to send a report to sharepoint? we are on 4.1 SP4?

a123 (BOB member since 2011-12-28)

8

Supposedly, with SSL enabled, you have you use @SSL in the path. But you found that it worked from your workstation and the server without it. So, thereā€™s no reason I can think of that it should work any differently from a scheduled job.

joepeters :us: (BOB member since 2002-08-29)

9

it is so silly that I can create a powershell script to send a report to sharepoint from our windows server. But an expensive tool like BO I canā€™t send a report to sharepoint using UNC path :nonod:

a123 (BOB member since 2011-12-28)

10

Well, I can attest to it working, though I havenā€™t tried it with an SSL site.

joepeters :us: (BOB member since 2002-08-29)

11

jopeters great news!

We can get BOE reports to SharePoint by scheduling to UNC path. So you may ask What did you do different?

Actually I did not make any changes at all. But our SharePoint team did make changes, they went from using windows AD authentication to using Active directory federated service (ADFS)

So as of now the only way to schedule reports successfully is to:

  1. Log into the BOE server
  2. Navigate to the web browser
  3. Navigate to SharePoint and log in using email address and password
    4.When scheduling report user name and password has to be the same as the log in credentials used in the browser authentication.

a123 (BOB member since 2011-12-28)

12

Thatā€™s interesting. I wonder if you had to do that because of SSL or for some other reason.

joepeters :us: (BOB member since 2002-08-29)

13

Also in order to successfully schedule a report I need to perform the following steps:

  1. Log into Business Objects server (with account that has access to SharePoint)
  2. Navigate to the browser and log into SharePoint
  3. In CMC Schedule report to file system and fill in user name & password with the same account that logged into the Business Objects server & SharePoint

As far as the UNC path I do not need to use ā€œ@SSLā€

a123 (BOB member since 2011-12-28)