Pimping SQL Developer and Data Modeler

Pimping SQL Developer and Data Modeler

• 2.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Extending ( pimping ) SQL Developer and Data Modeler Kris Rice Kris.rice@oracle.com || @krisrice Senior Director of Development Database Development Tools Group Oracle Confidential – Internal/Restricted/Highly Restricted
• 3.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Agenda  Simple and Easy changes  Custom xml  N Level reporting  Actionable Reports  Data Modeler and Javascript
• 4.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Preferences Linkable sql results • Fonts, Colors, Gutters, Look and Feel, Colored highlighting, Tab Spacing, Blink Rates, Insight timings, …
• 5.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Grid Enhancements Linkable sql results • Link sql results to other objects • Link to source code with line numbers
• 6.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | XML Based Enhancements • If you can write xml, you can enhance the tool. • Many places in SQL Developer can be modified with xml • Documented XML Schemas are provided on OTN
• 7.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Customize Menus • Customize with xml – Tree Navigation – Editors – Menu Actions • Shared from a central file server or host on a webserver
• 8.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Substititions from Dialogs • replace #0# with value • replace #"0"# with ,"value" • replace #,0# with ,value when not null and nothing when null • replace #,"0"# with ,"value" when not null and nothing when null • replace #esc(0)# with value with sql escaped chars
• 9.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Advanced Reports • Version aware reports • Access specific sql • Nested Reports • Actions on Rows
• 10.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Modeler Transformations • Interact with the model programmatically • Javascript included within the JDK • Multiple languages to choose from with JSR223
• 11.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Modeler Transformations • Interact with the model programmatically • Javascript included within the JDK • Multiple languages to choose from with JSR223
• 12.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Java Extensions • Built from jDeveloper SDK – http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index- 091862.html • Soon to be publishing a jumpstart extension
• 13.
  Copyright © 2014Oracle and/or its affiliates. All rights reserved. | 3rd Party Extensions • DBmaestro – http://www.dbmaestro.com/ – http://www.dbmaestro.com/products-solutions/dbmaestro-teamwork-features/ • Fourth Elephant – http://www.fourthelephant.com/insider/demo/ • Keep Alive – https://bitbucket.org/scristalli/sql-developer-4-keepalive