|
|
|
|
|
|
|
|
|
|
|
|
|
|
ENTERPRISE RESOURCE PLANNING
Integration of Notes and Domino with ERP systems
By Dmitry Irtegov
Lotus Notes and Domino represents the most successful non-relational DBMS (Database Management System) among those offered in the market. This success is ensured by a number of factors, such as record level security, replication, close integration with mailing and Web systems, and integrated infrastructure for using public key and private key encryption and digital signature. Record level security means that each document in the database has its own access control list. It allows for each user to create his own data subset to work with, or even two subsets: the first one could be modified by the user, and the second one could be seen.
Replication means the possibility to synchronize copies of databases located on different servers, or on the server and the client computer. Each field of each document includes a time mark, and the replication is conducted using the last time value. As the replication is carried out at the separate fields level, it allows you to avoid picking out a master replica and other restrictions peculiar to replication in relational databases.
In combination with record level security, replication provides unique flexibility in developing distributed systems, for example, for connecting remote offices and subdivisions in the other cities. Owing to the combination of these features, Lotus Notes enables access to all application functions without connecting to a server. A user makes changes to the local replica of the database and then replicates them to the server, when connection with the server is set. Importantly, even if an outside user finds a way to make changes to the local replica that are not matching up with the application's business logic, it will be impossible for him to replicate those changes to the server, assuming the security was designed properly.
ERP Systems The most successful ERP (Enterprise Resource Planning) systems are developed on top of relational DBMSs, because relational DBMSs are capable of effective processing of complex queries. A typical ERP system, such as SAP/R3, operates through a centralized server and a centralized data warehouse. Access control to this data is centralized as well. An R3 user can see all application data, though his ability to modify the data is restricted by the business logic. As a rule, to divide the whole R3 into several small parts or independent subdivisions without destroying the integrity proves to be a difficult task.
Possible integration scenarios Based on the information above, we could draw a conclusion that Notes and ERP are not competing systems, but rather complementary ones. One of the possible integration strategies could be to use Notes as an environment for collecting and entering data for the ERP system. Primary data entry into the system could represent proposals of subdivisions and even employees, or it could be the reports on current performance.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Advertisement --
Navigate the Document 'SharOllaboraGement' Universe
More than 60% of organizations are dealing with 'Content Chaos' -- Out of control Documents and Content.
Unfortunately, over 50% of those will rush into the wrong solution and ultimately fail.
The Document & Content Management Decision Matrix is a free tool for navigating the broad 'Document Sharing, Collaboration and Management' technology universe.
Use it to help you make the right decision based on your organizational preferences and needs.
Tap to download this complementary tool. |
-- Advertisement --
Write for DominoPower today!
Share your experience and expertise with other Lotus Notes and Domino users, administrators, and developers. DominoPower Magazine has grown nicely and now has new opportunities for contributing authors and editors.
Write about something you're an expert on and get your name in lights.
For Writers' Guidelines and to discuss topics, contact Staff Editor Joe Dolittle. This is your opportunity to shine in front of your peers, your clients, and Lotus.
Click for more info! |
|
|
|
|
|
|
|
|
|
|