Hello Martin,
Have you looked at the REMOTE source documentation?
The documentation has examples on reading from a REST service using syntax that looks like a SELECT statement. You can get data from your legacy DB and then use it in VANTIQ. You do not need to save it in a VANTIQ type before you use it.
If the above does not solve your problem then please give me more details of your problem.
Thank you.
Ken
There is also a JDBC connector available through the VANTIQ extension-source.
https://github.com/Vantiq/vantiq-extension-sources/tree/master/jdbcSource
Depending on the DB there may be the option to use triggers to use Rest calls or websockets to Post any new updates from the DB into VANTIQ.
When using a rest call you have to create your own polling system to pull in and update data to sync from the external DB to VANTIQ unless you’re pulling in the same info just about every time. If you use the JDBC connector a lot of those sync’ing type of features are already available.
- You must be logged in to reply to this topic.
Hi all,
could you point me to resources where I can learn how to fetch data from a legacy DB or similar for enrichment purposes? Do I have to pull the data into vantiq types before I can use it? Or is it possible to query the external system on demand via REST or similar?
Thank you!
Cheers,
Martin