Dynamic deployment of datasets

• Andyew

  Mr or Mrs. 500

  Points: 505

  More actions

  February 4, 2015 at 11:38 pm

  #303033

  Dear All,

  Hopefully the topic has the right terminology.

  OK we have a fairly sophisticated web based asset management app using SQL 2008 R2 as the storage.

  The application allows users to create their own table structures via the web interface for storage of data. We use an EAV model to facilitate this functionality. We recently added some code to dynamically create flat views of the pivoted EAV data.

  Now the challenge is to, just as dynamically, make the views available to the users via Reporting services.

  I am familiar with creating reports/datasets and publishing them via BIDS\VS however the potentially changeable nature of the source views is a challenge.

  My most basic requirement, without knowing the strict technical limitations, would be to push updated datasets to the reportserver so the users can access the datasets via reportBuilder and create/modify their reports.

  I would not be trying to make sure any reports currently referencing an updated data would also be updated. That's a bit too ambitious.

  I have reviewed many methods and scripts and I'm thinking my goal would be to use RS.exe to push .rsd files to the report server.

  However this seems to be based on the idea you already know what you intend to publish and just making a copy or re-deployment. In my case I have no idea what the Dataset will look like until the view is created. There could be many views per day created or modified.

  My questions amongst all this are

  - Am I approaching the problem the right way?

  - Is it even possible to push an rsd without an RDL?

  - Can I create the rsd's using some form of script to list the database views to be published as Datasets? The published data would be a simple "Select * from <view_name>"

  Hope you can help.

  regards

  Andrew