How to connect a mysql/oracle database to servicenow

[dev115415]

Hello I want to connect my servicenow app to an oracle/mysql database. How to do it?

I tried creating a data source in Inbound Integrations in ServiceNow studio. 

Also for the purpose of a trial I was doing with a mysql database. There I am getting an error- 

Could not connect to address=(host=localhost)(port=3306)(type=master) : Connection refused (Connection refused)

[newhand · Accepted solution]

HI@dev115415 

ServiceNow runs on the public internet, so it cannot connect to "localhost" directly. To connect to your database on your local network, you should fill in the "Use Mid Server" option (on the left side of your picture).

Before doing this, you need to create a mid server and ensure that the mid server can successfully access your database.

And, don't forget to change  the "localhost" to IP address...

[dev115415]

Thanks for your response. Please help me to how to fill the Mid server. I see many options there

[newhand]

@dev115415 
You should check the mid server definition to find out which mid server can reach your database, and select that one.