Storage Scope APIs

I found this document:StorageScope API P/N 300-003-713 Rev A01 September 2006, but I don't see it as being much help.
What would be helpful is how to actually use it.
Another question: how do I enable multi site reporting in storage scope?

STSAPI is automatically installed once you installed StorageScope. It consists of StorageScope views and tables. It is a database account called STSVIEW in ECC repository. You can directly access that.

The STSAPI is documented in the StorageScope API & Repository Reference Guide. The doc describes clearly of each views and tables. It also shows you how to access it.

Hi,

ControlCenter does not support multi-site reporting. If you would like a central storage data warehouse for all your ControlCenter sites then you can use the Enterprise Data Gateway (EDG) product. Here is some further info on EDG (this is an extract from knowledgebase article emc190250):

EDG (Enterprise Data Gateway) is a solution available from the Corporate Custom Reporting Team. EDG is a multi-site reporting service that EMC offers to customers that pulls data from EMC ControlCenter StorageScope (STS) using SQL and ECCAPI. EDG creates an external Reporting Data Warehouse of ControlCenter and other data that allows easy data integration and reporting. The latest version as of June 2008 is EDG version 1.5.1.

Purpose of EDG

ControlCenter 6.0 does not support Multi-site reporting on its own, but multi-site support for reporting is a standard feature of EDG. EDG can simultaneously provide multi-site reporting between multiple ControlCenter versions (5.2, 6.0, 6.1) at different sites. The EDG product is most useful for customers who have a large site with multiple ControlCenter Infrastructures and need a central storage data warehouse for all the ControlCenter sites.

To obtain support for EDG

EDG (Enterprise Data Gateway) is not supported by EMC ControlCenter teams or within the EMC Customer Support (CS) organization. To obtain support for EDG, contact your EMC field service representative or a local EMC TSG Account Team member familiar with the product can contact the EDG group directly.


Regards,

Seamus Coffey
EMC Global Services

Storage scope is pretty easy to use. The document while a bit long covers how to connect to Storage Scope using the API interface and also what you can expect in terms of tables and views.

Here is a break down of what you'll need to connect to the Storage Scope API:

1. Oracle ODBC drivers installed

Download and install from here: http://www.oracle.com/technology/software/tech/windows/odbc/htdocs/utilsoft.html

2. Update the tnsnames.ora file with the following information. Search for the file and you'll find it...

RAMBDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAMBDB)
)
)

3. Create an ODBC connection within Start -> Control Panel -> Administrative Tools -> Data Sources (ODBC)

3.1 Click the "System DNS" tab and select ADD
3.2 Scroll down to "Oracle ODBC..." and click Finish
3.3 Fill in the following details.
Data Source Name: ECC STS Connection
Service Name: RAMBDB
UserID: stsview

All other values can be left as their defaults. Click OK.

4. Viewing Storage Scope tables... there are many applications which allow you to view Oracle databases. I use DBVisualizer but you can also use Microsoft Excel.

Launch Microsoft Excel.
Select Data -> Import External Data -> New Database Query
From the list select "ECC STS Connection" and click OK

At this point Excel will attempt to connect to the storage scope server. If it is successful you will be prompted for a password to login. The password as documented within the EMC documentation is "sts" with NO quotes.

If you've passed this point you have successfully connected and can now browse the Storage Scope tables.

Re-read the Storage Scope API guide and start digging into the data.

Troubleshooting Steps: If the database connection fails validate that the port is not being blocked.

Start -> run -> cmd
type in telnet 1521

If you get a blank screen with a blinking cursor the port is open. If not it's possibly blocked by a firewall.