Skip to Content
author's profile photo
Former Member

report in WEBI with a JDBC connection thru netezza does not work (WIS 10091

Hello Gurus,

I have successufuly created a connection throu Universe Designer following this step:

http://www.forumtopics.com/busobj/viewtopic.php?t=165491☆t=0&postdays=0&postorder=asc&sid=8f05a7eabcf8acfca65cf676b1705f1a

The connection works on the universe but inside WEBI I receive WIS 10091.

Have you got any suggestion? Does Webi requires a particular configuration in order to use the jdbc Netezza?

The error I receive is "JAVA CLASS NOT FOUND - combusinessobject.connectionserver.java.drivers.jdbc.wrapper.JDBC.Wrapper"

ths to all

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 09:52 AM

    found the solution,

    in jdbc.sbo just under JDBCDRIVER TAG type something like this :

    <DataBase Active="Yes" Name="Netezza Server">

    <JDBCDriver>

    <ClassPath>

    <Path>C:\ YOUR_PATH_JDCB\YOUR_JAR</Path>

    </ClassPath>

    <Parameter Name="JDBC Class">org.netezza.Driver</Parameter>

    <Parameter Name="URL Format">jdbc:netezza://$DATASOURCE$/$DATABASE$</Parameter>

    ths to all

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 09:52 AM

    great solution!

    Add comment
    10|10000 characters needed characters exceeded