Author Topic: v15.2 - DB Builder to support databases later than 2012...  (Read 2261 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 7911
  • Karma: +205/-124
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
v15.2 - DB Builder to support databases later than 2012...
« on: November 09, 2020, 03:29:09 pm »
We're seriously looking into how to use DB Builder to model what we ACTUALLY see in our DB environment.  In particular, once we've done the first reverse engineer, can we maintain the model using Sparx as the real database evolves?  (Especially under our requirement of supporting the DB R_E while allowing us to overload the rendering?)

Our standard DB is SQL Server 2017.  We see in the list of DDL products the latest version that is supported is SQL Server 2012.

No problem we think! We can create a DDL set of datatypes for SQL Server 2017 by cloning the 2012 set and making any required adjustments.  However, as with the other parts of the DB R-E, things seem to be hardcoded.  If we change the DB from SQL Server 2012 to SQL Server 2017, the datatype of the column is NULLed (even though we have provided a set).  Changing from SQL Server 2012 to SQL Server 2008 reveals that the datatypes DO change - presumably under the "invisible hand" of Adam Smith. 

Has anybody managed to create DB models for DB Technologies other/later than those explicitly supported?  Can anyone (Sparxian?) confirm that it is hardcoded?

Do I have to put in a feature request and wait a decade (or more) to get today's set of DB technologies included?

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Richard Freggi

  • EA User
  • **
  • Posts: 351
  • Karma: +13/-7
    • View Profile
Re: v15.2 - DB Builder to support databases later than 2012...
« Reply #1 on: November 09, 2020, 09:08:53 pm »
My opinion is that EA is a bit of a stretch to model database schemas.  If you are working on the schema specifically, have you taken a look at DBeaver?  Great connectivity, open source, easy to use, great ergonomics.  It's not a great database DESIGN tool but it's an excellent database DOCUMENTAION tool.  For serious design at enterprise level you will need to cough up money for a leading data modeling tool.

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 7911
  • Karma: +205/-124
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: v15.2 - DB Builder to support databases later than 2012...
« Reply #2 on: November 09, 2020, 11:09:29 pm »
My opinion is that EA is a bit of a stretch to model database schemas.  If you are working on the schema specifically, have you taken a look at DBeaver?  Great connectivity, open-source, easy to use, great ergonomics.  It's not a great database DESIGN tool but it's an excellent database DOCUMENTATION tool.  For serious design at enterprise level, you will need to cough up money for a leading data modelling tool.
Thanks, Richard,
I've used many significant DB Modelling tools in the past.  We're not after a "heavy lifting" tool for this requirement.  The ability to link the R-E'd artifacts with the rest of the "Digital Twin" is what is more important for us.  We're NOT designing many DBs, we just want to know what they look like.  Most are application DBs which we want to understand.

As usual, it's an EAUI thing.  As I said, we thought it'd be easy, but it isn't!

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 7911
  • Karma: +205/-124
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: v15.2 - DB Builder to support databases later than 2012...
« Reply #3 on: November 16, 2020, 04:47:39 pm »
[BUMP]

Can anyone confirm or deny the DB types and versions are hard-coded?

Paolo
« Last Edit: November 16, 2020, 04:51:29 pm by Paolo F Cantoni »
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Graham_Moir

  • EA User
  • **
  • Posts: 729
  • Karma: +8/-12
    • View Profile
Re: v15.2 - DB Builder to support databases later than 2012...
« Reply #4 on: July 31, 2021, 01:50:23 am »
BUMP !