In this article
Overview
Snap Type
Oracle HCM - Read Snap is a Read-type Snap that reads records from Oracle HCM instance
Prerequisites
Valid account with the required permissions.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Snap Views
View Type | View Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| Each input document offers details associated with the data required from the target Oracle HCM instance. |
Output | Document |
|
| Each output document contains data retrieved from the Oracle HCM instance. If the Snap fails during the operation, it sends an error document to the error view containing the fields error, reason, resolution, and stacktrace. However, you must enable the Error view to view the error document. |
Error | Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:
Learn more about Error handling in Pipelines. |
Snap Settings
Expression
: JavaScript syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If disabled, you can provide a static value. Learn more.
SnapGPT
: Generates SnapLogic Expressions based on natural language using SnapGPT. Learn more.
Suggestion
: Populates a list of values dynamically based on your Account configuration.
Upload
: Uploads files. Learn more.
Learn more about the icons in the Snap Settings dialog.
Field Name | Field Type | Field Dependency | Description | |
---|---|---|---|---|
| ||||
Label* Default Value: ELT Database Account | String | None. | The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. | |
Number of records Default Value: | String/Expression | Sampling Type is Number of records. | Enter the number of records to output. | |
fieldset Name |
Specify advanced parameters that you want to include in the request. | |||
Field 1* Default Value: <value> or None. | String | Debug mode check box is not selected. | ||
Field 2 Default Value: <value> or None. | String | None. | ||
Snap Execution Default Value: | Dropdown list | N/A | Select one of the following three modes in which the Snap executes:
|
Troubleshooting
Error | Reason | Resolution |
---|---|---|
Account validation failed. | The Pipeline ended before the batch could complete execution due to a connection error. | Verify that the Refresh token field is configured to handle the inputs properly. If you are not sure when the input data is available, configure this field as zero to keep the connection always open. |
Examples
Excluding Fields from the Input Data Stream
We can exclude the unrequired fields from the input data stream by omitting them in the Input schema fieldset. This example demonstrates how we can use the <Snap Name> to achieve this result:
<screenshot of Pipeline/Snap and description>
Download this Pipeline.
Downloads
Download and import the pipeline into the SnapLogic application.
Configure Snap accounts, as applicable.
Provide pipeline parameters, as applicable.
Snap Pack History
Related Content
Endpoint Doc Link 1
Endpoint Doc Link 2