Remote connection to MSSQL 2008 using ABAP program

[former_member188883]

Hi,

I have my ECC 6.0 system running on Solaris/Oracle. I have a following requirement

1) Establish a remote connection to MSSQL 2008 database

2) Read and write entries into 2 tables of MSSQL 2008 using ABAP program

Note: I do not want to do any coding in JAVA. All coding needs to be done in ABAP language only

Request you to provide feasilbe approaches to accomplish the same.

Thanks and Regards,

Deepak Kori

[sunny_pahuja2]

Hi,

You have to use UD Connect method to connect MSSQL database to your ECC system.

Thanks

Sunny

[Former Member]

Hi,

And you have to challenge the request because interfacing 2 different systems with direct DB connections is one of the worse possible practices. The Data integrity is at risk and you create low level dependencies that will become nightmares in the future...

Regards,

Olivier

[ImtiazKaredia]

Check below thread

[former_member188883]

Hi ,

Solution mentioned in the link talks about BW interface. I do not have a BI system to interface in between.

If anyone has implemented any solution with ECC, that would be of great use.

Using UDconnect will require a Java stack and some coding in JAva front. This is not what I am interested into.

Incase anyone has implemented a better solution, please respond.

Regards,

Deepak Kori