Using DB
In the Open Standard
Safak VuralMember for 18 years 5 months
- Created
- 4
- 1
0
Dear planners,
After a good start with P3, It would be great if we(as a COMPANY) could pass to the P6. I wish to ask about PM database. We are using time recording and qs databses on a domain. If we installa PM database to same domain is it possible to create querries between this databases and use update querries to update P6.
Is there any problems you encounter or any prohibations from the software.
All kind of suggestions are highly appreciated.
Regards,
Safak
After a good start with P3, It would be great if we(as a COMPANY) could pass to the P6. I wish to ask about PM database. We are using time recording and qs databses on a domain. If we installa PM database to same domain is it possible to create querries between this databases and use update querries to update P6.
Is there any problems you encounter or any prohibations from the software.
All kind of suggestions are highly appreciated.
Regards,
Safak
4 replies
Oldest first- 0Dieter Wambach ·Safak
PMDB within a domain(MS SQL-Server 2005 SP2 or Oracle 10.2 or 11.1) shouldn’t be a problem. Have a look under "Tested Configurations" on your installation DVD and study the admin guide.
Together with P6 you receive an API (Application Programmers’ Interface). This will cover the handling of metadata as well. Read tables: no problem, write/edit tables: you’ll need some learning and experience - be careful.
Regards
Dieter - 0Safak Vural ·Dear Dieter,
Thank you for your support. I survey the 102 & 106 books. There are no information aboud the database systems and algorothms. If there are good papers or documents about this subject, could you share or link?
I am planning to use a IT help (proffessional about DB). For info; We are using MS SQL for other in project applications.
Regards,
Safak - 0Dieter Wambach ·Dear Safak
in 102 and 106 you won’t find that information. On your installation DVD or stick there is a directory "Docu". There you can find the admin guide.
D:\USB_P621SP\Documentation\English\Construction and Engineering --> file: adminguide.pdf
The data-model is under:
D:\USB_P621SP\Documentation\English\Technical Documentation\Schema Docs file: PMDB P6.2 Diagram.pdf (A0-format) and the description of all tables and processes: PM_62_schema.zip in the same directory.
Good luck!
Dieter
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?