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

UCMDB Federation and SQL Server

SOLVED
Go to solution
Highlighted
Isaev
Regular Collector

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 Shevchen
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.
Isaev
Regular Collector

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
Regular Collector
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
Regular Collector

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
Regular Collector

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
Regular Collector

Re: UCMDB Federation and SQL Server

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

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
Regular Collector

Re: UCMDB Federation and SQL Server

//Add this to "OnDomLoad" event