Integrate O'Reilly with Oracle Learning

Complete this one-time setup to configure integration, enable secure data exchange, and start importing, tracking, and managing O'Reilly learning in Oracle Learning.

  1. Make sure that you have an active account with O'Reilly that allows integrations.
  2. Configure Single Sign On between Oracle Learning and O'Reilly to ensure the correct exchange of user information for learner progression tracking. You can use any identity provider.
  3. Enable self-paced learning.
  4. In Oracle, create a job role that includes only the Learning Content Provider duty role--don't include any other duty role. The role lets this account use the necessary Oracle APIs to receive content and completions from O'Reilly.
    1. Go to Tools > Security Console.
    2. On the Roles tab, create your job role.
    Caution: If you have any IP restrictions or have enabled location-based access control (LBAC), make sure to enable the job role for access from all IP addresses. Otherwise O'Reilly will get API authentication failures when sending content to Oracle Learning.
  5. Create a user account that you'll use in step 6.
    1. On the security console Users tab, add a user account.
    2. Set Associated Person Type to None. Make sure the user isn't associated with a person or worker account.
    3. Enter the appropriate user details so you can identify the account.

      Give the account a meaningful user name, such as user.o'reilly. O'Reilly uses this user for both content and completion syncs.

    4. Add the job role that you created in step 4.
  6. Enable O'Reilly.
    1. Go to My Client Groups > Learning and Development > Configure External Providers.
    2. Configure O'Reilly and enter the user account created in step 5.
    3. Select a learning catalog profile to apply to all imported O'Reilly learning. The profile identifies who can see and manage the learning.
    4. Optional: Configure audience and catalog settings. The settings apply to new content imported after you validate your changes. Changes aren't automatically applied to content imported before you validate these changes.
    5. Validate the configuration/
    6. Optional: Change the attribute mappings between certain O'Reilly attributes and Oracle Learning attributes that you might have extended or changed.
  7. Contact O'Reilly Platform Integration (platformintegration@oreilly.com) and give them the user name created in step 2. In turn, they'll give you this information:
    • The trusted issuer name for their JWT token, it needs to exactly match the value used when configuring JWT
    • A public certificate so they can authenticate to the Oracle Learning APIs to send content and completion data
  8. Create an Oracle API authentication provider to authenticate incoming requests from O'Reilly.
    1. Go to ToolsSecurity Console.
    2. On the API Authentication tab, create the Oracle API authentication provider.
    3. Edit the API authentication configuration details so that you can enter the trusted issuer name provided by O'Reilly Platform Integration and select the JWT token type.
      Caution: You need to get the trusted issuer name from O'Reilly and the name that you enter needs to match the value they used when generating the token. Any other name results in authentication errors when O'Reilly tries to send content.
    4. Save your changes and close the page.
    5. Add a new inbound API authentication public certificate with a unique alias.
    6. Upload the public key (.cer extension file) provided by O'Reilly Platform Integration.
    7. Save your changes and select Done. Your environment can now accept incoming requests from O'Reilly.
  9. If they're not already scheduled because another provider is already enabled or you've been creating and managing your own self-paced learning, schedule these background processes.
    1. Go to Tools > Scheduled Processes.
    Process Input parameter Recommended frequency Description

    ESS job to run Bulk ingest to OSCS

    Program Name is OLC-REST Once per day, after the Load and Synchronize External Course Data process completes Make new content and updates visible to people in Oracle Learning
    Process Learning Experience Statements NA Once per day Process any learner experience statements that for some reason weren't processed immediately
    Process Learning Catalog Item Deactivations and Deletions NA Once per day, after the Load and Synchronize External Course Data process completes Deactivate content and withdraw active enrollments
  10. If you set the provider content visibility to private, schedule the Reconcile User Groups background process to run daily if it's not already scheduled.