Search DominoPower's 11,964 Lotus-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
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.


1  ·  2  ·  Next »
Other articles you might like
Home > Strategies > Interoperability (15 articles)
   A Sametime plugin for Trillian
   Integrating Twitter with an IBM internal social network
   Fun with Sametime and Skype
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent DominoPower Articles
It's time for Lotus to double-down on Linux and open source
Back to basics with Notes: what you can do now
Back to basics with Notes: what are the basics?
Back to basics with Notes
Smart Upgrade bug in Domino 8.5.1 (and some work-around tips)
Hands-on with XPages and the Lotus Solutions Catalog
A tool for migrating Exchange to Domino
Latest Lotus Headlines
IBM Lotus Quickr for WebSphere Portal 8.5 - Various Notes on Administration
Attachment Viewer on Steroids
Admin tip: Predictor, a pregnancy test for your Domino server
Lotus Traveler Webinar
Domino 8.5.1 mail routing problem solved
A small tip for upgrading your XPages apps from 8.5.1 to 8.5.2
What is in your plugin_customization.ini?
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Smartphone smarts for a mobile world
David Gewirtz Online: CNN commentary and analysis
OutlookPower: The strange case of Outlook losing notes and requiring passwords
-- 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!

ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Editor's Login