topic Re: Infor ERP XML files Connecting to Power BI Reporting (currently use INFOR Plug-In to SSRS) in Report Server

Infor ERP XML files Connecting to Power BI Reporting (currently use INFOR Plug-In to SSRS)

ela_shaked — Sun, 17 Mar 2024 08:14:50 GMT

Current situation that we have
in Infor ERP system ,user rendered SSRS report in HTML, PDF or XLS formats and see it as it would be pure Microsoft .
Behind the scenes, output Infor ERP XML files (!) connect between SSRS report dataset to Infor ERP LN reports,
with help of Infor ERP provided Plug-in.

We need to smoot migration to Power BI Paginated Reports with old SSRS reports.
As we understand SSRS report design file (.rdl) can be used in Power BI, with minor changed.

We are looking forward for connector Infor ERP XML files to Power BI .

Can some please recommend us, if there is any connector or third party tool which can help us.

Re: Infor ERP XML files Connecting to Power BI Reporting (currently use INFOR Plug-In to SSRS)

Anonymous — Mon, 18 Mar 2024 02:54:44 GMT

Hi ela_shaked ,

The current version of Power BI does not support direct connection to Infor ERP, you can try using a third-party connector.

Connector:Connect Infor to Power BI: Integrate your data | SyncHub

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Infor ERP XML files Connecting to Power BI Reporting (currently use INFOR Plug-In to SSRS)

ela_shaked — Mon, 18 Mar 2024 07:07:44 GMT

Hi Xianda Tang ,

Thank you for the answer.

The connection you reccomend is for Cloude Infor ERP , it's for our future I hope.

Sorry,didn't mention it in my question.

I search for connector to on prem XML files that Infor ERP system use to communicate with SSRS server .

Best Regards,

Ela Shaked

Re: Infor ERP XML files Connecting to Power BI Reporting (currently use INFOR Plug-In to SSRS)

Anonymous — Thu, 28 Mar 2024 09:28:57 GMT

Hi ela_shaked ,

Because you specifically need connectors for native XML files, consider the following approaches:
Infor Enterprise Server connector for Infor Reporting:
This connector retrieves XML files from an LN host via Adapter4ERP.
It splits the XML file into three separate files that Infor Reporting can then process as a data source
Infor Enterprise Server plug-in for Microsoft SQL Server Reporting Services (SSRS):
This plug-in also handles XML files.
It retrieves the XML file from the LN server via Adapter4ERP and populates an internal dataset.
SSRS uses this dataset to render reports

Translated with DeepL.com (free version)

Below is the link will help you:

docs.infor.com

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.