Skip to Content

Accessing SAP HANA tables inside the SYSTEM schema with Automated Analytics

If you are using an SAP HANA test or demo server you may be in a situation where business tables are placed inside the system schema of the system user. By default, Automated Analytics does not expose the system schema. In order to see the system schema you must add to your configuration file the following line:
ODBCStoreSQLMapper.*.AcceptTable.1=.

Depending on the environment, Desktop or Client-server, modify the file:

KJWizard.cfg under
…\SAP BusinessObjects Predictive Analytics\Desktop\Automated\EXE\Clients\KJWizardJNI

KxCORBA.cfg under
…\SAP BusinessObjects Predictive Analytics\Server\EXE\Servers\CORBA

Here is the system schema seen from Modeler:

Be the first to leave a comment
You must be Logged on to comment or reply to a post.