Project and Portfolio Management Practitioners Forum
cancel

Showing sharepoint data in PPM validation

Highlighted
Rajiv joseph
Contributor.

Showing sharepoint data in PPM validation

Hi,

I need to show, a list of values stored and updated in sharepoint, in PPM auto complete list. whenever the list is updated in sharepoint, in PPM validation also it should reflect dynamically.

Please share your ideas. Thanks in advance.

Regards,
Rajiv
4 REPLIES
Celil
Acclaimed Contributor.

Re: Showing sharepoint data in PPM validation

Hi joseph,

There are two way;

Solution1.Step1: Transfer the list content from Sharepoint to PPM:
Create a table in PPM DB which will become a shadow of the sharepoint list. After than you could write a code in sharepoint that could connect to PPM DB to write down the list content to the table. This code could triger when you add a new item to the sharepoint list.

Solution1.Step2: Get data from the table to validation:
In PPM, create a validation and write there a SQL which return validation content and which read data from the table.

That's all

Solution2.Step1: Transfer the list content from Sharepoint to PPM:
You could create a view that call a table which contain the sharepoint list data from sharepoint.

Solution2.Step2: Get data from the table to validation:
same as solution1.step2

That's all

I hope It is helpful for you.

Celil
Celil

IT Governance Professional
& PPM Solution Architect
Abdullah Rafiq
Respected Contributor.

Re: Showing sharepoint data in PPM validation

Celil,
those are both good options.
Rajiv joseph
Contributor.

Re: Showing sharepoint data in PPM validation

Thanks Celil.
AlexSavencu
Acclaimed Contributor.

Re: Showing sharepoint data in PPM validation

Actually, copying Sharepoint data to PPM DB might result in data inconsistencies due to changes in the Sharepoint data.

 

If you have the possibility to create a DB Link from the PPM Oracle DB to the Sharepoint DB and read data in the validation via the DB link, that would be a much better option.

 

Cheers,

Alex


--remember to kudos people who helped solve your problem