Skip to Content
Former Member
May 31, 2007 at 04:36 AM

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