Enterprise Data Management Cloud Service has got a rich set of RestAPIs that may allow you to run and automate many business processes. You can get all applications registered within your EDMCS instance by a simple GET Request.
This will return all applications listed down with many details.
You can capture application ID and list the connections defined within that particular application as follows.
Response will be the list of connections, their names, url, username, password etc…
Yes, it is right, you can capture the encrypted password and use it to test the connection yourself by reading connectionInfo.
Here is an example of how you can trigger an import for Entity dimension using connection. File name is assumed to be there in the source system before running this job from EDMCS side.
Once job starts, we get 202 Accepted https status.
Export is very similar to import, please notice we use connection ID in the request body and dimension ID in URL for both import and export restAPIs.
You can either check the job status from EDMCS screens or you can use another rest API to see the status of the jobs. See following example.
Depending on what business requirements you are serving, it is technically possible to run all those restAPIs mentioned in this post with Groovy Scripts and you can automate and interact with EDMCS services from EPM Cloud Business Rules.
