After a failed attempt to get SMP3.0 to consume a SOAP WS, I'm about to try to directly consume an Oracle DB.
I've followed several tutorials on how to setup the SMP to consume the Oracle DB, after creating the Destination configuration for the Oracle DB, I get the following message: "Connection test failed - Driver class oracle.jdbc.driver.OracleDriver not found".
I already followed several possible fixes for this issue:
I've tried the ojdbc6.jar and ojdbc7.jar. I've tried the generated bundle from eclipse and SMP "create_jdbc_bundle.bat", I've tried to put it directly in the Server\lib folder and also in the pickup folder.
Can anyone explain me why after following all the above tutorial, SAP note and discussion I can't get it to work?