# Oracle Fusion Cloud HCM Oracle Fusion HCM (Human Capital Management) is a comprehensive cloud-based human resources and workforce management system designed to help organizations effectively manage their human resources, talent acquisition, and workforce. OvalEdge enables connectivity to Oracle Fusion HCM using the Rest API, allowing for tasks such as crawling database objects, profiling sample data, and building relationships.
| This connector document should be used along with the [Generic Features of Connectors](https://docs.google.com/document/d/1MEkP-GCznqJHLlV6mxrBd-dOMyBNa5cT_-fHDAglFsc/edit) document which covers the generic features and settings (Establishing Connection, Connector Parameters, Connector Settings, etc.) of the OvalEdge connectors that are common. This document only outlines the specific connector information. | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ### Connector Characteristics | Connector Category | RDBMS | | -------------------------------------------- | ----------- | | Connectivity | API | | Connector Version |


| | Oracle Fusion HCM Versions Supported | 8 onwards | | OvalEdge Releases Supported (Available from) | 5.0 onwards | ### Supported Features |

Crawling of Metadata Objects


| Schemas, Tables, Table Columns, and Relationships | | ------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Metadata Source |

Oracle Commands

E.g.:

sys.db\_users (schemas)
All\_tab\_comments (Tables)
ALL\_TAB\_COLUMNS (Columns)

| | Profiling |

Table Profiling: Row Count, Column Count, View Sample data

Column Profiling: Min, Max, Null Count, Distinct, Top 50 values

Sample Profiling: Supported

| | Crawling of Query Logs | Supported | | Data Preview | Supported | | Data Lineage | Not Supported | | Data Quality Module | Not Supported | | RDAM (Remote Data Access Management) Support | Not Supported | | Bridge Support | Supported | |

Query Sheet Support

(Run simple queries)

| Not Supported | | Crawl of Usage Statistics (Source System) | Not Supported | | Certifications at Source (Source System) | Not Supported | ### Prerequisites (Prepare Oracle Fusion HCM Environment) The following are the prerequisites required for establishing a connection: * Driver Details JDBC driver is provided by default over the OvalEdge installation. In case it needs to be changed, add Oracle drivers into the OvalEdge Jar path (/home/ovaledge/jarpath) to communicate with the Oracle database. | Driver/API | Version | Details | | ---------- | ----------- | ----------------------------------------------------------------------------- | | API |


| https\://\:\/hcmRestApi/resources/\/\/describe | * Oracle Fusion HCM User Account and Permissions Create an Oracle Fusion HCM account to connect to OvalEdge with the following permissions to crawl metadata into OvalEdge. Required permissions and corresponding Oracle Fusion HCM commands are given below for your reference: | Operation | Access Permission | | --------------------- | --------------------------------------- | | Connection Validation | API Read | | Crawl objects | Read permission to access the resources | Note: Please put the code here for creating and granting privileges on the Oracle Fusion HCM system to establish a connection to OvalEdge and crawl & profile (Similar to Snowflake Connector). * Configure Environment Variables (Optional) This section describes the settings or instructions you should know before establishing a connection. If your environments have been configured, skip this step. For more information, refer to the "[Generic Features of Connectors](https://docs.google.com/document/d/1MEkP-GCznqJHLlV6mxrBd-dOMyBNa5cT_-fHDAglFsc/edit)" document. ### Oracle Fusion HCM - Specific Parameters | Fields | Details | | ----------- | --------------------------------------------------------------------------------------------------- | | End Point\* | Enter the Oracle Fusion HCM data source endpoint. This enables users to connect to the data source. | | Username\* | Provide a username to access the Oracle Fusion HCM. | | Password\* | Provide a password to authenticate to the Oracle Fusion HCM. | ### Connector Settings The following are the Oracle Fusion HCM Connector settings: * Crawler * Profiler * Access Instruction * Business Glossary Settings ### Limitations | S.No. | Description | | ----- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 1 |

Data Profiling for the following data type columns is not supported:

  • clob
  • blob
  • img
  • xml
  • image
  • int identity
  • varbinary
  • timestamp
  • binary
  • longblob
  • mediumblob
  • flag
  • geography
  • decimal
| ### Errors & Resolution | S.No. | Error Message(s) | Error Description/Resolution | | ----- | ---------------- | ----------------------------------------------------------------------------------------------------------------------- | | 1 | 401 Unauthorized | This error indicates that the provided credentials are invalid and do not grant the necessary authorization for access. | | 2 | 501 | Internal server error | ### FAQs Q1: How much does the driver cost? A: The JDBC Driver for Oracle is available at no additional charge. Q2: Can I use the driver to access Oracle from a Linux system? A: Yes! You can use the driver to access Oracle from Linux, Unix, and other non-Windows platforms.
--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.ovaledge.com/release8.1/connectors/connector-repositories/application/oracle-fusion-cloud-hcm.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.