locked
Expose on-premise database similar as with Microsoft Integration Runtime RRS feed

  • Question

  • Hi,

    When we wanted to query the on-premise database, we installed MS Integration Runtime and with few steps, we were able to move data from on-premise to the cloud.

    However, we would like to call procedures or do some CRUD operations over the on-premise database from the cloud. How can this be done ? Is there any way to use something similar to Microsoft Integration Runtime ?

    We are not able to modify the firewall or router settings where the database is located.

    Thanks.

    Roberto E.

    Tuesday, November 13, 2018 8:51 PM

All replies

  • You can have a try with Stored Procedure activity to call some SP over the on-prem database, here is the document:

    https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure

    • Proposed as answer by Jason_J (Azure) Wednesday, November 14, 2018 11:19 PM
    Wednesday, November 14, 2018 12:23 AM
  • The problem is that this only works with SQL Server. We would like to run stored procedures or functions in a Oracle 11g 64bits on-premise database.
    Wednesday, January 9, 2019 12:30 PM