11-18-2020 08:28 AM
Is there any way we can get a copy of the full ERD of the OnBase database? I know the Reporting Guide has the common tables, but I'd really be interested in seeing the full ERD for all database tables
11-18-2020 09:53 AM
Simply put on this one
With that being said, I think it might be a fun community project that some of us could go in on together and do our own version of course. 😉
11-23-2020 03:14 PM
I'm sure a full ERD is propriety. I know if I had designed a product, it would be. Also, don't get distracted, you don't need a full ERD - unless you are using each and every module that Hyland has designed. You don't even need an updated Reporting Guide.
You just need access to the DB, so you can query the table(s) and see the structure for yourself. Hyland provided the starting table names you'll need in the guide. Then update and create your own guide, with only the tables you use. I don't even need half of what is in the report guide. Also, only newbs wait on vendors, especially for something they can do themselves. That's how you get experience, by not waiting.
Just make sure you are using a test DB (copy of prod - daily or weekly) and never do anything in prod. Have fun, query, query and keep querying. You'll get there.
11-24-2020 07:05 AM
Thanks Tom... I'd still be interested in seeing a layout of how it all connects. I do what I need ahead of time and if I need to figure it out immediately I spend time to do so.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.