You can use Oracle HCM Cloud Connector to connect to Oracle HCM Cloud application from Data Integration. Use Oracle HCM Cloud Connector to read data from or write data to an Oracle HCM Cloud application.
To read data from an Oracle HCM Cloud source, you can use the XML schema data of the HCM extract definitions as sources in mappings and mapping tasks. When you run a mapping or mapping task, the Secure Agent downloads the HCM extract definitions instance from the WebCenter Content Server, decrypts the data if encrypted, and writes the data to the target.
To write data to an Oracle HCM Cloud target, you can use the XLS schema files as targets in mappings and mapping tasks. You can also use the .xls template files that contains the metadata of the flexfields as targets in mappings and mapping tasks. When you run a mapping or mapping task, the Secure Agent encrypts the data based on the encryption mode you specify in the connection property. Then, the Secure Agent uploads the data in the WebCenter Content Server from where the Secure Agent loads the data in the HCM Application Server. The Secure Agent creates new data in the HCM Application Server.
You can use the Oracle HCM Cloud Connector in a Source transformation, Target transformation, and midstream transformation in a mapping task.