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 |