How to integrate ADManager Plus with Oracle database and automate user lifecycle management
Oracle database is a relational database management system that helps to store and retrieve data and provides data management solution. By integrating ADManager Plus with Oracle database, user creation can be automated based on the new user data in Oracle database.
Actions supported
Upon integration of ADManager Plus with Zoho People, the following actions can be executed:
|
|
Steps to configure Oracle database settings
Navigate to the Automation tab and click HCM Integrations.
Click on Oracle DB located under Database.
In the Oracle DB Settings page, configure the following:
Server Name: Enter the server name.
Port Number: Enter the port number to establish the connection.
Database Name: Enter the name of the database in Oracle.
Authentication: Enter User name and Password for authentication
Click Test Connection and Save to establish connection and save the settings.
Note:
Click the Add Server option to configure multiple Oracle databases.
The Enable Integration button is turned on by default. Toggle it off to disable Oracle database integration.
Steps to add a new configuration
Click on Add a new configuration.
In the Description field, enter the details about the new configuration.
Configure the following details:
Select Server: Select the desired server from the drop down menu.
SID Name: Enter the SID name in Oracle database.
Table Name: Enter the name of the table in Oracle database.
Automation category: Select the automation type from the drop down menu.
Fetch the input for user creation from the Oracle DB table by mapping database Column Name to the LDAP Attribute Name.
Click Save to save the new configuration.
Steps to automate user creation
Click the Automation tab.
Select Automation from the left pane.
Click Create New Automation and configure the following:
Automation Name: Enter a name for the automation.
Description: Add a brief note about the automation.
Automation Category: Choose User Automation from the menu.
Select Domain: Select the domain/OUs where the automation should run. Child OUs can be eliminated by selecting Exclude Child OU(s) option.
Automation Task/Policy: Select Create Users from the menu.
Template to be applied: Select the template to be applied for user creation.
Select Data Source: Click More Options beside the Location of CSV option. Select Oracle DB from the menu. Enable Ignore current records in DB to ignore the already processed records and consider only the unprocessed records in the Oracle table for user creation.
Select Config: Select a configuration from the menu. Or click on Add New Configuration to add new configuration settings.
Implement Business Workflow: Select this option if the automation has to be executed through a workflow.
Execution Time: Configure the automation execution time and repeat the execution using hourly, daily, weekly, monthly, or more options.
Click Save to save the settings or Save & Run to save the settings and run the automation instantly.
New to ADSelfService Plus?
Related Articles
Integrate ADManager Plus with ADP and automate employee lifecycle management
ADP's cloud-based solutions help organizations seamlessly manage HR, payroll, and related processes. The solutions are focused on streamlining human capital management (HCM) by improving workforce and talent management, driving employee engagement, ...How to integrate ADManager Plus with Azure SQL database
ADManager Plus can be integrated with a list of databases to facilitate efficient AD management. This specific integration with Azure SQL database allows administrators to synergistically manage AD objects from their Azure SQL instance itself. ...How to integrate ADManager Plus with Boomi for efficient user life cycle management
Overview Boomi is an integration and automation platform that can help you instantly connect to applications, sync data, and automate processes such as employee onboarding. Integrating Boomi with ManageEngine ADManager Plus streamlines employee ...How to integrate ADManager Plus with Zoho People and streamline user lifecycle management
By integrating ADManager Plus and Zoho People, users can be automatically created in Active Directory based on the user details entered in Zoho People. Apart from user creation, this integration also supports user account management actions. Actions ...How to integrate ADManager Plus with HaloITSM for efficient user life cycle management
HaloITSM is an all-inclusive ITSM software solution that can help you manage incidents in your organization and meet your SLAs. By integrating HaloITSM with ManageEngine ADManager Plus, you can automate identity life cycle management, streamline ...