I have been given the task to Load all our company's project data from MS Project into SQL Server to be able to create reports and dashboards from the project data.
我已经完成了任务，将我们公司的项目数据从MS project加载到SQL Server中，以便能够从项目数据创建报告和指示板。
I know you can export a specific projects data into a access database, but every project must have it's own access database. So my first thoughts was to create some kind of dynamic access SSIS connector and ETL. So that the project managers export their projects to access and the SSIS package takes care of the rest.
我知道您可以将特定的项目数据导出到访问数据库中，但是每个项目都必须有自己的访问数据库。所以我的第一个想法是创建某种动态访问SSIS连接器和ETL。这样，项目经理就可以将他们的项目导出来访问，而SSIS包则负责其余的工作。
Is there a simpler way of doing this?
有没有更简单的方法?
My company also have a SharePoint infrastructure as well as SAP BusinessObjects infrastructure. Is there a way I can accomplish this by the use of SharePoint or bobj
我的公司也有SharePoint基础设施以及SAP商业项目基础设施。有什么方法可以通过SharePoint或bobj来实现这一点吗
2 个解决方案
#1
3
The simplest but costy way is called MS Project Server - it stores all data in MS SQL database already, has precalculated reporting database and so on. Here is a link http://technet.microsoft.com/en-us/evalcenter/hh973404.aspx. The last version can be either installed locally or hosted by Microsoft.
最简单但很省事的方法叫做MS Project Server——它已经将所有的数据存储在MS SQL数据库中，有预计算的报表数据库等等。这里是链接http://technet.microsoft.com/en-us/evalcenter/hh973404.aspx。最后一个版本可以在本地安装，也可以由微软托管。
Another option I see is to use kind of automation around MS Project which will load project plan, extract all interested information and upload to to your database. There is no big magic in this solution.
我看到的另一个选项是围绕MS项目使用某种自动化，它将加载项目计划、提取所有感兴趣的信息并将其上传到数据库。这个解决方案没有什么大的魔力。
The third option is to export projects to XML and then use the XML to upload data to SQL Server database. This solution is also doable through Project automation
第三种选择是将项目导出到XML，然后使用XML将数据上传到SQL Server数据库。这个解决方案也可以通过项目自动化来实现
#2
1
After defining your database and column structure in SQL Server, just use Project VBA to A) collect the project and task data into an array, B) set a connection string to your database, then C) send it. I have created several applications around this procedure and it works very well.
在SQL Server中定义数据库和列结构之后，只需使用Project VBA到A)将项目和任务数据收集到一个数组中，B)设置到数据库的连接字符串，然后C)发送它。我围绕这个过程创建了几个应用程序，它运行得非常好。
#1
3
The simplest but costy way is called MS Project Server - it stores all data in MS SQL database already, has precalculated reporting database and so on. Here is a link http://technet.microsoft.com/en-us/evalcenter/hh973404.aspx. The last version can be either installed locally or hosted by Microsoft.
最简单但很省事的方法叫做MS Project Server——它已经将所有的数据存储在MS SQL数据库中，有预计算的报表数据库等等。这里是链接http://technet.microsoft.com/en-us/evalcenter/hh973404.aspx。最后一个版本可以在本地安装，也可以由微软托管。
Another option I see is to use kind of automation around MS Project which will load project plan, extract all interested information and upload to to your database. There is no big magic in this solution.
我看到的另一个选项是围绕MS项目使用某种自动化，它将加载项目计划、提取所有感兴趣的信息并将其上传到数据库。这个解决方案没有什么大的魔力。
The third option is to export projects to XML and then use the XML to upload data to SQL Server database. This solution is also doable through Project automation
第三种选择是将项目导出到XML，然后使用XML将数据上传到SQL Server数据库。这个解决方案也可以通过项目自动化来实现
#2
1
After defining your database and column structure in SQL Server, just use Project VBA to A) collect the project and task data into an array, B) set a connection string to your database, then C) send it. I have created several applications around this procedure and it works very well.
在SQL Server中定义数据库和列结构之后，只需使用Project VBA到A)将项目和任务数据收集到一个数组中，B)设置到数据库的连接字符串，然后C)发送它。我围绕这个过程创建了几个应用程序，它运行得非常好。