How to connect SQL Server to SAP ByDesign

[Former Member]

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?

[luisdarui]

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-s...

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