Skip to Content
avatar image
Former Member

HANA Connectivity to SSM

Dear All,

I was trying to find how can we connect SSM to HANA. I know there is ODBC connector, but need some more detail on it.

Secondly, how would the data be pulled without having BW system on HANA. Will it through procedures in PASS or any other tool ?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 19, 2015 at 05:40 PM

    Muhammad,

    My understanding is that HANA is ODBC compliant and therefore you should be able to treat it as 'just another datasource'.

    Allow HANA to 'crunch' the larger volumes of transactional data to deliver the aggregated values you want to include in SSM. Then create a procedure to load that output via a procedure into PAS.

    Regards

    Colin Cooper

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2015 at 02:11 PM

    Dear Muhammad,

    Yes its possible.

    Via ODBC & also via BODS. Soon you are able to play with it 😊

    Regards,

    Rafikul Hussain

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 12, 2016 at 12:08 AM

    PAS can use a LINKID pointing at an ODBC connection to read almost any RDMS. You write a PAS proc to read the database and in the proc you embed a SQL statement. The result set loads to the PAS model. The PAS help includes examples of this.

    Cliff

    Add comment
    10|10000 characters needed characters exceeded