To connect to Oracle® Enterprise Data Management Cloud Service (EDMCS) as part of a chain, add a step that includes an Oracle EDMCS connection command. For example:
- Import and export hierarchies
- Transform hiearchies to a balanced or generational format
- Automate the management of EDMCS
To enable these commands, an IT admin first creates an Oracle EDMCS connector.
Convert parent-child file
To convert a parent/child data structure—also known as ragged—into a ragged generational or balanced format, use a Convert Parent-Child File command.
Properties
| Property |
Detail |
| Input file |
Enter the file to convert. |
| Delimiter |
Select the delimiter used in Input File. |
| Hierarchy type |
Select the type of hierarchy to convert the file to. |
| Parent column name |
Enter the name of the column that contains the parent values. |
| Child column name |
Enter the name of the column that contains the child values. |
Outputs
| Output |
Output type |
| Hierarchy file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Copy file between instances
To copy a file from a source environment to the current target environment, use a Copy File Between Instances command. For example, use this command to copy a file from a test environment to the production environment.
Properties
| Property |
Detail |
| Source file name |
Enter the name of the file to copy. |
| Source user name |
Enter the username for the source environment. |
| Source instance password |
Enter the password for the source environment.
Note: Alternatively, enter the password file generated by EPM Automate in Source password file.
|
| Source password file |
Enter the password file for the source environment.
Note: Alternatively, enter the password directly in Source instance password.
|
| Source URL |
Enter the URL of the source environment. |
| Target file name |
Enter the name for the copied file in the target environment. |
Outputs
None
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
| 10 |
Warning |
Command completed with warnings |
Create request
To creates a new Oracle EDMCS request, use a Create Request command.
Properties
| Property |
Detail |
| View name |
Enter the name of the view to create the request in. |
| Title |
Enter the request title. |
| Description |
Optionally, enter the request description. |
| Notes |
Optionally, enter the request notes. |
| Child column name |
Enter the name of the column that contains the child values. |
Outputs
| Output |
Output type |
| Request JSON |
JSON |
| Request ID |
String |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Create request items from file
To add items in an upload file to an EDMCS request, use a Create Request Items From File command.
Properties
| Property |
Detail |
| Request title |
Enter the EDMCS request title. |
| Sheet names |
Enter the request sheet names. |
| File |
Enter the file to use to create the request items. |
Outputs
| Output |
Output type |
| Updated request JSON |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Export dimension mapping to connection
To export a dimension mapping into a comma-separated values (CSV) file, use an Export Dimension Mapping to Connection command.
Properties
| Property |
Detail |
| Application name |
Enter the name of the application that contains the dimension. |
| Dimension name |
Enter the name of the dimension to export. |
| Connection name |
Enter the name of the connection to export the dimension to. |
| File name |
Enter the target file name to export the dimension mapping to. |
| Mapping location |
Enter the mapping location to export. |
Outputs
None
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Export dimension mapping to file
To export a dimension mapping into a CSV file, use an Export Dimension Mapping to File command.
Properties
| Property |
Detail |
| Application name |
Enter the name of the application that the dimension belongs to. |
| Dimension name |
Enter the name of the dimension to export. |
| File name |
Enter the target file name to export the dimension mapping to. |
| Mapping location |
Enter the mapping location to export. |
Outputs
| Output |
Output type |
| Export mapping file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Export dimension to connection
To export a dimension in Oracle EDMCS to an existing connection, use an Export Dimension to Connection command.
Properties
| Property |
Detail |
| Application name |
Enter the name of the application that contains the dimension to export. |
| Dimension name |
Enter the name of the dimension to export. |
| Connection name |
Enter the name of the connection to export the dimension to. |
| File name |
Enter the target file name to export the dimension to. |
Outputs
None
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Export dimension to file
To export a dimension in Oracle EDMCS to a downloadable CSV file, use an Export Dimension to File command.
Properties
| Property |
Detail |
| Application name |
Enter the name of the application that contains the dimension to export. |
| Dimension name |
Enter the name of the dimension to export. |
| File name |
Enter the target file name to export the dimension to. |
| Parent name |
To export only descendants of a parent member, enter the name of the parent. |
| Parent column name |
To export only descendants of a parent based on a column, enter the name of the column that contains the parent. |
Outputs
| Output |
Output type |
| Export dimension file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Get applications
To list the available Oracle EDMCS applications and retrieve their metadata, including dimensions, use a Get Applications command.
Properties
None
Outputs
| Output |
Output type |
| Applications list |
Array |
| Applications JSON file |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Get connections
To list the available connections for an Oracle EDMCS application, use a Get Connections command.
Properties
| Property |
Detail |
| Application name |
Enter the name of the application that contains the connections to list. |
Outputs
| Output |
Output type |
| Connections list |
Array |
| Connections JSON file |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Get dimensions mappings
To list the available mappings for an Oracle EDMCS dimension, use a Get Dimensions Mappings command.
Properties
| Property |
Detail |
| Application name |
Enter the name of the dimension's application. |
| Dimension name |
Enter the name of the dimension that contains the desired mappings. |
Outputs
| Output |
Output type |
| Dimension mappings JSON |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Get request
To retrieve the metadata of an Oracle EDMCS request, use a Get Request command.
Properties
| Property |
Detail |
| Request title |
Enter the title of the desired request. |
Outputs
| Output |
Output type |
| Request JSON |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Get requests
To list all requests the connector's integration user can access, use the Get Requests command.
Properties
None
Outputs
| Output |
Output type |
| Requests list |
Array |
| Requests JSON file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Get views
To list all views the connector's integration user can access, use a Get Views command.
Properties
None
Outputs
| Output |
Output type |
| Views list |
Array |
| Views JSON file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Import dimension from connection
To import a dimension into Oracle EDMCS from an existing connection, use an Import Dimension from Connection command.
Properties
| Property |
Detail |
| Application name |
Enter the name of the application that contains the dimension. |
| Connection name |
Enter the name of the connection to import the dimension from. |
| Dimension name |
Enter the name of the dimension to receive the import. |
| File name |
Enter the name of the file to import from at the given connection. |
| Reset dimension |
To reset the dimension prior to import, check this box. |
Outputs
None
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Import dimension from file
To import a dimension into Oracle EDMCS from an uploaded CSV file, use an Import Dimension from File command.
Properties
| Property |
Detail |
| File |
Enter the file to import. |
| Application name |
Enter the name of the application that contains the dimension. |
| Dimension name |
Enter the name of the dimension to receive the import. |
| Reset dimension |
To reset the dimension prior to import, check this box. |
Outputs
None
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |
Update request status
To update the status of an Oracle EDMCS request, use an Update Request Status command.
Properties
| Property |
Detail |
| Request title |
Enter the title of the request to update. |
| Status |
Select the status to update the request to. |
Outputs
| Output |
Output type |
| Updated request JSON |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Invalid arguments |
| 2 |
Error |
General failure |