Does CI-Link allow the interconnection of data retrieved from different database servers ?
Yes, in several ways. First, it is possible to open several connections to databases from different providers by creating several instance variables of the Database class and indicating different adapters. It is then possible, within a same method, to query these different database engines via the USE command which allows to choose onto which engine the next EXEC SQL order will be sent. The client parts of both database engines must then be located on the computer on which this method is executed. Secondly, it is possible to access data retrieved from another DBMS or even from other kinds of data sources through an applications server which can be located on another network and on another computer. This allows to make two very different envcironments communicate, for which both client parts are not necessarily available on the same computer (too old engine for instance). The same dialog can also be designed through XML flows by using the Web server built-in in CI-Link and deriving it t
