...
- REST / HTTP: Protocol
- Authentication Type : Basic HTTP
- URL: https://mylab-test.syensqo.com:8443
- Login: (Contact Admin)
- PaswordPassword: (Contact Admin)
(PROD)
- REST / HTTP: Protocol
- Authentication Type : Basic HTTP
- URL: https://mylab.syensqo.com:8443
- Login: (Contact Admin)
- PaswordPassword: (Contact Admin)
Note :
- Get the
...
- list of container IDs
...
- from the Oracle
...
- view, then iterate over it as
...
- an input variable in the URL.
- Container IDs are should be available in this view :IDBS_EWB_SEC.HISTORY_ENTRIES.ENTITY_PATH
Exemple :
- https://mylab-test.syensqo.com:8443/ewb/services/1.0/feeds/entities/ (ContainerID_List)
3.2 Oracle DB
Authentication:
...
- IDBS_EWB_SEC.HISTORY_ENTRIES.TARGET_ENTITY_ID AS Experiment_IDID
- IDBS_EWB_SEC.HISTORY_ENTRIES.ENTITY_PATH AS FOLDERPATH
- IDBS_EWB_SOLVAY_CUSTOM.DM_UserAccessPath_Full AS PERMISSIONS
- DBS_EWB_SOLVAY_CUSTOM.DM_EntityRolePermissions_Full AS ROLES
Note:
The Oracle database connection is enabled for Talend Remote Engines. However, when connecting to the database via a VDI, the connection may be disabled.
3.3 Datalab
- Source: GCP Bigquery table
- Project:
datagrow - gcp-sqo-datalab-(*)
- Dataset: bq_ds_datagrow_dev_ads_static
- Table: application_use
- filter: user
Table and filter: application_use WHERE user- _status='active' AND ROLE IN ('admin', 'lab_manager')
3.4 Target table:
Bigquery: DM.ELN_IDBS_AccessRights
...
- ELN → GCP job: Daily at 02:00 AM (server local time)
- Oracle → GCP job: Daily at 02:00 AM
- Datalab → GCP job: Daily at 02:00 AM
4. Contacts
...
& responsibilities:
- antoine.rey@syensqo.com / ELN Administrator
- prasanth.gnanasekar@syensqo.com / Data Engineering - Flow Maintenance
5. Annexe document:
This annex document could be helpful if you are looking for more details on access rights related to ELN. (link)