1 Reply Latest reply on Apr 25, 2018 10:16 AM by AlasdairRobertson

    Cloud Connection String for BIDS Report


      I'm trying to create/modify reports in Cloud ISM and am having difficulty in Visual Studio with the SaaSAppModel.rds data source. What values need to be entered on these screens for a cloud user?


      I have our DB name for the initial catalog, but using our tenant URL for the datasource doesn't work. We use AD authentication, so I assume Use Windows Authentication would work, but would like to see if anyone has any insight.




        • 1. Re: Cloud Connection String for BIDS Report
          AlasdairRobertson ITSMMVPGroup

          If you have a cloud tenant you cannot directly connect to the production database for reporting.  You can get access via OBDC I think to your staging database for report writing (you have to request these details).  If you need access to live data for example for PowerBI/Xtraction or similar then you need a reporting tenant.


          The alternative is to request a backup copy of your database download it to a local SQL server then write your report and upload it to production.