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?
I can share with you a macro which exports XML or JSON if you want to.
The issue is that CSV cannot naturally represent hierarchical or object-oriented data. This is because every CSV record is expected to have the same structure. (wikipedia)
Let me know about the macro.
You can also give a try to the macro: Export Model Meta Data to Excel: Exports model meta data for the active model to Excel.
Yes, understood :) I should have been clearer, here are two main use cases:
1. CSV/Excel - an export of the data dictionary with just the essentials. Table name, columns, type, nullability, PK/FK, description, sequence, etc. This is basically for human consumption - something we could provide to our customers, etc.
2. Use the data model data to drive downstream applications - we need to read the data model to drive downstream processes. E.g., we could have an application that reads the data dictionary from the data model and translate this to avro schemas for kafka, or could just be into a json for other applications to use to validate data, etc... so a json format export from Idera ER would actually be very good for this.
I think the latest screenshot I shared is doing something similar to what you search.
Anyway, here is the JSON macro I wrote which can be updated to add/remove the data you need: wJSON.zip
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.
Powered by IDERA