Convert Erwin model into CSV for Import into Collibra Conceptual/Logical model

Hey, I’ve been investigating the easiest way for a data architect to get an Erwin model into the Data Catalog without having to type everything in by hand.
I discovered there is a Erwin Query you run against the current model and save the results to a CSV file. Just go to Tools -> Query Tools. Its not the best editor, but it does the job.

Here is an example of the query you can do in Erwin.

SELECT TRAN(E.NAME) AS ‘Full Name’,
‘Candidate’ AS ‘Status’,
‘Data Domain’ AS ‘Asset Type’,
TRAN(E.DEFINITION) as ‘Description’,
‘Conceptual Weather Model’ as ‘Domain’,
‘DataCat Onboarding’ as ‘Community’,
TRAN(A.NAME) AS ‘groups [Business Asset] > Full Name’,
‘Data Concept’ as ‘groups [Business Asset] > Asset Type’,
‘DataCat Onboarding’ as ‘groups [Business Asset] > Community’,
‘Business Dimensions’ as ‘groups [Business Asset] > Domain Type’,
‘Conceptual Weather Model’ as ‘groups [Business Asset] > Domain’
FROM M0.ENTITY E INNER JOIN M0.ATTRIBUTE A
ON E.ID@ = A.OWNER@
ORDER BY 1, 2

You just need to change the Community name and the Domain names in the query so it goes to the correct place.
To get the attributes you have to union another Select on to this one.
Just match the column names to your Import View for your Domain.

I hope this helps the community.

davidbotzenhart

Posted 4 years ago · Edited 1 year ago·Last reply 4 years ago

2 comments

Alexandra Jorgenson

Admin4 years ago · Edited

Yes @david.botzenhart.duke-energy.com, thanks so much for sharing. Any suggestions for tags I can add to this solution post so it shows for appropriate search queries?

arthurburkhardt

·4 years ago · Edited

Thanks for sharing, that’s really nice!