Basant, A big question is whether the data will remain in these other tables and that is the master copy of the data and where it will be maintained and you want it "discovered" into the CMDB and kept in sync there OR is this a one time transfer into the CMDB and then the CMDB will become the owner and master source of this data.
Step 1 Create a dataset that will hold this data. This will be the drop location for the data from this source. Step 2 Create appropriate normalization (if any) and reconciliation ID and reconciliation merge jobs and activity for this data to clean, identify, and merge it with other data and into the production dataset Step 3 IF the data is going to remain in the custom tables and be owned there, use a process like AI to create a job that loads the data from the custom forms into the CMDB, mapped as appropriate. Take advantage of the feature to check timestamps (and key off last modified time) to only load things changed since last load. IF the data is going to be one time converted, I would still use AI to do the one time load as it is just the safest way to move the data -- but you could do some kind of custom data move as it will be done one time. Then, once moved, you can eliminate the old custom tables and just manage the data in the new dataset as being the master owner of the data now. Really, these directions are the same regardless of what data source you decide to integrate with/move into the CMDB. Doug Mueller -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Basant Soni Sent: Thursday, July 14, 2016 2:38 AM To: arslist@ARSLIST.ORG Subject: CMDB CI's data transferred... Hi Friends, I have a requirement in CMDB: - 1: Customers are storing their CI’s data in their custom tables and they want to move/transferred those CI’s data into BMC CMDB correct tables. 2: We would like to know, who and How can we decide to CI’s will be uploaded in which tables. Can anyone please let me know that how we can do this? I.e. how can decide/design that in which table those data will be transferred? I don’t know any idea/knowledge of BMC CMDB, we would be really helpful if someone provide me the documents. Regards, Basant Soni _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"