Author Topic: QEA and QEAX have new Repository.databaseType  (Read 3949 times)

Ian Mitchell

  • EA User
  • **
  • Posts: 506
  • Karma: +22/-4
  • The eaDocX and Model Expert guy
    • View Profile
QEA and QEAX have new Repository.databaseType
« on: January 06, 2022, 01:20:15 am »
Those who are looking at using the new QEA and QEAX databases for their repository, please note that there is a new 'RepositoryType' called "SL3" .
@Sparx please can this be added to the enum list of repository types in the automation documentation:
(V 15.2 version is at https://www.sparxsystems.com/enterprise_architect_user_guide/15.2/automation/repository3.html)

For naughty people who run SQL against the EA repository...
It looks like this repository type seems to behave in the same way as PostGreSQL, from the point of view of modifying the SQL: columns names come back in mixed-case.
Ian Mitchell, Designer, eaDocX


www.eaDocX.com
www.theartfulmodeller.com

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1324
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: QEA and QEAX have new Repository.databaseType
« Reply #1 on: January 06, 2022, 06:48:54 am »
Those who are looking at using the new QEA and QEAX databases for their repository, please note that there is a new 'RepositoryType' called "SL3" .
@Sparx please can this be added to the enum list of repository types in the automation documentation:
(V 15.2 version is at https://www.sparxsystems.com/enterprise_architect_user_guide/15.2/automation/repository3.html)
QEA and QEAX are new in V16.0 so perhaps you should reference version 16 help.
https://www.sparxsystems.com/enterprise_architect_user_guide/16.0/simulation___execution/repository3.html
It looks they have SQLLite mentioned in ConnectionString but not 'RepositoryType' so well spotted.

For naughty people who run SQL against the EA repository...
It looks like this repository type seems to behave in the same way as PostGreSQL, from the point of view of modifying the SQL: columns names come back in mixed-case.
Awe that's a bit harsh labelling them at "naughty". Thanks for the heads up though.

Happy new year. Lets hope its better than last year.
« Last Edit: January 06, 2022, 07:08:46 am by Sunshine »
Happy to help
:)