Universe Designer with ODBC Connection on MaxDB 7.7

[Former Member]

I am connecting my database which is on MaxDB 7.7.07 through ODBC connector (version 7.7.07.30) as System-DSN successfully. User is SUPERDBA.

After that I tried to define a universe with Universe Designer:

For the connection I select the generic ODBC-driver as RDBMS-engine and the ODBC connection out of System-DSN as datasource. Connection test is successfull.

I got a list of db-schemas. Adding a table out of SUPERDBA-schema is working fine, but when I try to add a table out of SAP-schema I got an error:

Exception: DBD, (SAP AG)(SDBODBC.DLL)(MaxDB) Base table or view not found;-4004 POS(15) Unknown table name: MARA State: 42S02

Anybody an idea how I can resolve this problem?

Thank you!

Mike

[Former Member · Accepted solution]

Check if SUPERDBA has access to the tables in SAP Schema.

Sowmya.

[Former Member · Accepted solution]

Hello Guys,

Could you please email (manishonline83@gmail.com) me the SAP Universe that you are connecting to MaxDB or at least tell me from where I can download it.

Thanks

Manish