Re: Oracle to MS Project Interface?

Hi Andrew,
the answer to your question depends upon how much and what kind of project data you want on the Oracle database. To get full project functionality you need to have the data stored in either Access or SQL Server. If all you want to do with project is display Gantt charts and track simple start, finish tasks then you could have that information stored in the Oracle dB and have project open sets of data from the oracle dB via ODBC. This approach will greatly limit the usefulness of the tool. What I would recommend is that you have your project data stored on a SQL server and then have your Oracle database pull information from the SQL Server as needed. This will give you the most flexible solution.

Good luck...

--
Brian K.
Microsoft Project MVP Candidate


Andrew Zitelli wrote in message <362F811A.FEC05C8A_at_tus.ssi1.com>...


>I have recently been asked to develop a system which is to include an MS

>Project 98 component, with the project data being stored in an Oracle

>db.  I have worked with Oracle for 10 years but have not previously

>worked with MS Project. I would like to use Oracle as the repository to

>store project data, for users from multiple sites to download.  Most of

>the documentation I have read so far refers to the Project data being

>stored in an Access database.

>

>Can anyone offer suggestions on how to get started, 3rd party tools or

>other tips that would help me?  I assume someone is already doing this

>and do not want to reinvent the wheel.  Thanks!

>