mooServer Connection


A FinanceHub mooServer Connection supports additional server side work flow, data submission and reporting tools.  

This type of connection should only be used with a mooServer enabled environment.


The mooServer "my OLAP Login" connection editor is found within the main FinanceHub menu group.





mooServer Connection Editor Window


The "my OLAP Login" connection editor window enables the user to enter connection details associated with an mooServer enabled Oracle OLAP enabled database instance.



Use the  button to expand the window for more options.




The User can perform the following actions:


       Open                        --        Open an existing connection file.

       Save                        --        Save a new Standard Oracle OLAP connection file.

       Connect                --        Initiate a connection to an Oracle OLAP enabled database instance based on the entered connection information.

       Disconnect                --        Disconnect from an existing connection.

       Help                        --        Open this Help Topic.

       Close                        --        Closes the Standard Connection Editor Window



       


mooServer Connection File


By default FinanceHub will look in the a location similar to below for pre-saved connection Files.


C:\Documents and Settings\{username}\Local Settings\


The following shows an example mooServer connection xml file:


<?xml version="1.0" standalone="yes"?>

<NewDataSet>

  <Settings>

    <Key>CONNProfile</Key>

    <Value>mooServer</Value>

  </Settings>

  <Settings>

    <Key>APP_UNAME</Key>

    <Value>bob</Value>

  </Settings>

  <Settings>

    <Key>HOST</Key>

    <Value>mooserver.myobjectiveolap.com</Value>

  </Settings>

  <Settings>

    <Key>PORT</Key>

    <Value>1521</Value>

  </Settings>

  <Settings>

    <Key>SID</Key>

    <Value>moo</Value>

  </Settings>

  <Settings>

    <Key>DB_UNAME</Key>

    <Value>mooserver</Value>

  </Settings>

  <Settings>

    <Key>DB_PASS</Key>

    <Value>jdsakldjLJKLJDASJDSKALJEEjkk</Value>

  </Settings>

</NewDataSet>


The following keys are stored:


       Key                                Description

       CONNProfile                --        User friendly description of the mooServer connection profile

       APP_UNAME                --        The username of the mooServer application user

       HOST                        --        The hostname or IP address of the mooServer enabled Oracle OLAP server you wish to connect to.

       Port                        --        The port of the Oracle database instance you wish to connect to.

       SID                        --        The SID of the Oracle database instance you wish to connect to.

       DB_UNAME                --        The username of the database connection, this is normally mooserver

       DB_PASS                --        The encrypted password hash of the database connection, this is normally set to never expire,

                                       as the user security has been delegated to the mooServer application.

                                       If it is changed new connection xml files must be distributed or update on change.


       Note: mooServer does not allow the storing of the application password.

       

You can save a connection file with any filename supported by the Microsoft Windows file system.