UCMDB and UD Practitioners Forum (Previously CMS)
cancel

UCMDB Federation. DBAdapter URL to SQL server

SOLVED
Go to solution
Highlighted
Mikhail123
Super Collector

UCMDB Federation. DBAdapter URL to SQL server

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
Alexander Arkhi
Honored Contributor
Solution

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.
Mikhail123
Super Collector

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..


Sergey Stefurak
Honored Contributor

Re: UCMDB Federation. DBAdapter URL to SQL server

Did you try it without space after semicolon?
Alexander Arkhi
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
Mikhail123
Super Collector

Re: UCMDB Federation. DBAdapter URL to SQL server

Thank you! You are right, I am quiet newby in UCMDB
Mikhail123
Super Collector

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