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 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://<host>:<port>/hcmRestApi/resources/<version>/<resource>/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" 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.