1. Import information from Oracle Taleo Enterprise Cloud Service to Oracle E-Business Suite
  2. Create Connections

Create Connections

Create the connections to the applications that you want to share data with.

To migrate data to and from Oracle Taleo Enterprise Cloud Service and Oracle E-Business Suite, sign into Oracle Integration Cloud and create SOAP, FTP, REST, and Oracle E-Business Suite connections.

Before You Begin Creating Connections

Before you begin creating connections, ensure that you created an Oracle Integration Cloud instance and that your user account has the appropriate role assignments.

  • If you don’t already have access to an Oracle Integration Cloud, then create one.

  • Ensure that your user account is assigned the ServiceAdministrator or ServiceDeveloper role for your Oracle Integration Cloud instance.

Sign In to Oracle Integration Cloud

Before you can sign in, you must have a user account that defines your user name, password, identity domain, and access rights to the service. You also need the URL for your instance.

When a service is activated, it sends your sign-in credentials and URL to the designated administrators. An administrator then creates an account for each user who needs access to the service. Check your email or contact your administrator for your account credentials and your service’s URL.

  1. Open your web browser and go to the service’s URL that was given to you in an email or by your administrator.
  2. Enter your user name (user ID) and password.
  3. Click Sign In.
  4. If you’re signing in for the first time, then you’re prompted to enter a new password for security reasons. Follow the instructions on the screen to complete this task.

Upload an SSL Certificate from Oracle E-Business Suite

You use certificates to validate outbound SSL connections. If you create an SSL connection, and the root certificate doesn’t exist in Oracle Integration Cloud, an exception is thrown. In that case, you must upload the appropriate certificate. A certificate enables Oracle Integration Cloud to connect with external services. If the external endpoint requires a specific certificate, request the certificate and then upload it to Oracle Integration Cloud.

To upload an SSL certificate:
  1. In the navigation pane, click Integrations, and then click the left arrow (<) next to Designer.
  2. Click Settings, and then click Certificates.
  3. At the top of the page, click Upload.
  4. In the Upload Certificate dialog box, select the certificate type. Each certificate type enables Oracle Integration Cloud to connect with external services.
    • Trust Certificate:

      1. Enter a unique alias for the certificate.

      2. Click Browse, and select the trust file (for example, .cer or .crt) to upload.

    • Message Protection Certificate: Use this option to upload a keystore certificate with SAML token support. Create, read, update, and delete (CRUD) operations are supported with this type of certificate.

      1. Enter a unique alias for the certificate.

      2. Click Browse, and select the certificate file (.cer or .crt) to upload.

    • Identity Certificate: Use this option to upload a certificate for two-way SSL communication.

      1. Click Browse, and select the keystore file (.jks) to upload.

      2. Enter the password of the keystore that’s being imported.

      3. Enter the comma-separated list of aliases from the keystore that’s being imported.

      4. Enter the comma-separated list of passwords corresponding to the key aliases.

      5. If you want to display the passwords, then select Show Key Password(s). This ensures that you are correctly entering the list of passwords.

  5. Click Upload.
  6. Click the certificate name to view the certificate’s details such as the subject, the issuer, the date it was issued, and the date it expires.

Create a TCC Export SOAP Connection

Create a SOAP connection to the SOAP wrapper to export data from Oracle Taleo Enterprise Cloud Service using the Taleo Connect Client.

  1. In the navigation pane, click Integrations, then click Connections.
  2. Click Create.
  3. In the search field, enter SOAP, and press Enter to filter the results. On the SOAP adapter tile, click Select.
  4. In the Name field, enter TCCExport, and click Create.
  5. Click Configure Connectivity. Enter the location of the deployed SOAP wrapper, for example http://198.51.100.1:9073/TCCClient/tccJobService?WSDL, as the WSDL URL property value, and click OK.
    You form this URL by adding TCCClient/tccJobService?WSDL after the public IP address of your Oracle Java Cloud Service instance and the HTTP port over which you access deployed applications.
  6. Click Configure Security. If you’re protecting the service with an OWSM policy, provide information required to invoke the service. If you’re not protecting the service with an OWSM policy, from the Security Policy list, select No Security Policy, and click OK.
  7. Click Test, and then click Test again.
  8. After you see a success message, click Save, and click Close.

