Skip to Content

How to connect SQL Server to SAP ByDesign

We want to pull data from our ByDesign database into a SQLServer database (into a view), because of a need to compare data with data in a totally different database, via Crystal Reports.

Has anyone managed to do this? Our ByDesign consultants managed to publish something for ODATA to connect to in SSMS, but we cannot get an ODATA connection in SQLServer. It just sits there trying to connect but never returns anything (gave up after 30 minutes).

Anyone got any other ideas?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 24, 2017 at 11:41 PM

    Hi Tim,

    If you want to connect to SQL Server to a 3rd party database - I honestly don't know which database vendor runs your ByDesign database, if this is SAP ByDesign, it must be SAP MaxDB. If yes, you just need to create an ODBC connection to MaxDB and then create a linked server from SQL Server to your MaxDB database:

    https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine

    Creating a view couldn't be optimal as it would have to pull the data everytime from the linked server.

    Add comment
    10|10000 characters needed characters exceeded