Could you please tell how to connect a servicenow app to database using JDBC.

[dev115415]

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.

https://www.microfocus.com/documentation/verastream-host-integrator/7-9/design-tool/connectors-apis/...

Could you please help me in connecting to that VHI system using ServiceNow app.

[Daniel Borkowi1]

Hi Dev115415,

that's easy, you can create a Data Source with type JDBC and but all credentials and Connection URL in. You can also use a MID Server if the database is not accessible from internet (see https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/import-set...). You can also utilize IntegrationHub with the JDBC step, see https://docs.servicenow.com/bundle/utah-integrate-applications/page/administer/flow-designer/referen....

If this was helpful, please mark the answer as helpful.

Greets

Daniel

[dev115415]

I am attaching a screen shot here. Is this the place where you create a datasource. Also where to write the connection url like we write in JDBC?--------- jdbc:apptrieve:table[;managementserver=managementserver_name][;domain=domain_name][;serverid=vhi_server] [;database=model_name][;session=sessionpool_name] [;user=user_name][;password=xxx]

[Daniel Borkowi1 · Accepted solution]

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.

[dev115415]

Thank you for your response. Is MID server required to be installed in the host computer? Actually the place where I am trying to connect is not my laptop but to an enterprise app. So I think they may not allow me to install this MID server on their host.