DA

Hello,

I'm interested in knowing ARIS capabilities regarding to data modeling.

Can someone confirm if it has functionalities for:

- Generate DDL scripts to implement a data model

- Capture an existing physical data model from a database or from DDL script to get it into ARIS

- Compare two data models in ARIS, database, or both

- Provide physical implementation details for different databases, for example storage details for Oracle, PostgreSQL, etc.

- Domain definition: to allow logically name a column data type to reuse it and isolate it from its physical implementation

Thanks!

David

by M. Zschuckelt
Posted on Tue, 10/01/2019 - 15:21

Hi,

- Generate DDL scripts to implement a data model

No, not out of the box.

- Capture an existing physical data model from a database or from DDL script to get it into ARIS

No, not out of the box.

- Compare two data models in ARIS, database, or both

Inside ARIS: yes

Inside a database: No, not out of the box.

- Provide physical implementation details for different databases, for example storage details for Oracle, PostgreSQL, etc.

You may realize this with custom attributes you define yourself. But there are no standard attribute types for this purpose.

- Domain definition: to allow logically name a column data type to reuse it and isolate it from its physical implementation

There are object types you can use for that purpose: Entity type, Enumeration, Enumeration occurrence.

ARIS generally is used for business information models, solution design models. It also has object types for tables and attributes. So you can model down to the physical level. But there is no specific support for certain database vendors' physical models.

ARIS also comes with the UML Designer client and a UML 2.5 profile (separate license for UML designer needed), if that is of any help to you.

As to "No, not out of the box": ARIS is fully programmable in JavaScript and with that you can have access to Java classes as well. But I suppose you are looking for a tool you don't want to develop yourself.

0
by David Alarco Author
Posted on Wed, 10/02/2019 - 10:44

Thank you for your reply, it helps me a lot

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • Profile picture for user freddy
  • Profile picture for user mikhubb
  • Profile picture for user harryratia
  • DC
  • ВА
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock