| |
| |
|
softwarecatch.com
|
|
|
|
Lotus Domino: Application Integration - A Programmer View
There are two approaches for application integration: ? Programmer's approach - for applications integration it is necessary to create some program codes; ? Integrator's approach - in this case special software products are to be used and the integration process set up by those software settings. The following tools may be used for the first approach: ? ODBC. In Lotus Domino codes may be used: o Three @-functions (@DbColumn, @DbLookUp and), which work with registrated ODBC-drivers . @DbColumn returns the whole column from external table, @DbLookUp process search by the key, and @DbCommand runs a command of ODBC-driver or external table (for ex, UDATE or DELETE); o Three inside LotusScript Data Objects (LS:DO), which support connection process, running of SQL-request and provide operations with received result table. This tool is more flexible than usage of described above @-functions (specifically, transactions mechanism, errors handling, etc); o Free NotesSQL ® ODBC-driver allows calling Lotus Domino databases by SQL. This method is available only for simple Lotus Domino databases, as them are not relation databases and SQL is not good to work with (problems with multiple fields values and different fields set in documents); ? JDBC. For direct using of JDBC mechanism, free IBM JDBC-driver may be downloaded, which allows calling Lotus Domino databases from Java-applications. This approach is better then use NotesSQL ® ODBC-driver, but can not be use with complex databases. JDBC technology also using in some integration mechanisms, but JDBC itself is hidden from the programmer(as example, using build in JSP Custom Tag Libraries); ? OLE. Using of this technology is in the Microsoft platforms frame. If this limitation is acceptable for a task, then using of this technology allows data exchanging from LotusScript to OLE-applications. Specifically it is possible to export data from Lotus Domino to MS Excel or MS Word. This technology often is using to create reports for Lotus Domino data. In Lotus Domino exists Notes/FX mechanism, which implicitly uses OLE- technologies. This mechanism allows to process automatic data exchange between fields of Lotus Domino forms and information stated on OLE-server. Lately Notes/FX are used in really applications very seldom; ? XML. Using of this technology in Lotus Domino R 6 allows processing of Lotus Domino objects' stream transformation (documents, design elements, ACL, etc.) into XML and back, apply in a stream XSLT to XML, put filters on translated/received information, as well as review XML by build in LotusScript-classes, processed DOM and SAX parsing; ? HTML. If an HTTP task is started on Domino server, then from external applications is available sending/receiving data by of the same name protocol; ? CORBA. This technology used in Lotus Domino more in Java content. Applets, servlets, Domino JSP Custom Tag Libraries, using this technology may exchange data with Lotus Domino; Apart in integration solutions line are DECS (Domino Enterprise Connection Services), DCR (Data Connection Resources) and LEI (IBM Lotus Enterprise Integrator for Domino) technologies. These technologies except of coding request administration settings to be tuned and may be refer as to first (programmer) as to second (integrator) approaches to integrate applications. DECS technology allows direct connection with DB2, Oracle, MS SQL Server, Sybase sources, and external sources by ODBC and OLE technologies. DECS technology requests of the same name task on the Domino server, as well as some settings in « DECS Administrator» database. Two types of documents can be created in this database: ? Connection, which provides the possibility connecting with an external system. Without details, let say that this document provides the path to external source and login and password for this connection; ? Activity, provides correspondence between Lotus Domino fields and information from external source. The correspondence is assigned by special Lotus Domino form and fields. This document can support up to four case types (form open in Lotus Domino, data changing, deleting or new record creation in Lotus Domino). After Activity document is activated the same processes in external source will be started if the tracking cases happen in Lotus Domino. For example, imputing and saving the new data in Lotus Domino (in case if them are tracking), analog data arrive in external source. DECS mechanism works correctly in case if external source data are worked with only by Lotus Domino. Otherwise, if the data arrived in external source omitting Lotus Domino they do not automatically transferred to Lotus Domino. DCR technology appeared in Lotus Domino R 6, is an interface extension for DECS technology and work only with corresponding task on Domino DCR server. Without details, the new design element by name DCR may be considered as analog of Connection document from « DECS Administrator» database. By the way, analogies of Activity documents are determinated directly in Lotus Domino forms. LEI technology may be considered as developing of DECS. Using of LEI allows to developers much more possibilities for data processing with build in Lotus Connector Classes for LEI. Good luck in your system setting up and contact us for any help in Moscow +7 (095) 918-3314, +7 (095) 918-3111 , in USA: 1-866-528-0577! Alba Spectrum Technologies P. Gottmann is a technical writer in Ronix Systems (http://www.ronix-systems.com) the European branch of Alba Spectrum Technologies ( http://www.albaspectrum.com ), IBM and Microsoft Business Solutions Partner serving clients in Berlin, Hamburg, Paris, Vienna, Roma, Munich, Madrid, Chicago, New York, Los Angeles, Miami, Denver, Phoenix, London, Sidney, Sao Paulo.
MORE RESOURCES:
Google News |
|
|
|
RELATED ARTICLES
Helping Newbies Understand Professional Software The Windows registry is a huge database that ensures normal computer operation. Installing and uninstalling software can make your registry a mess, leading to decreased PC performance and causing computer crashes. Removing Incoming Email in MS Exchange, C# Example The purpose of one of our projects was MS Exchange handler for processing incoming email.The basic source of knowledge was this article "Developing Managed Event Sinks/Hooks for Exchange Server Store using C#" by Logu Krishnan, published to the address http://www. Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. You should probably expect some issues when you have software development company to be bought by big player - in this case Great Plains Software was bought by Microsoft (Bill Gates was a friend to Doug Burgum - owner and leader of Great Plains Software - Great Plains Dynamics/eEnterprise). Five Reasons for Using an O/R Mapping Tool So, why should you use any O/R mapping tool? I am not talking about a specific tool but rather all O/R mapping tools in general. There are a number of reasons for using an O/R mapping tool but before I dive into that, let me give you a brief overview of what an O/R mapping tool really is. Microsoft Great Plains Project Accounting - Overview For IT Director/Controller Microsoft Business Solutions is now in process of creating so called Microsoft Suites: Microsoft Financials, Microsoft Logistics, Microsoft Manufacturing, Microsoft Professional Services - this last one will be based on Solomon Project module. The long story of Great Plains Software Project Accounting - it was originally created by MatchData, which was bought by Great Plains in late 1990-th and renamed into Great Plains Project Accounting. Great Plains Dynamics on Pervasive/Ctree support - overview for consultant All of us know that Microsoft bought former Great Plains Software and formed Microsoft (Great Plains) Business Solutions in the earlier 21st century. It was total success for GPS, we guess, but for Great Plains Dynamics / eEnterprise / Dynamics C/S+ clients it was the time of change. Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool DBxtra is a powerful query and reporting tool that hides many of the complexity and technical expertise required for creating connections to disperse data sources, building queries, designing reports, and delivery information throughout an enterprise or to your customer base.With the ability to connect to multiple databases or data sources at the same time, DBxtra allows for cross platform data aggregation and the ability to answer questions that would typically take IT time to migrate data into a single reporting database. Microsoft Great Plains in Metal Distribution: Implementation & Customization - Consultant Overview Microsoft Business Solutions Great Plains serves to the wide spectrum of horizontal markets and could be also considered as generic ERP/MRP/Accounting platform for light and advanced customization to fit verticals. In this small article we describe distribution sector with the example from metal distribution - Dealer/broker of industrial nonferrous by-product scrap, de-tins and de-oils industrial by-product scrap and finished parts. Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP Enabling Chinese input is quick and easy, there are only a few steps you need go through to install the Chinese Language support and input method before you can type Chinese in your word processor or other program.We have broken the steps to 3 different sections for your easier to read and follow. Demand More From Your Lead Tracking Software An integral part of any quality CRM system is lead tracking software. This is the part of the system that helps you gather customer data from your sales force. Are You Waiting for Microsoft Longhorn Operating System I love new technology. I am still ready to wait long for Longhorn. Importance of Coding Standards Programming Help for BeginnersWe write programs to instruct computers. When programming using a high level programming language like C++ or Java, we are using a syntax that is somewhat closer to human languages. Microsoft Great Plains Upgrade - Things to Consider and FAQ If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE.What is upgrade in the language of technology? Upgrade has server and client sides. Microsoft CRM Implementation - US Market Lessons Microsoft CRM is CRM answer from Microsoft Business Solutions. If you compare it to other traditional CRM applications, such as Siebel - you will see that Microsoft CRM does use all the resent Microsoft technologies, that means that Microsoft targets its CRM to Windows market exclusively, plus this means that Microsoft CRM is more difficult in its installation. MultiNational Corporation ERP Implementation - Microsoft Business Solutions Great Plains If you look back to the history, you will see that ERP for large publicly traded company had to be built upon very reliable hardware (more likely non-Intel hardware: mainframe, Sun sparc, etc.), powerful database platform: Oracle, DB2, Ingress, Sybase and reliable OS: UNIX. Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example Microsoft Business Solutions offers several ERP applications: Great Plains, Navision, Solomon and its own CRM solution - Microsoft CRM. Targeting to automate all business operations, Microsoft CRM is now integrated with Microsoft Great Plains and in the close future it should have integration with Microsoft Navision. The Tools and Features of Adobe Photoshop Adobe Photoshop is one of the world's leading graphics editing programs, developed by Adobe Systems. Available on Mac OS or PC, Photoshop is used as one of the leading image design programs for the World Wide Web. Three Steps To Windows Safety Heaven Now there are Three Steps To Heaven Just listen and you will plainly see How virus and hackers attack and destroy Your precious internet-connected computer toy Just follow steps one, two and threeStep one - Run windows update automatically each day Step Two - Always keep your antivirus running and updated Step Three - Install and configure a firewallFaster VirusToday can many viruses find and infect a computer connecting to internet in less then 5 minutes, even if the computer connects to internet using a modem. And how much time will the 24/7 connected computer not give the bad guys?So leaving a computer without proper protection is not advisable. Corel WordPerfect 7 Macro Programming Example Case study: A secretary using Corel WordPerfect 7 is often required to carry out calculations and insert the values into invoices or other documents.She does this by entering calculations into either a real calculator and transcribing the answer, or the Microsoft calculator and copying then pasting the result into the document. Microsoft Great Plains Implementation for Large Corporation - Overview for VP IT Microsoft Business Solutions Great Plains was historically designed to serve mid-market first and then with addition and acquisition of new modules - Great Plains Dynamics architects planned to enter into corporate market. When Microsoft SQL Server took its place as relatively reliable and stable database platform, Great Plains gained scalability.
|
|
Powered By: Free Work At Home Business Opportunity! |
| © 2006 |
