Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle SQL Developer PowerPoint Presentation
Download Presentation
Oracle SQL Developer

Oracle SQL Developer

243 Views Download Presentation
Download Presentation

Oracle SQL Developer

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Oracle SQL Developer What’s New in Version 4.1 Jeff Smith Jeff.d.smith@oracle.com || @thatjeffsmith Senior Principal Product Manager Database Development Tools Group Oracle Confidential – Internal/Restricted/Highly Restricted

  2. Agenda • 4.0.3 Updates • What version 4.1 could look like Improve application developers experience

  3. Oracle SQL Developer FREEOracle Database IDE/GUI Windows, OS X, *NIX More than 3,600,000 users worldwide My Oracle Support available via your DB license

  4. SQL Developer Data ModelerIncluded for free, also available as a separate download/program Strategy and Analysis Import Models Data Type Domains DFD ERD Multidimensional Logical Reporting Database Design Physical Star Schema Relational

  5. Project Raptor (2005) ~ Oracle SQL Developer v1.0 (2006) Version 1.5 (2008) Version 2.1 (2009) Version 3.0 (2011) Version 3.1, 3.2 (2012) Version 4.0 (2013) Version 4.0.3 (September 2014) Release History

  6. A Few Quick Notes on 4.0.3 • Primarily bug fixes • Support for Big Data Appliance (NoSQL) • SSH Tunnel Support for Oracle Connections

  7. Hive Connections Setting Up Connections to Hive

  8. Hive ConnectionsSQL Developer Data Modeler Supported Too! • Connect/Reverse Engineer • Design Hive Tables • Generate DDL

  9. SSH Tunneling • Integrated SSH support • Establish tunnel to machine that can talk to your database listener • User/PWD or SSH Keys

  10. Ok, let’s get to the GOOD STUFF

  11. Version 4.1 • Version 4.1 is in dev • Soon to be released as an Early Adopter • Yes, this is a tease • Stop by our Demo Pod, let us know what you think!

  12. Make Existing Stuff Better – Block text editing

  13. Preview data as you define column mappings Bad data highlighted Dates have a few pre-defined date formats to choose from – try to default to best match Make Existing Stuff Better – TABLE IMPORTs

  14. Make Existing Stuff Better – TABLE IMPORTs • Save your imports to run again later • And if you need to make this a repeatable process…

  15. Make Existing Stuff Better – TABLE IMPORTs Excel, delimited text imports – now scriptable via Command-Line Interface (sdcli)

  16. Make Existing Stuff Better – Code Insight Support for new database feature, SQL Text Expansion

  17. Brand New Stuff – SQL Logger • Captures all statements sent to the database • Extremely lightweight • Captures statement, parameters, and elapsed time

  18. Brand New Stuff – Instance Viewer • Visual overview of your current database status • No server side objects • No agents to install or manage • See problem, click on problem, resolve problem

  19. Brand New Stuff – Instance Viewer • Click, drill down into details screens • Control refresh rates for each metric • Built by our own database experts – what you NEED to see • Powered by Java FX, Java 8

  20. We release Oracle Database version 5 The client-server model is born And a little program makes it debut…with roots going back to 1982 Time to turn back the clock a bit…to 1985

  21. Wait, why is the SQL Developer guy talking about SQL*Plus? Statement completion?

  22. SQL History?

  23. New CommandsBuild your own?

  24. Oracle SQL Developer Data Modeler 4.1

  25. Brand Your Models Insert your corp. logoor any picture toyour diagrams

  26. Support for Constraints on Views Tables to Views Wizard, new option – create constraints

  27. Support for Constraints on Views

  28. Custom DDL Generation via Transformation Scripts • Dynamically generate DDL to prefix/append your objects, or replace entirely • Example: immediately after generating Table Creates, add journaling tables

  29. Versioning Status Indicators in the Design Tree

  30. And much, much more Watch out for 4.1 updates on OTN