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 FDMEE is installed (File location EPM_ORACLE_HOME/products/FinancialDataQuality/lib):

  1. aif-apis.jar

  2. 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"]