Now that I have some tables to work with, I'm ready to draw the relationships between them.
I going to add a few more entities before we move on. I've just created my first entity representing my customer table. Now, I'll even add an index for this entity. As I'm making changes to this entity, I can click on SQL Preview to see how Toad data Modeler is forward engineering this particular entity into Oracle. I can specify my keys by clicking on the Keys tab, click Add, and modify my first key. I can also make changes to the data type using this drop down menu. You can see I can quickly add as many columns as I'd like. Then I'm going to click on the Attributes tab to add my column information. I'm going to select Entity, and then click on my workspace. Now I'm going to add an entity to workspace to represent a customer table. I'm going to select Physical Oracle 11 GR2 database. Or, if you need to create a logical model with inheritance, select Logical Data Model. You can later convert a universal model to any other physical model. If you wanted to create a generic, universal model, you can do so by clicking on Universal Data Model. These are the databases Toad Data Modeler would forward engineer your model towards. And you can see the large number of platforms we support for physical modeling. Here, I have Toad Data Modeler open with a sample video rental model.īefore we get to this point, let's start with the basics.
#TOAD DATA MODELER REDSHYIFT HOW TO#
In this video, I'm going to show you how to create your first model with Toad Data Modeler.
My name is Matthew Phan, Systems Consultant for Dell Software.