Test Connections

[sateesh_kumar1]

Hi Team ,

Environment : BI 4.1 SP6 Patch2

OS : Windows 2012 R2

In our environment , we often see connection related issues either database issues / BOBJ connection drivers issues.

We are using 12 different databases for reporting (SQL server , Oracle and SAP BW ) in BOBJ .we created a WebI report to test whether all connections are working (refresh manually / schedule ) .

If there is any issue , we'll further refresh all connections one by one to find which connection has issue .

Can we automate the process of connection testing? ( not using report)

Idea here is , we need a batch file / .exe file which will execute on periodic basis to test a list of specified connections and captures Test connection description message either success message or failure message description for each specified connection .

which then should be sent BOBJ admins to take immediate action .

Origin of this idea is How to Test All Connection using BusinessObjects SDK

Can we write SDK to achieve this requirement ?

Thank you .

[DellSC]

This code uses the old COM-based Designer SDK which was used for .unv universes.  So, first, you will have the challenges of using COM in Java which may require locating an external library to allow this.  You'll also have to install the Universe Designer from the Client Tools install and "register" the component by running:

designer.exe -regsvr

This should allow you to get to all of the Relational and OLAP connections for testing.  However, it will not test any Data Federator connections.

The new Semantic Layer SDK is used for working with .unx universes.  The Semantic Layer Developer Guide says that it can be used to test connections.  However, I haven't been able to find anything in  the Developer Guide, API Reference, or sample code that provides information on how to do this.

-Dell