Versions Compared

Old Version 5

changes.mady.by.user Sagar Salokhe

Saved on

compared with

New Version Current

changes.mady.by.user Sagar Salokhe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Add Application

    image-20240811-010943.png

    image-20240811-011013.png

  2. Click on the Sync now button

    image-20240811-011134.png

    image-20240811-011211.png

  3. Enable ZUS

    image-20240811-011257.png

  4. Enter the configurations and Click on Next . All or any of the configurations can be kept blank here and can be provided in the ZINC local configurations.

    The configurations are

    1. Database Server Host: The host in the database connection string specifies the hostname or IP address of the database server.

    2. Database Server Port: The port in the database connection string specifies the port number on which the database server is listening. The default value is 1521.

    3. Database Name: The database name in the database connection string specifies the name of the database to connect to.

    4. Database Connection Parameters: It the parameters string from the database connection string. e.g. retry=true&service_name=Zilla

    5. Database Query: It is the query to retrieve the data from the database. This should be readonly query.

    6. Database Dialect: The dialect in the database connection string specifies the type of database you are connecting to. The dialect value should be oracle .

    7. Database Driver: The driver in the database connection string specifies the database driver to be used for the connection. The driver value should be oracledb .

    8. Database Connection String: The database connection string is an alternative method to configure the database connection. Instead of specifying individual values like host, port, database, username, password, dialect, and driver, you can provide a single connection string. The format should be: 'dialect+driver://username:password@host:port/database?parameters'. If this value is provided, it will be masked after saving because it contains username and password.

    9. Use Thick Mode Client: If 'Yes', the Oracle database connection will use thick mode, recommended for database versions older than 12. If 'No', the connection will use thin mode, suitable for Oracle database versions 12 and above.

    10. Database User: The username in the database connection string specifies the user account to connect to the database.

    11. Database Password: The password in the database connection string specifies the password for the user account to connect to the database.

      image-20241217-064506.png

  5. Sync will start and then it will fail with the error as shown in the image

    image-20240811-012907.png

  6. Go to the Settings

    image-20240811-013118.png

  7. Go to the Audit Logs and search by the application name

    image-20240811-013310.png

  8. Click on the Download button and download the CSV file

    image-20240811-013446.png

  9. Go back the application and click on the gear icon

    image-20240811-013606.png

  10. Enable the CSV sync and click on Sync Now

    image-20240811-014012.pngImage Removedimage-20241220-105634.pngImage Added

  11. Select the “Accounts & Permissions CSV File Upload” option and click on Next

    image-20240811-014129.png

  12. Upload the previously downloaded CSV file from the Audit Logs in step 8

    image-20240811-014315.png

  13. Do the column mapping and click on Next

    image-20240811-014448.png

  14. After column mapping is set, Discard the sync

    image-20240811-014608.png

  15. Then again click on the gear icon and disable CSV sync. Then click on Sync Now

    image-20240811-014747.pngImage Removedimage-20241220-105850.pngImage Added

  16. Sync will start

    image-20240811-014821.png

  17. Sync will be successful

    image-20240811-014910.png

...