The advantage of the SQLConnect approach is that the workstation user does not have to deal with the CA Datacom/DB options, such as server name, except when following the server administrator's instructions while configuring a data source. One data source equals one server.
A disadvantage of the SQLConnect approach is that a different data source must be configured for each server to which the user connects. Since the user only selects a data source name, the names chosen for the data source and server must be similar. In contrast, the other connection approaches lets the user use a single data source to access one or more servers. In this case the data source equates to all CA Datacom/DB servers, instead of a single server.
Another disadvantage is the requirement that configuration changes on the mainframe must be reflected in configuration changes to the configured data sources at the workstation.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|