Domain for synchronized users

Hi,

How can I add the domain for all users for SO Analyze? I'm using version 4.1.3.
With older version you can use the user import tool and set a domain.

Reg,
Wouter

Anders
Anders's picture
Adding domain to username

Hi Wouter,

You are correct. There is no a dedicated field/column to provide the domain name in the usersync module.

The way we provide the domain name in usersync module is to add the domain prefix/name to the username column in the datatable which provides data to the usersync definition:

  1. Enter the DataCentral: System Administration -> Analysis Dashboard -> Data Central
  2. Expand the SuperOffice CRM (Seven) datasource and open the "usSuperOfficeCRM" datatable
  3. Change the first column in the query:
a.name as [UserName]

to

'MyDomainPrefix\' + a.name as [UserName]

Replace "MyDomainPrex" with your own domain name/prefix.
ATTN! Remember the backslash between the domain name and the username

  1. Validate the query
  2. Save the datatable
  3. Rerun the usersync definition

I hope that this short description is helpful.
We have a registered feature wish to add a new import field where you can set the domain name in a column from the database or set the domain name for all users in the usersync definition screen. It is not implemented yet so I cannot promise in which release this feature will be included, but I will elevate the issue to a higher priority right away.

Regards,

Anders

w.mak@tignl.eu
Solution

Thanks for your answer. I'll already saw the SQL query, but I didn't know if I may change that and what the consequence are. But the is fast solution.

Thanks.

Wouter

 

Log in to post comments