Service Desk Practitioners Forum
cancel

NNM SD integration

Highlighted
Zoltan Molnar_1
Super Contributor.

NNM SD integration

Hi
I have to connect to NNM Solid database accross Solid ODBC driver installed on SD5.1.
I download and install SOlid ODBC driver on SD server.
Can You send me, or tell me across this forum what can I configured to connect to NNM database and import CI-s.
I can't send NNM data to another datawarehouse. We cannot use Oracle or SQL to store NNM data.
Thanks and best regards
2 REPLIES
Pietro Papagno
Super Contributor.

Re: NNM SD integration

In "NetworkName" you have to write: "TCPIP port "
I use MS Excel to store data (data->new query on database). Then if you want to import data from Excel to SD you have to configure Data Exchange.
Zoltan Molnar_1
Super Contributor.

Re: NNM SD integration

Hi Pietro
Thanks for your suggestion. I try this, but the error is same. our ini file is this:
--------------------------------
[DSN]
NAME=solid
USR=ovdb
PWD=ovdb


[SYSTEM]
LOG= TRUE
XML= TRUE
LOG_FILE=C:\DATAEXCH\log\NNM.log
XML_OUTPUT_FILE=C:\DATAEXCH\xml\NNM.xml
APPLICATION_NAME=NNM

[CLASSES]
NAME=NODE


[NODE]
-------------------------------------


The error information:
-------------------------------------
Unable to retrieve database connection to: 'jdbc:
odbc:solid', user 'ovdb'
-------------------------------------


Some suggestion?