IBM DB2/AS400 i-Series Database connection with ElegantJ BI
1. First add jt400.jar (Around 4-5 MB) file in ‘…\wildfly-8.2.0.Final\standalone\deployments\elegantjbi.war\WEB-INF\lib’
2. Connection Parameter
Driver Class : com.ibm.as400.access.AS400JDBCDriver
Database URL: jdbc:as400://90.90.90.90:446;
3. Add Username and Password (Client will provide)
4. Add ‘translate binary=true’ at the end of the database URL. Your Database URL will now look like jdbc:as400://90.90.90.90:446; translate binary=true
Note: If we do not add this parameter at the end of database profile, all the column values are fetched in Binary format.
Do not forget to put the above jar file at the time of version update.