# Need data from data service

**URL:** <https://forum.uipath.com/t/need-data-from-data-service/772440>\
**Category:** Data Service\
**Tags:** question, data-fabric, database, activities\
**Created:** [October 9, 2024, 12:19pm UTC](https://forum.uipath.com/t/need-data-from-data-service/772440 "2024-10-09T12:19:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![harshika.10732998](https://avatars.discourse-cdn.com/v4/letter/h/73ab20/32.png) [@harshika.10732998](https://forum.uipath.com/u/harshika.10732998)\
**Post date:** [October 9, 2024, 12:19pm UTC](https://forum.uipath.com/t/need-data-from-data-service/772440/1 "2024-10-09T12:19:04Z")

</div>

Hi All,

I want to pull data from UiPath data service and push it into sql datatbase.  
Is there any simple way to do this task?

I have tried with small table and able to extract from data services using query entity activities of UiPath.  
Now, I have to extract 28 L+ data from data service.  
Please suggest any alternative approach

thank you

---

<div class="post-metadata">

**Author:** ![Ehab\_Sawars](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ehab_sawars/32/401516_2.png) [@Ehab\_Sawars](https://forum.uipath.com/u/Ehab_Sawars)\
**Post date:** [November 5, 2026, 6:35am UTC](https://forum.uipath.com/t/need-data-from-data-service/772440/2 "2026-11-05T06:35:47Z")

</div>

For 28 lakh-plus rows, keep the transfer paged rather than loading everything into one DataTable. Query Entity Records supports Top up to 1,000 and Skip: fetch a page, map it to a DataTable, bulk-insert into a SQL staging table, then checkpoint that completed page.

Use a stable sort and retain the source record ID as a unique key so retries don’t duplicate rows. If records can change during export, use a controlled extraction window or incremental watermark. Reconcile counts before merging staging into the destination.