UCMDB and UD Practitioners Forum (Previously CMS)
cancel

UCMDB Federation and SQL Server

SOLVED
Go to solution
Highlighted
Isaev
Respected Contributor.

UCMDB Federation and SQL Server

Hi all.
Please, help me with inegration UCMDB and SQL Server.
I'm read all documentation, but have not found nothing interesting.
In DB SQL "DataBase1" have table "Device"
How use Federation UCMDB connect to this table?
In manuals used GenericDBAdapter. Where connecting settings to SQL database in UCMDB?
8 REPLIES
Dmitry Shevchenko
Acclaimed Contributor.

Re: UCMDB Federation and SQL Server

You provide connection settings to your SQL DB while creating a data store based on the adapter you built.

Try to get Integrations guide from uCMDB 8.0 documentation library. You'll be able to read how Generic DB Adapter is configured and deployed.
Isaev
Respected Contributor.

Re: UCMDB Federation and SQL Server

Dmitriy thank you!
I'am read manual's UCMDB8 integration guide and now connect is successful without orm.xml in UCMDBServer\j2f\fcmdb\CodeBase\MyAdapter\META-INF\ folder.
When I'm put orm.xml in this folder, UCMDB type error. I understand that orm.xml it is mapping between UCMDB and my RDBMS?
Mapping in integration guide is very bad described.
I'am create CIT in UCMDB - "Host Card" with attributes "vendor" and "host_name". In my RDBMS table exists three fields:
Device_ID,
Vendor,
Host_name.
What mapping must be in file orm.xml?
Beforehand thank you!
(P.S. I in Russia as you. If you better to write me at russian language, my email - isaev.misha@gmail.com
Later, i type answer in this Thread)
yuanji.xuan
Respected Contributor.
Solution

Re: UCMDB Federation and SQL Server

Maybe At first you'd better try the federation by setting simplifiedConfiguration.xml.

My successful deployment step by step doc of GenericDataAdapter is attached in the link below.Hope it can help you:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1317407

PS:In my deployment doc, the multinode CIs of "Host2" were created manually in uCMDB side at that time.But Now I think the CIs should be created by DDM automatically.
Isaev
Respected Contributor.

Re: UCMDB Federation and SQL Server

Yuanji, thank you!
In your Thread attach is actual and work?
You used GenericDBAdapter?
May be you send me example your orm.xml and simplifiedConfiguration.xml?
I'm try modeling in my server with your sample.
I shall very grateful!
Isaev
Respected Contributor.

Re: UCMDB Federation and SQL Server

I'm read your docs and connect is successfully, but when i must choose support CIT this list is empty. Why?
This sample work when in folder "CodeBase\TestDBA2\META-INF\" delete orm.xml. If used standart orm.xml the connect with error!
Isaev
Respected Contributor.

Re: UCMDB Federation and SQL Server

sorry, I'm has forgotten change adapter.conf.
Connect is successful!
Isaev
Respected Contributor.

Re: UCMDB Federation and SQL Server

Thank you yuanji.xuan@hp.com!
Your solution helped me!


solution:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1317407
Isaev
Respected Contributor.

Re: UCMDB Federation and SQL Server