Skip to Content
0

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

Nov 03, 2016 at 09:15 AM

250

avatar image

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!

Hong

10 |10000 characters needed characters left characters exceeded

Can we install

SDK for SAP ASE

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

Also use ODBC connection?

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

3 Answers

Ismael Cardoso
Nov 03, 2016 at 11:23 AM
0

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

BR.

Share
10 |10000 characters needed characters left characters exceeded
Mike Willett Nov 03, 2016 at 11:30 AM
0

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.

0
Avinash Kothare Nov 03, 2016 at 05:38 PM
0

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.

HTH

Avinash

Share
10 |10000 characters needed characters left characters exceeded