In my last blog post I described my new method for building scripts. Well, last week I delivered my first script to a client in France – it’s a script to import source-to-target mappings (otherwise known as Data Lineage) from Excel. The client has been relying on Excel to document the movement of data up to now, and that’s not a very good way of providing real data lineage that you can enquire on. By linking the PDMs together they’ll be able to construct much more effective data lineage in PowerDesigner.
Anyway, the client loved the script, once I’d made a couple of changes to allow for the fact that (unsurprisingly) they’re using the French version of PowerDesigner. Using my model-driven approach, it was simple for me to update the affected components and re-generate the complete script. Voila, as they say in France.