ECC – Connect to Storage Scope API


EMC Control Center comes with an optional component called Storage Scope. Storage Scope allows you to log data which is collected by ECC and report on it. As an alternative to using the default Storage Scope interface you can also directly connect to its database using ECC’s published API.

Storage Scope Database API Details
DB SID: rambdb
Username: stsview
Password: sts (Note: ECC 6.1 and higher the ECC Admin can change this password)

Storage scope is pretty easy to use. The documentation 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 breakdown of what you’ll need to connect using the Storage Scope API:

1. Oracle ODBC drivers installed

Download and install from here: Download Oracle JDBC Driver

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 = <IP address of ECC RepositoryStorage Scope Server>)(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 <storage scope server IP> 1521

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s