project professional/project server/oracle financial

[cloudno9]

Can i integrate these products togather so i can use oracle financial for financial reporting, use server for enterprise reporting and professional for data input?

Do i need any customized solution for this? and 3rd party recommendation? can i do data snychronization between project server sql database and oracle financial?

let me know please

 

[Wei-Dong XU [MSFT]]

Hi,

Appreciate your patience on this issue!

Project Professional can work very well with Project Prfessional whose base
data storage is SQL server. However, based on my research, there is one
utlity released by Microsoft to provide the support on the coopertaion of
SQL server and Oracle for Project & Oracle financial.

As I know, one 3rd party company provides the integration service for the
Project professional/ Project Server & Oracle financial. You may contact
them for more information regarding this issue:
http://www.ioko.com/DAIS/

In another way, I'd also suggest you can develop your own integration
application or use existing application for example BizTalk 2004 to perform
the integration. For Project development, this article may provide some
useful informtion for you:
Getting Started: Developing with Project 2003
http://msdn.microsoft.com/library/en-us/odc_pj2003_ta/html/odc_pjGetStarted.
asp?frame=true#odc_pjgetstarted_serverbaseddevelopment

Since Oracle is not Microsoft product, you may need to get the development
material from Oracle. In addition, .Net supports the Oracle database. These
kb articles may provide some assistance for you:
309361 How To Use a DataReader Against an Oracle Stored Procedure in Visual
C#
http://support.microsoft.com/?id=309361

308071 How To Access an Oracle Database by Using the OleDbDataReader and
Visual
http://support.microsoft.com/?id=308071

322158 INFO: Features and Limitations of the .NET Managed Provider for
Oracle
http://support.microsoft.com/?id=322158

320632 HOW TO: Fill a DataSet from an Oracle Stored Procedure by Using the
OLE
http://support.microsoft.com/?id=320632

Please feel free to let me know if you have any further question.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Yan-Hong Huang[MSFT]]

Hello,

I was reviewing the issue thread. Do you have any more concerns on it? If
you feel there is any we can help, please feel free to post here.

Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.