OData Client Compatibility: Difference between revisions
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
By default, new models are set to '''(Auto Detect)''' as this ensures the OData Feed can be used with many different clients. There are situations where you may need to choose a specific client. | By default, new models are set to '''(Auto Detect)''' as this ensures the OData Feed can be used with many different clients. There are situations where you may need to choose a specific client. | ||
= How to configure the OData Client Compatibility option == | |||
To configure the OData Client Compatibility option, follow these steps. | |||
# Go to '''app.odatalink.com'''. | |||
# Click on '''Models''' on the menu in the left-hand side. | |||
# Find the [[Models|model]] you want to work on and click '''View'''. | |||
# Select the '''Settings''' tab. | |||
# Click on the '''Edit Model''' button. | |||
# Find the '''Miscellaneous Options''' section. | |||
# Choose the [[OData Client Compatibility|OData Client Compatibility]] option required. | |||
# Click '''Save'''. | |||
= OData Client Compatibility Options = | |||
The following options are available. | |||
| Line 21: | Line 40: | ||
'''Azure Data Factory''' has some limitations in how it supports the OData standard. The main two limitations are that it: | '''Azure Data Factory''' has some limitations in how it supports the OData standard. The main two limitations are that it: | ||
* Does not support functions | * Does not support functions. | ||
: ''Functions will be accessible as as entity sets instead.'' | : ''Functions will be accessible as as entity sets instead.'' | ||
* Does not support complex types | * Does not support complex types. | ||
| Line 40: | Line 59: | ||
'''Fabric Data Factory''' has some limitations in how it supports the OData standard. The main two limitations are that it: | '''Fabric Data Factory''' has some limitations in how it supports the OData standard. The main two limitations are that it: | ||
* Does not support functions | * Does not support functions. | ||
: ''Functions will be accessible as as entity sets instead.'' | : ''Functions will be accessible as as entity sets instead.'' | ||
* Does not support complex types | * Does not support complex types. | ||
| Line 64: | Line 83: | ||
'''Solver''' has some limitations in how it supports the OData standard. The main limitations are that it: | '''Solver''' has some limitations in how it supports the OData standard. The main limitations are that it: | ||
* Does not support functions | * Does not support functions. | ||
: ''Functions will be accessible as as entity sets instead.'' | : ''Functions will be accessible as as entity sets instead.'' | ||
| Line 72: | Line 91: | ||
'''SQL Server Integration Services (SSIS)''' has some limitations in how it supports the OData standard. The main limitations are that it: | '''SQL Server Integration Services (SSIS)''' has some limitations in how it supports the OData standard. The main limitations are that it: | ||
* Does not support functions | * Does not support functions. | ||
: ''Functions will be accessible as as entity sets instead.'' | : ''Functions will be accessible as as entity sets instead.'' | ||
* Does not the Date data type | * Does not the Date data type. | ||
: ''Instead, dates will be returned using the DateTimeZoneOffset data type.'' | : ''Instead, dates will be returned using the DateTimeZoneOffset data type.'' | ||
* Does not support complex types | * Does not support complex types. | ||
| Line 83: | Line 102: | ||
'''Tableau''' has some limitations in how it supports the OData standard. The main limitations are that it: | '''Tableau''' has some limitations in how it supports the OData standard. The main limitations are that it: | ||
* Does not support functions | * Does not support functions. | ||
: ''Functions will be accessible as as entity sets instead.'' | : ''Functions will be accessible as as entity sets instead.'' | ||
* Does not support time zones | * Does not support time zones. | ||
: ''The time zone component of the DateTimeZoneOffset data type will be omitted.'' | : ''The time zone component of the DateTimeZoneOffset data type will be omitted.'' | ||
* Does not support complex types | * Does not support complex types. | ||