DB Connect with MSSQL Server 2005

[Former Member]

Folks,

Our BI team wants to establish DB Connect with MSSQL Server 2005 Database. [They need to extract the data from MsSQL server 2005 to generate the BI report]

Application server and DB are running in difference machines and in different environment

BW Application server : AS 400 and MS SQL server 2005 : Windows 2003 Server

Please help me to achieve this .

Regards,

Gnanaprakasam

[Former Member · Accepted solution]

Hi, in your configuration you can't use the DBCON , for this you need at least one WINDOWS application server for this ....

You can try to use the UD connect for JDBC. Regards.

[Former Member · Accepted solution]

If i am using UD connect to J2EE server for JDBC acces,then how to replicate the SQL table structure in BW System.

Can u explain the steps to connect BW to MSSQL through UD Connect.

One more clarifcation i need why cannot we use the DB Conn ? ...

[former_member204746 · Accepted solution]

One more clarifcation i need why cannot we use the DB Conn ? ...

you need a SAP server running on Windows in order to use DBCON. Is this your case?

[Former Member · Accepted solution]

Thanks Eric ... As I said earlier we are running the SAP BW applications in AS 400 machine ... S o we couldn't use the DBCONN Please guide us to accomplish the task

Edited by: rdhaprakasam2003 on Aug 10, 2010 8:03 PM

[former_member204746 · Accepted solution]

a possibility is to install an application server on Windows and connect it to your central instance residing on As/400... and force DBCON to run on the Windows application server

[Former Member · Accepted solution]

Eric,

As of now we cannot install an AS on windows .. This is big head ache for us to create a system.

Cannot we do this directly from As 400 Machine . [AS installed in AS 400 ].. what do u think abt UD connection

[former_member204746 · Accepted solution]

I can't say.

I have never used UD connect.

[Former Member · Accepted solution]

anyone help me yaar

[former_member204746 · Accepted solution]

try this link:

http://lmgtfy.com/?q=SAPUDconnectJ2EEserverforJDBC

[Former Member]

problem solved thanks to everyone

[Former Member]

Hi,

can you let me know how you have solved this problem

Thanks!

Edited by: Jagan P on Jan 14, 2011 8:29 PM

[former_member305396]

Hi,

Could you let us know how you have solved this problem we're facing the same

Thanks

[former_member184473]

Hello Gnanaprakasam,

Just to complement the previous information, you can refer to the following website for further information about UDC (via JDBC):

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/58f4db47-0501-0010-a2bf-ff01b150fdff|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/58f4db47-0501-0010-a2bf-ff01b150fdff]

Regards,

Eduardo

[former_member204746]

you can configure DBCON to use dbmssslib.dll to connect.

search Google or SDN with keywords RSA1 DBCON.

start with http://help.sap.com/saphelp_nw2004s/helpdata/en/58/54f9c1562d104c9465dabd816f3f24/content.htm

also read answer from Niyi Fadeyi in