File Library

Oracle SQL Developer Data Modeler (SDDM) has been around for a few years now and is up to version 3.x. It really is an industrial strength data modeling tool that can be used for any data modeling task you need to tackle. Over the years I have found quite a few features and utilities in the tool that I rely on to make me more efficient (and agile) in developing my models. This presentation will demonstrate at least 10 of these features, tips, and tricks for you. I will walk through things like installing the reporting repository, building a custom report on the repository using Oracle SQL Developer, modifying the delivered reporting templates, how (and when) to use the abbreviations utility, how to create and applying object naming templates, how to use a table template and transformation script to add audit columns to every table, how to add custom design rules for model quality checks (heck how to use the built in quality checks), and several other cool things you might not know are there. Since there will likely be patches and new releases before the conference, there is a good chance there will be some new things for me to show you as well. This might be a bit of a whirlwind demo, so get SDDM installed on your device and bring it to the session so you can follow along.