Connecting to IBM DB2/AS400 i-Series Database

Modified on Wed, 15 Mar 2017 at 11:19 PM

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;



AS400.png

 

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. 

IBM DB2 AS400 DB Connection Data Source URL DB Profile Creation ElegantJ BI Support ElegantJ BI Knowledgebase ElegantJ BI Articles ElegantJ BI Training Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article