CMDBuild Forum

Creation and sharing of a TOGAF model

Old Versions
#1

Hi,

 
First of all, I'd like to thank all people working on CMDBuild as it is a very good product that I'm deploying on my company.
 
This post is only to share with all of you our current work. As an IT Architect I'm responsible for a project which aims at renewing our CMDB tool. Being aware of TOGAF (an other things related to Enterprise Architecture) I have decided to define classes (our model) to match the TOGAF Content Metamodel and then to extend it a little bit with some ArchiMate concepts.
 
I think our work can be used by several people who wants to start quickly with CMDBuild without having to create a model from scratch. So I have decided to share with you (not now but asap) all sql queries needed to create the model with a modular approach allowing to extend it depending on the needs (used for TOGAF extensions to the core metamodel in our case).
 
If you are interrested, just let me know, and if you have already done something similar please let me know.
 
Regards.
#2

First of all thanks for your opinion on CMDBuild project, we're glad our software is useful for your company!

We know little about the TOGAF framework, but in these days we received two proposals for the integration of TOGAF and CMDBuild; this certainly indicates we need to know more about this type of solution.

Therefore, we're happy to accept your contribution and we'll publish it on the project site!

Please tell us how to publish your contacts and whether to publish your email or suggest our support (if someone asks for details about your scripts).

#3
Hi,
 
I hope this could help someone or provide a good starting point.  No problem to publish this work (but it's beta for the moment) with my name and company, but please (at least for the moment) keep my email hidden.
 
Here you'll find:
  • the SQL query needed to create classes and domains for TOGAF
  • some help to create a menu giving access to classes
 
Some explanations:
  • All classes (including domaines and attributes) have been created using the official TOGAF content metamodel
  • As someone may want to extend this model, in fact each TOGAF class is in fact a super class. So I've create real classes to allow the creation of some cards for testing purpose.
  • My recommandation: you can extend this model by creating classes, but don't changes those already created. This will ease migration to futur releases.
  • This should be considered a beta version: I still have to create extensions (read TOGAF for more information, and see below "roadmap") as I will need them in the near futur.
  • I've followed this naming convention:
    • all classes and domains start with togaf_xxx where xxx is the name of the extension (in this case 'core')
    • the "final" classes created to allow card creation is an instance and so ends with "_i"
    • all domains are in the form "togaf_extension_source_relation_target" where relation is the name of the ArchiMate relation that best match.
 
The primary purpose of TOGAF is Enterprise Architecture, and this kind of usage if perfect with CMDBuild. But this model can also be used as a starting point for a CMDB: in this case tou have to extend it this way (it's on my roadmap):
  • Technology equipments (computer, server, network equipments...) will be derived from "Physical Technology Component"
  • Software (not directly used by business people) will be derived from "Physical Technology Component"
  • Application (software used by business people) will be derived from 'Logical Application Component"
And here is my (sort of) roadmap:
  • create togaf extensions (governance, services, process modelling, data, infrastructure consolidation and motivation)
  • create an ArchiMate extension to allow some concepts and relations not already present in TOGAF (if needed)
  • create some standard reports (ie: artifact in TOGAF)
 
Regards,
 
SARRODIE Jean-Baptiste
IT Architect for Lafarge France
 
PS: I've just seen that lookup values are missing, I will update quickly.
 
Tecnoteca ha scritto:

First of all thanks for your opinion on CMDBuild project, we're glad our software is useful for your company!

We know little about the TOGAF framework, but in these days we received two proposals for the integration of TOGAF and CMDBuild; this certainly indicates we need to know more about this type of solution.

Therefore, we're happy to accept your contribution and we'll publish it on the project site!

Please tell us how to publish your contacts and whether to publish your email or suggest our support (if someone asks for details about your scripts).

 

#4

Jean-Baptiste,

 

Thank you for sharing.  I am very interested in this, but when I run the script I get a number of different errors.  Here is an example:

 

CREATE TABLE togaf_core_role (

    "FTE" double precision

)

INHERITS (togaf);

 

The togaf table does not exist in the script, so this CREATE TABLE statement fails. 

I believe that the root cause of the problem is that the pg_dump command only includes tables with the pattern "*togaf_core*" so it did not dump the "togaf" table.

 

Is it possible for you to recreate the script?

 

Bruce

Kissinger

 

 

Jean-Baptiste ha scritto:
Hi,
 
I hope this could help someone or provide a good starting point.  No problem to publish this work (but it's beta for the moment) with my name and company, but please (at least for the moment) keep my email hidden.
 
Here you'll find:
  • the SQL query needed to create classes and domains for TOGAF
  • some help to create a menu giving access to classes
 
Some explanations:
  • All classes (including domaines and attributes) have been created using the official TOGAF content metamodel
  • As someone may want to extend this model, in fact each TOGAF class is in fact a super class. So I've create real classes to allow the creation of some cards for testing purpose.
  • My recommandation: you can extend this model by creating classes, but don't changes those already created. This will ease migration to futur releases.
  • This should be considered a beta version: I still have to create extensions (read TOGAF for more information, and see below "roadmap") as I will need them in the near futur.
  • I've followed this naming convention:
    • all classes and domains start with togaf_xxx where xxx is the name of the extension (in this case 'core')
    • the "final" classes created to allow card creation is an instance and so ends with "_i"
    • all domains are in the form "togaf_extension_source_relation_target" where relation is the name of the ArchiMate relation that best match.
 
The primary purpose of TOGAF is Enterprise Architecture, and this kind of usage if perfect with CMDBuild. But this model can also be used as a starting point for a CMDB: in this case tou have to extend it this way (it's on my roadmap):
  • Technology equipments (computer, server, network equipments...) will be derived from "Physical Technology Component"
  • Software (not directly used by business people) will be derived from "Physical Technology Component"
  • Application (software used by business people) will be derived from 'Logical Application Component"
And here is my (sort of) roadmap:
  • create togaf extensions (governance, services, process modelling, data, infrastructure consolidation and motivation)
  • create an ArchiMate extension to allow some concepts and relations not already present in TOGAF (if needed)
  • create some standard reports (ie: artifact in TOGAF)
 
Regards,
 
SARRODIE Jean-Baptiste
IT Architect for Lafarge France
 
PS: I've just seen that lookup values are missing, I will update quickly.
 
Tecnoteca ha scritto:

First of all thanks for your opinion on CMDBuild project, we're glad our software is useful for your company!

We know little about the TOGAF framework, but in these days we received two proposals for the integration of TOGAF and CMDBuild; this certainly indicates we need to know more about this type of solution.

Therefore, we're happy to accept your contribution and we'll publish it on the project site!

Please tell us how to publish your contacts and whether to publish your email or suggest our support (if someone asks for details about your scripts).

 

 

#5
Hi,
 
You can find the last version here. 
 
Regards,
 
Jean-Baptiste Sarrodie
 
Bruce Kissinger ha scritto:

Jean-Baptiste,

 

Thank you for sharing.  I am very interested in this, but when I run the script I get a number of different errors.  Here is an example:

 

CREATE TABLE togaf_core_role (

    "FTE" double precision

)

INHERITS (togaf);

 

The togaf table does not exist in the script, so this CREATE TABLE statement fails. 

I believe that the root cause of the problem is that the pg_dump command only includes tables with the pattern "*togaf_core*" so it did not dump the "togaf" table.

 

Is it possible for you to recreate the script?

 

Bruce

Kissinger