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 .
you can configure DBCON to use dbmssslib.dll to connect.
search Google or SDN with keywords RSA1 DBCON.
also read answer from Niyi Fadeyi in DB Connect - system not accessible in QA
Just to complement the previous information, you can refer to the following website for further information about UDC (via JDBC):