Support
 
Phone Live Chat
 
Support
 
US: +1 888 720 9500
US: +1 800 443 6694
Intl: +1 925 924 9500
Aus: +1 800 631 268
UK: 0800 028 6590
CN: +86 400 660 8680

Direct Inward Dialing: +1 408 916 9393

 
 
 
 
 
Knowledge Base

How to fetch data from Oracle/ MSSQL database?

Synchronize and automate user creation, modification, and deletion in your Active Directory based on the HR databases by integrating ADManager Plus with databases such as MS SQL and Oracle

Steps to configure MS SQL server settings:

  1. Click the Admin tab.
  2. Select Integrations from the left navigation pane.
  3. Click MS SQL Server located under Database.
  4. In the MS SQL Server Settings page, configure the following:
    • Server Name: Enter the server name.
    • Instance Name: Enter the instance name and port number.
    • Authentication type: Select any of the following authentication types:
      • SQL Authentication: Enter 'User name' and 'Password' for authentication.
      • Windows Authentication: Enter 'Domain Name', 'User name' and 'Password' for authentication.
  5. Click Test Connection and Save to establish connection and save the settings.

Steps to configure 'Oracle DB' settings:

  1. Click the Admin tab.
  2. Select Integrations from the left navigation pane.
  3. Click Oracle DB located under Database.
  4. In the Oracle DB Settings page, configure the following:
    • Server Name: Enter the server name.
    • Port Number:Enter the portnumber to establish the connection.
    • Database Name:Enter the name of the database in Oracle.
    • Authentication:Enter 'User name' and 'Password' for authentication.
  5. Click 'Test Connection and Save' to establish connection and save the settings

Once you have configured MS SQL/Oracle DB, the AD user management will be synced with the entries made in that DB.

 

Request Support

Need further assistance? Fill this form, and we'll contact you rightaway.

  • Name
  • Email*
  • Phone Number
  • Country
  • Problem Description
  •  
    By clicking 'Submit', you agree to processing of personal data according to the Privacy Policy.
  •  

Select a language to translate the contents of this web page:

ADManager Plus Trusted By

The one-stop solution to Active Directory Management and Reporting
Email Download Link