Share via

SQL Web Interface to allow users to maintain a table

Ismail Cassiem 226 Reputation points
2021-01-16T00:17:13.137+00:00

Hi,

I have a file maintained centrally by a user for 5 countries which has become impossible as the users either late etc

How do i get the data loaded into the DW for 5 countries, i dont really want to create copies of the files for ach contry as the pkg refreshes 4 times a day and any of those files were open it would fail

Is there similar MDS Web interface available where i can have a dw table available to be edit by users?

Regards

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ismail Cassiem 226 Reputation points
    2021-01-18T21:35:50.047+00:00

    Hi,
    It's more of an wb interface that updates a table in DW. Users maintain an excel file but i have a near realtime job andcontinous to fail when user has files open
    i thought like mds, having a web where user can perhaps insert table that goes to a table within any dtabase the dw could read from
    please any ideas?
    thank you

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.