Smart Data Streaming: Tenant Database Systems 101
Tenant database systems (previously referred to as “multitenant database containers” or “multiple-container systems”) have been around since 2014 on the SAP HANA Platform. They were first introduced as an SPS 09 optional feature. In the upcoming 2.0 SP 01 release of SAP HANA, tenant database systems will become the new default architecture (see SAP Note 2423367 for information on the switch). For smart data streaming users, this may not affect you as much as you might think: the upgrade itself will have near-zero downtime upgrade options, data will be preserved, and the development process with streaming itself will not have any technical changes.
Quick Overview of Tenant Database Systems
Tenant databases are similar to virtualization in that you have multiple databases. However, with tenants you have multiple physical instances that share resources, and have no need for licensing virtualization software. Your system breaks down into two levels: the system database, which is essentially a system administration layer, and the actual tenant databases. Each tenant is distinct and has its own users, backups, repositories, database catalogs, etc. Tenants save you from potentially having to purchase multiple instances of SAP HANA or virtualize multiple databases to achieve the same effect; this can result in lower costs.
How the Change Affects Smart Data Streaming
Smart data streaming can be provisioned to any tenant database, and works in both low and high tenant isolation modes (high isolation requires authenticated communication between databases, and user separation at the OS level). Some file paths will change as a result of the conversion (see File and Directory Infrastructure). Workflow for creating, editing, starting, and stopping projects will otherwise remain the same. However, you will need to make sure that the users provisioned for your tenant databases have the proper authentications. You can also enable read-only access to other tenant databases, if needed.
How to Upgrade
The conversion to a tenant database system will happen automatically when you upgrade to 2.0 SP 01. If you are not upgrading to 2.0 SP 01, you can still choose to convert to a tenant database system if you are using 1.0 SP 09 – 2.0 SP 00 (see Creating and Configuring Tenant Databases for information). Keep in mind that you can’t revert once the change is done. After the conversion, you’ll have one system database and one tenant database containing all of your original data, retaining everything except for backup history. If you are adding smart data streaming to a system with multiple tenants, you will then need to manually provision the correct tenant.
Check out the SAP HANA Platform documentation, SAP Note 2096000, and the smart data streaming Installation and Update Guide for more information on tenant databases.