Top 5 Reasons to Migrate SAP IQ Systems to SAP HANA Cloud, Data Lake
It’s pretty well known that SAP HANA Cloud, data lake is built on the foundation of on-premise SAP IQ which makes it the perfect choice if you’re thinking about migrating your existing SAP IQ systems to the cloud. You don’t have to move, on-premise SAP IQ continues to be fully supported with SAP having committed to keeping version 16.1 in mainstream maintenance through at least 2027-12-31. However, it takes a lot of effort to maintain an on-premise database system and migrating to a cloud deployment provides the opportunity to offload a lot of critical but time consuming administration and maintenance tasks to the cloud service, which then frees up your database team to focus more time on higher value database development activities.
If you are thinking about migrating your on-premise SAP IQ system to the cloud, here are my picks for the top 5 benefits of moving to SAP HANA Cloud, data lake.
Ease of provisioning
Provisioning a new database in an on-premise environment is never a simple task. Even if you have software licenses already available you still have to go through the hardware procurement process, getting multiple quotes from vendors, waiting for delivery once a purchase order is submitted, and waiting for the hardware to be set up. The overall process usually takes a few months and depending on your hardware refresh cycle, it has to be repeated every 3-5 years.
With SAP HANA Cloud, data lake it takes just a few minutes from clicking Create Instance to having a running database, and perhaps best of all – you NEVER have to upgrade the hardware.
Near Zero Downtime Upgrades (NZDU)
Speaking of upgrades, hardware isn’t the only thing that needs to be upgraded when running your on-premise system. The database software has to be upgraded too, and that certainly happens more frequently than the hardware upgrades.
One of the bigger pain points in the execution of software upgrades of mission critical systems is scheduling and managing the system downtime, often having to align with very tight maintenance windows.
This is an area where SAP HANA Cloud, data lake provides real innovation leveraging control of the cloud infrastructure along with the fact that every SAP HANA Cloud, data lake instance is a multi-node scale out or multiplex system to execute a rolling NZDU that maintains read access to the system throughout the process.
Flexible scaling of compute
Coming back to the topic of provisioning, one of the challenging aspects of any on premise system is sizing. Hardware purchases, for both the server hardware and the storage hardware, are pretty inflexible. Sure, you can use virtualization software to deploy multiple smaller systems on a single server, but when you are deploying a database system that could scale to 10’s or 100’s of TB, or even PBs then sharing servers really isn’t an option.
If you are working with a mature on-premise database, then you likely have a good idea of how the data volume will grow over the next 3-5 year hardware cycle. However, if you’re standing up a new system your data volume and workload estimates might be solid for the first year but get less and less reliable the further out you look.
With an on-premise system you usually end up buying and provisioning a system that is over sized for the first year, that you hope the business will grow into over the hardware lifecycle, but which could end up being undersized before the end of the cycle.
Migrating your SAP IQ system to an SAP HANA Cloud, data lake system provides the ability to scale your compute resources – vCPU and memory – up or down as needed. Scaling can be done vertically or horizontally, either increasing the size of worker nodes or adding more worker nodes to the system.
Automatic storage resizing
One of the characteristics of SAP IQ that has felt outdated to me for a long time is the need to pre-allocate storage space in the form of dbspaces made up of multiple dbfiles. Monitoring the available space, and adding dbfiles as needed to grow the storage volume isn’t a difficult task but it is “one more thing” you have to do when administering an on-premise SAP IQ system.
That task goes away when you migrate to SAP HANA Cloud, data lake with the required storage volume being automatically allocated as you add data to the database. This also benefits your cost of ownership compared to an on-premise SAP IQ system because with SAP HANA Cloud, data lake you are only charged for the storage volume that you are currently using.
<Sorry, no picture for this one because you don’t
have to manage your storage volume. 😊>
Another cost benefit of migrating your on-premise SAP IQ system to SAP HANA Cloud, data lake Relational Engine is reducing the per unit cost of the storage volume. The performance of any disk based database is directly impacted by the throughput of the disk I/O and on-premise SAP IQ systems are normally provisioned on SSD storage to optimize throughput. In contrast, SAP HANA Cloud, data lake Relational Engine uses cloud native object storage, storing each database page as an object. This takes advantage of the huge bandwidth reading from cloud native object storage to greatly reduce the cost of storing TBs or PBs of data in SAP HANA Cloud, data lake Relational Engine while maintaining, or in some cases even improving query performance.
If eliminating the task of managing your dbspaces and reducing your storage costs isn’t enough, SAP HANA Cloud, data lake has another big storage enhancement over on-premise SAP IQ. With SAP HANA Cloud, data lake the storage volume automatically shrinks when you delete or truncate data from the system. This is done in 1 TB increments so you have to be removing a meaningful volume of data, but it means that your storage volume, and therefore your storage cost, will adapt over time as you data volume grows and shrinks.
Cost effective backups at scale
Managing database backups for an on-premise database system like SAP IQ can be a complicated and time consuming administrative task. The storage cost for maintaining a rotating set of full and incremental backups for an SAP IQ database of 10’s or 100’s of TB, or even PBs could also be overwhelming, especially if you had to keep duplicate copies of the backups at another physical data center for disaster recovery.
The use of cloud native object storage by SAP HANA Cloud, data lake Relational Engine revolutionizes the way that backups are made. With cloud native object storage SAP HANA Cloud, data lake takes advantage of a ‘copy on write’ feature that makes a snapshot of each object whenever it is updated or overwritten. Since each database page is written to storage as a unique object, that means each database page is individually backed up whenever a change is written out. SAP HANA Cloud, data lake still uses a combination of full and incremental backups for the catalogue database but there is no longer any need to make a full backup of the “user_main” dbspace and your total backup storage volume will consist of just the changed database pages plus the catalogue database backups.
Cloud native object storage also provides disaster recovery support since the storage volume is redundant across multiple availability zones, and therefore multiple data centers, within a hyperscalar region.
Hello Robert Waywell
well, your 5 reasons to migrate an existing IQ which is used for NLS/DTO and ILM has some mayor points not included:
Your Top 5 Reasons to review:
=> ever heard of Q – the easy Installer for SAP IQ
=> a binary upgrade of an on-premise IQ is as "fast/slow" as with SAP HANA Datalake and why must a customer in an automated solution plan an Upgrade?
=> simply add CPU/RAM controlled by IQ settings -
Note 3017355 – SAP IQ 16.1 SP04 PLx – correct SAPIQDB.cfg settings
=> same with on-premise IQ, called "reserved size" and enable SAP IQ for DBACOCKPIT can create additional user DB spaces with reserved size as well
=> also the DBACOCKPIT for IQ handled this for you and also automated with Q – the easy Installer for SAP IQ
Finally: does your migration path include the migration of NLS/DTO and ILM stored data?
no offence, but this need a little bit more beef to add until 2027-12-31 which you state as the mainstream end of IQ 16.1 SP05. Do you already know if this is the last release of IQ 16.1?
Note 2355295 - SAP IQ 16.0 and SAP IQ 16.1 SP Maintenance and Support Policy
Best Regards Roland
At this time BW/4HANA team has not yet implemented support for on premise BW/4HANA DTO to use SAP HANA Cloud, Data Lake Relational Engine as a storage option. As with all other SAP products, the strategic focus is on the cloud offerings in the form of SAP Data Warehouse Cloud including SAP BW Bridge for Data Warehouse Cloud. The BW and DWC teams are planning to implement a data tiering capability for BW Bridge which will leverage SAP HANA Cloud, Data Lake.
Similarly, while the S/4HANA ILM team has not yet certified SAP HANA Cloud, Data Lake as a storage tier for on premise S/4HANA ILM, they are working on implementing a cloud native ILM capability for S/4HANA Cloud which will also leverage SAP HANA Cloud, Data Lake.
thanks for the clarification. So which kind of IQ on-premise implementation are you targeting?
best regards Roland