Versions Compared

Old Version 1

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.

...

Info

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 https://zilla.atlassian.net/wiki/spaces/ZILLASUP/pages/edit-v2/2430271489?draftShareId=aac8a8bb-ad39-47fc-8ba9-9d755621a233.

Steps to sync the application

  1. Add the MSSQL application.

    image-20240817-110625.pngImage Added

    image-20240817-110659.pngImage Added

  2. Click on Sync Now .

    image-20240817-110815.pngImage Added

  3. Enable ZUS.

    image-20240817-110919.pngImage Added

  4. Enable the Zilla Universal Sync (ZUS) and fill in the config details.
    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 1433.

    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 mssql.

    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 pymssql .

    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. Database User: The username in the database connection string specifies the user account to connect to the database.

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

      image-20241220-113133.pngImage Added

  5. The sync will fail with the error as shown in the image

    image-20240817-111531.pngImage Added

  6. Go to the Settings

    image-20240817-111717.pngImage Added

  7. Go to the Audit Logs and Download the CSV file.

    image-20240817-111839.pngImage Added

  8. Go back to the application and click on the gear icon

    image-20240817-112021.pngImage Added

  9. Enable the toggle for “Accounts & Permissions CSV File Upload” and click on Sync Now

    image-20241220-113745.pngImage Added

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

    image-20240817-112332.pngImage Added

  11. Upload the previously downloaded CSV file in step 7 above.

...

  1. Do the CSV column mapping and click on Next

    image-20240817-112632.pngImage Added

  2. Now the column mapping is saved, Click on Discard.

    image-20240817-112808.pngImage Added

  3. Go back to the application and click the gear icon again

    image-20240817-112940.pngImage Added

  4. Disable the toggle “Accounts & Permissions CSV File Upload” and click on Sync Now.

    image-20241220-113951.pngImage Added

  5. Now onwards, sync will succeed.

    image-20240817-113238.pngImage Added

Include Page
Integrations Footer
Integrations Footer