Skip to Content

How to connect BW HANA with external non-SAP Sybase database? Use ASE SDK version or not?

Nov 03, 2016 at 09:15 AM


avatar image
Former Member

Hello, SAP Experts,

New System: BW on HANA

OS: IBM Power Linux 64bit

Old external non-SAP system: Sybase database

Now we would like to connect external Sybase database with BW on HANA . The BW application server is residing on IBM Power Linux.How should we do? also use which connection method?

Shall we use ASE SDK version in order to connect to SAP ASE from ODBC-based applications?

2093510 - How to Download Free SDK for SAP ASE [Windows, Linux, Unix]

Thank you!


10 |10000 characters needed characters left characters exceeded
Former Member

Can we install


in order to connect to external non-SAP Sybase database?

Also use ODBC connection?

* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ismael Cardoso
Nov 03, 2016 at 11:23 AM

Hey there,

I would suggest to integrate your Hana with Sybase using SDA/SDI.

You can check SAP Note 1868209 - SAP HANA Smart Data Access: Central Note


10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 03, 2016 at 11:30 AM

Whats a "non-SAP system: Sybase database" ?

Sybase is aka "SAP ASE"

Show 1 Share
10 |10000 characters needed characters left characters exceeded

SAP ASE for Business Suite = SAP Systems - ABAP and/or Java Application Servers - (ERP, CRM, SRM, Solution Manager, etc) running on SAP ASE ("Sybase database" ). For ABAP stacks, there is also an integration at ABAP coding level (ie DBA Cockpit).

SAP ASE for custom applications = non-SAP systems running on SAP ASE. Used by historical Sybase customers with their own applications.

Avinash Kothare Nov 03, 2016 at 05:38 PM

I would suggest a slightly different approach.

Looking at ASE tables from HANA is by using proxy table mechanism.

Any queries that join tables across servers are bound to be slow.

Instead if you can populate equivalent tables on HANA side by a mechanism like replication server (almost real time changes can be seen)

or batched copy of data for the set of tables.

Replication route will need some upfront set up work but will be good long term solution.

This way queries on HANA side will not slow down due data access across servers.



10 |10000 characters needed characters left characters exceeded