Forum Stats

  • 3,759,474 Users
  • 2,251,548 Discussions
  • 7,870,667 Comments

Discussions

FDMEE 11.1.2.4 to load data in HSF

3128173
3128173 Member Posts: 17
edited Oct 6, 2017 7:15AM in Financial Data Management

Hi everyone,

Going through the documentation, it seems that FDMEE 11.1.2.4 does not support HSF as a target although FDM did at some point.

The scenario i am interested in is extracting data from HFM in order to load them in HSF. An alternative would be to extract the data in a flat file and load it in HSF as a scond step.

Has anyone encountered a similar challenge in the past? Are there any other alternatives involving ODI/FDMEE customization? What do you believe?

Thanks in advance

Tagged:

Best Answer

  • Francisco Amores
    Francisco Amores Member Posts: 1,693 Bronze Crown
    edited Oct 5, 2017 9:59AM Accepted Answer

    Hi

    you can create a data load rule to extract data from HFM and create a file for a custom application.

    Then you can build a script to load that file into HSF using the command line utility.

    If the HSF server is not the same as the FDMEE server you may have to install the utility there or use psexec.

    I hope that helps

Answers

  • Francisco Amores
    Francisco Amores Member Posts: 1,693 Bronze Crown
    edited Oct 5, 2017 9:59AM Accepted Answer

    Hi

    you can create a data load rule to extract data from HFM and create a file for a custom application.

    Then you can build a script to load that file into HSF using the command line utility.

    If the HSF server is not the same as the FDMEE server you may have to install the utility there or use psexec.

    I hope that helps

  • 3128173
    3128173 Member Posts: 17
    edited Oct 6, 2017 7:15AM

    Thank you Francisco,

    I recall that HSF was to be included as a target in FDMEE v 11.1.2.4.100 but until now nothing has happened towards that end.

    Another question : In your opinion what would be the best option to load data in HSF since FDMEE is not an option? custom processes in ETL tools (eg SSIS) that create files to be loaded in a second step using the HSF utility?

    Thanks

    M

This discussion has been closed.