Oracle SQL Developer Data Modeler - for SQL Server

Need to reverse engineer a SQL Server database? Want a relational diagram for AdventureWorks? Oracle SQL Developer Data Modeler can do that.

1. Oracle SQL Developer Data Modeler For SQL Server And Other Fun and FREE Oracle Resources Jeff Smith Senior Principal Product Manager [email protected] @ thatjeffsmith https://www.thatjeffsmith.com

2. Why Model? Top Five Reasons to Model Empowers and safeguards change Communication Method to Gather Requirements Business Rules Validation Target User Involvement Documentation/Training

3. What is SQL Developer Data Modeler? No cost diagramming and data modeling tool Standalone application or available with SQL Developer Business rule and process flow doc & verification Powerful reporting engine DDL script generation

4. Technology and Architecture Java based Metadata stored in XML Files Database support Oracle 9i, 10g, 11g, and 12 c 3 rd party DB: SQL Server, DB2, JDBC ODBC Bridge Platform support Windows Linux OS X Supported Platforms

5. SQL Developer Data Modeler Strategy and Analysis Relational Database Design Data Type Star Schema Physical Multidimensiona l ERD DFD Logical Reporting Import Models Domains

6. Model entities, attributes, relationships, and entity type hierarchies Transform logical to many relational and multi-dimensional models Configurable forward and reverse engineering Logical Modeling Data Model – Entity Relationship Diagram (ERD)

7. Model Cubes, Dimensions, Levels and Hierarchies, Measures and slices Start from ROLAP, XMLA or from scratch Generate Oracle Analytical Workspaces Multidimensional Modeling

8. Model tables, columns and foreign keys Map one logical data model to one or more relational models Configurable forward and reverse engineering Relational Modeling

9. Define multiple physical implementations of a relational model Partitioning Schemes Production vs Test 2012 vs 2008 Define tablespaces, users, stored procedures, privs, etc. Supports storage templates for applying common properties across multiple objects Physical Design Properties Physical Model

10. Automatic or Manual Layouts Configurable Color Schemes Multiple Displays for alternate layouts and visual options SubViews for logical grouping and subsetting objects WYSIWYG PDF/PNG/JPGs Working with Diagrams

11. Getting Started jTDS JDBC Driver (JAR) Configure Connection Reverse Engineer OR Build From Scratch

12. Relational Design Objects Relationships SubViews Physical Tip: Use the Navigator to Find Your Way Around Your Diagrams

13. Properties Dialog Double-Click to Open

14. Right-Click to Preview DDL DDL

15. Reporting – WYSIWYG HTML w/Diagrams

16. Compares Side-by-Side… Model to Model Model to Live Live to Model

17. Version and Control Designs Alter Scripting One or many users supported Pending Changes Incoming Outgoing Side By Side Reporting Commit/Revert changes Versioning & Collaborative Design

18. SQL Developer Data Modeler Today Tomorrow: Data Modeler in the Cloud Better Reporting Faster Data Dictionary Imports Easier Versioning

19. SQL Developer Data Modeler on Oracle Technology Network (OTN) Oracle Learning Library Forums More Info

20. More Fun and FREE Stuff VirtualBox VMs with Oracle stuff already going Visual Studio for Oracle LiveSQL ~ SQL Fiddle, but Better Coming Soon a Free Cloud DB Service

21. VirtualBox Database Tools Web Apps Hands-on-Labs