Getting database Table information using JAVA SL SDK in Business Objects 4.2

[Former Member]

All,

We are using SAP Business Objects 4.2, I was asked to get Database tables used in a BO Universe using JAVA SL SDK.I can get Universe and Webi documents using SQL queries and using (infoStore) but couldn't figure how to get Database table names. Please let me know, how to approach this issue.

[ayman_salem · Accepted solution]

Hi Surya,

- for unx universes:

Take a look at the example SL_SDK under .. \SAP BusinessObjects Enterprise XI 4.0\SL SDK\SDK Samples

extract "com.sap.sl.sdk.authoring.samples.source.jar",

then look at (dataFoundation.getTables()) in ...\com\sap\sl\sdk\authoring\samples\CreateUniverseTest.java

- for unv:

you can use vba on the client side where "Universe-Design-Tool" is installed

hope that will help you

Ayman