The External Data Source
Prior to attaching to a data source, the appropriate network connectivity must be in place and defined. There is a separate Notes database to help you through this because the requirements for each data type are different. The database is the Domino Connectors Setup Guide, and is stored under the filename of LCCON6.NSF. This database is installed on the server in the Help directory by default.
At the time of this writing, DECS can connect to 90 data sources. There are five native connections, as shown in the following list:
- OLE DB
- Sybase
- Oracle
- DB2
- File system
Standard connections can be made through ODBC and JDBC. Available legacy and transaction-based systems include MQ/Series, CICS, and EDA/SQL. The data sources available to DECS continue to be expanded, and you should check the Enterprise Integrator Web site for new releases at http://www.lotus.com/home.nsf/welcome/ei.
DECS is very similar to Enterprise Integrator in the way that the requests are defined and stored. The DECS Administrator database is at the heart of the process and is where all relationships and activities are defined.
What DECS means to you is that you can provide real-time access to back-end data through the data mapping functionality provided in DECS. After fields are defined in a form, DECS is used to create a map from the fields linked to fields in an external data source.