Power BI Connector

What is the Power BI Connector for Infor SunSystems?

We have done all the hard work for you.

Our Connector solves the problem of automating the data extraction from an Infor SunSystems database and translating it into an Microsoft Power BI data model. This allows Power BI users to drop data entities on to their reporting canvas and build up effective visualisations and analytics without having to understand anything about the underlying SunSystems database schema.

Our connector for SunSystems translates data in to a meaningful and easily understood format, while offering flexibility to configure the system and controlling the scale of data extracted in to the Power BI reporting warehouse along with the content, such as Business Units, Ledgers, Chart of Accounts and Analysis Dimensions.

Our connector includes a web-based application interface where you can define how many periods you wish to import and which of these are summary totals, and which are transactional data. Meaning you do not have to populate the Power BI warehouse with transactional data where not needed for analysis.

You may also have some data in SunSystems which you do not want to make available in the reporting warehouse, such as payroll data, or other sensitive information. The interface allows you to define exclusion definitions, which remove data sets based on Business Unit, Chart of Account, Analysis Dimensions, or ledgers.

Security is obviously of utmost importance in reporting on financial data. The Connector caters for this with an embedded a Row-Level Security (RLS) model through the data which allows you to control which data users can view in the data model, as well as providing Data Set Exclusions to exclude confidential accounts and analysis from the data warehouse extract giving you confidence in the outcome.

Infor SunSystems Data Reporting made easy with Power BI

• Drag and drop Infor SunSystems data entities delivered to Power BI canvas
• Understands SunSystems data structures out of the box
• Web interface for extraction and security control
• Consolidate data from multiple systems together with Infor SunSystems data and analyse it in one report
• Selected extraction of data by Business Unit, Ledger, Chart of Accounts, and Analysis Dimensions
• Ability to define summary or detail transactions for different time periods
• Exclusion rules to remove unwanted 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 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 security model to allow Row Level Security across Business Units, Ledgers, Accounts and Analysis Dimensions
• Power BI helps streamline reporting workflows by automating processes and eliminating inefficiencies associated with the extraction and manipulation of data.
• Power BI significantly reduces the time spent on creating and preparing month end reports. Transformation rules are set once and data updated in real-time
• The powerful visualisations in Power BI make it possible to present complex data in an easy to digest way with data interactivity and relationships
• With its built-in collaboration capabilities, Power BI makes it easy to share and collaborate on data with not only Infor SunSystems users, but also users with 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.