User Tools

Site Tools


products:promonitor:6.8:userguide:api:confimportcsv

Import configuration via CSV

Description:

  • This API allows to import a configuration for groups, systems, users and connectors via a CSV file

Services:

Collect flat metrics
Description Consumes a CSV file with configutation data
Method POST
URL /snapshots/importcsv
Authorizations Admin user

Service usage

  • You need to post data to the service.
  • You can use curl with the below command
  • CSV configuration is written in config.csv file in this example
curl -H "Content-Type: application/csv" --data-binary @config.csv  -u '[ADMIN USER]:[PASSWORD]' http://[HOST]:[PORT]/snapshots/importcsv 

CSV format:

GROUP;Organization short name;group name;group short name
USER;group short name;user title; username;user password
SYSTEM_NETWEAVER;group shortname;system shortname;SID;title;role [optional];environement [optional];description
SYSTEM_HANA;group shortname;system shortname;SID;title;System number;multi-tenant (true/false);role;environement;description
CONNECTOR_ABAP;system shortname;host;client;logon group;MS port number; user title
CONNECTOR_J2EE;system shortname;title;host;system number;MS port number; user title
CONNECTOR_HANA;system shortname;title;host;port [optional];tenant;user title
CONNECTOR_SYBASE;system shortname;title;host;DB port number;user title;properties
CONNECTOR_MSSQL;system shortname;title;host;DB port number;user title;properties

Example:

GROUP;ORG01;GROUP 1;GRP01
GROUP;ORG01;GROUP 2;GRP02
USER;GRP01;USER S4H;PROMONITOR;asdff4!
USER;GRP02;USER QAL;qaluser;qwer789
USER;GRP02;USER SYB;sybuser;qwertoto789
USER;GRP02;USER MS;msuser;tqwer789
SYSTEM_NETWEAVER;GRP01;S4H000;S4H;Prod system;PRODUCTION;ECC;system PROD
SYSTEM_NETWEAVER;GRP02;QAL;QAL;QA system;QUALITY;BW;system QA
SYSTEM_HANA;GRP02;HAQ;HAQ;QA system;00;true;PRODUCTION;PI;Ceci est mon system QA
CONNECTOR_ABAP;S4H000;mys4hana.agentil.local;100;SPACE;3600;USER S4H
CONNECTOR_J2EE;QAL;mys4hana.agentil.local;00;;USER QAL
CONNECTOR_SYBASE;QAL;QAL sybase;aglgesyb.agentil.local;9900;USER SYB;
CONNECTOR_MSSQL;QAL;QAL MS;aglgems.agentil.local;6600;USER MS;toto=false
CONNECTOR_HANA;HAQ;HAQ tenant1;aglgehaq.agentil.local;;TENANT1;USER HAQ
CONNECTOR_HANA;HAQ;HAQ tenant2;aglgehaq2.agentil.local;23558;TENANT2;USER HAQ

Note:

  • Items must be declared in the following order:
    • GROUPS
    • USERS
    • SYSTEMS
    • CONNECTORS
  • Users in connector must be referenced by user title
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/userguide/api/confimportcsv.txt · Last modified: 2022/04/13 16:49 by rbariou