The obvious case is to retrieve data from a third party system, but there is nothing that prevent us to also use local tables or a mix of remote and local tables and present them as one remote table. We can also see the remote tables like a kind of enhanced database view, that allows for example to :
1.aggregating data from multiple sources, both local or remote;
2.Making calculations;
3.Applying logic and complex conditions;
Benefits:
There is also an option to cache the data that has been retrieved for a certain time, to reduce the load and improve performances.
As you can see, Remote tables are a nice feature to use external data in ServiceNow and have them always up to date. It can be use in numerous scenario where external data need to be always up to date and when it is OK to have it read-only in ServiceNow.
Best part is they are view only tables. Like no use of database storage in Snow. No issues with perfomance if there is a huge data coming from another system.
First Step: Create Remote Table
Second: Create Remote Definition
Note: For using this option, Integration hub plugin should be installed.
Sample Script for Remote Definition attached.
Hope this helps.
Regards,
Shamma
Regards,Shamma Negi
