- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2023 04:04 AM
Hello
I want to connect to an external database using JDBC. That is not oracle/mysql db but a VHI.
The following link describes the way to connect using JDBC but it is in JAVA.
Could you please help me in connecting to that VHI system using ServiceNow app.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2023 04:50 AM - edited 05-16-2023 04:55 AM
Yes that is the right place. The connection URL is automatically generated in background, so you need to put all informations in seperate fields, e.g. user_name in field username. But OOTB only MySQL, MSSQL and Oracle is supported. But in the Docs there is a description, how to add new JDBC drivers for other database format: https://docs.servicenow.com/bundle/utah-integrate-applications/page/administer/import-sets/reference...
You need to this steps beforehand and you need a MID-Server. Also adding the field Connection URL field to the form is need in your case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2023 05:23 AM
No it doesn't, if you JDBC driver on the MID can reach the database then it's enough. This means you should have a host in the same network or at least firewall rules needs to be in place to allow this connection from the network there the MID Server is hosted.
For testing purposes you can also install the MID on your laptop if this has access to the database, but I'm sure that's not fitting the corporate compliance.
So next action I would recommend if they don't have already a MID in place: request for a Server (Windows or Unix depends on for which you have a JDBC driver available) with access to your target database and install the MID Server there.
