我可以链接到R中的Business Objects Universe吗？ [英] Can I link to Business Objects universe in R?

问题描述

是否可以链接到R中的Business Objects Universe？

Is it possible to link to a Business Objects Universe in R?

我可以将R连接到SQL数据库，但这并不能给我提供已创建所有联接的Universe。我的最终用户当前通过Business Objects获得数据，但是R会更好地满足他们的需求。而且，由于他们已经熟悉字段名以及如何在业务对象中链接表，因此我希望他们仅将R链接到现有的BOBj Universe。
谢谢！

I can connect R to a SQL database but that doesn't give me the Universe where all the joins are already created. I have end users that currently get there data through Business Objects but R would better suit their needs. And, since they are already familiar with field names and how the tables are linked in Business Objects, I would like for them to just link R to the existing BOBj universe. Thanks!

推荐答案

由于不允许我推荐特定软件（对我来说是新软件，但公平的是公平的） :)）我只提到两个选项：
1）在互联网上搜索使odbc访问业务对象Universe的软件。这些是我最喜欢的搜索引擎上的好关键字： odbc利用SAP BusinessObjects Security
具有明显的优势，可以确保所有用户访问均受业务对象控制，但是数据必须通过该服务器传输，并且您将需要向SAP以及新odbc的供应商支付许可证费用...
2）为有问题的用户提供ODBC访问与BO报告/ Universe相同的表的权限，并使确保允许他们在其数据提供程序中查看SQL。然后告诉他们编写一份报告，然后将SQL复制并粘贴到R
选项二可以为您节省一些许可证并为您提供更好的性能，但是我个人会选择选项1）：）

Since I'm not allowed to recommend specific software (new to me, but fair is fair :)) I'll just mention two options: 1) search the internet for software that gives odbc access to business objects universes. These are good keywords on my favorite search engine: 'odbc leverages SAP BusinessObjects Security' It has the distinct advantage of making sure that all user access is being governed by business objects, but data will have to travel through that server, and you will need to pay for licenses to SAP as well as the vendor of the new odbc... 2) give the users in question ODBC access to the same tables that the BO reports/universe run against, and make sure they are allowed to see the SQL in their dataproviders. Then tell them to 'cook up a report, and the copy&paste the SQL to R' Option two may save you some licenses and give you better performance, but I would personally go for option 1) :)

这篇关于我可以链接到R中的Business Objects Universe吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！