大量 Excel 数据拉取 - 避免 ODBC
我们需要向用户提供对系统数据的大型子集的临时访问，以便在 Excel 中进行分析。 我们不想授予直接 ODBC 访问权限。这将限制我们在不中断用户进程的情况下更改数据库布局的能力。
Web 服务似乎不适合处理涉及数百或数千条记录的数据量。
作为直接 ODBC 访问的替代方案，您有何建议？
We have a requirement to provide ad-hoc access to large subsets of a system's data to users to analyse in Excel.
We do not want to grant direct ODBC access. This will curb our ability to make DB layout changes without our users' processes breaking.
Web Services seem ill suited for the volume of data at stake, in the region of 100's of thousands of records.
What would you suggest as an alternative to direct ODBC access?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
有一个“视图”的数据库概念，它完全可以满足您的需要 - 它允许公开大量数据，并且只要您注意向用户公开相同的数据，就可以自由地更改数据库模式。
我同意您关于 Web 服务的看法 - 这不仅是数据量的问题，而且让 Web 服务与 Excel（2007 及更高版本）一起使用这一事实绝非易事。此外，您将像使用视图一样锁定数据库模式。
对于真正大量的记录，您可以考虑数据仓库 - 一个单独的数据库，您可以在其中提供只读访问以用于报告目的并从读/写数据库提供数据。通过 SSIS 可以轻松快速地完成馈送。
华泰
There is a database concept of a "view" which does exactly what you need - it allows to expose large set of data and gives you a freedom of DB schema changes as long as you take care of exposing the same data to a user.
I agree with you regarding web services - it is not only the volume of data, but also the fact getting web services to work with Excel (2007 and above) is far from trivial. Also you will lock your DB schema as much as you would with a view.
For the really, really huge number of records you can consider data warehousing - a separate db, where you provide a read only access for reporting purposes and feeding the data from your read/write database. The feed can be easily and quickly done via SSIS.
HTH