cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to SQL Server DB through Java stack distributed system

Former Member
0 Kudos

Hi,

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

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).

Regards

Ben