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"