How to create a data module from data servers

[tfjurgen]

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

[bus_pass_man]

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.

[tfjurgen]

Thank you bus_pass_man, I was able to see the content after I added JDBC drivers into the drivers directory.

[arjunBandi]

how to create jdbc drivrer for 11 cognos

[MFGF]

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.

[prikala]

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.

[MFGF]

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.

[prikala]

Yes, setting that option was first thing  I did (the connection will not show as Data server without it).

[MFGF]

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.

[prikala]

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...

[MFGF]

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.

[bswenson]

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.  ::)