Forum Discussion

rcis's avatar
rcis
New Contributor
8 years ago

How do you configure a iSeries Navigator (AS400) database in SoapUI NG Pro?

How do you configure the database in SoapUI NG Pro to connect with the AS400 database (iSeries Navigator?) This is what I currently have set up - I'm looking for any suggestions/ideas.  Thanks!   ...
  • rcis's avatar
    rcis
    8 years ago

    In Preferences > JDBC drivers, I was able to get it configured by adding the following for the driver:

    com.ibm.as400.access.AS400JDBCDriver

    I then added the Connection String Template as:

    jdbc:as400://<HOST:123.123.12.12>/<DB>:user=<USER>;password=<PASSWORD>;

     

    *Note to get the IP address, open a CMD window and ping the database (i.e. ping databaseName.corp.company.com)

groovyguy's avatar
groovyguy
Community Hero

The host is the ip address or FQDN of the device/server/computer/etc that hosts the database. 

rcis's avatar
rcis
New Contributor
8 years ago

After entering in the IP address, it still didn't like the configuration I had.  Does anyone have an example of what files they added to their ext folders along with how they configured it in SoapUI to be able to talk to their iSeries Navigator (AS400) database?

  • groovyguy's avatar
    groovyguy
    Community Hero
    8 years ago

    You are definitely on the right path. The files you need to place in the bin/ext folder are the java driver / connector jars for connecting to whatever language database is hosted on the device.