I'm looking for a tool to assist with the creation of databases diagrams for an enterprise geodatabase. Essentially, I would like to create a table with: field names, data types and length (domains would be nice but not necessary). It looks like Scheme Reader (from table) should allow me to do this but I haven't been able to figure it out. Is anyone able to provide an example? ESRI use to have a tool to do this but it no longer works with 10.5+. Documenting your geodatabase design
Page 1 / 1
You can also use the reader for the underlying database.
For example: If the database is Oracle, you can use the Oracle Non Spatial reader to collect all required information from the USER_TAB_COLUMNS or ALL_TAB_COLUMNS view in the database.
That view contains TABLE_NAME, COLUMN_NAME and DATA_TYPE.
See this link: ALL_TAB_COLUMNS
Hi @dos_gis, thanks for your question!
I admit I didn't know the answer to this and went for the Schema Reader (from table) as my first attempt as well. Unfortunately the name is confusing - this reader would be used to read a table that already contains the database diagram you wish to create. Instead, look at the Schema Reader (Any Format). You can read schemas from ESRI formats here, including File Geodatabases. You should be able to get domains through as well, with an extra parameter setting in the reader.
Option 2 is to use a FeatureReader and look at the output from the Schema port. This is essentially the same functionality.
Hope this gets you started on the right track!
Best,
Nathan
Hi @dos_gis,
I have done something that is, I guess, the other way around. I created an Excel-template that can be filled and using FME with PythonCallers, I can automatically build the database. It has support for tables, geometries, coordinate reference systems and domains. I am still working on support for subtypes, but that is work-in-progress.
If that is what you are looking for, please let me know. I might be able to share it.
Hi @dos_gis,
I have done something that is, I guess, the other way around. I created an Excel-template that can be filled and using FME with PythonCallers, I can automatically build the database. It has support for tables, geometries, coordinate reference systems and domains. I am still working on support for subtypes, but that is work-in-progress.
If that is what you are looking for, please let me know. I might be able to share it.
Hi, I needed something similar and I managed to solve it without using python... I published my workspace here: https://community.safe.com/s/question/0D54Q000080jXc2SAE/excel-to-schema-geodatabase