Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Polish

Jeśli masz problem ze zrozumieniem jak działa zadanie zaplanowane, sprawdź opis: Zadanie zaplanowane

Panel
titleOpis

Zadanie zaplanowane pozwalające na przepisanie danych ze źródła danych do bazy danych.

Panel
titleWymagania

Co najmniej jedno zdefiniowane źródło danych umożliwiające operację odczytu danych.

Panel
titleParametry konfiguracyjne
Nazwa parametruTyp parametruOpisUwagi i ograniczenia
Id źródła danych*Tekst Id źródła danych z którego dane zostaną przpisane. 
Nazwa bazy danych*Tekst

 Nazwa bazy w której dane zostaną zapisane.

 
Nazwa schematu w bazie danych*Tekst Schemat w bazie danych, w którym znajduje się tabela docelowa.

 

Nazwa tabeli*Tekst Nazwa tabeli w której zostaną zapisane dane. 
Mapowanie parametrów*Tekst  Mapowanie parametrów źródła -> bazy.

Kolejne mappingi powinny być rozdzielane za pomocą przecinka np.

pierwszaKolumnaZeŹródła=pierwszaKolumnaZBazy,drugaKolumnaZeŹródła=drugaKolumnaZBazy

Typ synchronizacji*Tekst  KluczTekst Typ synchronizacji danych.

Do wyboru są następujące rodzaje:

  • insert- tylko dopisuje,
  • overwrite- usuwa wszystkie rekordy i dodaje nowe,
  • upsert- dopisz lub zaktualizuj, jeżeli wartość podana w parametrze "Klucz" już istnieje.
KluczTekstKlucz, którego wartosć będzie sprawdzana przy typie synchronizacji "upsert". 

Parametr*- pole wymagane

 

Panel
titlePrzykładowa konfiguracja

Image Added

 

 

English

← Return to the list of available setters

← Return to the list of available applications 

Info

If you have trouble understanding how the action works, check the descriptions: Application, Setter, Conditional execution, Component parametersdescriptionScheduled task

Category:

Action location:

Available from version:
Panel
titleBasic information
Description

A scheduled task that allows you to rewrite data from a datasource to a database.

 
Panel
titleDescription
Requirements

One or more defined data sources that enable the data read operation.

Panel
titleConfiguration parameters
Name of the parameterParameter typeDescriptionNotes and restrictions
Domain nameDatasource id*TextDomain we are trying to connect toId of the datasource from which the data will be rewritten. 
Base DNDatabase name*TextA Distinguished Name (DN) represents a signle object or whole container in hierarchical directory, at which the DN is written from lower to higher hierarchical levels from left to right e.g. CN=John Smith, OU=consultants. The DC values (Domain Component) have to be skipped in this parameter. 
Import filter*TextImport filter allows to enter criteria to narrow down the search results for objects in the domain. Objects are selected based on the entered attribute values of the objects in the filter

Filter syntax:

(attribute operator value)

 

Atrybuty:

  • cn (user common name),
  • sn (surname),
  • telephoneNumber,
  • l (localization),
  • objectCategory,
  • objectClass.

 

Operatory:

  • = (Equality),
  • \>= (Greater than or equal to),
  • <= (Less than or equal to),
  • =* (Presence),
  • ~= (Approximate),
  • & (AND),
  • | (OR),
  • ! (NOT).

 

Przykłady użycia:

  • (cn=John Smith) returns object, which common name "John Smith",
  • (ObjectClass=*) returns all objects,
  • (&(objectCategory=person)(objectClass=user)(!(cn=John Smith))) zwraca wszystkich użytkowników oprócz użytkownika "Jan Nowak",
  • (sn=sm*) returns all objects with a surname that starts with "sm",
  • (&(objectCategory=person)(objectClass=contact)(|(sn=Nowak)(sn=Kowalski))) returns all contacts with a surname equal to "Smith" or "Johnson".
Default group*TextName of the group to which the users will be assgned if the Add to default group parameter is set to true 
Add to default group*TextDetermines if users have to be added to the specified default group.Enter a boolean value of true or false in the field.
Add to LDAP group*TextUsers will be assigned to the groups on the system that are assigned to them on the LDAP server.Enter a boolean value of true or false in the field.
Create unexisted groups*TextDetermines whether to create groups in the system to which the users imported from the LDAP server belong to. If the option is set to false, the user will be added to the default group if there is no group in the systemEnter a boolean value of true or false in the field.
Synchronize*TextSpecifies if the data on the LDAP server should also be changed on the system after updating. Data update concerns adding, deleting or modifying a user.Enter a boolean value of true or false in the field.
Deactivation of users in selected groups*TextIt allows the deactivation of users in the system belonging to at least one of the groups listed in this parameter. This parameter is important only when the Synchronize parameter is set to true. If there are users in the system that do not exist any longer on the LDAP server, then after running a scheduled task with set synchronization and no indication of user groups to which these users belong, they will not be removed from the system.Enter group names after the semicolon.
Default user*TextDetermining to which user will be assigned substitutions, reports, tasks, views of the deactivated user. If the <superior> value is specified, the user's bindings will be transferred to his superiors, and if the user has no defined superiors, the bindings will go to the system administrator. If the field is left blank, the connections will go to the system administrator. 
Excluded groups*TextGroup names from which a user cannot be removed, even if he is no longer assigned to such a group on the LDAP server. This parameter is relevant only when the Synchronize parameter is set to true.Enter group names after the semicolon.
The name of the database where the data will be saved. 
Schema name in database*TextThe schema in the database where the target table exists. 
Table name*TextName of the table in which the data will be saved. 
Parameters mappings*TextSource -> database mapping
Subsequent mappings should be separated with a comma, e.g. 
firstDatasourceColumn=firstDatabaseColumn,secondDatasourceColumn=secondDatabaseColumn
Synchronization type*TextData synchronization type.

The following types are available:

  • insert (only adds),
  • overwrite (removes all records and adds new ones),
  • upsert (add or update, if the value given in the "Key" already exists).
KeyTextThe key value of which will be checked with the "upsert" synchronization type. 

Parameter*- required field

Panel
titleSample configuration

Panel
titleSample configuration

A sample configuration of the LDAP server in the system that allows to perform a scheduled task with completed parameters as above looks as follows

Image Removed

Image Removed