topic Re: Is it possible to restrict which "Database" to load data from after a database connect in Management & Governance

Is it possible to restrict which "Database" to load data from after a database connection is made?

jblomqvist — Sat, 16 Nov 2024 01:23:06 GMT

Hi,

Is it possible to restrict which databases to load data from after a database connection is made?

For example once you make a SQL Server data connection and click "select data" it's this option:

Is it possible to restrict which values a user can select from this drop-down list?

Re: Is it possible to restrict which "Database" to load data from after a database connect

agni_gold — Sat, 26 Sep 2020 13:53:24 GMT

for this, you need to add different data connections.

While an alternate way is to keep one configuration excel where you store your connection string something like below and call in your script :

OLDEDB CONNECT TO

[Provider=SQLOLEDB.1;
Persist Security Info=True;
User ID=UserID;
Initial Catalog=DataBaseName;
Data Source=DatabaseHostName/IP;
Use Procedure for Prepare=1;
Auto Translate=True;
Packet Size=4096;
WorkstationID=QlikSenseServerHostName;
Use Encryption for Data=False;
Password = YourPassword;
Tag with column collation when possible=False] ;

Re: Is it possible to restrict which "Database" to load data from after a database connect

Anders_Eriksson — Mon, 28 Sep 2020 10:14:40 GMT

Access to different databases you restrict in the database server.
You need different accounts for the different databases and the configure different connections in Sense.