MSSQL: 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 the MSSQL application.

    image-20240817-110625.png

    image-20240817-110659.png

  2. Click on Sync Now .

  3. Enable ZUS.

  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.

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

  6. Go to the Settings

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

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

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

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

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

 

  1. Do the CSV column mapping and click on Next

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

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

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

  5. Now onwards, sync will succeed.