Storing data using Data Source into remote table

Vijay Baokar
Kilo Sage

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!!

 

5 REPLIES 5

pratikjagtap
Giga Guru

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

 

OlaN
Giga Sage
Giga Sage

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.

Ankur Bawiskar
Tera Patron
Tera Patron

@Vijay Baokar 

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

Remote tables 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Vijay Baokar 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader