Accessing data warehouse (using embedded solid database) via ODBC

[larsniklasson]

Hi,

I want to access NNM's data warehouse using MS Excel, MS Access or some other product that can use ODBC.

I'm running NNM 6.4 on Solaris 9. I'm also using the Solid database that comes with NNM.

What configurations do I have to do to enable ODBC access to my data warehouse database?

And what configurations do I have to do at the client side (MS Excel 2002)?

Best Regards
Niklasson

 

[rkodama]

Hi!

just pick Win32 ODBC driver located into your Solaris box and install at Windows machine:

$OV_CONF/analysis/reportTemplates/Solid/driver/

after you should configure an ODBC DSN path:

tcpip [name of your NNM machine] 2690

usually username and password for NNM is "ovdb".

Good Luck!

Roberto Kodama