Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to setup ReadOnly Connection for a particular database

Mohd-Siddiqui1
8 - Asteroid

Hi there,

 

I have one database connection which is already saved in Alteryx under Option->Advanced Options->Manage Data Connections.

Currently due to permissions issue my manager wants this database permissions to be changed to READONLY.

I am struggling to change this. I have tried Read Uncommitted option available in input tool but i think it is not working.

May you please help me regarding the same,

 

8 REPLIES 8
Kakuffo
Alteryx
Alteryx

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

Mohd-Siddiqui1
8 - Asteroid

Hi @Kakuffo 

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.

 

 

Kakuffo
Alteryx
Alteryx

sure, Which database are you connecting to?

 

Mohd-Siddiqui1
8 - Asteroid

Hi @Kakuffo 

 

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!

Kakuffo
Alteryx
Alteryx

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.

Kakuffo_1-1662389079674.png

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

 

Mohd-Siddiqui1
8 - Asteroid

Hi @Kakuffo 

 

is this the ODBC Driver screenshot?

Kakuffo
Alteryx
Alteryx

@Mohd-Siddiqui1 

Yes it is

Mohd-Siddiqui1
8 - Asteroid

Hi @Kakuffo 

 

I am getting ODBC Data Source Administrator only when I am doing IN-DB connections for IN-DB input tool using the path Options->Advance Options->Manage IN-DB Connections.

When I am doing connections for input tool using the path Option->Advanced Options->Manage Data Connections, I am not getting any option to edit the connection string and setting it to READONLY and neither any ODBC Data Source Administrator dialog box.

I need to set READONLY for one of the database which is saved under Option->Advanced Options->Manage Data Connections

May you please help.

Labels