read data from external SQL database

Question

What's the best approach for reading data from external SQL database?

I have a table with 1000000 records in SQL database

How will the data be displayed? All records with paging? One at a time? — Mike Smith - MCT, Commented Sep 17, 2018 at 16:24

LZ_MSFT · Accepted Answer · 2018-09-18 01:35:59Z

0

In SharePoint, we can use Business Connectivity Services (BCS) to achieve it.

1.Using SharePoint Designer create BCS External Content Type.

2.Using SharePoint Designer create Add/Edit/Delete operations metadata.

3.Using SharePoint Designer create Lists & Form.

4.Using Central Administration set Permissions for external Content Type.

References:

answered Sep 18, 2018 at 1:35

LZ_MSFT

6,2491 gold badge8 silver badges7 bronze badges

Thank you, I asked to select the best option , please read my question again,
– Arul kumar
Commented Nov 2, 2018 at 17:59
I suggest you use BCS to access date from external database.
– LZ_MSFT
Commented Nov 5, 2018 at 1:22
Is bcs can Handel million records?
– Arul kumar
Commented Nov 16, 2018 at 0:41

Add a comment |

1 Answer 1