You are not logged in.

Connection to IBM i5 (AS400)

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Niaah

Trainee

  • "Niaah" started this thread

Posts: 3

Date of registration: Sep 7th 2010

  • Send private message

1

Tuesday, September 7th 2010, 3:39pm

Connection to IBM i5 (AS400)

Hey guys,

i've got some trouble connecting the palo etl server to an AS400 database:

i downloaded the jdbc driver (jt400.jar) and inserted it to \Palo Suite\tomcat\webapps\etlserver\WEB-INF\lib.

in palo web interface i used generic DB connection and set the driver class to "com.ibm.as400.access.AS400JDBCDriver"

when i want to test the connection, the error shown in the attached picture occurs.

i also tried to insert the following in the component.xml: (did read that somewhere)

Source code

 
1

<component name="AS400" jdbc="as400" driver="com.ibm.as400.access.AS400JDBCDriver" class="com.jedox.etl.components.connection.RelationalConnection"/>


having done that, there is a empty field expecting some XML input, where i actually don't know what to type in (see picture 2).

I hope someone knows what i did wrong and can help me solving this problem




edit: i tested the JDBC driver with squirrel SQL right now and it works fine

This post has been edited 2 times, last edit by "Niaah" (Sep 7th 2010, 3:52pm)

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Tuesday, September 7th 2010, 4:00pm

Niaah

Trainee

  • "Niaah" started this thread

Posts: 3

Date of registration: Sep 7th 2010

  • Send private message

3

Tuesday, September 7th 2010, 4:35pm

thanks for your reply
i already read those threads and can't see where they are able to help me.
could you give me a hint?

since i know my driver's class name and have tested the driver in squirrel, i actually have no idea where the problem is.

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

4

Tuesday, September 7th 2010, 6:22pm

Hi,

  • if you use the GenericDB Feature, you have to enter the complete JDBC Server URL, not just the IP in the respective fields.
  • if you use a custom AS400 connection you have to write the XML fragment on your own


BTW: I already sent a feature request to Jedox for shipping the JT400 Driver with ETL Server.

regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

Niaah

Trainee

  • "Niaah" started this thread

Posts: 3

Date of registration: Sep 7th 2010

  • Send private message

5

Wednesday, September 8th 2010, 10:41am

thank you very much tish1, inserting "jdbc:AS400://" in front of the IP solved the problem :)

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

6

Wednesday, September 8th 2010, 9:49pm

Allways welcome.
Robert Tischler
Senior Consultant Vector SW DV GmbH
Rate this thread