Integration

lokeshlokesh
Tera Contributor

How to get the data from third party application i.e., AFSCP to servicenow bye using JDBC connection. please explain briefly how to do in servicenow instance with images.

 

1 ACCEPTED SOLUTION

AshishKM
Kilo Patron
Kilo Patron

Hi @lokeshlokesh

You need to setup data source using JDBC connection and database credentials. Check the below example in your instance.

AshishKMishra_0-1703790727242.png

Write transform map for incoming data and map with target table and add this transform map to data source. You also need MID Server for this data source.

AshishKMishra_1-1703790871376.png

Based on data load frequency, you can create a scheduled job on this data source and get the data feed.

 

Let me know if you have any other query.

 

-Thanks,

AshishKMishra

 

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

View solution in original post

1 REPLY 1

AshishKM
Kilo Patron
Kilo Patron

Hi @lokeshlokesh

You need to setup data source using JDBC connection and database credentials. Check the below example in your instance.

AshishKMishra_0-1703790727242.png

Write transform map for incoming data and map with target table and add this transform map to data source. You also need MID Server for this data source.

AshishKMishra_1-1703790871376.png

Based on data load frequency, you can create a scheduled job on this data source and get the data feed.

 

Let me know if you have any other query.

 

-Thanks,

AshishKMishra

 

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution