Part two of Peter Spielvogel's post on using Ipedo with external modeling tools. Peter is Ipedo’s Director of Product Marketing - S.P.
In my last post, I discussed how to use a data modeling tool such as such as CA ERwin, Embarcadero ER/Studio, or IBM Rational Rose to build virtual tables in Ipedo.
Another situation that customers ask about is how to share the views they build in Ipedo with other architects that need to understand the relationship among tables and how disparate data sources are joined to one another.
Again, my colleague, Jamie Wang, Ipedo’s Director of Engineering, identified this straightforward process and trained me how to do it.
In this case too, Ipedo’s ability to behave like a relational database allows data modeling tools to reverse engineer the schema objects and relationships among them. Let’s see how this works.
For the purpose of this example, we have created a data model in Ipedo joining some human resources tables. The Ipedo Administrator console appears below.
Next, open your modeling software. In this case, we are using CA ERwin. Select the option to Reverse Engineer a database.
Select the options and which driver to use. We’ll choose to reverse engineer Ipedo’s Logical/Physical model and use the generic ODBC driver.
Choose what information from the database (Ipedo in this case) you want to extract. Since our interest is in reusing the view (model) we built in Ipedo, we want ERwin to reverse engineer everything - tables, column names, primary and foreign key relationships, etc.
