P6ProLinkMSql Application Overview

This Android application enables Primavera P6 Professional stand-alone users to remotely update the P6Pro database whether from construction site or from other remote areas than where the P6Pro software is located. The raw construction progress data collected have to be verified/confirmed by P6Pro user before scheduling in P6Pro software. When the activities’ progress data have been confirmed, the user only has to press F9 or use schedule option in the P6Pro program. This application eliminates the double data input by P6Pro user when updating a project schedule file.

In order to use this Android application, user has to install Microsoft SQL Server Express database connected to the P6Pro program.

Prerequisite:

P6ProLinkMSql

Must use Primavera P6 Professional stand-alone version.
Must install Microsoft SQL Server Express (MSSE) as your database. (2008R2 or 2012 are all acceptable)
Please read DocID 906474.1 in Oracle Support Primavera Solutions for installation of the MSSE database.

Must have network router installed at your office and configured for public port forwarding IP set up.
Your office/home computer where the MSSE database is located should not be in sleep mode.

Usage – a short version

1. Open P6ProLink android application

2. Connect to your P6Pro database from your mobile device

3. Select your schedule project, activity and input progress information

4. Press Update button to revise the activity data information in P6Pro

5. Exit from the android application

6. Open your P6Pro software and review the progress data you have input

7. Confirm your P6Pro progress input and press F9

Video presentation

User can view the Youtube P6ProLink video presentation.

Pre-requisites when using the mobile application

1. You must be P6 Professional stand-alone user.

2. You must have the Microsoft Sql Express Server database installed. (Does not connect with Oracle Server or Oracle Sqlite database)

3. You must use wifi router at office or where your P6Pro software is located

4. Your computer must not be in sleep mode when you connect from remote area

1. P6ProLink application icon

After the user installs the P6ProLink android application, the above P6ProLinkMSql icon will appear on the android mobile device.

2. P6ProLink Login Screen

When the user clicks on the P6ProLink icon, the above login screen will appear on the mobile device.

1) Database Address shall be the IP address designated by the user wifi router port forwarding IP address when user setup the server port for Microsoft Sql Express Server.

2) Database Port shall be the port designated when MS Sql Express Server was installed by the user and the default Port assigned by MS Sql Express Server is 1433.

3) Database Name shall be the database which contains the P6 Professional scheduling projects data are located and it can be PMDB, PPMDB, and etc.

4) Database User ID can be designated by the user but the default for the MS Sql Express Server is “sa”. (Systems Administrator)

5) Database Password shall the password assigned by the user for the MS Sql Express Server database.

6) After completing the login input information to P6ProLink, click the “Login” button. If there are no errors connecting to the user’s MS Sql Express Server on the user’s computer, then the following screen below will appear. If the connection is bad, then error message will pop up indicating the database connection failed.

MS Sql Server Express Additional configuration help

1) Instruction for installing Microsoft Sql Express Server:

a. MS Sql Express Server 2008R2

Refer to “How2InstallMSSQLServerExpress2008R2.pdf” file for instructions.

b. MS Sql Express Server 2012

Refer to “How2InstallMSSQLServerExpress2012.pdf” file for instructions.

Please also refer to Oracle Primavera Support Solution DocID 906474.

2) Instructions for setting up the port forwarding IP address in your router is as follows:

User can view the presentation video of setting up port forwarding steps for the wifi router.

And you can also google search “How to setup port forwarding on a ‘manufacturer’ router”.