从Project Server 2010中提取数据 [英] Extracting data from Project Server 2010

问题描述

嗨伙计们，

我想问你的专业知识。 我已经完成了将项目服务器2010中的数据提取到列表中的任务，可能是在项目服务器的excel中。 然后将此数据更新为定制的SQL服务器数据库。

I'd like to ask for your expertise.  I have been givin the task of extracting data from project server 2010 into a list, perhaps within excel from project server.  This data will then be updated into a bespoke SQL server database.

该文件将包含以下字段：

项目名称

项目描述

Benifit类型

风险名称

风险类别

等......

The file would include such fields as:
Project Name
Project Description
Benifit Type
Risk Name
Risk Category
etc...

但是我认为这就像查询Project Server SQL服务器数据库中的数据一样简单。 我现在不确定是否是这种情况因为我被告知PS数据库是不可能的，因为架构很复杂。 我不确定Project
服务器布局，并希望有人能给我一些了解获取此类数据的信息。



我可以检索这个来自SQL数据库的数据？

我是否必须使用XML通过Sharepoint提取它？ （所以我被告知）

However I thought it would be as simple as querying the data from the Project Server SQL server database.  I'm now not sure if this is the case as I've been told the PS database is unquerable as the schema is complex.  I'm unsure of the Project server layout and was hoping someone could give me a little insight into obtaining this type of data.

Can I retrieve this data from a SQL database?
Do I have to extract it via Sharepoint using XML? (so I've been told)

非常感谢

推荐答案

您好Cidr

Hi Cidr

可以查询Project Server数据，但出于读取目的，请参阅
SDK文档您将找到报告数据库的完整模式，从中您可以获取您要查找的值通常在MSP_EPMProject_Userview中的项目服务器报告数据库中，您将获得大部分项目级别值

Project Server data can be queried but for readonly purposes , refer to the SDK documentation you will find the complete schema of reporting database, from where you can get the values you are looking for typically within project server reporting DB within MSP_EPMProject_Userview you will get most of the project level values

如果有帮助，请告诉我们

Let us know if this helps

这篇关于从Project Server 2010中提取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！