Hi guys,
I'm trying to create a data module from a data server that's created within the Cognos Analytics, but it gives me the message 'Results are empty' after I selected this data server, what I missed here?? Thnx
1. Confirm that you have your JDBC drivers in the drivers directory. If you don't you will need to add them there and then re-start the cognos service.
2. Confirm that your data server definition is correct. Test it in the dialog. Also see if you can import metadata from it into FM or Cube Designer.
Thank you bus_pass_man, I was able to see the content after I added JDBC drivers into the drivers directory.
how to create jdbc drivrer for 11 cognos
Quote from: arjunBandi on 17 Mar 2016 08:21:51 AM
how to create jdbc drivrer for 11 cognos
JDBC drivers are created by the vendor of the data source. You need to download the relevant driver file(s) and put them into the Drivers folder in your Cognos Analytics instance.
Cheers!
MF.
I wonder what are the limitations for datasources to be used to create data modules?
I am getting "Results are empty" after selecting Data server.
Database is Oracle, jdbc6.jar is located at \Drivers and I can use the connection in FM (C11 version) to create DQM packages so everything should be ok.
Quote from: prikala on 01 Apr 2016 06:32:59 AM
I wonder what are the limitations for datasources to be used to create data modules?
I am getting "Results are empty" after selecting Data server.
Database is Oracle, jdbc6.jar is located at \Drivers and I can use the connection in FM (C11 version) to create DQM packages so everything should be ok.
Did you check the option in the data source dialog to enable the data source for web-based modelling?
MF.
Yes, setting that option was first thing I did (the connection will not show as Data server without it).
Quote from: prikala on 01 Apr 2016 06:54:27 AM
Yes, setting that option was first thing I did (the connection will not show as Data server without it).
Not sure what else to suggest in that case. If you can create DQM packages in FM, that proves the JDBC driver works. I'd log it with IBM support I think.
Cheers!
MF.
Found the reason! My own laziness, I think!
I had used ojdbc6.jar from ancient Oracle 11.2 distribution, dated from 2011.
I replaced it with ojdbc7.jar downloaded directly from Oracle 12.1 download page and now I can see my schemas in db.
Either that or some aggressive caching: I must confess I initially tried to create data module before I placed the odjbc6.jar in the right place. I rebooted the server a few times but that did not help. Waiting over the weekend might have done the trick but replacing the driver was first thing I did this morning...
Quote from: prikala on 04 Apr 2016 12:10:44 AM
Found the reason! My own laziness, I think!
I had used ojdbc6.jar from ancient Oracle 11.2 distribution, dated from 2011.
I replaced it with ojdbc7.jar downloaded directly from Oracle 12.1 download page and now I can see my schemas in db.
Either that or some aggressive caching: I must confess I initially tried to create data module before I placed the odjbc6.jar in the right place. I rebooted the server a few times but that did not help. Waiting over the weekend might have done the trick but replacing the driver was first thing I did this morning...
Good find! Glad you sorted it!
MF.
We are just starting with Cognos. We are looking for how to set the option in the data source dialog to enable the data source for web-based modelling?
Thanks
Found it! I knew as soon I asked it would appear. ::)