Another guest post, this time by Peter Spielvogel, Director of Product Marketing - S.P.
We have recently been getting inquiries from customers about integrating Ipedo with their enterprise modeling tools such as CA ERwin, Embarcadero ER/Studio, or IBM Rational Rose.
I will deal with the other direction (build bottom-up model in Ipedo and then move into modeling tool for sharing and reuse) in a separate blog.
Thanks to Jamie Wang, Ipedo’s Director of Engineering, for figuring out the process and training me in how to use the modeling tools and connect the models to Ipedo.
The process was surprisingly simple. The key is that Ipedo looks, acts, and talks like a relational database, which is what these modeling tools are accustomed to connecting with. I’ll run through the steps below.
First, build a model in your modeling tool. In this case, we used CA ERwin.
Choose the Forward Engineer/Schema Generation option from the Tools menu.
For Ipedo, use the ODBC/Generic driver, version 3.0.
Enter your user name and password to access the Ipedo server.
Choose what options you want to build in Ipedo: Schemas, Tables, Columns, and Indexes.
Customize the DDL script that the modeling tool generates so it generates virtual tables in Ipedo rather than the physical tables it usually builds in a relational database.
Open Ipedo and see all the tables you modeled in ERwin. Even though the tables may have originated in different databases, they are now available to build Views that combine their information along with Web Services, spreadsheets, or other information sources. That’s the beauty of EII.
Yes, it really is that easy.
