Lotus Domino: Application Integration – A Programmer View

There are 2 approaches for application assimilation:

oProgrammer’s technique – for applications combination it is needed to create some program codes;

oIntegrator’s approach – in this instance unique software products are to be made use of as well as the combination process set up by those software application setups.
The following tools might be used for the first strategy dominoqq:

oODBC. In Lotus Domino codes might be made use of:

oThree @- features (@DbColumn, @DbLookUp and also), which deal with registrated ODBC-drivers. @DbColumn returns the whole column from outside table, @DbLookUp process search by the key, and @DbCommand runs a command of ODBC-driver or exterior table (for ex-spouse, UDATE or REMOVE);.

oThree inside LotusScript Information Things (LS: DO), which sustain link process, running of SQL-request as well as provide procedures with gotten result table. This tool is much more versatile compared to use of defined above @- features (particularly, purchases mechanism, errors dealing with, etc);.

oFree NotesSQL ® ODBC-driver enables calling Lotus Domino data sources by SQL. This technique is readily available just for easy Lotus Domino databases, as them are not relationship databases as well as SQL is bad to collaborate with (troubles with multiple fields values and also different areas set in documents);.

oJDBC. For straight use JDBC device, complimentary IBM JDBC-driver could be downloaded, which enables calling Lotus Domino databases from Java-applications. This technique is much better then use NotesSQL ® ODBC-driver, but can not be use with complicated data sources. JDBC technology likewise making use of in some combination systems, however JDBC itself is concealed from the designer( as example, utilizing build in JSP Personalized Tag Libraries);.

oOLE. Use this technology is in the Microsoft systems frame. If this limitation is acceptable for a task, then using of this modern technology permits information exchanging from LotusScript to OLE-applications. Specifically it is feasible to export data from Lotus Domino to MS Excel or MS Word. This innovation typically is utilizing to create reports for Lotus Domino data. In Lotus Domino exists Notes/FX device, which implicitly makes use of OLE- innovations. This mechanism enables to refine automatic information exchange in between areas of Lotus Domino types and info mentioned on OLE-server. Lately Notes/FX are made use of in really applications very seldom;.

oXML. Use this modern technology in Lotus Domino R 6 enables handling of Lotus Domino things’ stream transformation (files, design aspects, ACL, and so on) right into XML and also back, apply in a stream XSLT to XML, placed filters on translated/received info, along with testimonial XML by construct in LotusScript-classes, processed DOM and also SAX parsing;.

oHTML. If an HTTP job is started on Domino server, then from outside applications is readily available sending/receiving data by of the very same name method;.

oCORBA. This technology used in Lotus Domino a lot more in Java content. Applets, servlets, Domino JSP Custom-made Tag Libraries, utilizing this modern technology could exchange data with Lotus Domino;.

Apart in integration options line are DECS (Domino Venture Connection Provider), DCR (Data Link Resources) and also LEI (IBM Lotus Business Integrator for Domino) technologies. These technologies other than of coding demand management setups to be tuned and might be refer as to first (developer) as to second (integrator) approaches to integrate applications.

DECS innovation permits straight connection with DB2, Oracle, MS SQL Web server, Sybase resources, and external resources by ODBC and also OLE technologies.

DECS innovation requests of the very same name task on the Domino web server, in addition to some setups in” DECS Manager” data source. Two kinds of records can be produced in this database:.

oConnection, which provides the possibility connecting with an outside system. Without information, let claim that this paper provides the course to outside resource and login as well as password for this connection;.

Leave a Reply

Your email address will not be published. Required fields are marked *