Tableau experts help plzz.

[pandugadu999]

1st qn..Tableau lo 100 workbooks unnay..each workbook is using seperate query but using same 1 database. So datadources lo i have to create 100 datadources. Is there way to create 1 database connection and point all 100 workbooks to this connection...bcoz future lo database connection change aithe i have to change it 100 times kada....,

[pandugadu999]

2nd qn....workbooki security permission 

Lets say 100 workbooks and 200 users...some of the workbooks ni certain users ki restrict cheyyali...how to do that..there will be lot of conbinations...help flz 

[tacobell fan]

check this.. not sure if this helps

 

http://bicortex.com/tableau-server-workgroup-postgresql-database-schema-and-data-synchronization/

[srshb445]

Only 1 database connection undi annavu, u might have 100 data sources , underlying query will be same for that 100 datasources.......no need to change this.....future lo it the database connection changes, all you have to it to replace the existing the database with the new databse......as long as the new database has all the views and fields same as the old one, you don't need to change anything to your underlying query of your 100 days soudces

[pandugadu999]

2 minutes ago, srshb445 said:

Only 1 database connection undi annavu, u might have 100 data sources , underlying query will be same for that 100 datasources.......no need to change this.....future lo it the database connection changes, all you have to it to replace the existing the database with the new databse......as long as the new database has all the views and fields same as the old one, you don't need to change anything to your underlying query of your 100 days soudces

Query is different for each workbook.but database is same...so each workbook will have different datasouurce kada..

[srshb445]

15 minutes ago, pandugadu999 said:

Query is different for each workbook.but database is same...so each workbook will have different datasouurce kada..

Okk query is diff kada....try this option and see......edit connection and look of you can apply changes at a time to all 100 datasources.....try that and see, even I am not sure

[srshb445]

39 minutes ago, pandugadu999 said:

1st qn..Tableau lo 100 workbooks unnay..each workbook is using seperate query but using same 1 database. So datadources lo i have to create 100 datadources. Is there way to create 1 database connection and point all 100 workbooks to this connection...bcoz future lo database connection change aithe i have to change it 100 times kada....,

Either replace connection or edit connection, we can do it only for 1 data source at a time.......there must be other workaround for this.....sorry, naaku strike avvatledu

[pandugadu999]

7 minutes ago, srshb445 said:

Okk query is diff kada....try this option and see......edit connection and look of you can apply changes at a time to all 100 datasources.....try that and see, even I am not sure

Yup..u can select all and edit...working bro...thanks.

[pandugadu999]

 

8 minutes ago, srshb445 said:

Either replace connection or edit connection, we can do it only for 1 data source at a time.......there must be other workaround for this.....sorry, naaku strike avvatledu

We can edit multiple at a time..i just found out..

[srshb445]

3 minutes ago, pandugadu999 said:

Yup..u can select all and edit...working bro...thanks.

Awesome

[pandugadu999]

15 minutes ago, srshb445 said:

Awesome

2nd qn chudu bro..

[chapstick]

1 hour ago, pandugadu999 said:

2nd qn chudu bro..

Tableau desktop-server tab- user filter.

try this one for user level access.

[pandugadu999]

48 minutes ago, chapstick said:

Tableau desktop-server tab- user filter.

try this one for user level access.

Konchem detail explain chey bro

[iPhoneX]

3 hours ago, tacobell fan said:

check this.. not sure if this helps

 

http://bicortex.com/tableau-server-workgroup-postgresql-database-schema-and-data-synchronization/

 

assalu thala thoka sambandham leni post vesav ga

[iPhoneX]

3 hours ago, pandugadu999 said:

1st qn..Tableau lo 100 workbooks unnay..each workbook is using seperate query but using same 1 database. So datadources lo i have to create 100 datadources. Is there way to create 1 database connection and point all 100 workbooks to this connection...bcoz future lo database connection change aithe i have to change it 100 times kada....,

No you cannot have 1 db connection pointing to multiple workbooks. Verything is local to workbook

 

Kani anni oke sari same connection ki change cheyyochu tableau server lo. Still they remain different connections.