Forum Discussion

Joshrodgers123's avatar
Joshrodgers123
Advocate V
2 years ago
Solved

DB2 - Package Collection

We are trying to connect to a DB2 server with the new OPDG in pipelines. When connecting, we need to set the Package Collection property for it to work correctly. This property is available in DFG2/P...
Pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Joshrodgers123 ,

    Internal Team confirmed that workaround doesn't work
    Currently, even PQ shows package collection, it is not stored.

    Team is going to have a discussion internally. So far, please treat it as a feature gap.
    Apologize for the inconvenience.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Joshrodgers123 ,

We have an update from internal team -

This is considered as a feature gap. Team is going to work on it, at present we don't have a concrete ETA. Also you are right, doc is not updated yet. It should appear here once it is updated - Connector overview - Microsoft Fabric | Microsoft Learn


In between, this should be a workaround - 

You can create the connection in Power Query, and then use it in pipeline.

Note: For on-premises connection, it is resuable. But for cloud connection, it is not.

 

Hope this is helpful. Please let me know incase of further queries.

 

Joshrodgers123's avatar
Joshrodgers123
Advocate V
2 years ago

Thanks for the update.

I don't think that workaround will work though. The connection settings like package collection, sql statement, and connection timeout are specific to a query, not a connection. They do not transfer from one dataflow to another, or from a dataflow to a pipeline.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Joshrodgers123 ,

    I'm still waiting for a response from the Internal Team. We will update you once we hear back from them.
    A    ppreciate your patience.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Joshrodgers123 ,

      Internal Team confirmed that workaround doesn't work
      Currently, even PQ shows package collection, it is not stored.

      Team is going to have a discussion internally. So far, please treat it as a feature gap.
      Apologize for the inconvenience.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Joshrodgers123 ,

        Glad to know that your query was resolved. Please continue using Fabric Community on your further queries.