Copy clients & passwords

Post Reply
AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Copy clients & passwords

Post by AmbPin »

Hello,

Is it possible to copy sufficient files from one TM1 server to another so as to enable a user to be able to log in to both servers independently but using the same user name and password.

I have one cube server that contains headcount and salary information to which I need to provide restricted access to people who are admin in our main server. What I wondered was can I copy sufficient client files from the main server to the headcount server each morning so that the passwords remain in synch?

Thanks for any help you may be able to provide.
whitej_d
Community Contributor
Posts: 103
Joined: Mon Sep 05, 2011 11:04 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Copy clients & passwords

Post by whitej_d »

Hi,

If it's just the passwords that need copying over, then just the }Clientproperties.cub would do it.

If you need to copy over new users, then }Clients.dim
new group - }Groups.dim

and for user group assignments - }ClientGroups.cub
AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Re: Copy clients & passwords

Post by AmbPin »

Brilliant, thank you.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Copy clients & passwords

Post by tomok »

You need to make sure 1) it's a one-way copy only and 2) you do all your user maintenance (and this also means users changing their passwords) on the main server only.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Copy clients & passwords

Post by lotsaram »

Do you plan to copy the client properties cube wholesale or just export selective content? be aware that the encrypted password values in the client properties cube can contain non-printable break characters that aren't handled at all well within TI variables and depending on version can reliably crash the server on export or import if such values are encountered (which is entirely random as it all depends what passwords users have set.)

You say you're using CAM so simple integrated login is out, but wouldn't you be better served linking CAM to LDAP and having all passwords centrally managed in one place rather than the work-around setup you're proposing?
AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Re: Copy clients & passwords

Post by AmbPin »

I would prefer to use integrated security but unforetunately we dont have a very joined up network yet so its not really practical at the moment.

Copying the }Clientproperties.cub & }Clients.dim as suggested seems to be doing the trick.
Post Reply