Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ConstMoss
Helper I
Helper I

OData Option

why should we use Odata option if there is an option to use SQL Server connection directly? for example, for dynamics gp 2016, we can connect to GP using odata feed or sql server connection. what is the difference and what are the pros and cons?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

OData is an API protocol, so you are limited to only get the results that the API server side is programed to give you.

Where as with the SQL Server connection you are able to run any SQL query against the DB (as long as you have the permission of course)

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

OData is an API protocol, so you are limited to only get the results that the API server side is programed to give you.

Where as with the SQL Server connection you are able to run any SQL query against the DB (as long as you have the permission of course)

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.