Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can i connect FDM to a relational source and target

SRApr 5 2014 — edited Apr 8 2014

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.
This post has been answered by Francisco Amores on Apr 7 2014
Jump to Answer

Comments

Francisco Amores
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

Marked as Answer by SR · Sep 27 2020
JeffJon

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.    

1 person found this helpful
SR

Thanks Amores and Jeff. I will do the research.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2014
Added on Apr 5 2014
#business-intelligence-applications, #fdm, #financial-data-management, #performance-management-applications
3 comments
1,849 views