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

[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!

Hong

[Former Member]

Can we install

SDK for SAP ASE

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

Also use ODBC connection?

[former_member89972]

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

[Former Member]

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

Sybase is aka "SAP ASE"

[crisnormand]

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.

[cardoso]

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.