SQL server database and Project 2007

[fpaz]

Hi,

I have a database in SQL Server 2000 with manufacturing data (customer
orders, production orders, production times and materials, etc.) I'm
using the ODBC database access in order to integrate the data in SQL
with a production planning in Project 2000.

It's a 2-way system. By using stored procedures I add new tasks in
MSP_TASKS (each for a production order), MSP_LINKS and MSP_ASSIGNMENTS,
customized fields in MSP_FLAG_FIELDS, MSP_TEXT_FIELDS, etc. and Project
calculates and give me back the finish dates, MSP_CALENDAR_DATA, the new
links between tasks, etc. and, of course, a lot of customized Gantt
Charts, Network Diagrams and so on.

I just recently discovered that Project 2007 is not able to save data
of a ODBC source!! How is that possible! Is there another way to
integrate my SQL database with Project? Integration with Excel is a very
bad choice for someone working with a DBMS like SQL Server and it not
allows a real integration. The same about de .mdb files.

Of course I'm using Project 2000 and I'm not in trouble right now. But
that producto is close for obsolescence... It's very frustating to
develop something without chances of survival in the future!

Any help? Someone with a similar problem/experience?

Thanks

 

[Gérard Ducouret]

Hello fpaz,

If you want to work with MS Project (Professional version) 2007 and SQL
Server, you will have to install Project Server 2007 which will create its
own databases on SQL Server.

Gérard Ducouret

 

[fpaz]

Thank you, Gérard,

Do you know if there is a database reference in Project Server 2007
like the one in Project 2000 (http://www.msproject.com/P2K Projdb.htm?
Can you recommend me a good book in amazon to manage data from SQL
Server in Project Server 2007?


Thanks

 

[Andrew Lavinsky]

You might check out Project 2003, and see if that supports your needs. There
were some major changes between 2003 and 2007 which probably removed the
functionality you're looking for.

Not that this helps necessarily. Not sure if the support outlook for 2003
is any better than 2000.

There's also the option of macros or third party tools somehow to pull the
data back and forth. I don't know of anything in existence, but you could
either develop something or contract someone to develop it. That's how many
of the tools like SAP or Maximo interact with the Project client. You might
try posting that question on the Project Developer newsgroup and see if
anyone recommends something.

 

[Gérard Ducouret]

fpaz,

Office Project Server 2007 data is partitioned into four databases in
Microsoft SQL Server:
http://technet.microsoft.com/en-us/library/cc973099.aspx
But only the "Reporting" database architecture is described by Microsoft.
You can access it programmatically by the PSI interface:
The Microsoft Office Project 2007 SDK contains documentation, code samples,
how-to articles, and programming references to help customize and integrate
the Project 2007 clients and Project Server 2007 with other applications for
enterprise project management.
http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&displaylang=en

Gérard Ducouret