Forum Discussion

vivien57's avatar
vivien57
Icon for Super User rankSuper User
2 years ago
Solved

Connection to On-Premise Oracle Database with Fabric Data Pipeline

Hello everyone,

It's easy to connect to an Oracle On-Premise database with a DataFlow but it seems to be more complex with a Data Pipeline?

Indeed, with Azure Data Factory (in the Azure ecosystem) the definition of a linked service allows you to do this, but on the Data Pipeline Fabric side this doesn't seem to be possible.

Has anyone managed to answer this scenario?

Thanks in advance,

Have a nice day

Data Integration
  • DennesTorres's avatar
    DennesTorres
    2 years ago

    Hi,

     

    If I'm not mistaken, the list says it's possible the connection to Oracle, not to Oracle on premises. Being on premises is the limitation.

     

    Unfortunatelly, at the moment, yes, you would need to migrate the flows.

     

    But let's assume you are ingesting this data into a lakehouse on an Azure data lake storage. You could create shortcuts on your fabric lakehouse to this data lake storage and keep using data factory until the fabric pipeline support for on premises connection is released.

     

    Kind Regards,

     

    Dennes

8 Replies

  • DennesTorres's avatar
    DennesTorres
    Icon for Power Participant rankPower Participant
    2 years ago

    Hi,

     

    Data pipelines don't support on premisse gateways yet. You need to use a dataflow gen 2 for that.

     

    Kind Regards,

     

    Dennes

      • DennesTorres's avatar
        DennesTorres
        Icon for Power Participant rankPower Participant
        2 years ago

        Hi,

         

        If I'm not mistaken, the list says it's possible the connection to Oracle, not to Oracle on premises. Being on premises is the limitation.

         

        Unfortunatelly, at the moment, yes, you would need to migrate the flows.

         

        But let's assume you are ingesting this data into a lakehouse on an Azure data lake storage. You could create shortcuts on your fabric lakehouse to this data lake storage and keep using data factory until the fabric pipeline support for on premises connection is released.

         

        Kind Regards,

         

        Dennes

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi vivien57 

     

    Glad that your query got resolved.

    Please continue using Fabric Community for any help regarding your queries.

     

    Thanks