BC On Prem SQL table access vs Cloud table Access - Level of granularity in data access for cloud vs On Prem

(0) Share

Report

Posted on by Warric

Hi All

For our current BI solution we directly access our on Prem SQL server with BC installed and report using those tables (via SSIS/SSAS). If we move to the public cloud solution would this level of access be unavailable?

Is it possible to create the same level of detailed reports using azure and BC connectors as directly accessing BC Cloud? i.e. do you have access to the same granular detail of all your data?

Thanks

Warric

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Steven Renders 5,672 Moderator on at

Like (1)

Report

In BC Saas you don't have access to the SQL database.

You can use (and create) api's and webservices to expose the data. These api's and webservices are based on Query or Page objects.

So the answer is kind of a yes, since you can use or create the api's that you need.

What you can not use are views, stored procedures,... because they need o be created in the db, which you can not access.

Queries and pages give you access to the tables+fields, so you decide which tables, fields,... you expose in the api's, and then consume that data in Power BI, or any other tool that can connect to a datasource using rest-api's or odata webservices.

Was this reply helpful? Yes No