Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
 View Only
Expand all | Collapse all

Primavera P6 and Asana connections

  • 1.  Primavera P6 and Asana connections

    Bronze Contributor
    Posted Feb 15, 2021 03:15 PM
    Hello,

    I'm hoping to create some integration between Asana task management tool and Primavera P6 running Web Services, and am running into dead ends.

    For access to Asana, I've found a connector for Power Automate and Power Apps. However it seems I must have a Task ID already identified before I can make any calls.  Is there a way to query a Workspace to get IDs for related Projects, and then to query a Project ID to get related Tasks?  Having a task list, I could then take action on the specific task ID.

    On the P6 side, the Primavera Web Services offers support for SOAP style calls.  However I can't find a way to connect to it with either PowerApps or Power Automate.  I see only one SOAP connector but it looks like it's specifically for a different app, and can't be used for Primavera. Is it possible to make a generic SOAP connection. If so, how do I go about that?

    Thanks,
    Steve

    ------------------------------
    Steve Bolton
    Sr. Business Analyst
    ------------------------------


  • 2.  RE: Primavera P6 and Asana connections

    Top Contributor
    Posted Feb 16, 2021 01:34 AM
    You can create a custom connector for SOAP APIs in Logic Apps, so try that.

    If you must use power automate, you can develop some middleware in PowerShell to hit the API using the New-WebServiceProxy cmdlet, in a PowerShell Azure function or Azure automation runbook. Call those by HTTP or the Azure Automaton connector respectively.

    Here's a random blog I found about hitting SOAP APIs in PowerShell https://jpearson.blog/2019/04/09/calling-soap-services-from-powershell/


    ------------------------------
    Will Page
    Technical consultant
    Christchurch, NZ
    ------------------------------



  • 3.  RE: Primavera P6 and Asana connections

    Bronze Contributor
    Posted Feb 17, 2021 08:18 AM
    Thanks Will.  I'll look into those options.

    ------------------------------
    Steve Bolton
    Sr. Business Analyst
    ------------------------------



  • 4.  RE: Primavera P6 and Asana connections

    Posted Feb 18, 2021 02:12 AM
    Hi Steve,
    Actually I haven't worked with ASANA, tbh

    but I have actually integrated Primavera P6 and Power BI in depth.
    Below is the demonstration of the work,
    Project Controls using Data Analytics (Primavera P6 and Power BI Integration)
    YouTube remove preview
    Project Controls using Data Analytics (Primavera P6 and Power BI Integration)
    View this on YouTube >




    ------------------------------
    Jawad Ali
    4763
    ------------------------------



  • 5.  RE: Primavera P6 and Asana connections

    Bronze Contributor
    Posted Feb 18, 2021 08:31 AM
    Hi Jawad.

    Thanks for the link to your YouTube channel.  It looks like you have done a lot of data analytics with P6, but from what I was able to tell it's all via export to Excel and then read from there into Power BI.

    What I'm looking for is to get data using Power Apps or Power Automate via the P6 the Primavera Web Services directly rather than needing an export to Excel first. I then need to use that task info to update related records in an Asana project.

    ------------------------------
    Steve Bolton
    Sr. Business Analyst
    ------------------------------



  • 6.  RE: Primavera P6 and Asana connections

    Posted Feb 18, 2021 08:38 AM
    What if I tell you I never opened excel?? :)
    i connect P6 data warehouse directly with Power BI. means zero modification in excel u won't even open excel.
    see how it works.

    1-You update P6, (press F9)
    2-You run reports (I designed them in P6 for structuring and modeling)
    3- You press refresh in Power BI.

    its that easy

    above all this model is fully automated that it ill adopt any project data automatically

    if you need any assistance and help do right me here

    ------------------------------
    Jawad Ali
    4763
    ------------------------------



  • 7.  RE: Primavera P6 and Asana connections

    Bronze Contributor
    Posted Feb 19, 2021 08:20 AM
    Nice enough for that application.  However what I said I was looking for is to get data using Power Apps or Power Automate via the P6 Primavera Web Services directly. That's the type of connection help I'm looking for. The P6 Web Services uses SOAP protocol. Have you connected using that at all?

    ------------------------------
    Steve Bolton
    Sr. Business Analyst
    ------------------------------



  • 8.  RE: Primavera P6 and Asana connections

    Posted Oct 20, 2021 09:41 PM
    Steve,

    I was wondering if you ever got an answer with this question?  I'm looking into the same problem now and I'm in the midst of trying to create a custom connector for Power Apps, but I need to figure out how to get the WS-Security layer working with that.  I'm also looking at it from Powershell, using the New-WebServiceProxy cmdlet to create a proxy object.  But when I do that I have trouble actually utilizing the services.  I tried with the Project Service to do a ReadProjects, but I don't seem able to create the payload properly.

    Anyway, I was wondering how far you got and was hoping you might have a bit of insight.  Thanks!

    D.
    --

    ------------------------------
    David Kuhl
    Stunt Dummy
    ------------------------------



  • 9.  RE: Primavera P6 and Asana connections

    Posted Oct 21, 2021 05:29 AM

    Hi David,

     

    Mustang develops many interfaces to P6 via P6 Web Services using .NET/C#.  We considered developing a P6 connector for Power BI for resale.  But after reviewing it, I decided that a connector is not really feasible because of the amount of P6 data that needs to be extracted and the numerous requests to retrieve the data.  Therefore, I decided to develop an extraction software utility that builds a reporting DB for BI reporting – the utility is called P6ETL™.  Once the P6 data is extracted from the P6 DB into the P6ETL™ DB, users can develop BI reports with any report development tool that can connect to a SQL Server DB.  To learn more about P6ETL™, go to www.p6etl.com.

     

    However – if you just want to connect to the P6 DB (either the native DB or the PX DB) with Power BI, check out this LinkedIn Group: https://www.linkedin.com/groups/13914226/ I created a couple videos in the group to demonstrate how to create Power BI reports for P6.

     

    Thank you

    Paul Ciszewski



    ------------------------------
    Paul Ciszewski
    Project Manager
    ------------------------------



  • 10.  RE: Primavera P6 and Asana connections

    Posted Oct 21, 2021 09:42 AM
    Thanks for that, but I'm more interested in pushing data back to the P6 system.  I'm trying to build a custom connector for that, but I'm getting tripped up on the WS-Security token and nonce that P6 requires.  I'm not sure how to get that into the connector yet.

    Cheers,
    D.

    ------------------------------
    David Kuhl
    Stunt Dummy
    ------------------------------



  • 11.  RE: Primavera P6 and Asana connections

    Posted Aug 17, 2021 06:23 AM
    Mustang Technologies developed an integration to Oracle Hosting/OCI called P6ETL™. P6ETL™ extracts the data from the Primavera P6 database using P6 Web Services and then P6ETL™ creates a reporting database (the P6ETL™ SQL Server database). Then users can connect Power BI to the P6ETL™ database and create Power BI reports. To learn more, go to www.p6etl.com

    However – if you just want to connect Power BI to the P6 DB, check out this LinkedIn Group: https://www.linkedin.com/groups/13914226/ I created a couple videos in the group to demonstrate how to create Power BI reports for P6.

    ------------------------------
    Paul Ciszewski
    Project Manager
    ------------------------------