To add a personal database connection, use this file format:
<?xml version="1.0" encoding="UTF-8"?> <AnalyzerAdmin> <ModifyUsers> <User LoginID="hyper1"> <Database Name=”DBName” Server=”epmsd030” Database=”Sample” Cube=”Basic” AliasTable=”Long Names” Type=”1” User=”admin” Password=”password” LoginMode=”1”> </User> </ModifyUsers> </AnalyzerAdmin>
Database requests to add a database connection. If a database connection file with the same name exists, the operation is aborted.
Database Attributes | Description | Permitted values | Example |
|---|---|---|---|
Name | Connection File name—File is created in /Users/user_name/Databases/. user_name—User’s name, defined in tag User. For this, user connection is created. | ||
Server | Essbase server host name | ||
Database | Application Name | ||
Cube | Cube Name | ||
AliasTable | Which alias to use | ||
Type | Type of connection to create. Only Analytic Services connections can be created. | 1 | |
User | User’s login for connection | ||
Password | Password for connection | ||
LoginMode | Login mode of DB connection | 1 – Use User’s ID and Password; 2 – Prompt for User ID and Password; 3 – Enter User ID and Password | 1 – Example, [“hyper1”, “hyper1”] 2 – always show dialog “Database Logon” 3 – Use specified in User, Password properties values |