Skip to Content

SLT Server installation on HANA DB is feasible ?

Hello SLT Gurus,

We are thinking to install SLT Server standalone system on HANA DB? what is the advantages and disadvantages except HANA cost (is not the concern here).

I hardly seen any customer running SLT on HANA.

Appreciate your inputs

Regards,

Amit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 21, 2017 at 09:51 AM

    Hi

    SLT server is nothing more then a Netweaver ABAP with DMIS component installed. As for any other NW system you could choose any of the SAP Netweaver supported databases. In my opinion both ASE and Hana could be a good option. I will consider to use Hana SLT if it is to be used for a high performance real time case having SLT as a hub in a multi sources and multi target systems scenario. Otherwise ASE database could be the best case and perhaps more affordable in terms of cost.

    Hope it helps
    Best regards

    A.Nunes

    Add comment
    10|10000 characters needed characters exceeded

    • We have noticed a high database load on SLT server. Top expensive statements are coming from following tables:

      DMC_MT_TABLES
      IUUC_TABLES
      DMC_ACT_REC
      DBA_UNDO_EXTENTS
      DMC_ACT_REC_LOG
      IUUC_RS_STATUS
      DMC_STREE
      BALDAT
      DMC_LOG_INDEX
      DMC_RFC_SETTINGS

      We are currently running our SLT server on Oracle. Can we expect performance improvement by migrating to HANA. Does SLT coding have been optimized to run on HANA?

      We have in mind to use ODP framework in the future and so, increase SLT database usage for ODQ temporary persistence. Does ODP/ODQ have been optimized to run on HANA as well?

  • avatar image
    Former Member
    Jun 20, 2017 at 04:05 PM

    Hi,

    SLT is used to Replicate data from SAP or Non-SAP systems into HANA. This can be Real Time or scheduled.

    One of the main uses of using SLT is to provide data to SAP HANA for BI purposes. So that live dashboards can be kept up to date with transactional data.

    It is also used as the data transfer tool for many SAP products like BW and SAP Accelerators.

    Few other uses:

    • Real-time ( and scheduled) data replication.
    • Ability to migrate data into HANA format while replicating data in real time.
    • Unlimited release coverage (from SAP R/3 4.6C onwards) sourcing data from ABAP based SAP Applications.
    • Handling of cluster and pool tables.
    • Automatic non-Unicode to Unicode conversion during load/replication.
    • Table settings and transformation capabilities (such as filtering data, enriching table structure, make data anonymous)
    • Fully integrated with HANA Studio.
    • Enhanced monitoring capabilities via SAP Solution Manager and Mobile App SAP Replication Manager.

    You can find more about SLT here -> https://archive.sap.com/documents/docs/DOC-59784

    Hope this helps.

    Regards,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Manoj,

      I fully understand the SAP SLT Usage, its simple question - whether we can INSTALL SLT on HANA DB not Oracle or SAP DB etc. ? We going to use SLT for SAP CAR and ECC integration with HANA.

      Thanks,

      Amit

  • avatar image
    Former Member
    Jun 21, 2017 at 07:57 AM

    Dear Amit,

    Before plan to install SLT, you can get features about SAP Data Services and SAP SLT and plan your customer compatible.

    Regards,

    V Srinivasan

    Add comment
    10|10000 characters needed characters exceeded