Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
tutorial:adm:systems_db_treenodes [2018/03/05 08:50] stloukalp |
tutorial:adm:systems_db_treenodes [2018/08/27 13:16] klementm |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Systems - DB: TreeNodes (org. structure) synchronization ====== | ||
+ | ===== What do you need before you start ===== | ||
+ | * You need install **CzechIdM 7.7.0** (and higher). | ||
+ | * You need be logged in as **admin**. | ||
+ | * You need enable **ACC** module. | ||
+ | * You must have database **jdbcTest** with table **organizations**: | ||
+ | < | ||
+ | CREATE DATABASE " | ||
+ | WITH OWNER = idmadmin | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | </ | ||
+ | < | ||
+ | CREATE TABLE public.organizations | ||
+ | ( | ||
+ | id character varying(255), | ||
+ | code character varying(255), | ||
+ | name character varying(255), | ||
+ | parent character varying(255) | ||
+ | ) | ||
+ | WITH ( | ||
+ | OIDS=FALSE | ||
+ | ); | ||
+ | ALTER TABLE public.organizations | ||
+ | OWNER TO idmadmin; | ||
+ | </ | ||
+ | * And add two records: | ||
+ | < | ||
+ | INSERT INTO public.organizations( | ||
+ | id, code, name, parent) | ||
+ | VALUES (' | ||
+ | |||
+ | INSERT INTO public.organizations( | ||
+ | id, code, name, parent) | ||
+ | VALUES (' | ||
+ | </ | ||
+ | |||
+ | ===== Create and edit DB system ===== | ||
+ | We have completely empty organization' | ||
+ | {{ : | ||
+ | Now we go into **Systems** agenda and add new system. Click on green button **Add**. | ||
+ | {{ : | ||
+ | Fill **System name** and at bottom of page there is green button **Save and continue**, so click on it. | ||
+ | {{ : | ||
+ | Go to **Configuration** tab and fill in information about your database. Ours are as such: | ||
+ | < | ||
+ | ^ Host ^ jdbc: | ||
+ | | Port | 5432 | | ||
+ | | User | idmadmin | ||
+ | | User Password | ||
+ | | Database | ||
+ | | Table | organizations | ||
+ | | Key Column | ||
+ | | JDBC Driver | ||
+ | | JDBC Connection URL | jdbc: | ||
+ | </ | ||
+ | {{ : | ||
+ | Then go to tab **Scheme** and generate scheme. | ||
+ | {{ : | ||
+ | Then go to **Mapping** and click on **Add** button. | ||
+ | {{ : | ||
+ | Now fill in information from picture bellow and click on **Save and continue**. | ||
+ | {{ : | ||
+ | At the bottom of page, there are mapped attributes. We are going to add 4 attributes: | ||
+ | < | ||
+ | ^ Attribute in schema ^ Name ^ Identifier ^ Entity attr. ^ Extended attr. ^ Entity field ^ IdM key ^ | ||
+ | | code | code | false | true | false | Code (String) | ||
+ | | name | name | false | true | false | Name (String) | ||
+ | | parent | ||
+ | | id | id | true | false | true | ||
+ | </ | ||
+ | |||
+ | Fill "code, name, parent" | ||
+ | |||
+ | <note warning> | ||
+ | |||
+ | {{ : | ||
+ | But " | ||
+ | {{ : | ||
+ | Now we have 4 mapped attributes: | ||
+ | {{ : | ||
+ | Go to tab **Synchronization** and **Add** new synchronization. | ||
+ | {{ : | ||
+ | Fill the form as in the picture below and click on **Save and continue**, then click on green **arrow** and option **Save and run sync** will show up, so click on it: | ||
+ | {{ : | ||
+ | Confirm start synchronization: | ||
+ | {{ : | ||
+ | Wait a few seconds, so synchronization can finish its job. And then go to **Organization** section (in the left menu). And there is now organization tree from the database. | ||
+ | {{ : | ||
+ | If you have it in a state like in the upper picture you successfully complete this tutorial. | ||
+ | |||
+ | < |