Description:

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

Services:

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;My PI system
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