Skip to Content
0

How to connect SQL Server to SAP ByDesign

Jul 24, 2017 at 11:41 AM

117

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Luis Darui
Jul 24, 2017 at 11:41 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded