How to create a data source connection using MYSQL

[shabbir5]

Hi All,

In my PDI i am trying to make connection and get data from MYSQl to servicenow

--> I installed MYSQL in my personal laptop

-->now i have MYSQL 9.0 command line client

--> this is having some default data like Actor 

now i want to get that MYSQL data into servicenow with the help of a data source using JDBC connection

in data source I provided the required ( sql server name , user name , password ,port number , database name ) 

for this POC i need to install mid server in my personal laptop or not required ?

and getting below error while testing the data source

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

can someone help me how to achieve this ?

Thank you,

Shabbir Shaik

[palanikumar]

Hi,

You need a Mid Server for this requirement. Since ServiceNow is hosted in cloud, it cannot access your local host. Install MID server and connect MySQL via MID Server.

Thank you,

Palani

[Amit Verma]

Hi @shabbir5 

As told by @palanikumar , mid server is must for connecting the ServiceNow instance and the SQL environment hosted on your laptop. You can install the mid service on your laptop, configure it and give it a retry.

Thanks and Regards

Amit Verma