About RobertWaywell

RobertWaywell · 12-18-2023

SAP HANA dynamic tiering (“DT”) was the first SAP HANA feature introduced to provide the ability to tier data between HANA in-memory storage and disk based storage. The customer response to DT confirmed that SAP HANA customers wanted and needed to sc...

RobertWaywell · 11-22-2022

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 S...

RobertWaywell · 09-09-2021

SAP is pleased to announce the latest release of SAP IQ - Version 16.1 SP 05 is now available! This latest SP includes various enhancements such as: New client/connection security options SAP IQ servers now support encrypted TDS conne...

RobertWaywell · 04-16-2019

With the exponential growth of data showing no signs of slowing, customers looking to lower their total cost of ownership (TCO), while still leveraging their vast reservoirs of data to maximum effect, must continuously manage their data storage costs...

RobertWaywell · 01-08-2019

CCL or Continuous Computation Language is the scripting language used to develop projects for HANA streaming analytics and Streaming Lite. CCL is derived from SQL which helps with the learning curve for experienced database developers who are startin...

RobertWaywell

Take a look at the JSON_TABLE function. It will present the result of the function as a table structure which can then be referenced as a table in other queries: JSON_TABLE Function (JSON)

RobertWaywell

You are going to have to check the IBM documentation to find out what databases their product supports. This page mentions supporting "Sybase" which could refer to old versions of SAP ASE or possibly old versions of SAP IQ.https://www.ibm.com/product...

RobertWaywell

The most likely reason for only getting 5 names is that the query " SELECT DISTINCT EMPLOYEE_NAMES FROM "H_CPO_MAIN"."TABLE_NURO";" is only returning 5 values. Have you run the query outside of the procedure to check the result set?

RobertWaywell · 03-12-2024

I took a quick look at the Appian documentation and it appears that you should be able to use a JDBC connection: https://docs.appian.com/suite/help/24.1/Connected_System_Object.html I would not recommend using HANA streaming analytics. HANA streamin...

RobertWaywell · 03-07-2024

A growth rate of 50 - 100 GB per year would be considered relatively small. A HANA Cloud, HANA database using NSE can readily support up to at least 10 TB of data and for a pure archiving use case then you can scale beyond that.

User Statistics

User Activity

SAP HANA Dynamic Tiering is Deprecated

Top 5 Reasons to Migrate SAP IQ Systems to SAP HANA Cloud, Data Lake

SAP IQ 16.1 SP 05 is now available

SAP HANA Native Storage Extension: A Native Warm Data Tiering Solution

CCL Tips and Techniques: Sampling - Output every N seconds

Re: HANA DB usage of JSON embedded functions

Re: IBM Security Guardium

Re: Unable to fetch Distinct values into the For loop in SAP HANA.

Re: API to connect data from HANA to APPIAN

Re: [HANA CLOUD] How to back up a schema from PRD and imp...