Create a TCC Import SOAP Connection

Create a SOAP connection to the SOAP wrapper to import data from Oracle Taleo Enterprise Cloud Service using the Taleo Connect Client.

  1. From the Connections page, click Create.
  2. On the SOAP adapter tile, click Select.
  3. In the Name field, enter TCCImport, and click Create.
  4. Click Configure Connectivity. Enter the location of the deployed SOAP wrapper, for example http://198.51.100.1:9073/TCCClient/tccJobService?WSDL, as the WSDL URL property value, and click OK.
  5. Click Configure Security. If you’re protecting the service with an OWSM policy, provide information required to invoke the service. If you’re not protecting the service with an OWSM policy, from the Security Policy list, select No Security Policy, and click OK.
  6. Click Test, and then click Test again.
  7. After you see a success message, click Save, and click Close.

Create an FTP Connection to Get the Export File

Create an FTP connection to get the export file, and move the file to the Oracle Integration Cloud host for processing.

The file contains information about allthe accepted candidates exported from Oracle Taleo Enterprise Cloud Service using the Taleo Connect Client.

  1. From the Connections page, click Create.
  2. In the search field, enter FTP, and press Enter to filter the results. On the FTP adapter tile, click Select.
  3. In the Name field, enter GetFTP, and click Create.
  4. Click Configure Connectivity. Enter the IP address of your Oracle Java Cloud Service host for the FTP Server Host Address property value.
  5. For the FTP Server Port property value, enter 22.
  6. From the SFTP Connection list, select Yes, and click OK.
  7. Click Configure Security. In the Security Policy list, select FTP Server Access Policy. In the User Name field, enter tcc. In the Password and Confirm Password fields, enter the tcc user’s password. Click OK.
  8. Click Test, and then click Test.
  9. After you see a success message, click Save, and click Close.

Create an FTP Connection to Send a File

Create an FTP connection to send a file from the Oracle Integration Cloud host to the Oracle Java Cloud Service host.

This file correlates Oracle Taleo Enterprise Cloud Service record numbers to the Oracle E-Business Suite employee numbers, and this file is used to import data back to Oracle Taleo Enterprise Cloud Service.

  1. From the Connections page, click Create.
  2. On the FTP adapter tile, click Select.
  3. In the Name field, enter PutFTP, and click Create.
  4. Click Configure Connectivity. Enter the IP address of your Oracle Java Cloud Service host for the FTP Server Host Address property value.
  5. For the FTP Server Port property value, enter 22.
  6. From the SFTP Connection list, select Yes, and click OK.
  7. Click Configure Security. In the Security Policy list, select FTP Server Access Policy. In the User Name field, enter tcc. In the Password and Confirm Password fields, enter the tcc user’s password. Click OK.
  8. Click Test, and then click Test.
  9. After you see a success message, click Save, and click Close.

Create a REST Connection

Create a REST connection to trigger the integration that contains the Oracle E-Business Suite adapter from the main integration.

  1. From the Connections page, click Create.
  2. In the search field, enter REST, and press Enter to filter the results. On the REST adapter tile, click Select.
  3. In the Name field, enter ebs-rest-endpoint.
  4. From the Role list, select Trigger, and click Create.
  5. Click Test.
  6. After you see a success message, click Save, and click Close.

Create a Connection to Oracle E-Business Suite

Create a connection to enable communication between Oracle Integration Cloud and Oracle E-Business Suite.

  1. From the Connections page, click Create.
  2. In the search field, enter E-Business Suite, and press Enter to filter the results. On the Oracle E-Business Suite adapter tile, click Select.
  3. In the Name field, enter EBSImport, and click Create.
  4. If you are using the On-Premises Agent to connect to Oracle E-Business Suite:
    1. Click Configure Agents.
    2. Select the agent group that you created for the Oracle E-Business Suite connection, and click Use.
  5. If you aren’t using the on-premises agent to connect to Oracle E-Business Suite Suite:
    1. Click Configure Connectivity. Enter the host and port number that you use to access Oracle E-Business Suite as the Connection URL property value, and click OK.
    2. Click Configure Security. Enter the credentials for the hrms user, or a user with similar entitlements, and click OK.
  6. Click Test, and then click Test again.
  7. After you see a success message, click Save, and click Close.