Is there an option to export out the data dictionary as a csv/xls?
I'd like to get every single table and columns into this data dictionary with the field specs, descriptions, etc.
You can use a MetaWizard Export Bridge: Metadata Excel Format
Is there a more simplified version of the export? Maybe a CSV with just table names, column names, types and nullability?
And is there something that can be done via command line?
We are trying to get the model information out to a format that downstream processes can read from and use. Could be for applications downstream to read and convert to avro schemas for kafka, etc..
Is there a good way of getting the model data out?
The macro called "Export Meta Data to Excel Version 2.1" might be a good one to try, as it is configurable. It may already have all the elements you want.
spfister I am getting "ActiveX Automation: server could not be found" error when running that.
You probably don't have Excel installed in the machine.
Here is another macro which exports some of the data you want: wExportAllMetaDataCSV.zip
You can edit it to add the properties you need and not currently present.
William W. this is a great macro. I want to add the view as well as table DDL to the result. How can I do that?
You can edit the macro & update it to achieve what you need.
Line 177, you can see a loop which iterates with all the entities. To do the same, with Views, you'd also need a loop with the Views.
Look for Views & View in the Automation Interface Reference:
The DDL for a table is available with the property TableDDL of an Entity:
Powered by IDERA