Skip to main content

Does anyone know if it's possible to link the IFS database to Microsoft Fabric?

https://learn.microsoft.com/en-us/fabric/database/mirrored-database/open-mirroring

We're currently using the self hosted bi, but I can't say that's a perfect solution so we're looking for better alternatives.

Hi ​@JoDe,

I’m from the R&D Data and Analytics team.
May I know which version of self hosted BI is you are currently using (sql server based or datalake based)?
What are the pain points of that solution you are experiencing now?

Fabric open-mirroring is not a concept we are using or have tested yet.

Best regards,
Subash
 

Hi ​@subashfestus, We've been on IFS cloud since the 21R2, and we've not had great experiences with the self hosted BI setup. We've had: 

  • multiple times where the environment settings suddenly were removed after updates
  • Tables in the SQL environment suddenly containing duplicate records
  • Data loads suddenly breaking because of sudden incorrect data types
  • The setup for the tabular models and dataloads not being very straight forward and user friendly

Currently I believe we use both SQL server and datalake? But preferably we'd only write it to the datalake.

Terms & ConditionsCookie settings