最终用户临时报告工具：Microsoft SQL Server Management Studio 还是 Microsoft Access？
我们的集中 IT 部门为大约 200 名员工的一般用户群建议了两种主要的即席查询工具：
Microsoft SQL Server Management Studio 2008 (SSMS)
Microsoft Access 2003
环境
后端数据库是只读的 Microsoft SQL Server 2005 数据库。
架构有 400 多个表；允许我们的普通员工访问原始数据将是一场灾难。
我们将在原始数据上构建一个“抽象层”，供我们的普通员工运行临时查询。
我们将在原始数据上构建一个抽象层很可能包含多个视图。
多名用户具备Microsoft Access的基础知识；没有人使用过SSMS。
上述哪种工具（或替代方案）最适合大约 200 人的绝对非技术人员用户群？各自的优点和缺点是什么？
此外，IT 部门还建议教人们 T-SQL，以便他们可以使用 SSMS。这合理吗？
Our centralized IT department has suggested two primary ad hoc query tools for our general user base of approximately 200 staff members:
Microsoft SQL Server Management Studio 2008 (SSMS)
Microsoft Access 2003
Environment
The backend database is a read-only Microsoft SQL Server 2005 database.
The schema is 400+ tables; allowing access to the raw data for our general staff would be a disaster.
We will be building an "abstraction layer" over the raw data for our general staff to run ad hoc queries against.
The abstraction layer will most likely contain a number of views.
A number of users have basic knowledge in Microsoft Access; none have used SSMS.
Which of the above tools (or alternative) would be best for a decidedly non-techie user base of approximately 200 people? What are the pros and cons of each?
Also, the IT department has suggested teaching people T-SQL so they may use SSMS. Is this reasonable?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（9）
这个怎么样？ i-net Clear 报告（以前称为 i -net Crystal-Clear）有一个强大的临时报告组件，对于非技术用户来说是一个易于使用的东西。您的用户根本不需要了解有关报告的任何信息。他们只需选择报告类型、数据即可找到适合需求的报告。
数据抽象可以通过创建所谓的数据视图来轻松完成，数据视图可以由您的管理人员设计。有多种方法可以访问临时报告 GUI。我们有一个 Web GUI、一个 Java Applet 或一个独立的 Java 程序。
披露：是的。我在建造这个的公司工作。
How about this one? i-net Clear Reports (used to be called i-net Crystal-Clear) has a powerful ad-hoc reporting component that is made to be an easy-to-use thing for non-technical users. Your users won't have to know anything about reporting at all. They simply select the kind of report, the data et voila there is a report suiting the needs.
The data abstraction can be done easily by creating so called data-views which can be designed by e.g. your administration. There are various ways to access the ad hoc reporting GUI. We have a web GUI, a Java Applet or a standalone Java program.
Disclosure: Yep. I work for the company who built this.
“抽象层”是 Access 的正确方法。创建一个 MDB，将所需的基本视图链接到其中并分发给用户。允许他们根据需要在自己的 MDB 中创建新的查询和报告。
现在，我不太确定如何阻止他们在具有一百万条或更多记录的表上运行笛卡尔连接。
Your "abstraction layer" is the right approach to take with Access. Create an MDB with the basic views required linked into it and distribute to the users. Allow them to create new queries and reports in their own MDB as required.
Now how you are going to stop them from running a Cartesian join on tables with a million records or more I'm not quite sure.
微软为企业和最终用户提供了一个免费工具，称为“Report Builder”。它支持 SQL Server Reporting Services 的全部功能。它的好处是提供了类似于 Microsoft Office 的用户界面。
您可以从这里下载最新版本“Report Builder 3.0”
http://www.microsoft.com/download/en /details.aspx?DisplayLang=en&id=6116
有关 MS Report Builder 的更多信息，请查看此链接
http://technet.microsoft.com/en-us/library/dd207008.aspx
Microsoft have a free tool for business and end users which called "Report Builder". It supports the full capabilities of SQL Server Reporting Services. The good thing it is provides a Microsoft Office look-like user interface.
You can download latest version "Report Builder 3.0" from here
http://www.microsoft.com/download/en/details.aspx?DisplayLang=en&id=6116
And for more information about MS Report Builder check this link
http://technet.microsoft.com/en-us/library/dd207008.aspx
尝试教“非技术人员”T-SQL 查询具有 400 多个表的模式可能效果不佳，除非他们仅限于查询视图，并且视图隐藏了各种连接的所有丑陋的复杂性 我们公司也
有类似的情况，早期用的是Access，后来大家都转用T-SQL和SSMS。 IMO，这就是您想要采取的方法。
不过，这一点的成功将取决于您的观点的质量，或者更好的是您向最终用户提供的报告的质量。
兰迪
Attempting to teach "non-techie" people T-SQL to query a schema with 400+ tables probably isn't going to do well, unless they are limited to querying the views only, and the views hide all the ugly complexities of various joins, grouping etc.
Our company was in a similar situation where Access was used early on, and then we switched everyone over to use T-SQL and SSMS. IMO, this is the approach you'd want to take.
Again though, the success of this will depend on the quality of your views, or better yet, reports you provide your end-users.
Randy
我会更多地研究诸如 Stonefieldquery.com 之类的东西，它是专为非开发人员构建报告而设计的。并不是说 Access 中的报表编写器或查询生成器不好，而是可能太多了。我认为它们还提供了一种集中共享报告和查询的方法。多人将无法打开单个访问文件并创建报告（我认为查询构建是可以的。）。
大多数人会使用拖放功能，但大约 5-10% 的人会需要 SQL，然后您可以利用“可教学时刻”并为他们提供一些培训。
I would look more into something like Stonefieldquery.com that is designed for non developers to build reports. Not that the report writer or query builder in Access is bad, but may be too much. I think they also provide a way to centralize reports and queries where they can be shared. Multiple people are not going to be able to open a single access file and create a report (I think query building is OK.).
Most will use the drag and drop capability, but about 5-10%will come thing a need for SQL and then you can take advantage of the "teachable moment" and get them some training.
Access 的缺点肯定是成本；假设您获得了 SQL 服务器的适当许可，SSMS 应该是免费的。
根据实际需求，某些用户实际上可能更适合使用 Crystal Reports（从未想过我会这么说）或 Reporting Services。
Cons for Access certainly would be cost; SSMS should be free assuming you're properly licensed for the SQL server.
Depending on the actual needs, some users might actually be better off with Crystal Reports (never thought I'd say that), or Reporting Services.
您可以创建一系列 sql server 分析多维数据集，并让用户与使用 excel 的用户连接，以便他们可以使用 excel 的数据透视表。
you could create a series of sql server analysis cubes and have the users conenct to those using excel so that they can use excel's pivot tables.
作为临时报告的新手，并且我自己做这项工作，我使用了 Izenda.com 临时报告。这非常简单，我可以自己做，而不是外包。
Being a newbie at ad hoc reporting and doing the work myself, I used Izenda.com ad hoc reporting. It was very straight forward, and I could do it myself versus outsourcing.
检查 SQLS*Plus - http://www.sqlsplus.com
我发现 SQLS*Plus 是一个非常有效的命令line SQL 服务器报告工具 - 这是一个免费工具（供个人使用），允许我生成带有 HTML 和 CSV 格式的标题、标题、自定义掩码中的列格式、设置报告长度、页面大小等的报告。了解它与非常著名的 Oracle SQL*Plus 报告工具非常相似
Check SQLS*Plus - http://www.sqlsplus.com
I found SQLS*Plus to be a very effective command line SQL server reporting tool - this is a free tool (for personal use) and allows me to generate reports with the titles, headers, in HTML and CSV formats, format columns in custom masks, set report length, pagesize, etc. As I understand it is very similar to very well known Oracle SQL*Plus reporting tool