teiid-documents | Community documents for Teiid Engine and Teiid Server
kandi X-RAY | teiid-documents Summary
kandi X-RAY | teiid-documents Summary
Community documents for Teiid Engine and Teiid Server
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of teiid-documents
teiid-documents Key Features
teiid-documents Examples and Code Snippets
Community Discussions
Trending Discussions on teiid-documents
QUESTION
Where can I set the locale for translators and what is the accepted format. E.g. I have seen instances where the locale is set as nl_NL, nl-NL. I want to force the locale of Teiid Springboot to be UTF-8 in order to make sure that ORDER BY clauses are correctly pushed down to the source. I figured that I have to set org.teiid.collationLocale, but the documentation for the correct locale points to an outdated Java 6 page. https://teiid.github.io/teiid-documents/master/sb/admin/System_Properties.html
We use the default Teiid Oracle translator and use Hikari for our datasources. The documentation of the translators points to setting the collation for translators in the execution factory; As far as I know we don't use those right now. https://teiid.github.io/teiid-documents/master/sb/dev/Translator_Capabilities.html
What are the steps I should take to force the locale for the engine to UTF-8 and do the same for the translators?
Note: we use a DDL with data wrappers to specify our connection to our Oracle sources.
...ANSWER
Answered 2021-Feb-11 at 17:21There is no collation support directly on order by clauses. The best you can do is inform the engine (org.teiid.collationLocale property) what collation it should be using and set a collation execution property on each translator to inform the engine as to what the translator will use, then Teiid can choose not to push orderings if there is a mismatch.
QUESTION
While scouting the documentation we found the following properties that we want to set.
- max-source-rows-allowed
- exception-on-max-source-rows
Found on the following page: https://teiid.github.io/teiid-documents/16.0.x/content/admin/Other_Considerations.html
However, we have tried several ways to set these without avail. The properties are not listed on the following page. https://github.com/teiid/teiid-spring-boot/blob/master/docs/Reference.adoc
How can we set these properties?
...ANSWER
Answered 2021-Jan-06 at 13:44Teiid spring boot does not currently allow setting properties like these, which are normally set in the Teiid WildFly subsystem, in an elegant way. The only workaround is to wire in your own EmbeddedConfiguration with all the appropriate settings - as the TeiidAutoConfiguration logic won't make any additional changes to a supplied configuration.
You can also log an issue / supply a patch to have this properties set from the configuration file.
QUESTION
I'm looking to use Salesforce to, using Odata, connect to Teiid+Wildfly, which in turn connects to SQL Server.
When I read the documentation for Teiid 13, under limitations, it says OData $search is not supported.
http://teiid.github.io/teiid-documents/13.0.x/content/client-dev/OData4_Support.html
The following feature limitations currently apply.
- search is not supported
- delta processing is not supported
- data-aggregation extension to specification is not supported
- $it usage is limited to only primitive collection properties
However when I read the documentation for Jboss Data Virtualization, under limitations, it doesn't list that $search is not supported.
The following feature limitations apply:
- Delta processing is not supported.
- The data-aggregation extension to the specification is not supported."
Anyone know why there's a difference? Does the paid JBoss flavour have extra code allowing OData $search parameters?
Thanks in advance.
...ANSWER
Answered 2020-Mar-12 at 13:35$search is not available in the JBoss Data Virtualization either, I would think it is a documentation issue.
The reason $search is not implemented as $search expected to works on all the content like cache search, which would be a very expensive operation in Teiid as it does not hold any content. I would think one needs an Elastic Search like backend integration to support for this where all the content is also cached.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install teiid-documents
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page