Sage X3 x PowerBI

Question

Hi, 
 I want to connect a few sql databases from Sage X3 to PowerBI. What is the recommended way to do this? If it is ODBC then where can I get the Sage X3 drivers for this?

chris hann · Accepted Answer

hello, as far as I know, all of Sage X3 data is in a database in MS SQL or Oracle DB (depending on what you have installed). You should be able to connect and pull whatever data you'd like from SQL. Sage X3 uses ODBC to connect to MS SQL and you can see the setup in the ODBC functionality in windows.

steve_gibbs · Answer

I would recommend that you evaluate the Sage Data & Analytics solution which is purpose built to support using Power BI with Sage X3. It includes a reporting ready pre-built X3 data model, many pre-defined KPIs, out of the box Power BI dashboards, smart data modeling capabilities, a security model for the X3 data, and more. It may be more than what you need as described in this post, but depending on your longer term needs it could be a fit.

Sage X3

Sage X3 x PowerBI

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING