Infor SunSystems connector for Microsoft Power BI

As a client of the Infor SunSystems financial management system, you may be experiencing firsthand the challenges of applying modern analytics tools such as Microsoft Power BI to uncover insights from your financial data. This challenge is not only limited to the analysis of SunSystems data, but also combining it with other non-SunSystems data for a 360° view of the business.

As a long-standing Microsoft and Infor partner, Professional Advantage can help you solve this challenge. We have developed a data connector to help you automatically extract and load your SunSystems (v4 or v6) financial data into Power BI.

This allows Microsoft Power BI users to simply drop data entities on to their reporting canvas and build up effective visualisations and analytics without having to understand anything about the underlying Infor SunSystems database schema.

- Drag and drop Infor SunSystems data entities delivered to Microsoft Power BI canvas

- Understands SunSystems v4 and v6 data structures out of the box

- Web interface for extraction and security administration

- Consolidate data from multiple systems together with Infor SunSystems data and analyse it in one report/dashboard

- Selected extraction of data by SunSystems Business Unit, Ledger, Chart of Accounts, Analysis Dimensions and Periods

- Ability to define summary or detail transactions for different time periods

- Exclusion rules to exclude unwanted or confidential data from extract by Business Unit, Ledger, Chart of Accounts and Analysis Dimension

- Builds out a register for all changes in the SunSystems database and, leverages Microsoft Power BI's incremental refresh capabilities to ensure the data warehouse is up to date. This only extracts new data available in Infor SunSystems

- Additionally works for iPOS eProcurement data in the same connector

- Includes a dataset security model to allow Row Level Security across Business Units, Ledgers, Accounts, Analysis Dimensions and Periods

With its built-in collaboration capabilities, Microsoft Power BI makes it easy to share and collaborate on data with not only Infor SunSystems users, but also users within the organisation that do not have access to Infor SunSystems but utilise its data in their business role, such as executive level managers, cost centre or department managers etc.

This Infor SunSystems Microsoft Power BI Connector is sold and supported in English