Storing data using Data Source into remote table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2025 11:25 PM
Hi Folks,
I need some expert's suggestions here:
I have Data Source with JDBC type which basically fetch the data from external system using some SQL query and at other side i have a remote table created. Is it possible to store the data in remote table using Data Source of JDBC type ?
Please suggest!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2025 11:41 PM
Hi @Vijay Baokar ,
Remote Tables are virtualized — they don’t store data in ServiceNow's local database. Trying to push import set rows into a remote table would fail because:
What You Can Do Instead:
Option 1: Import JDBC Data into a Local Table
- Use the JDBC Data Source to import into a staging table.
- Use a Transform Map to move data into a normal ServiceNow table.
- If needed, expose that data externally via Scripted REST or Virtual Agent.
Option 2: Flip the Flow – Use Remote Table Instead of JDBC
- If the goal is to display external data without storing it, you could skip JDBC entirely and:
- Use a Remote Table backed by a Scripted REST API or JDBC call (via MID).
- This allows real-time views without data storage.
If my response helped, please hit the 👍Thumb Icon and accept the solution so that it benefits future readers.
Regards,
Pratik

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2025 11:58 PM
Hi,
Could you please elaborate on your question, and what it is you are trying to do ?
Remote tables are used to connect to another ServiceNow instance, and retrieve data from that instance.
JDBC data sources are a way to import data into your instance using a SQL query on the external database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2025 12:00 AM
I believe this is possible using the script step
I haven't tried though, I have used remote table to bring data from external API etc
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 02:09 AM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader