Real-Time Data Integration from Oracle to ServiceNow

[Lisa Goldman]

Hello,

We are currently using ServiceNow (JDBC) to connect to an Oracle Database and extract data entered by a third-party application.  At the moment, this process is handled through a scheduled import that runs at a specific time.

Could someone please let us know is it possible to configure ServiceNow to read data from the Oracle Database in real-time, so that new entries are pulled in as soon as they are added?

Thank you.

[Sateesh Kumar D · Accepted solution]

Hello,

There could be more than one possible way depending on the function you are trying to address.

1) For instance, if the data pulled into ServiceNow from oracle is used by users only to consult you can use remote table(allows you to access and interact with data from external systems as if it were part of your ServiceNow instance, without actually importing or storing the data within the ServiceNow database) instead of using JDBC import, because you don't need to hold all the data in ServiceNow until someone wants to look at the data.

2) If the functional requirement forces to bring all the data into ServicenNow (don't do it only for reporting purpose if there are no business / functional need for it) , you might have to continue with JDBC but if there are any complex data structure in import which makes the import slower then you should consider Robust Import Set Transformer to make the import process faster and easier.

3) Alert-natively you can explore web-hooks options available in concern third party application to establish a realtime integration with ServiceNow

Feel free to reach if you need any further clarity on any other provided options.

[Lisa Goldman]

Hi @Sateesh Kumar D 

Thank you for the detailed feedback — it's well-structured and provides a practical breakdown of integration approaches based on different functional needs.

I learned something new today and will definitely share this knowledge with my team members.

Thank you again!