SAP PO 7.31 JDBC channel to read a SAP PO database table.

[former_member183909]

Hi

I can connect to my regular MS SQL database tables OK.  For various reasons I wanted my own table actually in the SAP PO database itself.

I have deployed my own database table using NWDS into SAP PO.   I can see it in NWA > Troubleshooting > Database > Open SQL Browser.

I have in fact added a record to this table by connecting to it via MS SQL Studio - and can see the record OK

But I cannot get my JDBC communication channel to work for SAP PO to actually access one of it's own tables that resides in it's database (i.e. my table I've deployed).

What should the JDBC Driver be set to in the JDBC Sender communication channel ?

JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection : jdbc:sqlserver://UKSDSQLMI01:1433;databaseName=RID

[Former Member]

Hi

Does your PO system based on MS SQL or Oracle . Normally the java tables are stored in oracle and we use the following parameters to connect to the data base

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@server:1584:dbname

[former_member192343]

Hi, did you deploy MS SQL driver on PO server?

[former_member183909]

It was just due to the Port.  I removed it and now it works.