如何在不暴露数据库元数据和数据密钥的情况下将BI数据传递到客户端 [英] How to deliver BI data to client without exposing Database metadata and data keys

问题描述

我们收到了客户的请求，要求他们通过授予对我们数据库的只读权限来访问原始数据。 一般来说，这是一个好主意吗？ 如果不是一个好主意，那么替代解决方案是什么？

解决方案

您好xxcmwxx，

最佳解决方案是站起来的PowerBI报表服务器，从数据库导出数据，并构建数据模型以支持客户需要的报表和仪表板。这会创建与数据库的隔离，并为您的客户提供他们想要的特定
数据。 

Power BI报表服务器

您还可以将历史数据导出到SQL数据仓库实例，以进行长期存储，然后使用Analysis Services构建模型并进一步增强数据，然后通过Power BI客户端向最终用户提供这些数据：  企业
带有SQL数据仓库的Azure中的BI

这是一个关于Power BI的好博客：  Power BI和Power BI指南架构图

我希望这些信息有用，

问候，

Mike

We have a request from a client to provide them with access to there raw data by granting read only access to our database.  In general, is this a good idea?  If it is not a good idea, what are alternative solutions?

解决方案

Hi xxcmwxx,

The best solution is to stand-up a PowerBI Report Server, export data from your database, and build a data model to support reports and dashboards that your customer desires. This creates isolation from the database and provides your customer the specific data they desire. 

Power BI Report Server

You could also export historical data to an SQL Data Warehouse instance, for longer term storage, and then use Analysis Services to build models and further enhance the data, which then becomes available to the end-user through Power BI client: Enterprise BI in Azure with SQL Data Warehouse

This is a good blog with regard to Power BI: A Guide on Power BI and Power BI Architecture Diagram

I hope this information is helpful,

Regards,

Mike

这篇关于如何在不暴露数据库元数据和数据密钥的情况下将BI数据传递到客户端的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！