UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

UCMDB Federation. DBAdapter URL to SQL server

SOLVED
Go to Solution
Advisor

UCMDB Federation. DBAdapter URL to SQL server

[ Edited ]

Hi everyone!

I 'am trying to create GenericDBaAdapter to connect to Microsoft SQL Server database. I cancot establish the connection because of the wrong URL (seems to me).

I enter such one:

URL: dbtype=Microsoft SQL, dbname=HPCACORE, sid=sa, pwd=cit

Could you tell me, is anything wrong?

(ODBС source is connecting properly with such passwords and login)

 

 

P.S. This thread has been moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp forum Moderator

6 REPLIES
Honored Contributor

Re: UCMDB Federation. DBAdapter URL to SQL server

You should type URL:
dbtype=sqlserver;dbname=HPCACORE
user and password should be mentioned in appropriate fields.

Enjoy.
Advisor

Re: UCMDB Federation. DBAdapter URL to SQL server

Thank you a lot, Alexander!

Now I'am trying to enter URL:

dbtype=sqlserver; dbname=HPCACORE

as you told. But it still doesn't work..

Mistake is: "Сan't create dynamic Java classes" ODBC source is connecting properly to that base. Something is still wrong..


Honored Contributor

Re: UCMDB Federation. DBAdapter URL to SQL server

Did you try it without space after semicolon?
Honored Contributor

Re: UCMDB Federation. DBAdapter URL to SQL server

1st - do not use spaces where it is not necessary.
2nd - did you configure the orm.xml or simplifiedconfiguration.xml properly before creating a data store?
3rd - once you've configured the orm (mapping of GDBA) - cleanup the folder \j2f\fcmdb\CodeBase\GenericDBAdapter\generic_db_adapter and try again
Advisor

Re: UCMDB Federation. DBAdapter URL to SQL server

Thank you! You are right, I am quiet newby in UCMDB
Advisor

Re: UCMDB Federation. DBAdapter URL to SQL server

Alehander!
Would you help me with Generic Adapter store. Is it enough only to configure simplifiesconfigurationfile.xml to create data store properly?
//Add this to "OnDomLoad" event