Forum Discussion

MathieuSGA's avatar
MathieuSGA
Icon for Advocate I rankAdvocate I
11 months ago
Solved

Detect/Capture whenever a Data Connection has been leveraged/activated

Hi all, Is it possible to detect whenever a data connection has been leveraged/activated, for example through a Copy Data activities ? If so... ...are those "features" only available to Fabric...
admin
governance
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    11 months ago

    Hi MathieuSGA,

    Thank you for the follow up.

    Based on my understanding, Microsoft Fabric does not currently provide an automatic tenant wide alert or log that explicitly indicates when a specific data connection for example, your ERP has been accessed. Historical monitoring at that level of granularity requires the use of existing monitoring APIs or audit logs.

    Please consider the following steps which may assist in resolving the issue:

    1. Navigate to Monitor, then to Pipeline runs or Activity runs. Apply filters for the ERP outage time window and review the Copy activity details to confirm whether the ERP linked service or dataset was used.
    2. Query Pipeline Runs or Activity Runs using the Fabric REST API to retrieve start time, end time, and connection or dataset details.
    3. Request that the administrator check Purview, Unified Audit Logs, or Data Connection Auditing for events related to the ERP connection during the outage to obtain tenant level evidence across workspaces.

    For further reference, please consult the following documentation:
    Monitor Copy activity - Microsoft Fabric | Microsoft Learn
    Activity Runs - Query By Pipeline Run - REST API (Azure Data Factory) | Microsoft Learn
    Track user activities in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
    Data connection auditing for exfiltration protection | Microsoft Learn

    We hope that the information provided will assist you in addressing the issue. If you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
11 months ago

Hello MathieuSGA 

 

If I understood correct, yes, it's possible, especially when you are using copy activity in fabric, you can use in buitl Fabric monitor. Not only Fabric admins everyone who has access they can vbe able to view it. Pls have look on below pic

 

Kindly go through this thread Monitor Copy activity - Microsoft Fabric | Microsoft Learn It might helps you.

 

Pls let me know if it helps you.

 

Thank you!!

 

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

 

 

 

  • MathieuSGA's avatar
    MathieuSGA
    Icon for Advocate I rankAdvocate I
    11 months ago

    Hi suparnababu8,

     

    Do you mean that I can monitor Data Pipeline executions that trigger the CopyData Activity leveraging the data connection I want information from ?
    If so, the way I thought about my usecase was:

    - a Data conenction has been defined (for example to get data from an On-Premise) source/database,

    - now that I made it available to a set of users, I might not be responsible to know where, how and by whom those data and retrieved through this Data Connection.

     

    In  a nutshell: I might not know the complete set of Data Pipelines/Fabric artifacts to look for in the Fabric Built-in Monitoring Hub.

     

    Am I understanding your suggestion correctly ?