web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How can expose / conne...
Small and medium business | Business Central, N...
Suggested Answer

How can expose / connect Business Central SaaS database with Jedox?

(0) ShareShare
ReportReport
Posted on by RE-24072358-0 154
Hello Experts,
 
My customer want to establish a connection between Business Central SaaS database with jedox.(Jedox is a Business Intelligence and Corporate Performance Management solution). 
 
Once the connection is established, the user want to query the Business Central tables in jedox to extract, transform for generating required information and reports. 
 
The version of Business Central is:-  IN Business Central 22.5 (Platform 22.0.61221.0 + Application 22.5.59966.60134). 
 
The jedox knowledgebase specified about JDBC driver to establish third party rdbms connections. 
 
Can I establish a connection between Business Central and Jedox by standard prebuilt API's in BC? If yes, is it possible to query the BC tables? 
 
Share your thoughts on this. 
 
Appreciate for your time. 
 
Best Regards,
Ranjith E S 
 
 
 
Categories:
Dynamics 365 Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 103,741 Super User 2026 Season 2 on at
    First of all, including Microsoft's first-party products, Power BI, Power Automate, Excel, etc., cannot directly access BC tables.
    What is being accessed is Odata in the Web Service, or APIs (Standard andcustom).
    And sorry, I don't know the Jedox product very well, but if you publish the page for Odata or customize a new API page, it should be accessible. But as mentioned at the beginning, there is no way to access all tables in the standard.
     
    Hope this helps.
    Thanks.
    ZHU
  • RE-24072358-0 Profile Picture
    RE-24072358-0 154 on at
    Hi Yun Zhu,
     
    Thanks for your time. 
     
    Is it possible to query the data in a third-party system if I connect to publish Odata in the web service or use standard APIs? I'm trying the same, but it would be helpful if someone already had such experience.
     
    Regards,
    Ranjith E S
  • Suggested answer
    RE-24072358-0 Profile Picture
    RE-24072358-0 154 on at
    Hello,
     
     
    This is achieved by BC API's. Done the OAuth configuration for BC APIs and able to establish the connection with jedox. 
     
    Thank and Regards,
    Ranjith E S 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 727 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 512 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 321 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans