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) |
|
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.
- 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:
|
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.