In IBM® Cognos Controller the Datamart database server has to be of the same type as the Cognos Controller database server

In Cognos Controller the Datamart database server has to be of the same type as the Cognos Controller database server, else you might receive an error.

If the Datamart database server is not of the same type as the Cognos Controller database server, then you might receive the following error when you publish to data mart:

Invalid object name 'dmversion'

Make sure that the Cognos Controller database server is of the same type as the Datamart database server.