pandugadu999 Posted May 2, 2018 Report Share Posted May 2, 2018 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...., Quote Link to comment Share on other sites More sharing options...
pandugadu999 Posted May 2, 2018 Author Report Share Posted May 2, 2018 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 Quote Link to comment Share on other sites More sharing options...
tacobell fan Posted May 2, 2018 Report Share Posted May 2, 2018 check this.. not sure if this helps http://bicortex.com/tableau-server-workgroup-postgresql-database-schema-and-data-synchronization/ Quote Link to comment Share on other sites More sharing options...
srshb445 Posted May 2, 2018 Report Share Posted May 2, 2018 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 Quote Link to comment Share on other sites More sharing options...
pandugadu999 Posted May 2, 2018 Author Report Share Posted May 2, 2018 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.. Quote Link to comment Share on other sites More sharing options...
srshb445 Posted May 2, 2018 Report Share Posted May 2, 2018 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 Quote Link to comment Share on other sites More sharing options...
srshb445 Posted May 2, 2018 Report Share Posted May 2, 2018 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 Quote Link to comment Share on other sites More sharing options...
pandugadu999 Posted May 2, 2018 Author Report Share Posted May 2, 2018 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. Quote Link to comment Share on other sites More sharing options...
pandugadu999 Posted May 2, 2018 Author Report Share Posted May 2, 2018 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.. Quote Link to comment Share on other sites More sharing options...
srshb445 Posted May 2, 2018 Report Share Posted May 2, 2018 3 minutes ago, pandugadu999 said: Yup..u can select all and edit...working bro...thanks. Awesome Quote Link to comment Share on other sites More sharing options...
pandugadu999 Posted May 2, 2018 Author Report Share Posted May 2, 2018 15 minutes ago, srshb445 said: Awesome 2nd qn chudu bro.. Quote Link to comment Share on other sites More sharing options...
chapstick Posted May 2, 2018 Report Share Posted May 2, 2018 1 hour ago, pandugadu999 said: 2nd qn chudu bro.. Tableau desktop-server tab- user filter. try this one for user level access. Quote Link to comment Share on other sites More sharing options...
pandugadu999 Posted May 3, 2018 Author Report Share Posted May 3, 2018 48 minutes ago, chapstick said: Tableau desktop-server tab- user filter. try this one for user level access. Konchem detail explain chey bro Quote Link to comment Share on other sites More sharing options...
iPhoneX Posted May 3, 2018 Report Share Posted May 3, 2018 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 Quote Link to comment Share on other sites More sharing options...
iPhoneX Posted May 3, 2018 Report Share Posted May 3, 2018 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. Quote Link to comment Share on other sites More sharing options...
.thumb.jpg.abf7d08f99d33f7507f9f0e982085cc3.jpg)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.