Command-Line Utility for SQL Modeler to JSON (ODM)

A standalone Command-line Utility transformsqlmodel.sh is provided that can run on Lower Environments to generate JSON (ODM) files from the SQL Modeler Files. This Utility does not have any dependency on OFSAA. It is available in the $FIC_HOME/utility directory. You can copy the Utility to any machine and run it.

To run the Utility from the Console, follow these steps:

1. Navigate to the $FIC_HOME/utility/TransformSQLModel/bin directory (or the directory where the Utility exists).
2. Execute transformsqlmodel.sh using the following command:

   transformsqlmodel.sh <sqlXmlPath> <destinationFolder> <modelName>

   • <sqlXmlPath> - The absolute path of the SQL Modeler Files.
   • <destinationFolder> - The destination path to store the output JSON (ODM) files.
   • <modelName> - The name of the Model.

   Output after Running the Utility

   The ODM is generated with the Model Name entered. The ODM has the entity-wise JSONS and a Master XML File, which contains the information about the entity wise JSON.

   For example:

   transformsqlmodel.sh …/erwin/erwinXML/MDL_SQL_MODELER.xml

   …/erwin/erwinXML mdl_name

   Verify the log files located in the $FIC_HOME/utility/TransformSQLModel/logs directory.

   Limitations

   • Supertype-subtype is not supported.
   • Model version has to be added entity-wise as an UDP.
   • Index tablespace is not supported.
   • Logical-table UDPs are not supported.