Add/Update Multiple Groups

Operation Name

Add/Update Multiple Groups

Function Overview

Adds/updates group based on input data.
Affiliating the data to specified group is also available.

Data Model

XML type.
For more details on input output schema, refer to "Schema".

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required/Optional Use of variables Description Remarks
Name Required Not available
 
Input data Required Not available Select a component on the script canvas.  
Required settings
Item name Required/Optional Use of variables Description Remarks
Destination Required Not available Select a global resource.
For more details on global resource settings, refer to "Global resource properties".
  • [Add]:
    Adds a new global resource.
  • [Edit list]:
    Enables to edit the global resource settings in "Edit resource list".
 
Update accounts that match the value of the Search key Optional Not available Search input data of items that [Search key] is selected as criteria, then select whether to update if matching accound exists.
  • [Not checked]:(Default)
    Delivers input data to Mapper without update.
  • [Checked]:
    Updates input data of items that [Update object] is selected.
 
Search key/Update object Required - Specify the item regarded as search key and the item regarded as Update object.  
Search key/Update object/Search key Optional Not available Select the item regarded as search key.
  • [Checked]:
    Regards as a search key.
  • [Not checked]:(Default)
    Not regards as a search key.
  • Criteria will be a match with corresponding item of input data.
  • If multiple rows are selected, it will be AND criteria.
Search key/Update object/Update object Optional Not available Select the item regarded as Update object.
  • [Checked]:
    Regards as an Update object
  • [Not checked]:(Default)
    Not regards as an Update object.
 
Search key/Update object/Item name Required Not available Display item name.  
Search key/Update object/Item name(Japanese) Required Not available Display item name(Japanese).  
Comments
Item name Required/Optional Use of variables Description Remarks
Comments Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.
 

Schema

Schema definition

Input schema

<?xml version="1.0" encoding="Shift_JIS"?>
<activedirectory>
<group>
  <cn></cn>
  <sAMAccountName></sAMAccountName>
  <groupType></groupType>
  <groupNameIncludedMember></groupNameIncludedMember>
  <description></description>
  <mail></mail>
  <info></info>
</group>
</activedirectory>
Item name Item name(Japanese) Remarks
cn Group name
  • Since group name cannot be updated, it cannot be used as [Update object].
  • Maximum character string length for settings is 64 characters.
sAMAccountName pre-Windows 2000 group name
  • Maximum character string length for settings is 256 characters.
groupType Group type
groupNameIncludedMember Belonging group name
  • Specify affiliated group name.
  • If specifying multiple groups, set up by using "," (comma) to separate and enclose it with ""(double quotation).
  • Because "," is used as delimiter, Group name that includes "," cannot be specified.
  • It cannot be used as [Search key].
description Description  
mail E-mail  
info Notes  

Output schema

<?xml version="1.0" encoding="Shift_JIS"?>
<activedirectory>
<group>
  <cn></cn>
  <sAMAccountName></sAMAccountName>
  <groupType></groupType>
  <groupNameIncludedMember></groupNameIncludedMember>
  <description></description>
  <mail></mail>
  <info></info>
</group>
</activedirectory>
Item name Item name(Japanese) Remarks
cn Group name  
sAMAccountName pre-Windows 2000 group name  
groupType Group type
groupNameIncludedMember Belonging group name  
description Description  
mail E-mail  
info Notes  

Loading Schema on Mapper

Schema is loaded automatically
For more details, refer to "Edit schema".

Mass Data Processing

Mass data processing is not supported.

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available Component Variables

Component variable name Description Remarks
register_count Stores the number of data that are registered.
  • Default value is null.
update_count Stores the number of data that are updated.
  • Default value is null.
skip_count Stores the number of data that did not registered/updated.
  • Default value is null.
message_category Stores the category of message code corresponding to the occured error.
  • Default value is null.
message_code Stores the code of message code corresponding to the occured error.
  • Default value is null.
message_level Stores the severity of message code corresponding to the occured error.
  • Default value is null.
error_type When an error occurs, the type of error occurred will be stored.
  • Default value is null.
  • Error is represented in the format depicted below.
    Example:"java.io.FileNotFoundException"
  • The message may vary depending on the DataSpider Servista version.
error_message When an error occurs, the message of error occurred will be stored.
  • Default value is null.
  • The message may vary depending on the DataSpider Servista version.
error_trace When an error occurs, the trace of error occurred will be stored.
  • Default value is null.
  • The message may vary depending on the DataSpider Servista version or the client application used.

Content of Process Per Settings

Update
row that match
value of the key
Search key Update object Match
data
Process
No update Not selected Not selected/selected Yes/no Register all items of input data that have been set
No update Selected Not selected/selected No Register all items of input data that have been set
No update Selected Not selected/selected Yes Give input data to Mapper without register/update
Update Not selected Not selected/selected Yes/No Register all items of input data that have been set
Update Selected Not selected No Register all items of input data that have been set
Update Selected Selected No Register all items of input data that have been set
Update Selected Selected Yes Update items that [Update object] are selected
If target inputa data is"", set point will be deleted
Update Selected Not selected Yes Nothing will update because [Update object] are not selected

Specification Limits

Main Exception

Exception name Cause Solution
InputDataNotFoundException [Input data] is not specified. Specify [Input data] or draw a data flow.
ResourceNotFoundException
Resource definition could not be found. Name:[]
[Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found. Name:[<name of global resources>]
Resource definition selected in [Destination] is not found. Confirm the global resource specified in [Destination].
InvalidPropertyConfigurationException
Required items for resource is not speficied.
Required items for resource selected in [Destination] is not specified. Specify required items for resource.
InvalidPropertyConfigurationException
Required item is not specified.
Required item is not specified. Specify required items.
InvalidPropertyConfigurationException
It exceeds the maximum length.
Input items for character string length exeeded its maximum value. Enter value within character string length that can set up.
InvalidPropertyConfigurationException
Set point is false. Group type
Value of [Group type] is false. Enter the correct value to[Group type].
InvalidPropertyConfigurationException
Set point is false. Group name(Pre-Windows2000)
Following invalid characters are entered in [Group name(Pre-Windows2000)].
". , / \ [ ] : ; | = + * ? < > ""
Enter the correct value to [Group name(Pre-Windows2000)].
InvalidPropertyConfigurationException
Group name cannot update.
Account that matches [Search key] is already registered and [Group name] is specified in [Update object]. Confirm the settings.
jp.synctrust.util.account.context.ContextException
Cannot register because matching account already exists.
Account that matches [Group name] or [Group name(Pre-Windows2000)] is already registered. Confirm the settings.
jp.synctrust.util.account.context.ContextException
Failed to revise the entry.
[Group name] is revised with a following content.
  • Revise "domain local" to "global"
  • Revise "global" to "domain "local"
Cannot revise the content of cause, take one of the following steps for solution.
  • Revise input data.
  • Unselect [Update object] of Group type from [Search key/Update object].
java.rmi.UnmarshalException Certificate has not been imported in $DATASPIDER_HOME/jre/lib/security/cacerts. It is necessary to import certificate in $DATASPIDER_HOME/jre/lib/security/cacerts.