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

 

OLE DB to SQL Native Client with 11.0.3+ versions of Cognos

Started by gohabsgo, 08 May 2017 11:01:46 AM

Previous topic - Next topic

gohabsgo

Hey Folks,
So we made extensive use of OLD DB sql servers connections (i know, i know...) and now with out upgrade to 11.0.6 we're in the process of converting them to SQL Native client (and adding JDBC at the same time).  This all works just fine however..

The issue we have is we have dozens and in some cases hundreds of signons created for each data source.  It seems when you flip the old OLE DB sources (that show up as "other type" after the 11.0.6 upgrade) it wipes out (and warns you that it will do so) all existing connections and signons and they need to be re-entered.  In our case this is extremely painful.

Anyone aware of an easier way to do this?  Are we stuck doing this manually or can this be done perhaps through a script via sdk?

Or worst case, perhaps there is a way for us to take an export of the existing signons for each data source connection?

We're looking to save some pain/time and the probable fat fingers that will make various mistakes along the way if this is a total manual process.

Thanks!

TomCognos