My main concern is how to connect to external database(sql server in my case) and retrieve data , to be shown in a Table in the UI Designer. What are the possibilities available to do such a thing !
I did some research , found possibility with a connector and Rest API extension. But I still don't get the main difference between both of em.
any clarification ?