Skip to Content
avatar image
Former Member

Reg use of Tablefunctions

Hi guys,

I need the elaborated procedure for JDBC to JDBC with Table functions scenario.Please help me.

Thanks in Advance,

Devika

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 18, 2008 at 10:28 AM

    Hi

    please check the bleow mentioned links :

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC

    https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3928-- [original link is broken] [original link is broken] [original link is broken] JDBC Receiver Adapter -- Synchronous Select u2013 Step by Step

    FILE to JDBC Adapter using SAP XI 3.0 ---File to JDBC

    XI : How to Re-Process failed XI Messages Automatically

    https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2590--good [original link is broken] [original link is broken] [original link is broken] one

    the driver details :

    Driver: com.sap.portals.jdbc.oracle.OracleDriver

    - URL: jdbc:sap:oracle://<server>:<port>;SID=<sid> e.g.

    jdbc:sap:oracle://myoracleserver:1521;sid=PIL

    Regard's

    Chetan Ahuja

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2008 at 10:58 AM

    use blog for JDBC To JDBC scenario

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbc%2bto%2bjdbc

    use for JDBC reciever Structure http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

    reciever adapter parameter

    username:<Oracle System user>

    Password:Login password of oracle

    driver : oracle.jdbc.driver.OracleDriver

    url:jdbc:oracle:thin:@<serverhostname>:1521:<SID>

    SID is Oracle server database name.

    Check always serialable property.

    Edited by: Dharamveer Gaur on Sep 18, 2008 1:03 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2008 at 11:09 AM

    Well here is another link, but one I hope does help!

    Oracle Table Functions and JDBC Sender Adapter

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded