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

UCMDB Federation and SQL Server

SOLVED
Go to Solution
Frequent Advisor

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
HPE Expert

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

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)
Frequent Advisor

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

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!
Frequent Advisor

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!
Frequent Advisor

Re: UCMDB Federation and SQL Server

sorry, I'm has forgotten change adapter.conf.
Connect is successful!
Frequent Advisor

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
Frequent Advisor

Re: UCMDB Federation and SQL Server

//Add this to "OnDomLoad" event