This content has been marked as final. Show 2 replies
There is a Data Mart Adapter that will export the data from FDM to a flat file for import into another system. If you have purchased the FDM Adapter Suite Licensing, you can look into this adapter.
Hi Per1 person found this helpful
There are other adapters for FDM so you do not have to use exclusively HFM / Essbase as targets. It sounds as though you may be interested in the 'Pull' adapter, please see the Oracle readme doc for one of the latest versions of that:
Essentially it imports to FDM as normal (stored in its underlying relational schema be it SQL or Oracle) and then outputs to text file I believe as standard but I'm sure that you could amend that if required to be a relational target.
One thing to note is that some of the features of the HFM adapter in particular regarding FDM checking HFM for valid target intersections / members won't be there but you can I believe load a table of valid values into FDM and use that as a replacement to that feature.
Worth a look at least to compare against ODI. ODI will be able to perform similar tasks but as you suggest may not be as end user friendly (in my opinion / experience).