This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

Categories

Can i connect FDM to a relational source and target

SR
SR Member Posts: 172
edited Apr 8, 2014 10:04AM in Financial Data Management

I am new to this tool. I have some basic questions. I sis my research but could not find clear answer.

Can i connect a relational table as source  and target for a FDM application. Relational source is not eBS or other applications, just a relational table. I would like to load same data from one relational table to another table using FDM. I am looking at wrong tool? Which adapter do i need to use? Is ERPI source adapter ? Which target adapter?

Can can somebody please suggest? Thanks in advance.

Tagged:
· Share on TwitterShare on Facebook

Best Answer

  • Francisco Amores
    Francisco Amores EPM Data Integration Specialist SPAINMember Posts: 1,694 Bronze Crown
    Answer ✓

    Hi,

    If you are new to this tool, you should know that FDM will not be released from 11.1.2.4.

    It is replaced by FDMEE which is already available in 11.1.2.3.

    In any case, you can extract data from relational db using an integration script. FDM does not load data to a non Hyperion EPM target db but you could it get it working using custom script.

    Regards

    · Share on TwitterShare on Facebook

Answers

  • Francisco Amores
    Francisco Amores EPM Data Integration Specialist SPAINMember Posts: 1,694 Bronze Crown
    Answer ✓

    Hi,

    If you are new to this tool, you should know that FDM will not be released from 11.1.2.4.

    It is replaced by FDMEE which is already available in 11.1.2.3.

    In any case, you can extract data from relational db using an integration script. FDM does not load data to a non Hyperion EPM target db but you could it get it working using custom script.

    Regards

    · Share on TwitterShare on Facebook
  • JeffJon
    JeffJon Member Posts: 1,141

    As Franscisco mentioned to import from a source table, you would use a SQL integration script.  There is a sample of this in the FDM Administrator Guide.

    For loading to a target DB Table, you would use the Data Mart adapter which would allow for the data to be extracted to a flat file, which you could then import into any target source you wish.    

    JeffJon
    · Share on TwitterShare on Facebook
  • SR
    SR Member Posts: 172

    Thanks Amores and Jeff. I will do the research.

    · Share on TwitterShare on Facebook
This discussion has been closed.