Analytics Software

Hi,

I want to develop a connector to load data to and read data from Planning. I have following doubts regarding for this custom connector.

1) Is there any API to connect to Hyperion Planning ? If not then can we use Essbase Java API to connect to Planning ?

2) Loading data to Hyperion Planning application using Essbase Java API would be possible at application layer (Hyperion Planning) or at database layer (loading data directly to essbase database) ?

3) If we load data directly to essbase database how are we going to recognize which essbase server is connected with Hyperion Planning application ? Does user require to know in advance the underlying databse server ? Is there any API in Essbase or in Planning to connect to Planning application ?

4) If we load data directly to essbase database how to find out Planning applications and essbase application ? In other words how to differentiate between essbase applications and Hyperion Planning appllications ? Or How to recognize Planning applications ? Is there any API in Essbase to find out this ?

5) If we read data directly from Essbase how do we recognize data from a Planning application ?

6) What is the difference between Classic planning application and EPMA planning application ? Can we develop a connector to work with both these flavour or type ?

7) Can we use HFM COM APIs to extract and load data to and from Hyperion Planning ?

Please suggest.

Many Thanks