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
Question
Geodatabase Database Diagram
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
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
+9- Safer
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
+10Hi @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
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.