Insert a record in an external database from a script include ( without using MIDServer / JDBCProbe / Orchestration)

[praveenmuramal1]

Hello Community,

Can someone point me to an example or provide code snippet to make a JDBC Connection and do a sql insert ?

I am trying to insert a record into a table that exists in external database from script include. All the examples I could find are using MIDServers JDBCProbe.

I can't use

Webservice - ( Reason : External Database don't have support for this)

MIDServer - ( Reason : No Mid Server )

JDBCProbe - ( Reason : No Mid Server )

Orchestration - ( No subscription for Orchestration )

Thanks,

Praveen

[Patrick Schult2 · Accepted solution]

I don't think you have a way to do this without the use of a MID server. You mentioned that you don't currently have a MID server. Have you considered just...getting one? There's no cost or licensing other than the computer you install it on (if you have to buy one or spin up a VM). It's useful for plenty of things, and there is something to be said about avoiding the "square peg / round hole" situation.

[praveenmuramal1]

Patrick, Thanks for the clarification. We are going towards the path of not using MID server.

[Sreenivas]

Hi Patrick,

Actually I am trying to move servicenow Table data to sql server. Kindly let us know the steps.

Thanks for your help.

Regards,

Sreenivas

[Patrick Schult2]

Check out a tool called SnowMirror - it's designed for this purpose.

If you are looking for a more "free" solution, you could set up Export Sets on your instance to export to a MID server's export directory. You would then have your SQL server import the CSV on a recurring basis.