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

Connecting to SQL Server DB through Java stack distributed system


I creating a JCo connection to a SQL server database. We have distributed ABAP+JAVA system i.e. ABAP is on one instance/server and Java on another instance/server. The ABAP system is a BW 2004s system and Java is a Enterprise Portal which I am using as a AS JAVA and BI JAVA stack for my BI system.

My question is when I create a JCo connection to the SQL server do I give the gateway and host of the ABAP system or the Java system?

I am guessing it will be the Java system but BI will be using the RFC destination through the Java stack and retrieving data from the SQL Server.

Please help.

For those of you know wants to know what this is for, it is for UD Connect.

Thanks a lot

Message was edited by:

BW Novice

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 31, 2007 at 03:12 PM


    You have to gateway and host of ABAP system.

    Note: you are not going to communicate directly to database .. you are going to communicate through application server (ABAP).



    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.