Oracle Database: PO Box

Owned by Sagar Salokhe
Last updated: Dec 20, 2024
4 min read

Prerequisite:

ZUS in the Cloud service is deployed in your AWS account. Contact Zilla Customer Support to set up ZUS in the Cloud in your AWS account.

OR

ZUS in the Cloud service is deployed on a VM in any cloud platform or on premise datacenter. Contact Zilla Customer Support to set up ZUS in the Cloud. Click on the link for the instructions.

Click on the link for the instructions ZUS in the Cloud Deployment.

Steps to sync the application

  1. Add Application

    image-20240811-010943.png

    image-20240811-011013.png

  2. Click on the Sync now button

  3. Enable ZUS

  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.

       

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

  6. Go to the Settings

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

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

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

  10. Enable the CSV sync and click on Sync Now

     

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

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

  13. Do the column mapping and click on Next

  14. After column mapping is set, Discard the sync

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

  16. Sync will start

  17. Sync will be successful