Forum Discussion

Prasad1's avatar
Prasad1
Helper 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.

 

Regards

Prasad

Need Help

5 Replies

  • 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
      Helper 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
        Advocate 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