|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Workiva Support Center

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

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

  • Last updated on

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 Connector Connection, select Oracle FDMEE and the GroundRunner to use with the connector.
    oracle-fdmee-connector_01.png
  3. Under Basic Info, enter a unique name and description to help identify the connector.
  4. Under Properties, enter the connection's details:
    oracle-fdmee-connector_02.png
    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.
With the Oracle® FDMEE connector, you can use commands in a chain to interact with Oracle Financial Data Quality Mana...