We read data from a table in SAP HANA database using Informatica PowerCenter. The connectivity is established by SAP HANA ODBC drivers.
Recently the HANA database is moved from one physical location to other after which we have observed a 50% decrease in the performance of data reading.
There are no other changes in any of the HANA database settings.
When verified with Network team there is no bottle neck in any of the network components.
One suggestion received from network team is to try out changing the packet size of data read from Informatica odbc settings. Is there any such option to modify the packet size for HANA ODBC driver?
Can anyone of you suggest what could have deteriorated the performance?