If you are unable to create a new account, please email support@bspsoftware.com

 

Framework Manager: creating data source for Exasol IMDB

Started by eroor, 28 Jun 2017 06:51:25 AM

Previous topic - Next topic

eroor

Hello,
I'm trying to use an Exasol IMDB data source to create a package with framework manager 11.0.6. I have created Exasol data server connection in Cognos 11.0.6 and successfully tested it. Now, if I try too use this connection in framework manager I get an error: BMT-IMP-0002 Failed to execute metadata request. invalidDriverLocationCAF-WRN-2082 An error has occurred. Please contact your administrator.
It seems, FM cannot detect Exasol jdbc driver, but the driver is inside "drivers" folder and like I said, testing the connection from Cognos Analytics was successful. I also tested FM witch SQL Server and had no problems using the connection and creating a package.
I know Exasol is somewhat exotic DB, but it was Cognos certified and should be working.
Best regards

MFGF

Quote from: eroor on 28 Jun 2017 06:51:25 AM
Hello,
I'm trying to use an Exasol IMDB data source to create a package with framework manager 11.0.6. I have created Exasol data server connection in Cognos 11.0.6 and successfully tested it. Now, if I try too use this connection in framework manager I get an error: BMT-IMP-0002 Failed to execute metadata request. invalidDriverLocationCAF-WRN-2082 An error has occurred. Please contact your administrator.
It seems, FM cannot detect Exasol jdbc driver, but the driver is inside "drivers" folder and like I said, testing the connection from Cognos Analytics was successful. I also tested FM witch SQL Server and had no problems using the connection and creating a package.
I know Exasol is somewhat exotic DB, but it was Cognos certified and should be working.
Best regards

Hi,

Can you check to see if you have the "Import relational metadata" capability granted, as per the below technote:

http://www-01.ibm.com/support/docview.wss?uid=swg21624136

Cheers!

MF.
Meep!

eroor