Trusted Contributor.. debasish86 Trusted Contributor..
Trusted Contributor..
740 views

HP PPM and Tableau integration

Jump to solution

Hello HP PPM gurus,

Currently I have received a requirement to integrate HP PPM 9.32 and Tableau. UNfortunately, I haven't worked on integration to any of the reporting tool and would require assitance from all you amazing people.

Kindly revert if anyone has ever done this OR any sort of supporting document which could be of help

Awaiting response

Regards

Debasish

0 Likes
1 Solution

Accepted Solutions
Derek Giedd Honored Contributor.
Honored Contributor.

Re: HP PPM and Tableau integration

Jump to solution

We use Tableau to generate reports from PPM.  We have our PPM database replicated to another database for reporting purposes.  Tableau pulls the data directly from this database.  So, there is nothing to do on the PPM side, you would just set up Tableau to read from your PPM database.  You are responsible for creating the SQL to pull the data you need.

-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
3 Replies
Derek Giedd Honored Contributor.
Honored Contributor.

Re: HP PPM and Tableau integration

Jump to solution

We use Tableau to generate reports from PPM.  We have our PPM database replicated to another database for reporting purposes.  Tableau pulls the data directly from this database.  So, there is nothing to do on the PPM side, you would just set up Tableau to read from your PPM database.  You are responsible for creating the SQL to pull the data you need.

-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
Trusted Contributor.. debasish86 Trusted Contributor..
Trusted Contributor..

Re: HP PPM and Tableau integration

Jump to solution

hello Derek,

Thank you for the information and sincerely appreciate your response.

To trouble you a bit more, would be able to share any sort of documentation OR steps that you followed in terms of system configuration or settings as I am quite new to this and might not have enough expertise.

Awaiting your response.

Regards

Debasish

0 Likes
New Member.. ujjwal_Anand
New Member..

Re: HP PPM and Tableau integration

Jump to solution

Hi,

You can just create a DB account in PPM database and give grant access to your database , in that way Tableau can access PPM Database and can query the data exactly like the SQL developer, if the purpose is to generate specific report then you can simply create a View or Mview in PPM and again grant access to Tableau account.

i have implemented the solution for client and they are using that view to publish Tableau Dashbords.

Feel free to get in touch if you need more information.

Regards,

Ujjwal Anand

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.