Using JAVA IDE to Develop Scripts

You can use popular Java IDE tools like Oracle jDeveloper, or Eclipse to develop and test scripts. Before using Eclipse to develop scripts you must install and configure the PyDev Interpreter. Refer to http://pydev.org for more details. After you have configured the IDE environment, copy the following JAR files from the EPM Server where Oracle Hyperion Financial Data Quality Management, Enterprise Edition is installed (File location EPM_ORACLE_HOME/products/FinancialDataQuality/lib):

aif-apis.jar
aif-custom.jar

In addition, download appropriate (Oracle or SQL Server) JDBC driver JAR. After you have copied these files to the Project working directory, include them in the Project you create. Below is sample of the initialization steps required when running from your selected IDE:

#Start Initialize Code

#Required for Dev Mode. Not required in production script

import java.math.BigDecimal as BigDecimal

import java.sql as sql

import com.hyperion.aif.scripting.API as API

fdmAPI = API()

conn = None

conn = sql.DriverManager.getConnection("jdbc:oracle:thin:@server:1521:orcl", "user", "password");

conn.setAutoCommit(False)

fdmAPI.initializeDevMode(conn);

print "SUCCESS CONNECTING TO DB"

fdmContext = fdmAPI.initContext(BigDecimal(1720))

#End Initialize Code Required for Dev Mode. Not required in production script

#Code to be added to production script

print fdmContext["LOCNAME"]

print fdmContext["LOCKEY"]

print fdmContext["APPID"]