How to setup ReadOnly Connection for a particular database

hey @Mohd-Siddiqui1

By default the input tool only allows for data reading. the only way a user would write back to the database would be using the output data tool.

However if this is not sufficient when you set up the data source on the system, you can adjust the read and write capabilities via the driver set up, this is definately the case for SQL however it willd epend on the database you are connecting too.

If this solves your issue please mark the response, this will help other users with the same issue find the answers quickly

Thank you for your response.

Could you please help me with setting up the data source for READONLY, and how can I adjust the read and write capabilities through the driver setup?

It would be very helpful if you can illustrate this with an example.

sure, Which database are you connecting to?

Apologies but database details are confidential and hence cannot be shared. If you can help me by taking any test database example from your end and saving that database in READONLY mode in Alteryx under Option->Advanced Options->Manage Data Connections.

Apologies again!

No problem please see my attached screenshot. This will need to be actioned outside of Alteryx, as Alteryx does not foster data connections but leverages existing ones created by the data source manager.

hopefully this helps. It may require Admin rights to make the adjustment

is this the ODBC Driver screenshot?

@Mohd-Siddiqui1

Yes it is