Problem connecting Rapid Miner 5 to maxdb

Robertk
Robertk New Altair Community Member
edited November 5 in Community Q&A
Hello,

I have got a problem when trying to read data from a maxdb-database (former sapdb).

I've added a new database driver inside Rapid Miner (Tools -> Manage Database drivers) and used the operator "Read Databases". The URL to the database is:

jdbc:sapdb://<dbserver>:7210/<dbinstance>

Unfortunately I get an error when running the process:

"Cannot create example set meta data: Database error occurred: [getTypeInfo][-4004] (at 798): Unknown table name:SYSODBCTYPES."

I tested the connection with another database-program (Squirrel SQL client) with the same url, user and password, which works fine; So I'm assuming that the database-driver itself is not the problem.


Any help on this?

Thank you
Tagged:

Answers

  • land
    land New Altair Community Member
    Hi,
    if you click on the test connection button in the manage Connections dialog, does the green ok icon show up?

    Greetings,
      Sebastian
  • Robertk
    Robertk New Altair Community Member
    Hi Sebastian,

    the connection test also throws an error "[getTypeInfo][-4004] (at 798): Unknown table name:SYSODBCTYPES" (no green light)
  • land
    land New Altair Community Member
    Hi,
    that's a little bit difficult to debug for me without having the MaxDB. You already googled for that error? It's definitivly thrown by the driver and not by RapidMiner, so I cannot say too much to this issue without having it here.

    Greetings,
      Sebastian

Categories