Hi,
Is it possible to integrate with Spreadsheet Server for an IFS hosted IFS Cloud customer using ODBC connection?
The customer currently has multiple reports in their existing ERP solution that they would like to utilize in IFS, without needing to re-create.
Thank You & Best Regards,
Dinesha
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.