Creating/editing server
Use the Edit tab of Server Editor to create/edit a server and specify its definition.
Name
Enter the name of the data source that is being defined to the federated database.
Wrapper
Use the drop-down list to select the wrapper that the federated server uses to interact with data sources of the type and version denoted by Server type and Server version.
Server type information
Server type
Use the drop-down list to specify the type of data source denoted by Server name. Possible values are: DB2, INFORMIX, MS SQL, ODBC, ORACLE, SYBASE.
Server subtype
Use the drop-down list to specify the subtype of data source denoted by Server name.
Server version
Use the drop-down list to specify the version of the data source denoted by Server name.
Authorization
Remote login
Specifies the authorization ID under which any necessary actions are performed at the data source.
Password
Specifies the password associated with the authorization ID represented by Remote login. If password is not specified, it will default to the password for the ID under which the user is connected to the federated database.
Options
This area lists available server options which can be added to the server definition. Assign values for options where necessary.