Skip to Content
avatar image
Former Member

DB connect to SQL server

Hello everyone,

We are trying connect our SAP BW system (Oracle) to an external database (MSSQL server 2000). Is there any dependency that the SAP BW application server should be Microsoft Windows for us to install the MSSQL client? Will DB connect work for us if our AS is UNIX server?

Any help on this is really appreciated.

Thanks & Regards,

Aashish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 26, 2008 at 08:35 AM

    If you want to connect DB to extract data, first you must install the client of you source DB in your BI server, and config the DB-connect in OS by ODBC(MS SQL), and then create a DB-connect source system in BI system.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I did what you said, but the error while I´m trying to extract data from a Business One DB still happen.

      The configuration of ODBC creating a source system with the name of the SBO server, the test was successful.

      Any clue?

  • avatar image
    Former Member
    Dec 25, 2008 at 08:35 PM

    Hi,

    You should not have a problem. We have carried out extracts using DB Connect from MS SQL and DB2 systems into the same BI system.

    Let me know if you need any further information

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2009 at 01:32 AM

    Got it....

    thanks.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Aashish,

      you wrote 'Got it ...' ... so can you tell us, did you manage to connect from a SAP BW Unix AS to MSSQL via DB connect? If yes, can you provide the steps that you followed?

      Regards

      Konrad