Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ela_shaked
Regular Visitor

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

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.

3 REPLIES 3
v-xiandat-msft
Community Support
Community Support

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.

 

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

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.