Testing the Integration Server Connection to Essbase Server

When isolating connection problems between Integration Server and Essbase Server, use Integration Services Shell to establish a connection to a data source and OLAP Metadata Catalog, and then attempt to load members into an Essbase database.

To test the Integration Server connection to an Essbase Server:

Verify that Integration Server is running.
If Integration Server is not running, start it. If Integration Server will not start, check to ensure that the Integration Services environment variables are set. See Correcting Integration Server Problems.
Verify that the Essbase Server is running.
At a command prompt, start Integration Services Shell by typing
```
olapicmd 
```
If Integration Services Shell does not start, make sure that the software is installed and that the Integration Services environment variables are set. See Correcting Integration Server Problems.
At the Integration Services Shell command prompt, use the login command to connect to Integration Server; for example, type
```
login cypress 
```
Set the data source to the sample data source by typing
```
setsource "DSN=TBC;CODEPAGE=English_UnitedStates.Latin1@Binary;UID=TBC;
PWD=password" 
```
The DSN parameter requires the ODBC data source name, which may differ from the database name in the data source.
Set OLAP Metadata Catalog to the sample OLAP Metadata Catalog by typing
```
setcatalog "DSN=TBC_MD;CODEPAGE=English_UnitedStates.Latin1@Binary;
UID=TBC;PWD=password" 
```
The DSN parameter requires the ODBC data source name, which may differ from the OLAP Metadata Catalog database name in the data source.

Set the instance of Essbase Server to which you want to connect by typing

settarget "DSN=sequoia;UID=TBC;PWD=password;"

Note:

If you are using Integration Services Console on a client computer that is outside the firewall for your network, and you require access to an Integration Server and Essbase Server located inside the firewall for your network, be sure to use a name or an IP address for the Essbase Server that is accessible from both sides of the firewall.

Test the connection to the Essbase Server by attempting to perform a member load by typing
```
loadmember "APP=OLAP_TBC;DBN=Basic;OTL=TBC Metaoutline;"
```
Check the status of the preceding command by typing
```
status 
```
If the connection failed, the message IS Error: Unable to login to Essbase Server is displayed. Make sure that the Essbase Server is running. Verify the name of the metaoutline in Essbase. Also verify the name of the test application and database in Essbase. Repeat Step 7 and Step 8 of this procedure to retest the connection.
After you can connect successfully to the Essbase Server, proceed to Testing the Integration Services Console Connection to Essbase Server.