IFS Cloud and Spreadsheet Server

@khtdinesha I guess I didn’t understand your scenario properly, thus the additional questions.

If your customer is implementing IFS Cloud as their ERP, why would they need the reports they have built for their old ERP solution? For sure the data structure (tables/views) between IFS Cloud and the old ERP would not match, so they would need to rebuild their reports based on IFS data structure.

As far as I know ODBC is not allowed for IFS hosting. OAuth via IAM client is the only way to connect to an IFS managed IFS Cloud environment, no direct DB access is allowed.

When it comes to BI, R&D has built quite a nice framework → self hosted BI with SQL Server. MAybe this is something that could be useful for your customer? There are lots of pre-built Power BI reports (which could be tweaked if needed).

https://docs.ifs.com/techdocs/24r1/050_reporting/450_self_hosted_bi_int/

Hi,

Thank you for the response. Not much needs to be rebuilt since the data they are retrieving has already been implemented in IFS as well. So we can re-use majority of the reports with small tweaks, without needing to re-create them. 

Thank you for the confirmation on the ODBC connection and also the information on BI.

Best Regards,

Dinesha