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

[Former Member]

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.

[RobertWaywell]

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?

[Former Member]

Hi,

Thanks for your reply.

1) Ideally I would like to create the tables through Designer

2) I will be inserting/updating/deleting data

3) Yes I have, there is a temporary table function which I can use to make tables in the target datastore, which is the what I hope to push to the warm data store.

[RobertWaywell]

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