New features in Installation, Security, Administration, Data Provisioning are included in SPS 10 Revision 100 of SAP HANA.
Text mining now could be done using SQL functions. In the current revision , you could use "TM_GET_RELATED_TERMS" to find out top ranked terms which is related to current term used for the text mining. In the same way , "TM_GET_RELATED_DOCUMENTS" SQL function is for finding our top ranked documents related to the current document. Not only that, through the SQL functions a set of documents could be categorized.
A new group of audit actions is added in this revision. You can perform audit on extended storage using the audit action group "SAP HANA Dynamic Tiering" . This release of SAP HANA Dynamic Tiering could be installed an SAP HANA System with multi-tenant database mode and ofcourse each tenant database with dynamic tiering requires its own dedicated dynamic tiering host.
Automatic failover is working in this revision, it is initiated when the dynamic tiering worker and standby hosts are allocated to the same high availability group. If they are assigned to different groups, then also failover could be triggered through a manual process. Users could change the assigned group names using SAP HANA Studio.
Three new pre-delivered data provisioning data adapters are added in the Revision 100 and they are SAP ASE , Teradata and SAP HANA. Using these adapters , you could write back to a virtual table using Data Sink node in a flowgraph, applicable for some remote resources. DDL changes from remote sources are propagated to SAP HANA in real time.
Without defining table ranges, generic parallel replication of a table is possible using the replication scenarios - via ODP framework , into PSA Storage , into SAP DB Schema , into a SAP ABAP-based system (table based) , a SAP ABAP-based system into the Application layer .
Now, syntax checking of rule definitions could be done while doing the replication, this has come as an advanced replication setting.
Creation of dedicated SAP HANA Service in the smart data streaming is introduces as a new feature to simplify the connections to SAP HANA Databases. To create the dedicated service , you need to create ODBC service before you want to enable it for SAP HANA. Smart data streaming server you want to connect also needs to be of the version SPS10 or later.
There are many more enhancements and new additions are done in SPS10, it could not be demonstrated in a topic , each point could make a complete article, We tried to be brief and to show some glimpse of it.