Are you migrating data models from SAP PowerDesigner to Idera ER/Studio Data Architect? You’ll soon find that the standard PowerDesigner LDM import in ER/Studio doesn’t convert everything properly. For example, some data types aren’t converted in the way I would like them to be converted.
I came across this issue when I imported the FIB-DM model (in PowerDesigner format) to ER/Studio. I could manually update the incorrect data types, or write a macro to do it. The macro would need to know which data types to fix, based on knowledge of the data types in the original PowerDesigner model.
I didn’t want to hard-code the attribute names in a macro, instead I’ve used the template language within PowerDesigner to generate a macro to update the exact objects that I know there will be problems with.
If you’re converting any PowerDesigner models to ER/Studio, you’ll come across the same issues as I did, so take a look at what I’m doing –
Generating a macro to update an ER/Studio model from a #PowerDesigner model
