|
|
|
Junior Member
 
Group: Forum Members
Last Login: 6/10/2008 12:52:43 AM
Posts: 12,
Visits: 2
|
|
Hello,
Is there an easy way to import ERWIN models into Teradata MDS?
Thanks a lot
Calvin
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/19/2008 3:41:51 PM
Posts: 3,
Visits: 10
|
|
Four years later I realize - did you figure out how to get ERwin metadata into MDS? I'm just starting down this path.
- Robert
- Rob
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/2/2008 6:20:26 PM
Posts: 4,
Visits: 9
|
|
ERwin lets you export directly to MDS. ERwin 7 or later has bridges from Meta Integration Technology Inc. (MITI) embedded and provides an export wizard that lets you pick Teradata MDS as the target export.
When you move ERwin model information into MDS you have 2 scenarios. The bridge first looks to see if the physical metadata from ERwin (i.e. tables, columns, views) already exists in MDS:
1) If the answer is yes, the bridge will only export out the logical model ( entities, attributes, etc.) and then associates these to the corresponding warehouse data already loaded in MDS.
2) If the answer is no, the bridge will export both the physical and logical data from the models.
The bridge also allows you to export ERwin modeling information from RDBMS other than Teradata into MDS. So if you have an ERwin model for DB2, SQLServer, etc., you can still export this out into MDS and there will be a field in the Database class that identifies the database type it represents.
|
|
|
|