Forum Discussion

oskark's avatar
oskark
New Member
1 year ago
Solved

Extract data from Fabric

Hi! I have a customer who wants to retrieve their data from Fabric. There are a couple of solutions for extracting data to an Azure SQL database or Azure ADLS. However, the customer is not currently...
workspaces
  • NandanHegde's avatar
    NandanHegde
    1 year ago

    There is a direct connector in data pipelines in fabric to access lakehouse, so that should work to copy the data

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi oskark 
Thanks for using Microsoft Fabric Community Forum.
As suggested by NandanHegde , using Copy Data Activity in Fabric can be used to Export data from Fabric to on-premises effectively and securely using On-Premises Data Gateway.
Here are the Pros and Cons of Copy Data Activity:

Pros:

  • Automation: Automates the data transfer process, reducing manual effort.

  • Reliability: Ensures data consistency and integrity during transfer.

  • Scalability: Can handle large volumes of data efficiently.

  • Integration: Seamlessly integrates with on-premises data gateways for secure data transfer.

  • Schedule and Monitor: Schedule the pipeline to run at regular intervals and monitor its performance to ensure data is transferred correctly.

Cons:

  • Setup Complexity: Requires initial setup and configuration of data pipelines and on-premises data gateways.

  • Maintenance: Ongoing maintenance and monitoring are needed to ensure smooth operation.

  • Cost: Costs associated with data gateway licenses and infrastructure.

     

Fabric APIs to extract data and built custom UI:

To extract data using Fabric APIs and build a custom UI, begin by setting up API access and obtaining the necessary credentials. Familiarize with the Fabric REST API documentation to understand the available endpoints and methods.

The next step involves using the APIs to extract data from Fabric, storing it in a suitable format such as JSON or CSV. Once the data is ready, develop a custom web UI using frameworks like React, Angular, or Vue.js to display the information in a user-friendly manner. Finally, deploy the custom UI to ensure it meets the desired requirements


Pros and Cons:

Pros:

  • Customization: Allows for complete customization of data extraction and UI design.

  • Flexibility: Can tailor the solution to specific business needs and requirements.

  • Control: Provides full control over data processing and presentation.

Cons:

  • Development Effort: Requires significant development effort and expertise in API integration and web development.

  • Maintenance: Ongoing maintenance and updates are needed to keep the custom UI functional and secure.

  • Complexity: Can be complex to implement and manage, especially for non-technical users.

Hope the above points may answer your doubts regarding Copy Data and Fabric APIs.
If you need assisatnce setting up please reach out.

If this post helps, please accept whichever solution meets your needs and a kudos would be appreciated.

Thanks and Regards.