Domino needs enterprise data integration services -- especially those that're up to date.
Data connectors offer only very limited connection services.
The data connections need to:
- Allow for full-bore SQL accesses to relational data from a server.
- Be able to run SQL SELECT statements on a relational database and deliver a collection of information to a Domino application.
- Allow loosely coupled connections to often only occasionally-available enterprise data sources (cache & store information at reliable points in the day, and allow for delayed-update services to connections that actually update data on the enterprise.
- Allow for executing SQL to update into a transactional system, or run stored procedures, or a combination of the two.
- Allow authentication methods in keeping with protecting the data sources, while protecting credentials with encryption (more than basic).
- Allow for the Domino server reading WAS interfaces to data from a WA server.
- Allow for JDBC connections through XPages.
- Allow definition of enterprise data sources through XPages.
- Allow access to these data sources from server-side scripting.
- support interpreting XML data formats.
- Avoid dictating database designs to enterprise dbas.
- Allow access & use of metadata.