We are working with databases that are not natively supported in Sparx 14 (e.g., SAP Hana). A current shortcoming is that the "data type mapping" feature (to express equivalency of data types from one platform to another) does not work with databases that you have added yourself. I've confirmed this "bug" with Sparx Support.
Currently when you change the "database" of a table element from one platform to your own custom version, Sparx either maps everything to "varchar" or in the case of going from one custom DB to another custom DB, you lose the datatype and length/precision specifications.
To compensate, I wanted to write my own script to "convert table from database platform x to database platform y", however, I can't seem to find where the "Database" property is exposed in the EA Object Model.
Does anyone have a sample script to manipulate the extended properties associated with EA's data modeling extension (e.g., Database Platform)?