Skip to Content

BI Java SDK

Hi, I am trying to make a DB connection using the tutorial:

"How To Use the BI Java SDK in a Portal iView" from NWDE

and I have 2 questions.

1.- the documentation say that I need to import the com.sap.portal.ivs.connectorservice_api.jar. This is already imported but the "import com.sapportals.portal.ivs.cg.ConnectionProperties; " remain with error.

where do I found the correct jar to import ?

2.- this is an example to connect with a bi_xmla system and retrieve the schemas

How can I modify it in order to connect to a bi_jdbc system and retrieve the tables?

IConnectorService connectorService;

IConnectorGatewayService connectorGatewayService;

IConnection connection;

try { connectorService = (IConnectorService) PortalRuntime .getRuntimeResources() .getService( IConnectorService.KEY);

connectorGatewayService = connectorService.getIConnectorGatewayService();

ConnectionProperties connectionProperties =

new ConnectionProperties( request.getLocale(), request.getUser());

connection = connectorGatewayService.getConnection( "AB5_XMLA", connectionProperties);

IBIOlap olap = ((IBIConnection) connection).getOlap();

List schemas = olap.getSchema();

Schema schema = null; for (int i = 0; i < schemas.size(); i++) { schema = (Schema) schemas.get(i);

response.getWriter().write( "schema: " + schema.getName() + "<br>"); } } catch (Exception e) { e.printStackTrace(); }

Regards.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 04:12 PM

    Answer to your first question...

    Add the jar file portal_services_api_lib that has the ConnectionProperties class.

    Second question...

    I think there are examples in the BI SDK Documentation on BI JDBC Connectors..try those.

    Regards,

    Smitha

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.