Folder structure and authorization mirroring from enterprise resource planning systems to document management systems

摘要

A system and accompanying method adapted to facilitate folder structure and authorization mirroring between a Document management System (DMS) and an Enterprise Resource Planning (ERP). An example method includes providing a first user option to view a representation of a database structure of a database application of an ERP system; displaying a second user option to select a portion of the representation of the database structure; and offering a third user option to create a folder structure for a Document Management System (DMS) based on the selected portion of the representation of the database structure. In a more specific embodiment, the method further includes providing a fourth user option to adjust permissions for users to access one or more folders of the folder structure based on permissions associated with a database object of the database structure. The fourth user option includes an option to synchronize one or more permissions and/or grants associated with the selected portion of the representation of the database structure with one or more ACLs associated with one or more folders of the folder structure.

主权项

1. A method performed by one or more processors comprising:
selecting, in response to user input, a root node of a relational database wherein the relational database is included in an Enterprise Resource Planning (ERP) application; showing, using the one or more processors, the root node and one or more child nodes in a first window of a user interface, with a hierarchical structure of the root node and the one or more child nodes determined by one or more foreign keys; displaying, in the first window of the user interface and using the one or more processors, selection control areas adjacent to the root node and the one or more child nodes to allow selection of nodes to be included in a proposed hierarchical folder structure; adjusting, in response to user input and using the one or more processors, permissions for users to access one or more folders of the proposed hierarchical folder structure based on permissions associated with a database object of the relational database; synchronizing, using the one or more processors, one or more permissions and/or grants associated with the root node and one or more child nodes with one or more Access Control Lists (ACLs) associated with one or more folders of the proposed hierarchical folder structure; and showing using the one or more processors, the proposed hierarchical folder structure for a Document Management System (DMS) in a second window of the user interface, with folders in the hierarchical folder structure having names and child/parent relationships mirroring the hierarchical structure of the root node and the one or more child nodes.