The free version of the Financial Industry Business Data Model has been downloaded many times – it’s managed using the SAP PowerDesigner modelling tool, and users of other data modelling tools need to import the PowerDesigner Logical Data Model that is supplied. There are two concerns here:
FIB-DM is a very big model with some deep super/subtype hierarchies
even if your tool can import a PowerDesigner model, the chances are that the import doesn’t work perfectly
If your tool of choice is Idera ER/Studio Data Architect, you can use the built-in metadata import feature to import the PowerDesigner model, but I know that you won’t be happy with the result, so I’ve converted the model for you.
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 –