Forum Discussion
Advocate IVAccessing On-Prem API via Python/PySpark in Notebooks
All right.
This is actually very often the case.However, we can think of two additional ideas.
Mirroring would be another idea if you already have the data in the SQL server or, as you have already written, incremental copy with CDC to a fabric SQL database.
Both are currently still in preview, but according to my tests they work very well.
Unless it is critical, these would be alternatives.Best regards
Super UserHi YevgenyM,
another option, if available, would be to use an Azure Function that retrieves the data and then stores it.
Of course, this requires a connection to on-premises.
Best regards
- YevgenyM
Nope, we don't have full control over azure services in the organization and prefer to stick to fabric services we do have full control over them.
Currently, it is most likely we write the data to on-prem MSSQL
The next step will be incremental copyjob to bronze lakehouse.
- spaceman127
All right.
This is actually very often the case.However, we can think of two additional ideas.
Mirroring would be another idea if you already have the data in the SQL server or, as you have already written, incremental copy with CDC to a fabric SQL database.
Both are currently still in preview, but according to my tests they work very well.
Unless it is critical, these would be alternatives.Best regards
- YevgenyM
I forgot about Mirrored MSSQL.
I will check both options and reply here which one provies better stability and performance.
spaceman127, do we need MSSQL enterprise edition to enable mirroring or standard will be enough?
