Skip to Content
Author's profile photo Marc DANIAU

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:

Assigned tags

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