🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Connecting DB2/as400 to Rapid Analytics using jt400 driver

User: "JayCarr"
New Altair Community Member
Updated by Jocelyn
So, I got RA up and running in Ubuntu Linux.  Everything seems to be working correctly so far, but for some reason I can't add a connection for our as400s...

I followed the directions in this post as closely as I could:
http://rapid-i.com/rapidforum/index.php/topic,4437.0.html

I ended up putting the jt400.jar into //server/default/lib
I put the db2-400-ds.xml into //server/default/deploy

And it had this text in it (schema, username and password redacted, they are correct in my implementation)

<datasources>
  <local-tx-datasource>
    <jndi-name>DB2-400</jndi-name>
    <connection-url>jdbc:as400:*********;prompt=false;extended dynamic=true;package=jbpkg;package cache=true;package library=jboss;errors=full</connection-url>
    <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
    <user-name>*******</user-name>
    <password>*******</password>
    <min-pool-size>0</min-pool-size>
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
        -->

        <!-- sql to call on an existing pooled connection when it is obtained from pool
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
        -->
      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
        <type-mapping>DB2/400</type-mapping>
      </metadata>

  </local-tx-datasource>

</datasources>
After doing all of this I go into RapidAnalytics at "localhost:8080" and sign in. I go to Administration > Data Connections > Create New Connection Entry.  When I go to the drop down for the different DBs though my DB2/400 doesn't show up? 

What am I doing wrong?  I did change the .xml file a bit so that the connection string more closely matched the working string I have in RapidMiner (after trying it the standard way first), but other than that I feel like I followed the instructions to the letter...

Find more posts tagged with