SAP Adaptive Server Enterprise (ASE) has been a certified data repository for SAP Business Suite for some time now. You may not know it, but SAP ASE is also certified with SAP BW as the main store as well as with SAP IQ as the Near-Line-Store (NLS) to BW. You can find the report here if you have a support account:
SAP certifies Business Warehouse with SAP ASE database to support SAP IQ ODBC near-line storage
SAP BW running on ASE with IQ as the NLS allows lower TCO by optimizing storage costs. Hot Data, that is information that is read and/or written frequently, is best kept in ASE on faster storage. Warm data, that is information that is infrequently accessed can be kept in ASE on slower, less expensive storage. Cold data, information that is rarely access and never changed, can reside in the IQ NLS in a compressed format on less expensive storage, yet still immediately available to BW if needed. All of this is transparent to the end user. You can learn more about the NLS solution by going here:
SAP BW Near-line Storage Solution (NLS) Based on SAP IQ
Conceptual Architectural Diagram:
- SAP Managed Tags:
3 Comments
