Using IntegrationHub ETL without Data Source
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hello,
How can I use an existing Import Set Table with IntegrationHub ETL?
I have an external application that is pushing data into our ServiceNow instance using the basic Table APIs (not adjustable). To receive the data, I've created an Import Set table. Using the standard Transform process, we convert this data into CIs. However, due to the variety of data coming in through the connection, I feel that the Robust Transform Map and the IntegrationHub ETL process is more fitting.
When I attempt to create ETL components, it is asking for a Data Source to trigger from. Except, I don't really have one as this data is being pushed, not pulled. I created a dummy Data Source and attempted to get a configuration that works by choosing , but it never finds data - which is pretty much expected. There is data already in the table, but the ETL selector won't let me grab and use it.
Am I going about this the wrong way? Is there a way to use the ETL system on data it doesn't pull in directly through a Data Source?
Thanks!
-Travis
- Labels:
-
Orchestration (ITOM)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
@travisbridg Hope you are creating the Data source with type 'REST (Integration Hub)' and Request action. Configuring this Action in flow designer.
You can go through this Youtube link, where he connected the Data source to an API and the data import through an action (This approach should work for push data, as that would try to touch the data source configured).
https://youtu.be/m52m_XuqYwE?si=bz6HTwizauxSkLgj
Same link is available as part of the Servicenow University course as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi Mannapuram, thank you for taking the time to answer!
In my instance, the Request Action field didn't appear for me when I selected REST (IntegrationHub) so getting that added was helpful.
Watching the video, it looks like he ultimately uses the source API to pull fresh data rather than uploading to an Import Set, so we deviated from my particular issue there. This will help me for a future implementation though, so I really appreciate that.
Thanks!
-Travis
