Skip to Content

Remote connection to MSSQL 2008 using ABAP program

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 25, 2011 at 11:22 AM

    Check below thread

    DB Connect MS SQL Server

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Mar 25, 2011 at 06:06 PM

    Hi,

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

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

    • 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