idea Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling in Data Management Ideas

Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

PeterFitts — Thu, 29 Sep 2022 22:26:25 GMT

In previous versions ESRI supported Visio or Rational Rose as a CASE tool for Geodatabase modeling. These CASE tools can be cumbersome to use or expensive. We are seeing more and more that Enterprise Architect (http://www.sparxsystems.com.au/products/ea/8/index.html) is the CASE tool of choice in projects where data model documentation is required, but without Geodatabase integration it is difficult to use for data model development.

Enterprise Architect is relatively inexpensive CASE tool when compared to Rational Rose, and it performs significantly better than Visio. Having the Geodatabase types integrated into EA, similiar to how they are in Visio and Rational Rose would provide a robust CASE tool for Geodatabase development that does not require an ESRI CASE tool to be developed, and it would satisfy the user community that has requirements for data model documentation.

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

MarceloMarques — Thu, 29 Jul 2010 18:06:19 GMT

The CASE tool needs to support annotations, feature linked anno, dimensions, etc, things that the Visio CASE tool always lacked.

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

MarceloMarques — Thu, 29 Jul 2010 18:08:42 GMT

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

MarceloMarques — Tue, 22 Jun 2021 08:07:07 GMT

https://community.esri.com/ideas/1802

Merge GDBT, MXDPERFSTAT, GDBDesigner, GDBDiagrammer, GDBReporter into ONE extension

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

danan — Tue, 22 Jun 2021 08:07:10 GMT

Agreed, but why limit things to one tool? The XML Schema of the Geodatabase seems to contain everything one needs to create a UML Profile of the Geodatabase. If interested, please vote on this idea:

https://community.esri.com/ideas/2720

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

danan — Tue, 22 Jun 2021 08:07:13 GMT

For what it's worth Esri Professional Services (EPS), the consulting arm of Esri, seems to use Enterprise Architect already. So your idea makse great sense. Certainly, Sparx Systems likes to showcase that Esri users EA, e.g.:

http://www.sparxsystems.com.au/downloads/pdf/esri_lbs_delivery_case_study.pdf

And here's the UML Profile of the Geodatabase idea link, active this time:
https://community.esri.com/ideas/2720

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

juliaharrell — Wed, 03 Nov 2010 23:05:23 GMT

EA is a great choice, but this one already has support for spatial features and works with both Oracle 10g Locator and PostGIS. Maybe esri should provide support for both.

http://geomaticblog.net/2010/08/31/moskittgeo-from-uml-to-spatial-databases-and-back/

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

PeterFitts — Mon, 18 Jul 2011 00:06:07 GMT

Good news! This was recently announced:

http://community.sparxsystems.com/news/110711/sparx-systems-releases-arcgis-uml-profile
http://www.sparxsystems.com/enterprise_architect_user_guide/9.0/domain_based_models/about_arcgis.html

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

danan — Sat, 27 Aug 2011 17:08:33 GMT

@pfitts, this is indeed good news. Sparx Systems would like user feedback on its ArcGIS UML Profile. Please see the response from Ben @ Sparx Systems on the following support forum thread:

http://forums.arcgis.com/threads/14543-Is-it-possible-create-annotation-feature-class-with-Case-tool

Dana Nibby
GIS for DBAs. Database Concepts for GIS
http://spatialdba.com

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

Anonymous User — Fri, 18 Nov 2011 18:13:36 GMT

Hi Everyone,

Thank you for you feedback on this Idea. We have currently moved this to Under Consideration for a future release.

Regards,

Despina

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

JuanBohorquez1 — Mon, 28 Nov 2011 15:29:41 GMT

Additionally, to model all the elements within the CASE Geodatabase, for example, Topology Rule, Mosaic Dataset, Raster, Spatial references, adn others.

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

danan — Fri, 20 Jan 2012 21:55:07 GMT

Sparx Systems may be releasing a non-beta version of its ArcGIS profile (a UML profile of the geodatabase) to coincide with the official release of ArcGIS 10.1. So stay tuned:

http://www.sparxsystems.com/arcgis

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

LorneDmitruk4 — Tue, 30 Oct 2012 21:55:36 GMT

It would also be nice to be able to incorporate incremental updates using the import wokspace document.

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

PeterVeenstra — Thu, 02 May 2013 20:50:54 GMT

ldmitruk has the right of it. EA is great. Sparx are great folks and are willing to work with the ESRI community. But until the XML Workspace Import functionality supports incremental schema updates then this solution won't work well. EA can build a schema fast and easy. It is a great tool to work with and there is a rich set of functionality. Need the incremental schema update.

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

PeterVeenstra — Tue, 22 Jun 2021 08:07:16 GMT

Business Case
Currently the XML Import Tool will create a new geodatabase. There is no methodology for ‘updating’ the schema for an existing Geodatabase. Sparx Systems Enterprise Architect is an excellent UML modeling tool that generates ESRI format ‘XML Workspace’ document. There is the need to incrementally update the existing Geodatabase with changes to the schema as modeled by Enterprise Architect. The existing VISIO XMI Case Tool Import wizard does this. As changes are located between the input XML (or previous the XMI) and the existing Geodatabase then these were highlighted in the interface to allow the user to accept them or not. Present the user with a listing of potential changes.

Changes could be additions of feature data sets, feature classes, tables, fields, domain values, relationships classes. Deletions could be for/from the same list. Updates are trickier but could involve changing field types for attributes. I would treat them like a standard geodatabase edit – delete/add. Delete the old and replace with the new. But do not delete tables with data in them.

The more I noodle around with this in my head I think I need to be a little more specific on what we need here. But this is a start. Again, let me know if there is any other steps I need to take.

Peter

https://community.esri.com/ideas/2720
(I tied this one to “Integrate with Sparx Systems Enterprise Architect CASE Tool for Geodatabase modeling” for lack of a better alternative.)

Re: Integrate with Sparx Systems Enterprise Architect CASE tool for Geodatabase modeling

DavidColey — Mon, 30 Jun 2014 18:51:15 GMT

What about for encoding geodatabase behaviors such as ID generation or auto-generating related geometries such that the behavior is independent of geodatabase type. Much like the old CASE-Visual C++ tutorials