E9.1 Connection between Excel/Power BI to JDE

[leech64]

Hello!
How can you make a connection between Excel/PowerBI and JDE?
I am trying to query data from JDE so I don't have to keep logging in, running a report, and finally exporting it to my desktop.

Thanks in advance!

 

[Larry_Jones]

Your connection would be to the JDE Database (Oracle, SQL Server, ...) not directly to JDE.

 

[glen7x]

You could try invoking ReST calls from Excel to the AIS.