The SETTARGET command enables you to identify a target Essbase Server computer for Integration Server to use with a load command.
SETTARGET DSN=EssbaseServicesdataservername;UID=username;PWD=password[;]
Parameters | Description |
---|---|
The TCP/IP name or number of the computer where Essbase Server is running | |
The password for logging on to Essbase Server—case-sensitive |
SETTARGET "DSN=FIG;UID=TBC;PWD=Password"