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
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

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.