Last post Apr 09, 2009 02:20 PM by haggisns
Apr 09, 2009 02:20 PM|haggisns|LINK
We are using TM1 Planning Server (formerly Aplix) now owned by Cognos.
There product support DNS Aliases if you are using only one server.
However, we would would like to have an easier disaster recovery plan.
Currently we copy all the data from a data folder onto our DR server every half hour.
in the event of a disaster, we make some config changes to the server then using the TM1 management software have to
go into every single excel sheet and change the links (TM1 propietary controls using an Excel ADD-IN) to point to the name of the DR Server.
TM1 web application basically converts excel spreadsheet data into xml on the server then renders the xml into HTML and sends it to the browser as html tables.
Users then can make updates to the grid and send cell edits back to the server.
I was wondering if httphandler could be written to that when it sees any reference to say : friendlyservername, it replaces it with realservername just before it sends
it off to the browser. In this way, if a disaster is ever declared I won't have to change hundreds of URL links in excel spreadsheets to point to different server name.
I have done lots of tests and their software only supports DNS on the one server, not if you copy the system over to another servername. They also don't support relative referencing,
their proprietary way of creating the links, creates full path names only.
Cognos seems to believe we are a special case and likely won't fix their product to support the above scenario.
Is it possible to write an httphandler and register on my IIS server to change server name to something different?
I'd be happy to give a code snippet to Cognos and see if they can implement it for us :). If I do the leg work maybe they'll put it in.