I'm going to set up an Azure BI solution that is intended to read raw data from IFS Cloud with Data Factory and place it in a data lake. Then read it into SQL Server and create own dim and fact tabels. Then create tabular models in Analysis Services that Power BI can read from.
Is it possible to fetch tables directly with Data Factory using IFSINFO, or is it only possible to fetch from access views?
How have others done your BI solutions and data retrievals from IFS Cloud?
Hi
There is an inbuilt solution called IFS Analysis models as a BI solution in IFS Cloud.
IFS Analysis Models consists of a framework that supports transferring data from IFS Cloud Information Sources to a Data Warehouse hosted in Microsoft SQL Server, and a set of Microsoft Tabular Models connecting to this Data Warehouse.
By using that Data warehouse or Tabular Models, you will be able to create BI reports such as power BI reports and dashboards. Based on your requirement, you can retrieve data to the data warehouse which are not available in IFS standard models.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.