How to import data models
Importing information into Oracle SQL Data Modeler allows you to adopt the definitions of the source tables and attributes. In the previous chapters, we have followed a top-down approach to building the data model; the capability to import tables enables the bottom-up approach to be included into the design of the data model.
Getting ready
Get the necessary connection details for the source environments in order to reverse engineer the necessary information. For this recipe, we will be using the HR sample schema from Oracle. If you wish to use the same example, ensure this is installed in your database.
How to do it...
Importing data models from the database saves vast amounts of time and errors. It can be done as follows: ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
