July 3, 2018 at 12:11 am
Hi, I'm part of a small DW/BI team using SQL 2008( upgrading to 2016 in a couple of months) + tableau . There are frequent changes that we receive from business which needs running Update queries on a couple of tables. I'm trying to find a quick and easy solution where we can have an interface provided to users which will allow them to make changes on their own after running few validations.don't want an excel/csv load , something more like a web page, but we don't have any .net skillset so don't want to take that path. Also, tableau ( or any reporting tool) doesn't have a write back feature. Is there any new feature in 2016 that can be used? . The data is sensitive so can't have any 3rd part tool or a cloud based solution.
July 3, 2018 at 6:47 am
sounds to me like you need a bespoke app to complete your task. alternatively you could create a stored procedure and allow your uses to execute this via SSMS?
it is possible to create something simple in VBS, user could run vbs script that allows the to pass parameters and execute a SP but that all depends on how cowboy you want to go
in the interest of security, i would go with the bespoke app development
***The first step is always the hardest *******
July 3, 2018 at 7:35 am
rohit.anshu - Tuesday, July 3, 2018 12:11 AMHi, I'm part of a small DW/BI team using SQL 2008( upgrading to 2016 in a couple of months) + tableau . There are frequent changes that we receive from business which needs running Update queries on a couple of tables. I'm trying to find a quick and easy solution where we can have an interface provided to users which will allow them to make changes on their own after running few validations.don't want an excel/csv load , something more like a web page, but we don't have any .net skillset so don't want to take that path. Also, tableau ( or any reporting tool) doesn't have a write back feature. Is there any new feature in 2016 that can be used? . The data is sensitive so can't have any 3rd part tool or a cloud based solution.
MDS might be a possibility for you. This would allow you to give your users a controlled way of modifying data in SQL Server using Excel or Internet Explorer. But there is a learning curve.
July 5, 2018 at 6:25 pm
Thanks for the suggestions guys.. Since this is not to be done urgently, I'm inclined to explore MDS and then make a decision even if it takes up some time. No harm in learning something new if it solved the problem and is sustainable. Thanks again
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply