What is that?
It is a Java based program, and is used to push data from one HFM application to another HFM application.
When will I need it?
– Have a need to push data from one HFM application to consolidated application.
– Don’t want to create a new automated solution from scratch to solve your data extract and load needs.
– Don’t want to acquire license of any ETL tool to extract from one HFM application and load data to another HFM application.
– You need simple easy to manage code for just your specific extract / transform / load needs.
Then, it is our Data Integration Tool that you need. It is Java based, platform independent and easy to configure.
What does it do?
The program uses Java APIs to extract data from one application and loads to another application as per the configuration.
– Data is extracted to database in the form of star schema (Uses the extract to database option of HFM to perform this)
– Pre created mapping tables help to transform the data suitable for the target loading needs.
– The data after transformation is pushed to a file.
– Then the file is loaded to the target HFM application.
As simple as that.
How to start with JAVA API for HFM?
– The documentation for JAVA API provided by Oracle is a good starting point. However our JAVA expert could see that the document here https://docs.oracle.com/cd/E40248_01/epm.1112/hfm_javadoc/index.html is not complete, it also has deprecated methods and functions in the guide. Note that it can be used as a reference to start the JAVA API programming for HFM. However, one will be in need to use their JAVA expertise along with this reference guide to create the code snippets needed to push data from one HFM application to another HFM application.
– Oracle SDK demo codes are based on Jdeveloper 11.1.1.7.1 version of the software. It is good to install the same software to try the sample programs provided by Oracle in the SDK documentation to start using JAVA API for HFM. You will find the demos at the SDK link available here at http://www.oracle.com/technetwork/middleware/financial-management/overview/index.html
The SDK DEMO HFMCustomizations.zip creates an application by name SDKDEMO. The JAR files used are available in both platforms on 11.1.2.4 versions as I checked myself in both platforms. Apart from the JAR files used in this demo – we needed to include other required JARs as needed by our integration tool.
VB versus JAVA?
Before 11.1.2.4 JAVA API – the VB methods were used to run the program – We converted our existing customized integration tool from VB to use JAVA. These VB dlls are still available within the EPM installation, As we know Oracle is moving towards supporting JAVA API, it is better to stop using those VB methods going forward. Here is a quick compare and contrast between VB and JAVA.
Easy to implement?
Our DIT tool can be configured easily for anyone having the need to push data from one HFM application to another HFM application – It doesn’t matter if you are using SQL server Database or Oracle Database for HFM configuration. And it doesn’t matter if you have Exalytics or Windows for your HFM 11.1.2.4 EPM environment.
Our customized integration tool can handle it all.
Reference
1) Oracle JAVA API documentation
2) HFMCustomizations.zip from Oracle
Hi,
I have a question fot you:
It is possible to call Extended Analytic and passed a file xml for extracting a Data from the star schema using the java class?
Yes It is possible. We have set it up in our model.
Hello, I have a question on extracting data from HFM to flat file using HFM API ?
@Vissu – Will be glad to answer – What is your question ?