Forum Discussion

Prasad1's avatar
Prasad1
Icon for Helper I rankHelper I
8 years ago

Connecting JD Edwards to Power BI

  Hi   We are using JD Edwards (On AS/400). I want to use Power BI on JD Edward ERP data. May I know is there any automated way to connect JD Edwards to Power BI?   Thanks in advance.   Regard...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Prasad1,

You use JD Edwards on AS/400, it means that you can get JD Edwards data by connecting to IBM DB2 database for AS/400.

In this case, you can use IBM DB2 Database connector in Power BI Desktop to connect to the database. Or you can create ODBC connection to AS400 following the guide in this blog, then use the ODBC connector in Power BI Desktop to connect to this ODBC data source.

Regards,
Lydia

  • Prasad1's avatar
    Prasad1
    Icon for Helper I rankHelper I
    8 years ago

    Hi Lydia

     

    Thank you very much for your response. Will ask our Admin to follow as advised.

     

    Will post the status here after completion of the task.

     

    Thanks

    Prasad

    • DavidKett's avatar
      DavidKett
      Icon for Advocate IV rankAdvocate IV
      8 years ago

      Hello, 

       

      We have developed a QuickLaunch solution that connects JD Edwards ERP to Power BI. We include a SSAS Tabular model with overe 20 perspectives and 1500 pre-defined measures and KPIs. Please check our our website at www.PreferredStrategies.com or find us in the Power BI Partners section of PowerBI.com. 

       

      Thanks, 

       

      David Kettinger

    • StoilovDobrin's avatar
      StoilovDobrin
      New Member
      7 years ago

      Did you complete the task?

      • DavidKett's avatar
        DavidKett
        Icon for Advocate IV rankAdvocate IV
        7 years ago

        You can connect Power BI to any JD Edwards database. IBM, Oracle, and SQL Sever. Just choose the Server and Database and connect. 

         

        The trouble is how to make since out of the data you get back ie decimals, julian dates, table joins, business logic, etc. Also, it is not a best practice to frequently query a production transaction system. If you are interested in a more turnkey solution check out www.PreferredStrategies.com.