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

JDBC connection XI to MSSQL

Hi!

I'm starting whit SAP XI. I need to connect from SAP XI (on UNIX) to MSSQL DB.

I know that I have to install and configure drivers for JDBC adapter, but the question is:

Whot I have to do after that. Is anything what I have to do on XI side. How and where I have to create that connection for taking data from this database. I have to write some program in Java or I can use some module from XI to do that?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Oct 26, 2006 at 09:40 AM

    Hi,

    After you install the driver you use the Sender or Reciver JDBC adapter to connect to the database.

    The parameters in the JDBC adapter,

    If you have already deployed the drivers (msbase.jar, mssqlserver.jar, msutil.jar).

    Driver:

    com.microsoft.jdbc.sqlserver.SQLServerDriver

    Connection for MS SQL Server:

    jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

    If you are using the new SQL Server 2005 jdbc driver (sqljdbc.jar). Setup is basically the same, except the driver is now:

    com.microsoft.sqlserver.jdbc.SQLServerDriver

    And the URL is slightly different as well:

    jdbc:sqlserver://host:1433;DatabaseName=name

    Regards,

    Bhavesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2006 at 11:09 AM

    Can you give me some example how to configure all that things?

    PS: Masz moze numer gg pogadaliby&#347;my na ten temat. Moze szybciej bym mogl rozwiazac ten problem.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 26, 2006 at 09:41 AM

    Hi,

    after you deploy the jdbc driver for mssql

    on your XI all you need to do is to

    maintain the jdbc channel - nothing more

    (then just standard routing)

    deploying the jdbc driver:

    https://websmp205.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDrivers.zip

    Regards,

    michal

    -


    <a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2006 at 09:55 AM

    OK but I still dont know where this JDBC adapter is situated and how to run this adapter to put this parameters:

    Driver:

    com.microsoft.jdbc.sqlserver.SQLServerDriver

    Connection for MS SQL Server:

    jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

    Maybe I have to run some transaction like dbco and write this there.

    Please advice me step-by-step

    Add a comment
    10|10000 characters needed characters exceeded

    • hi,

      >>>OK but I still dont know where this JDBC adapter is situated and how to run

      did you deploy the driver as per my link?

      then you need to configure it in integration directory

      ( transaction sxmb_ifr on XI)

      but you also need to configure the rest of the routing

      in the integration directory and the repository part too

      for jdbc weblogs you can have a look at documents

      section in XI FAQ link below

      Regards,

      michal

      -


      <a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

      Message was edited by: Michal Krawczyk

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.