Skip to Content
author's profile photo Former Member
Former Member

Regarding JDBC Adapter

Hello Experts,

If i want to perform File to JDBC Scenario, Is it require any pre-requisite for JDBC Adapter configuration.

Thank you

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 01:27 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 12:55 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 12:58 PM

    Hi,

    Yes, it is necessary to follow the structure of the JDBC to insert the data into the database else throws exception, but as UPDATE command is mandatory you should use it, if you dont want to any updation just type <TEST> there in the Update column.

    follow this links it will be very useful

    FILE to JDBC Adapter using SAP XI 3.0

    Receiver Structure

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    JDBC Discussions

    JDBC- X I - R/3 Scenario

    Step By Step Process

    JDBC Receiver Adapter -- Synchronous Select – Step by Step

    regards,

    Kishore

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 01:01 PM

    Hi,

    The Prerequisite for JDBC adapter :

    -Access to a database system or any other database that provides

    JDBC drivers, to write the data into DB.

    -The Driver should be deployed in the Server.

    -Configure User in the SQL enterprise manager tool or similar tool for any other databases

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 01:01 PM

    Hi,

    Pre-requisites for JDBC Adapter is

    Install JDBC drivers on XI Server

    Follow the bellow guide on how to install

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guides/how%20to%20install%20and%20configure%20external%20drivers%20for%20jdbc%20and%20jms%20adapters.pdf

    Configuration of JDBC Adapter for SQL Server

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

    Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

    UserID and Password.

    If the connection is not working find the correct port number.

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d8033

    Regards

    Seshagiri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 01:05 PM

    Hi,

    You need to have your JDBC drivers installed in the SAP XI server and you can start configuring the JDBC details with the driver and the connection parameters.

    Regards,

    Nithiyanandam

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 02:00 PM

    HI,

    File to JDBC:-

    FILE to JDBC Adapter using SAP XI 3.0

    XI: How-to on JDBC receiver response

    For Configuring jDBC adapter -

    http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

    To do Jdbc scenarios initially we have to install jdbc drivers in the XI server to get connected to the database . and specify the connection details in the jdbc communication channel.

    Regards,

    Pradeep

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.