Skip to Content

How to configure datastore to push tables to extended storage/dynamic tiering

Hi,

I would like to check if it is possible to configure the datastore in SAP Business Object Designer such that the tables will reside in the extended storage/dynamic tiering in SAP HANA instead of the default in-memory destination.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 24, 2017 at 12:50 PM

    I'm not particularly familiar with BOBJ Designer. I did take a short look a that BOBJ Universe Design Tool user guide. Is that the same tool or should I be looking at something else?

    A couple of questions that I have for you:

    1) Are you creating tables through Designer or all those already created?

    2) Are you inserting/updating/deleting data through Designer or are you just selecting existing data?

    3) If you are creating tables through Designer, do you have the ability to customize the CREATE TABLE... SQL statement that is generated?

    Add comment
    10|10000 characters needed characters exceeded

    • Temporary tables usually only exist for the duration of a connection. I'm not sure that's what you want.

      However, if you can control the SQL statement used to create the table, the you will be able to define the table partitions including specifying the storage location - DEFAULT STORAGE or EXTENDED STORAGE - for each partition.

      Part 8 of the Getting Started with Dynamic Tiering tutorial group will walk you through the the CREATE TABLE syntax to create a multi-store table. Getting Started with SAP HANA Dynamic Tiering