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

Notifications

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 152
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
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,331 Super User 2025 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 152 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 152 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans