The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"DB2 ODBC"

agurruchagaagurruchaga Member Posts: 11 Contributor I
edited June 2019 in Help

Good Morning,

 

I am trying to connect to a DB2 database via ODBC but I keep getting "No suitable driver found" error. Can anyone explain what's the configuration to make it work? 

Thanks

Tagged:

Answers

  • Pavithra_RaoPavithra_Rao Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 123 RM Data Scientist

    Hi @agurruchaga,

     

    RapidMiner can connect to any database having JDBC Drivers.

    I found that IBM DB2 does provide JDBC Drives. Here is the link to download it.

     

    The following articles provide instruction on How to add JDBC driver and connect from RapidMiner Studio.

     

    How do I add database drivers for new databases in RapidMiner Studio

     

    How to Connect a Teradata Database to Studio?

     

    Cheers,

    Pavithra

     

     

  • agurruchagaagurruchaga Member Posts: 11 Contributor I

    Thank you. I made some progress but still can't connect properly. I am getting the following error : 

    image.png

    I've found that the problem is the DB is not finding the schema so it doesn't find any tables. The issue is I don't know how to configure schema name/separator. Any clues?

     

    Thank you.

Sign In or Register to comment.