Using the Options Query
You can use the Options Query property to create a configuration table. You can then use this table to update adapter options at runtime.
The Options Query returns one row. Table column names should be set for property names and row value should be set for property value.
If you set the OPTIONS_QUERY property to
select * from conf
and that query returns 1 row with 1 column called DIRECTORY containing the value /user/myuser, then the adapter is configured with the DIRECTORY property set to /user/myuser. Each time the adapter runs its configuration gets dynamically computed from the conf table. You can also use views for the OPTIONS_QUERY.