BusinessObjects Board

Where is Datastore information stored in the BORP?

dataservices job design
#1

Hi,
I was trying to produce a list of all datastores within a BORP and show their connection details using SQL.
For instance when you edit a datastore I would like to be able to query the BORP to retrieve the datastore name and data source and if possible the username.
The other question is if there is more than one configuration I only want to bring back where default configuration equals Yes.
I used to know my way around the BORP tables but it’s been a while.
Regards,
Ben

BOBen :australia: (BOB member since 2011-02-08)

#2

Check out this thread and see if it has what you want: Datastore Configuration Parser

eganjp :us: (BOB member since 2007-09-12)