Kartic's Musings on Corporate Information and Knowledge Management

September 18, 2008

Export Files to SharePoint Document library from Business Objects and Adobe LiveCycles

Filed under: SharePoint — kartickapur @ 11:56 pm

Apart from Sharepoint, our company has also implemented other Workflow and Business Intelligence tools:

·         Adobe Lice Cycles Server – To manage electronic forms and workflow

·         Business Objects XI – To generate business Intelligence reports for Finance and Operations

 

Business Requirement:

·         Store the completed Adobe LiveCycles Form in SharePoint Document library and make is searchable.

·         Export the Business Objects report to SharePoint Document library and publish it on sharepoint.

 

We achieved this simply by following the steps below:

1.       Go to document library and open it in the windows explorer view. Copy the UNC path for the explorer view which will go something like this //<sharepoint_server>/<site..>/<site.>/<Document_library>/

2.       Go to Business Objects and Adobe server and start the web client service. This service is needed to access and modify internet based files (sharepoint doc library).

3.       In the business objects, schedule the report to be exported to a file location. Provide the UNC location, copied earlier.

4.       To export from Adobe livecycle, you can export the file to a UNC location at any step in the workflow (sorry don’t have any screen shots).

 

You can get the following advantages from Sharepoint:

·         SharePoint search facility (to locate a particular type of report or form)

·         Version control to browse the older version of the same report or form. SharePoint actually stores a new file with same name as a new version of the document (you of course need the versioning turned on).

Excel services can be used to publish report to a SharePoint page (this should be updated with the latest version).

Advertisements

6 Comments »

  1. Thank you
    This is a cool website.

    Comment by business intelligence — September 27, 2008 @ 12:33 pm

  2. hi .. we are using BO XI 3.1 and Share point 2007 for integration.
    we have followed the above same …

    we have tried to to scheduled the BO report to share point server using unmanged disk (file location). for this we have configured Desination server and Webiprocessing server’s desination. but scheduling get feiled with following error:

    login error. [Logon failure: unknown user name or bad password.]: [CrystalEnterprise.DiskUnmanaged]

    here we have used the Administartor user of desination server in user account configuration in desination of both servers

    Thanks in advance …

    Comment by Vilas — January 2, 2010 @ 11:36 am

  3. as mentioned in post about UNC path
    //////

    hoever i save and close the destination setting page of server above setting will get changed automatic to

    \\\\\\

    i.e. / get changed to \

    Comment by Vilas — January 2, 2010 @ 11:51 am

  4. HI,
    Thanks for cool post. we are trying to use BO Enterprise XR R2 portal integration kit for SharePoint to view reports. I wonder if you have used this kit for sharepoint integration? Also have you tried searching BO reports based on BO Metadata? Any tips or idea?

    Comment by pryank — March 16, 2010 @ 5:06 pm

  5. How do we enter domain user login info in above. Its not working for me

    Comment by Pratik — March 12, 2012 @ 3:55 pm

  6. Howdy! I just wish to give a huge thumbs up for the great info you will have right here
    on this post. I shall be coming back to your blog for extra soon.

    Comment by autotrader san antonio tx — April 21, 2013 @ 2:58 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: