自动下载 BusinessObjecs Web Intelligence 报告
我的任务是自动检索几个 BusinessObjects Web Intelligence 报告和对其进行进一步加工。
我没有其他方法来访问这些数据(这是我遵循的第一个途径),所以我将必须进行一些屏幕抓取。 唉,该界面似乎仅限用户使用。 咕噜!
以前有人这样做过吗? 喜欢分享吗?
另外,有谁知道有一个很好的自动化网络浏览器库吗? 我知道有一个 python 东西可以用于测试 Web 应用程序 - 但我需要 .NET 中的东西......你最喜欢什么?
PS:我还检查了这个线程(自动从网页获取报告),但是我希望有一个 Web Intelligence 特定的解决方案。
I'm tasked with automating the retrieval of a couple of BusinessObjects Web Intelligence reports and further processing thereof.
I have no other means of access to this data (this was the first avenue I followed), so I will have to do some screen scraping. Alas, the interface seems user-only. Grr!
Has anyone done this before? Like to share?
Also, does anyone know of a good library for automating the web browser? I know there is a python thingy out there that can be used for testing web applications - I need something in .NET though... What is your favorite?
PS: I have also checked this thread (automate getting report from webpage), but am hoping for a Web Intelligence specific sollution.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
BO 作业调度程序可以设置为在给定时间自动运行报告并将其导出为 Excel、CSV 等。报告可以转储到 Web 服务器上,这将比尝试违背操作更容易进行屏幕抓取或下载BO 网络报告直接进行,因为网络报告是分页的。
我个人没有这样做过,但我曾与为我这样做的顾问合作过。 您最好的选择可能是请一位经验丰富的 BO 顾问来为您设置。
The BO job scheduler can be set up to automatically run reports at a given time and export them as Excel, CSV, etc. The reports can be dumped onto a web server, which will make for easier screen scraping or downloads than trying to go against the BO web reports directly, because the web reports are paginated.
I haven't done this personally, but I've worked with consultants who've done it for me. Your best bet is probably going to be calling in an experienced BO consultant to set it up for you.
如果您尝试复制 Web 浏览功能,那么使用 cURL 确实不会出错,从 .NET 程序调用 cURL 脚本不会有任何问题。
我不熟悉网络智能,但我们使用 cURL 每 2 秒运行 30 个实时报告,从自定义网络服务读取数据。 Web 智能可以响应 HTTP POST 吗? 例如我们发布这样的参数:
If you're trying to replicate web browsing functions, you really can't go wrong with cURL, you'll have no problems calling a cURL script from your .NET program.
I'm not familar with web inteligence but we use cURL to to run 30 real-time reports every 2 seconds reading from a custom web service. Can web intelligence respond to HTTP POSTs? For example we post parameters like this:
您是否考虑过使用 BusinessObjects Enterprise 支持的公共 API 来实现此类目的? 所有文档均可在 SAP 开发人员网络网站 上获取。
具体来说,如果我使用 Java,我将考虑 BusinessObjects Platform SDK 和 REBean API 的组合来完成这项工作。 另外,还有一些 WS API 可以让您做很多相同的事情。
Have you considered using the public APIs that BusinessObjects Enterprise supports for this sort of purpose? All of the documentation is available on the SAP Developer Network site.
Specifically, I would be looking at a combination of the BusinessObjects Platform SDK and the REBean API to do this work, if I were using Java. Alternatively there are some WS APIs that will let you do much of the same stuff.
你看过QaaWS吗? (查询作为 Web 服务)——它应该让您能够访问 WebI 报告正在使用的同一个 Universe 查询——但如果您依赖 WebI 报告作为预处理器,这可能不会给您带来多大好处。 只是一个想法。
Have you looked at QaaWS? (Query As A Web Service) -- it should let you get access to the same universe query that the WebI report is using -- but that may not do you much good if you are relying upon the WebI report as a pre-processor. Just a thought.
您是否看过 Report Launch,它是一个基于 Web 的框架,它包装了 BOE,并为所有类型的调用(如您所描述的调用)提供了单一 URL 调用。
Have you looked at Report Launch its a web based framework that wraps BOE and provides sinple URL calls for all types of calls like the one your described.