Connector to Oracle Financial Data Quality Management, Enterprise Edition (FDMEE)

With the Oracle® FDMEE connector, you can use commands in a chain to interact with Oracle Financial Data Quality Management®, Enterprise Edition (FDMEE). For example, with this connector, you can:

• Run web service calls to perform the Import, Validate, and Export functions of FDMEE data rules
• Retrieve data rules and balance column mappings in Oracle FDMEE

Note: This connector is built by Workiva and connects to a third-party system. While our Support team can help configure this connector within your workspace, we are unable to troubleshoot or otherwise assist with any issues that originate outside of the Workiva platform.

Prerequisites

To enable the connection, the connector uses the FDMEE Web Service interface, secured with basic username and password authentication. To set up the connector, you'll need:

• A designated integration user set up in Oracle FDMEE for the connector
• The integration user's authentication credentials
• The full URL for the Oracle FDMEE Web Service interface to connect to, such as http://localhost:28080/oracle-epm-erpi-webservices/RuleService
• A GroundRunner set up to interact with the FDMEE Web Service interface

Compatibility

• The Oracle FDMEE connector only supports version 11.1.2.4 or lower.
• The FDMEE connector is built for the legacy, on-premises Data Management product. For management command related to Oracle Cloud EPM, please select an appropriate Oracle connector.

Note: The Oracle FDMEE connector only supports version 11.1.2.4 or lower.

Set up the Oracle FDMEE connector

To make the connector available for use in your organization's chains, an org security administrator must first enable it from Configuration.

Once the connector is enabled, follow these steps:

1. From Chain Builder, click Connections  compare_arrows, and then Create at the top right.
2. Under BizApp Connection, select Oracle FDMEE and the GroundRunner to use with the connector.
   
3. Under Basic Info, enter a unique name and description to help identify the connector.
4. Under Properties, enter the connection's details:
   
   

   Property	Details
   Web service URL	Enter the full URL of the Oracle FDMEE Web Service interface to interact with, such as http://localhost:28080/oracle-epm-erpi-webservices/RuleService
   Username	Enter the username for the connector's integration user in Oracle FDMEE.
   Password	Enter the password for the Username property.

   Note: All sensitive credentials are automatically encrypted and stored at Advanced Encryption Standard (AES)-256 encryption.

5. Select the environments to use with the connection, and click Save.
6. To test the connection, create and run a chain with the connector's Get Data Rules command, and verify it returns a valid output.

Troubleshooting

If the connection to Oracle FDMEE fails:

• Verify the integration user's authentication credentials.
• Check the URL for the FDMEE Web Service interface.
• Check the GroundRunner selected for the connector.